Petrol (p.petrol.1.0.0.doc.petrol.Petrol)

Sourcetype table_name

Uniquely identifies a table in the system.

Sourcemodule Type : sig ... end

Defines all supported SQL types.

Sourcemodule Expr : sig ... end

Provides an SQL E-DSL for writing well-typed SQL expressions.

Sourcemodule Schema : sig ... end

Provides an E-DSL for specifying SQL tables in OCaml.

Sourcemodule Query : sig ... end

Provides an E-DSL for specifying SQL queries in OCaml.

Sourcemodule Request : sig ... end

This module defines a request type t that can be executed by Caqti (see exec, find, find_opt). The functions defined in this module cache their inputs, so it is safe to call these repeatedly.

Sourcemodule StaticSchema : sig ... end

Provides a helper interface, primarily for prototyping/debugging, that declares a static table without any versioning.

Sourcemodule VersionedSchema : sig ... end

Provides an interface that declares a versioned schema.

Source

val exec : 
  (module Caqti_lwt.CONNECTION) ->
  (unit, [< `Zero ]) Request.t ->
  (unit, [> Caqti_error.call_or_retrieve ]) result Lwt.t

exec db req executes a unit SQL request req on the SQL database db.

Source

val find : 
  (module Caqti_lwt.CONNECTION) ->
  ('a, [< `One ]) Request.t ->
  ('a, [> Caqti_error.call_or_retrieve ]) result Lwt.t

find db req executes a singleton SQL request req on the SQL database db returning the result.

Source

val find_opt : 
  (module Caqti_lwt.CONNECTION) ->
  ('a, [< `One | `Zero ]) Request.t ->
  ('a option, [> Caqti_error.call_or_retrieve ]) result Lwt.t

find_opt db req executes a zero-or-one SQL request req on the SQL database db returning the result if it exists.

Source

val collect_list : 
  (module Caqti_lwt.CONNECTION) ->
  ('a, [< `Many | `One | `Zero ]) Request.t ->
  ('a list, [> Caqti_error.call_or_retrieve ]) result Lwt.t

collect_list db req executes a SQL request req on the SQL database db and collects the results into a list.