package sqlgg

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

Install

Dune 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
OCaml

Innovation. Community. Security.

GitHub Discord Twitter Peertube RSS
About
Changelog Releases Industrial Users Academic Users Why OCaml
Ecosystem
Packages Community Events OCaml Planet Jobs
Resources
Install OCaml Get Started Platform Tools Language Manual Standard Library API Books Exercises Papers OCaml Playground Logo
Policies
Carbon Footprint Governance Privacy Code of Conduct