sqlite

🎂Cake 🪶SQLite adapter which passes PreparedStatements to the sqlight library for execution.

Functions

execute_raw_sql

pub fn execute_raw_sql(
  sql_string sql_string: String,
  db_connection db_connection: Connection,
) -> Result(Nil, Error)

Execute a raw SQL query against an SQLite database.

read_query_to_prepared_statement

</>

pub fn read_query_to_prepared_statement(
  query query: ReadQuery,
) -> PreparedStatement

Convert a Cake ReadQuery to a PreparedStatement.

run_query

</>

pub fn run_query(
  query query: CakeQuery(a),
  decoder decoder: Decoder(a),
  db_connection db_connection: Connection,
) -> Result(List(a), Error)

Run a Cake CakeQuery against an SQLite database.

This function is a wrapper around run_read_query and run_write_query.

run_read_query

</>

pub fn run_read_query(
  query query: ReadQuery,
  decoder decoder: Decoder(a),
  db_connection db_connection: Connection,
) -> Result(List(a), Error)

Run a Cake ReadQuery against an SQLite database.

run_write_query

</>

pub fn run_write_query(
  query query: WriteQuery(a),
  decoder decoder: Decoder(b),
  db_connection db_connection: Connection,
) -> Result(List(b), Error)

Run a Cake WriteQuery against an SQLite database.

with_connection

</>

pub fn with_connection(
  filename filename: String,
  callback callback: fn(Connection) -> a,
) -> a

Connection to a SQLite database.

This is a thin wrapper around the sqlight library’s Connection type.

with_memory_connection

</>

pub fn with_memory_connection(
  callback callback: fn(Connection) -> a,
) -> a

Connection to an in-memory SQLite database.

This is a thin wrapper around the sqlight library’s Connection type.

write_query_to_prepared_statement

</>

pub fn write_query_to_prepared_statement(
  query query: WriteQuery(a),
) -> PreparedStatement

Convert a Cake WriteQuery to a PreparedStatement.