httk.db.backend.duck_db module

This provides a thin abstraction layer for SQL queries, implemented on top of DuckDB.

class httk.db.backend.duck_db.Duckdb(filename, existing_db=None)

Bases: object

class DuckdbCursor(db)

Bases: object

It should be noted that in DuckDB the cursor is frivolous, meaning creating a cursor returns a duplicate of the connection object.

close()

property description

execute(sql, values=[])

fetchall()

fetchone()

alter(sql, values, cursor=None)

close()

commit()

create_table(name, primkey, columnnames, columntypes, cursor=None, index=None)

cursor()

get_row(table, primkeyname, primkey, columnnames, cursor=None)

get_rows(table, primkeyname, primkeys, columnnames, cursor=None)

get_val(table, primkeyname, primkey, columnname, cursor=None)

insert(sql, values, cursor=None, key_index=None)

insert_row(name, columnnames, columnvalues, cursor=None)

modify_structure(sql, values, cursor=None)

query(sql, values, cursor=None)

rollback()

table_exists(name, cursor=None)

update(sql, values, cursor=None)

update_row(name, primkeyname, primkey, columnnames, columnvalues, cursor=None)

httk.db.backend.duck_db.db_close(connection)

httk.db.backend.duck_db.db_duckdb_close_all()

httk.db.backend.duck_db.db_open(filename)