kreator

gleam add kreator

This is a very wip query builder made in pure gleam to be used with multiple DB dialects.

import kreator as k
import kreator/sqlight as ks
import kreator/where.{and_where_equals}
import kreator/value as v
import gleam/dynamic
import sqlight

pub fn main() {
    use conn <- sqlight.with_connection(":memory:")
    let assert Ok(_) = sqlight.exec(
      "create table users (id integer primary key autoincrement, email text, name text)",
      conn,
    )

    let insert_user_query =
        k.table("users")
        |> k.insert([#("email", v.string("b@b.com")), #("name", v.string("Bruno"))])
        |> k.to_sqlite()

    let select_user_query =
        k.table("users")
        |> k.where(and_where_equals(_, "id", v.int(1)))
        |> k.to_sqlite()

    let assert Ok(_) = ks.run_nil(insert_user_query, on: conn)

    let assert Ok(user) = ks.first(
        select_user_query,
        on: conn,
        expecting: dynamic.tupple3(dynamic.int, dynamic.string, dynamic.string)
    )

    io.debug(user) // #(1, "b@b.com", "Bruno")
}

Further documentation can be found at https://hexdocs.pm/kreator.

Development

gleam run   # Run the project
gleam test  # Run the tests
gleam shell # Run an Erlang shell

TODO

• add codec support generated from schema files
• add joins
• add aggregations
• add subqueries
• add pagination helpers