sqlgg 20200521 · OCaml Package

type statement

type connection

type params

type row

type result

module Types : sig ... end

datatypes

type num = Types.Int.t

type text = Types.Text.t

type any = Types.Any.t

type datetime = Types.Datetime.t

exception Oops of string

val get_column_Bool : row -> int -> Types.Bool.t

val get_column_Int : row -> int -> Types.Int.t

val get_column_Text : row -> int -> Types.Text.t

val get_column_Any : row -> int -> Types.Any.t

val get_column_Float : row -> int -> Types.Float.t

val get_column_Decimal : row -> int -> Types.Decimal.t

val get_column_Datetime : row -> int -> Types.Datetime.t

val get_column_Bool_nullable : row -> int -> Types.Bool.t option

val get_column_Int_nullable : row -> int -> Types.Int.t option

val get_column_Text_nullable : row -> int -> Types.Text.t option

val get_column_Any_nullable : row -> int -> Types.Any.t option

val get_column_Float_nullable : row -> int -> Types.Float.t option

val get_column_Decimal_nullable : row -> int -> Types.Decimal.t option

val get_column_Datetime_nullable : row -> int -> Types.Datetime.t option

val start_params : statement -> int -> params

val finish_params : params -> result

val set_param_null : params -> unit

set_param_* stmt index val. index is 0-based,

raises Oops
on error

val set_param_Text : params -> Types.Text.t -> unit

val set_param_Any : params -> Types.Any.t -> unit

val set_param_Bool : params -> Types.Bool.t -> unit

val set_param_Int : params -> Types.Int.t -> unit

val set_param_Float : params -> Types.Float.t -> unit

val set_param_Decimal : params -> Types.Decimal.t -> unit

val set_param_Datetime : params -> Types.Datetime.t -> unit

val no_params : statement -> result

val select : 
  connection ->
  string ->
  (statement -> result) ->
  (row -> unit) ->
  unit

Perform query (cardinality "any") and return results via callback for each row

raises Oops
on error

val select_one_maybe : 
  connection ->
  string ->
  (statement -> result) ->
  (row -> 'r) ->
  'r option

Perform query (cardinality "zero or one") and return first row if available

raises Oops
on error

val select_one : 
  connection ->
  string ->
  (statement -> result) ->
  (row -> 'r) ->
  'r

Perform query (cardinality "one") and return first row

raises Oops
on error

val execute : connection -> string -> (statement -> result) -> int64

Execute non-query.

raises Oops
on error

returns
number of affected rows

package sqlgg