httk.db.backend package

Submodules

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]
Sqlite.alter(sql, values, cursor=None)[source]
Sqlite.close()[source]
Sqlite.commit()[source]
Sqlite.create_table(name, primkey, columnnames, columntypes, cursor=None, index=None)[source]
Sqlite.cursor()[source]
Sqlite.get_row(table, primkeyname, primkey, columnnames, cursor=None)[source]
Sqlite.get_rows(table, primkeyname, primkeys, columnnames, cursor=None)[source]
Sqlite.get_val(table, primkeyname, primkey, columnname, cursor=None)[source]
Sqlite.insert(sql, values, cursor=None)[source]
Sqlite.insert_row(name, columnnames, columnvalues, cursor=None)[source]
Sqlite.modify_structure(sql, values, cursor=None)[source]
Sqlite.query(sql, values, cursor=None)[source]
Sqlite.rollback()[source]
Sqlite.table_exists(name, cursor=None)[source]
Sqlite.update(sql, values, cursor=None)[source]
Sqlite.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]

Module contents