Packages

sqlitex

0.0.6
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, [])



    for row <- rows do

      build_row(types, columns, row, into)

    end

  end



  defp build_row(types, columns, row, into) do

    values = row |> Tuple.to_list |> Enum.zip(types) |> Enum.map(&translate_value/1)



    columns

      |> Enum.zip(values)

      |> Enum.into(into)

  end



  def with_db(path, fun) do

    {:ok, db} = open(path)

    res = fun.(db)

    close(db)

    res

  end



  defp translate_value({str, :datetime}) do

    <<yr::binary-size(4), "-", mo::binary-size(2), "-", da::binary-size(2), " ", hr::binary-size(2), ":", mi::binary-size(2), ":", se::binary-size(2), ".", _fr::binary-size(6)>> = str

    {{String.to_integer(yr), String.to_integer(mo), String.to_integer(da)},{String.to_integer(hr), String.to_integer(mi), String.to_integer(se)}}

  end



  defp translate_value({:undefined,_type}) do

    nil

  end



  defp translate_value({val, _type}) do

    val

  end

end