Sqlitex
Summary↑
| close(db) | |
| create_table(db, name, table_opts \\ [], cols) | Create a new table |
| exec(db, sql) | |
| open(path) | |
| query(db, sql, opts \\ []) | |
| with_db(path, fun) |
Functions
Create a new table name where table_opts are a list of table constraints
and cols are a keyword list of columns. The following table constraints are
supported: :temp and :primary_key. Example:
[:temp, {:primary_key, [:id]}]
Columns can be passed as:
- name: :type
- name: {:type, constraints}
where constraints is a list of column constraints. The following column constraints
are supported: :primary_key, :not_null and :autoincrement. Example:
id: :integer, name: {:text, [:not_null]}