Packages

sqlitex

0.0.7
1.7.1 1.7.0 1.6.0 1.5.1 1.5.0 1.4.3 1.4.2 1.4.1 1.4.0 1.3.3 1.3.2 1.3.1 1.3.0 1.2.0 1.1.1 1.1.0 1.0.2 1.0.1 1.0.0 0.8.3 0.8.2 0.8.1 0.8.0 0.7.0 0.6.1 0.6.0 0.5.0 0.4.0 0.3.0 0.2.0 0.1.0 0.0.9 0.0.8 0.0.7 0.0.6 0.0.5 0.0.4 0.0.3 0.0.2 0.0.1

A thin Elixir wrapper around esqlite

HexDocs

Current section

Files

Jump to
Readme
40 Versions
1 Dependency
Dependants
Files
Activity
sqlitex lib sqlitex.ex
Raw

lib/sqlitex.ex 

defmodule Sqlitex do

  def close(db) do

    :esqlite3.close(db)

  end



  def open(path) do

    :esqlite3.open(path)

  end



  def query(db, query, opts \\ []) do

    {:ok, statement} = :esqlite3.prepare(query, db)

    types = :esqlite3.column_types(statement) |> Tuple.to_list

    columns = :esqlite3.column_names(statement) |> Tuple.to_list

    rows = :esqlite3.fetchall(statement)

    into = Keyword.get(opts, :into, [])

    Sqlitex.Row.from(types, columns, rows, into)

  end



  def with_db(path, fun) do

    {:ok, db} = open(path)

    res = fun.(db)

    close(db)

    res

  end

end