Module Connector.MakeSource

Constructs the main module used to connect to a database for the given concurrency model.

Parameters

module Pool : Pool.S with type 'a fiber := 'a System.Fiber.t and type switch := System.Switch.t and type stdenv := System.stdenv
module Loader : Driver_loader.S with type 'a fiber := 'a System.Fiber.t and type switch := System.Switch.t and type stdenv := System.stdenv and type ('a, 'e) stream := ('a, 'e) System.Stream.t

Signature

Sourceval connect : ?subst:(Caqti_template.Dialect.t -> Caqti_template.Query.subst) -> ?env:(Caqti_driver_info.t -> string -> Caqti_query.t) -> ?config:Caqti_connect_config.t -> ?tweaks_version:(int * int) -> sw:System.Switch.t -> stdenv:System.stdenv -> Uri.t -> ((module Loader.CONNECTION), [> Caqti_error.load_or_connect ]) result System.Fiber.t

connect uri locates and loads a driver which can handle uri, passes uri to the driver, which establish a connection and returns a first-class module implementing Caqti_connection_sig.S.

connect uri connects to the database at uri and returns a first class module implementing Caqti_connection_sig.S for the given database system. In case of preemptive threading, the connection must only be used from the thread where it was created.

The correct driver for the database system is inferred from the schema of uri; see the respective drivers for the supported schemas and related URI syntax. A driver can either be linked in to the application or, if supported, dynamically linked using the caqti-dynload package.

  • parameter subst

    Alternative to env when using the new experimental API.

  • parameter env

    If provided, this function will do a final expansion of environment variables which occurs in the query templates of the requests executed on the connection.

  • parameter config

    Configuration parameters related to the interaction with the database.

  • parameter tweaks_version
Sourceval with_connection : ?subst:(Caqti_template.Dialect.t -> Caqti_template.Query.subst) -> ?env:(Caqti_driver_info.t -> string -> Caqti_query.t) -> ?config:Caqti_connect_config.t -> ?tweaks_version:(int * int) -> stdenv:System.stdenv -> Uri.t -> ((module Loader.CONNECTION) -> ('a, [> Caqti_error.load_or_connect ] as 'e) result System.Fiber.t) -> ('a, 'e) result System.Fiber.t

with_connection uri f calls connect on uri. If connect evaluates to Ok connection, with_connection passes the connection to f. Once f either evaluates to a result, or raises an exception, with_connection closes the database connection.

  • parameter config

    Passed to connect.

  • parameter tweaks_version
Sourceval connect_pool : ?pool_config:Caqti_pool_config.t -> ?post_connect: ((module Loader.CONNECTION) -> (unit, 'connect_error) result System.Fiber.t) -> ?subst:(Caqti_template.Dialect.t -> Caqti_template.Query.subst) -> ?env:(Caqti_driver_info.t -> string -> Caqti_query.t) -> ?config:Caqti_connect_config.t -> ?tweaks_version:(int * int) -> sw:System.Switch.t -> stdenv:System.stdenv -> Uri.t -> (((module Loader.CONNECTION), [> Caqti_error.connect ] as 'connect_error) Pool.t, [> Caqti_error.load ]) result

connect_pool uri is a pool of database connections constructed by connect uri.

Do not use pooling for connections to volatile resources like sqlite3::memory: and beware of temporary tables or other objects which may not be shared across connections to the same URI.

If you use preemptive threading, note that the connection pool must only be used from the thread where it was created. Use thread local storage to create a separate pool per thread if necessary.

  • parameter post_connect

    A task to run after establishing a new connection and before the connection becomes available to the application. This function can be used to customize to the database session.

  • parameter config

    Passed to connect when creating new connections.

  • parameter subst

    Passed to connect when creating new connections.

  • parameter env

    Passed to connect when creating new connections.

  • parameter tweaks_version