cake
Cake is an SQL query building library for RDBMS:
- 🐘PostgreSQL
- 🪶SQLite
- 🦭MariaDB
- 🐬MySQL
For examples see the tests.
Types
Base wrapper query type to be able to pass around read and write queries in the same way.
pub type CakeQuery(a) {
CakeReadQuery(@internal ReadQuery)
CakeWriteQuery(@internal WriteQuery(a))
}
Constructors
-
CakeReadQuery(@internal ReadQuery)
-
CakeWriteQuery(@internal WriteQuery(a))
pub type PreparedStatement =
@internal PreparedStatement
pub type WriteQuery(a) =
@internal WriteQuery(a)
Values
pub fn get_params(
prepared_statement prp_stm: @internal PreparedStatement,
) -> List(param.Param)
Get the parameters of the prepared statement.
pub fn get_sql(
prepared_statement prp_stm: @internal PreparedStatement,
) -> String
Get the SQL of the prepared statement.
pub fn read_query_to_prepared_statement(
query qry: @internal ReadQuery,
dialect dlct: @internal Dialect,
) -> @internal PreparedStatement
Create a prepared statement from a read query.
pub fn to_prepared_statement(
query qry: CakeQuery(a),
dialect dlct: @internal Dialect,
) -> @internal PreparedStatement
Create a prepared statement from a Cake query.
Also see cake/dialect/*
for dialect specific implementations of this.
pub fn to_read_query(
query qry: @internal ReadQuery,
) -> CakeQuery(a)
Create a Cake read query from a read query.
Also see cake/dialect/*
for dialect specific implementations of this.
pub fn to_write_query(
query qry: @internal WriteQuery(a),
) -> CakeQuery(a)
Create a Cake write query from a write query.
Also see cake/dialect/*
for dialect specific implementations of this.
pub fn write_query_to_prepared_statement(
query qry: @internal WriteQuery(a),
dialect dlct: @internal Dialect,
) -> @internal PreparedStatement
Create a prepared statement from a write query.