Sqlite Toolkit - Functions


The following functions are available:

SQLITE connection

sqliteCreate a sqlite database connection
@octave_sqlite/isopenCheck if a sqlite connection is open
@octave_sqlite/closeClose a sqlite connection
@octave_sqlite/sqlfindFind information about table types in a database.

Importing Data

@octave_sqlite/fetchRun a SQL query on a sqlite database
@octave_sqlite/sqlreadRead rows of data from a table

Exporting Data

@octave_sqlite/sqlwriteInsert rows of data into a table.

Database Operations

@octave_sqlite/commitCommit changes to a database
@octave_sqlite/executeExecute a SQL statement on a sqlite database
@octave_sqlite/rollbackRollback changes to a database
@octave_sqlite/sqlupdateUpdate rows of data into a table.

Support Functions

dbtableCreate a table of data
dbrowfilterCreate an unconstrained dbrowfilter object with columns names.
struct2dbtableCreate a dbtable from a struct
readdbtableCreate a dbtable from a file