Db Sqlite

class dffml.db.sqlite.SqliteDatabase(cfg)

CONFIG

alias of SqliteDatabaseConfig

CONTEXT

alias of SqliteDatabaseContext

class dffml.db.sqlite.SqliteDatabaseConfig(filename: str)

no_enforce_immutable()

By default, all properties of a config object are immutable. If you would like to mutate immutable properties, you must explicitly call this method using it as a context manager.

Examples

>>> from dffml import config
>>>
>>> @config
... class MyConfig:
...     C: int
>>>
>>> config = MyConfig(C=2)
>>> with config.no_enforce_immutable():
...     config.C = 1

class dffml.db.sqlite.SqliteDatabaseContext(parent: BaseDatabase)

create_table(table_name: str, cols: Dict[str, str]) → None

Creates a table with name table_name if it doesn’t exist

insert(table_name: str, data: Dict[str, Any]) → None

Inserts values to corresponding cols (according to position) to the table table_name

lookup(table_name: str, cols: Optional[List[str]] = None, conditions: Optional[Union[List[List[Condition]], List[List[Tuple[str]]]]] = None) → AsyncIterator[Dict[str, Any]]

Returns list of rows (satisfying conditions if provided) from table_name

remove(table_name: str, conditions: Optional[Union[List[List[Condition]], List[List[Tuple[str]]]]] = None)

Removes rows (satisfying conditions) from table_name

update(table_name: str, data: Dict[str, Any], conditions: Optional[Union[List[List[Condition]], List[List[Tuple[str]]]]] = None) → None

Updates values of rows (satisfying conditions if provided) with data in table_name