httk.db.backend.sqlite module

This provides a thin abstraction layer for SQL queries, implemented on top of sqlite,3 to make it easier to exchange between SQL databases.

class httk.db.backend.sqlite.Sqlite(filename)[source]

Bases: object

class SqliteCursor(db)[source]

Bases: object

close()[source]
description
execute(sql, values=[])[source]
fetchall()[source]
fetchone()[source]
alter(sql, values, cursor=None)[source]
close()[source]
commit()[source]
create_table(name, primkey, columnnames, columntypes, cursor=None, index=None)[source]
cursor()[source]
get_row(table, primkeyname, primkey, columnnames, cursor=None)[source]
get_rows(table, primkeyname, primkeys, columnnames, cursor=None)[source]
get_val(table, primkeyname, primkey, columnname, cursor=None)[source]
insert(sql, values, cursor=None)[source]
insert_row(name, columnnames, columnvalues, cursor=None)[source]
modify_structure(sql, values, cursor=None)[source]
query(sql, values, cursor=None)[source]
rollback()[source]
table_exists(name, cursor=None)[source]
update(sql, values, cursor=None)[source]
update_row(name, primkeyname, primkey, columnnames, columnvalues, cursor=None)[source]
httk.db.backend.sqlite.db_close(connection)[source]
httk.db.backend.sqlite.db_open(filename)[source]
httk.db.backend.sqlite.db_sqlite_close_all()[source]