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]¶