glodbc

Gleam ODBC Library that is based on the odbc erlang library.

gleam add glodbc@1

Example Usage

import glodbc.{varchar, integer}

pub fn main() {
  // Testing with MariaDB, other ODBC Databases work too of course! Just have the right driver!
  let connstring =
    "Driver={MariaDB ODBC 3.0 Driver};DSN=localhost;UID=testuser;PWD=password"
  let assert Ok(conn) = glodbc.connect(connstring, [#(AutoCommit, True)])

  let assert Ok(glodbc.Selected(_col_names, _rows)) =
    glodbc.sql_query(conn, "Select * from test.testtable;")

  let assert Ok(glodbc.Updated(_rowcount)) =
    glodbc.sql_query(conn, "Update test.testtable set name='Fred' where id=1")

  let assert Ok(glodbc.Updated(_rowcount)) =
    glodbc.sql_query(
      conn,
      "Insert into test.testtable (id, name, age) values (2, 'Jonas', 18)",
    )

  let assert Ok(Selected(_col_names, _rows)) =
    glodbc.param_query(conn, "Select age from test.testtable where name=? and id=?", [
      [varchar("Fred", 100), integer(1)],
      [varchar("Jonas", 100), integer(2)],
    ])

  let assert Ok(glodbc.ODBCOk) = glodbc.commit(conn, glodbc.Commit)
  // or Rollback

  let assert Ok(_tabledescription) = glodbc.describe_table(conn, "test.testtable")
  // -> [Description("id", SqlInteger), Description("name", SqlVarchar(100)), Description("age", SqlInteger)]

  let assert Ok(glodbc.ODBCOk) = glodbc.disconnect(conn)
}

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

Development

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