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]