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