Database module

database:sqlite:open#

Open a connection to a SQLite database.

Parameters

• database_filename: path to the database file

Return value UserType: an open connection to a SQLite database

Author

• @rstefanic

Example

(let db (database:sqlite:open "test.db"))

database:sqlite:close#

Close an open connection to a SQLite database.

Parameters

• database: an open SQLite database object

Return value number: SQLite exit code (0 on success).

Author

• @rstefanic

Example

(database:sqlite:close db)

database:sqlite:exec#

Execute a SQL query.

Parameters

• database: an open SQLite database object
• sql: SQL statement(s)

Return value number: SQLite exit code (0 on success).

Author

• @rstefanic

Example

(database:sqlite:exec db "CREATE TABLE company(id INT PRIMARY KEY NOT NULL, name TEXT NOT NULL);")

database:sqlite:exec_with_callback#

Run a SQL statement on the database and run a callback function on each row in the results. The callback function takes one argument which will be passed a list of the results from a row.

Parameters

• database: SQLite Object
• sql: a string of the query or queries that you’d like to run
• callback: a function to run on every row returned

Return value number: SQLite exit code.

Author

• @rstefanic

Example

# CREATE TABLE user (id INT PRIMARY KEY NOT NULL, name TEXT NOT NULL);
# INSERT INTO user (id, name) VALUES (1, 'Jane Doe'), (2, 'John Doe');

(database:sqlite:exec_with_callback
  db
  "SELECT * FROM user;"
  (fun (row) (print row)))
# ["1" "Jane Doe"]
# ["2" "John Doe"]

database:sqlite:last_insert_row_id#

Get the row id of the last row inserted into the database.

Parameters

• database: SQLite Object

Return value number: id of the last row inserted

Author

• @rstefanic

Example

(database:sqlite:last_insert_row_id db)