cake/adapter/postgres

execute_raw_sql

pub fn execute_raw_sql(
  sql_string sql_string: String,
  db_connection on: pog.Connection,
) -> Result(pog.Returned(Nil), pog.QueryError)

read_query_to_prepared_statement

</>

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

Convert a Cake ReadQuery to a PreparedStatement.

run_query

</>

pub fn run_query(
  query query: cake.CakeQuery(a),
  decoder decoder: decode.Decoder(a),
  db_connection db_connection: pog.Connection,
) -> Result(List(a), pog.QueryError)

Run a Cake CakeQuery against an PostgreSQL database.

This function is a wrapper around run_read_query and run_write_query.

run_read_query

</>

pub fn run_read_query(
  query query: sqlite_dialect.ReadQuery,
  decoder decoder: decode.Decoder(a),
  db_connection on: pog.Connection,
) -> Result(List(a), pog.QueryError)

run_write_query

</>

pub fn run_write_query(
  query query: sqlite_dialect.WriteQuery(a),
  decoder decoder: decode.Decoder(b),
  db_connection on: pog.Connection,
) -> Result(List(b), pog.QueryError)

Run a Cake WriteQuery against an PostgreSQL database.

with_connection

</>

pub fn with_connection(
  host host: String,
  port port: Int,
  username username: String,
  password password: option.Option(String),
  database database: String,
  callback callback: fn(pog.Connection) -> a,
) -> a

Runs a callbakc on a connection to a PostgreSQL database.

NOTICE: ⚠️⚠️⚠️ You should probably be using gleam_erlang’s supervisor.new, supervisor.add, and supervisor.start instead, to create the database connection.

See pog’s official documentation https://hexdocs.pm/pog/.

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

with_named_connection

</>

pub fn with_named_connection(
  process process: process.Name(pog.Message),
  host host: String,
  port port: Int,
  username username: String,
  password password: option.Option(String),
  database database: String,
  callback callback: fn(pog.Connection) -> a,
) -> a

Runs a callback on a connection to a PostgreSQL database.

NOTICE: ⚠️⚠️⚠️ You should probably be using gleam_erlang’s supervisor.new, supervisor.add, and supervisor.start instead, to create the database connection.

See pog’s official documentation https://hexdocs.pm/pog/.

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

In addition to with_connection you may specify the erlang process name.

write_query_to_prepared_statement

</>

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

Convert a Cake WriteQuery to a PreparedStatement.

cake_pog - v1.3.0

Values