Install SQLite Dependency

Fedora 31:

sudo dnf -y install sqlite-devel

Ubuntu 20.04:

sudo apt install -y libsqlite3-dev

Windows:

• Download the source zip from SQLite Downloads
• Create a new sqlite subfolder inside v/thirdparty
• Extract the zip into that folder

fn connect(path string) ?DB

struct DB {
pub mut:
	is_open bool
mut:
	conn &C.sqlite3
}

fn (db DB) @select(config orm.SelectConfig, data orm.QueryData, where orm.QueryData) ?[][]orm.Primitive

sql expr

fn (mut db DB) close() ?bool

close Closes the DB. TODO: For all functions, determine whether the connection is closed first, and determine what to do if it is

fn (db DB) create(table string, fields []orm.TableField) ?

table

fn (db DB) create_table(table_name string, columns []string)

fn (db DB) delete(table string, where orm.QueryData) ?

fn (db DB) drop(table string) ?

fn (db DB) error_message(code int, query string) IError

fn (db DB) exec(query string) ([]Row, int)

Execute the query on db, return an array of all the results, alongside any result code. Result codes: https://www.sqlite.org/rescode.html

fn (db DB) exec_none(query string) int

In case you don't expect any result, but still want an error code e.g. INSERT INTO ... VALUES (...)

fn (db DB) exec_one(query string) ?Row

Execute a query, handle error code Return the first row from the resulting table

fn (db DB) insert(table string, data orm.QueryData) ?

sql stmt

fn (db DB) last_id() orm.Primitive

fn (db DB) last_insert_rowid() i64

Returns last insert rowid https://www.sqlite.org/c3ref/last_insert_rowid.html

fn (db DB) q_int(query string) int

Returns a single cell with value int.

fn (db DB) q_string(query string) string

Returns a single cell with value string.

fn (db DB) str() string

fn (db DB) update(table string, data orm.QueryData, where orm.QueryData) ?

struct Row {
pub mut:
	vals []string
}