package sqlgg

  1. Overview
  2. Docs
SQL Guided (code) Generator

Install 

dune-project
 Dependency

ygrek.org Readme Edit opam file Versions (4)

Authors

  1. Y
    ygrek

Maintainers

  1. Y
    ygrek@autistici.org

Sources

sqlgg-20200521.tar.gz
md5=b9e861726ce73364e303f0cc1d5ec049
sha256=b9bfd29dc5c880c324ed77ec333053317fd0806f5a64b573b5031ee7fc227deb
sha512=5f73a65b5cf5c17788a75f64b3def21a9d8e53b32a876a4fee4570317a20b48ca69879e9dadaa399d7e57f2e9d262850650bcb031fd90f6bf21abdf8d99ce1a6

doc/sqlgg.lib/Sqlgg/Sql/index.html

Module Sqlgg.SqlSource

Sourcemodule Type : sig ... end
Sourcemodule Constraint : sig ... end
Sourcemodule Constraints : sig ... end
Sourcetype attr = {
  1. name : string;
  2. domain : Type.t;
  3. extra : Constraints.t;
}
Sourceval make_attribute : string -> Type.t -> Constraints.t -> attr
Sourcemodule Schema : sig ... end
Sourcetype table_name = {
  1. db : string option;
  2. tn : string;
}
Sourceval show_table_name : table_name -> string
Sourceval make_table_name : ?db:string -> string -> table_name
Sourcetype schema = Schema.t
Sourcetype table = table_name * schema
Sourceval print_table : 'a IO.output -> (table_name * attr list) -> unit
Sourcetype param_id = {
  1. label : string option;
  2. pos : int * int;
}

optional name and start/end position in string

Sourcetype param = {
  1. id : param_id;
  2. typ : Type.t;
  3. attr : attr option;
}
Sourceval new_param : ?attr:attr -> param_id -> Type.t -> param
Sourcetype params = param list
Sourcetype ctor =
  1. | Simple of param_id * var list option
  2. | Verbatim of string * string
Sourceand var =
  1. | Single of param
  2. | Choice of param_id * ctor list
Sourcetype vars = var list
Sourcetype alter_pos = [
  1. | `After of string
  2. | `Default
  3. | `First
]
Sourcetype alter_action = [
  1. | `Add of attr * alter_pos
  2. | `RenameTable of table_name
  3. | `RenameColumn of string * string
  4. | `RenameIndex of string * string
  5. | `Drop of string
  6. | `Change of string * attr * alter_pos
  7. | `None
]
Sourcetype select_result = schema * param list
Sourcetype direction = [
  1. | `Fixed
  2. | `Param of param_id
]
Sourcetype int_or_param = [
  1. | `Const of int
  2. | `Limit of param
]
Sourcetype limit_t = [
  1. | `Limit
  2. | `Offset
]
Sourcetype col_name = {
  1. cname : string;
    (*

    column name

    *)
  2. tname : table_name option;
}
Sourceand limit = param list * bool
Sourceand nested = source * (source * join_cond) list
Sourceand source = [ `Select of select_full | `Table of table_name | `Nested of nested ] * table_name option
Sourceand join_cond = [
  1. | `Cross
  2. | `Search of expr
  3. | `Default
  4. | `Natural
  5. | `Using of string list
]
Sourceand select = {
  1. columns : column list;
  2. from : nested option;
  3. where : expr option;
  4. group : expr list;
  5. having : expr option;
}
Sourceand select_full = {
  1. select : select * select list;
  2. order : order;
  3. limit : limit option;
}
Sourceand order = (expr * direction option) list
Sourceand 'expr choices = (param_id * 'expr option) list
Sourceand expr =
  1. | Value of Type.t
    (*

    literal value

    *)
  2. | Param of param
  3. | Choices of param_id * expr choices
  4. | Fun of Type.func * expr list
    (*

    parameters

    *)
  5. | Select of select_full * [ `AsValue | `Exists ]
  6. | Column of col_name
  7. | Inserted of string
    (*

    inserted value

    *)
Sourceand column =
  1. | All
  2. | AllOf of table_name
  3. | Expr of expr * string option
    (*

    name

    *)
Sourcetype columns = column list
Sourcetype expr_q = [
  1. | `Value of Type.t
    (*

    literal value

    *)
  2. | `Param of param
  3. | `Choice of param_id * expr_q choices
  4. | `Func of Type.func * expr_q list
    (*

    return type, grouping, parameters

    *)
]
Sourceval expr_to_string : expr -> Ppx_deriving_runtime.string
Sourcetype assignments = (col_name * expr) list
Sourcetype insert_action = {
  1. target : table_name;
  2. action : [ `Set of assignments option | `Values of string list option * [ `Expr of expr | `Default ] list list option | `Select of string list option * select_full ];
  3. on_duplicate : assignments option;
}
Sourcetype stmt =
  1. | Create of table_name * [ `Schema of schema | `Select of select_full ]
  2. | Drop of table_name
  3. | Alter of table_name * alter_action list
  4. | Rename of (table_name * table_name) list
  5. | CreateIndex of string * table_name * string list
  6. | Insert of insert_action
  7. | Delete of table_name * expr option
  8. | Set of string * expr
  9. | Update of table_name * assignments * expr option * order * param list
  10. | UpdateMulti of source list * assignments * expr option
  11. | Select of select_full
  12. | CreateRoutine of string * Type.t option * (string * Type.t * expr option) list
Sourcemodule Function : sig ... end