glitr_convert_sql

Create SQL requests effortlessly using glitr_convert

Installation

gleam add glitr_convert_sql

Usage

import gleam/io
import glitr/convert as c
import glitr/convert/sql

pub type User {
  User(id: String, name: String, age: Int)
}

pub fn user_converter() -> c.Converter(User) {
  c.object({
    use id <- c.parameter
    use name <- c.parameter
    use age <- c.parameter
    use <- c.constructor
    User(id:, name:, age:)
  })
  |> c.field("id", fn(v) { Ok(v.id) }, c.string())
  |> c.field("name", fn(v) { Ok(v.name) }, c.string())
  |> c.field("age", fn(v) { Ok(v.age) }, c.int())
  |> c.to_converter
}

pub fn main() {
  let alice = User("1", "Alice", 24)

  sql.insert("users", user_converter(), [alice])
  |> io.debug
  // INSERT INTO users (id, name, age) VALUES ('1', 'Alice', 24);

  let happy_birthday_alice = User(..alice, age: 25)

  sql.update("users", user_converter(), alice, "id")
  |> io.debug
  // UPDATE users SET name='Alice', age=25 WHERE id='1';

  sql.select("users", user_converter())
  |> io.debug
  // SELECT id, name, age FROM users;
}

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

Features

• Select all requests
• Insert requests
• Update requests

Backlog

• Select + where requests
• Delete requests
• Integrate more features like order by, returning and joins

Development

gleam run   # Run the project
gleam test  # Run the tests