sql

SQLEntry([sqlval, sqltype, fileval, key])

Represent an entry in a SQLite database.

SQLiteDB(db_fn[, table])

Interface class which wraps the sqlite3 module.

find_sqltype(val)

Find sqlite data type which matches the type of val.

fix_sql_header(header)

fix_sqltype() applied to any sqltype in header

fix_sqltype(sqltype)

Fix sqltype string.

get_test_db()

Return in-memory database for playing around.

makedb(filename, lists, colnames[, table, ...])

Create sqlite db filename (mode='w') or append to existing db (mode='a').

sql_column(key, lst[, sqltype, sqlval_func, ...])

Convert a list lst of values of the same type (i.e. all floats) to a list of SQLEntry instances of the same column name key and sqltype (e.g. 'float').

sql_column_old(key, sqltype, lst[, ...])

Examples

sql_matrix(lists[, header, colnames, ...])

Convert each entry in a list of lists ("matrix" = sql table) to an SQLEntry based on header.