Db Base

class dffml.db.base.BaseDatabase(config: Optional[Type[dffml.base.BaseConfig]])

Base class for database interaction

class dffml.db.base.BaseDatabaseContext(parent: dffml.db.base.BaseDatabase)

Base context class for database interaction

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

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

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

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

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

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

abstract remove(table_name: str, conditions: Optional[Union[List[List[dffml.db.base.Condition]], List[List[Tuple[str]]]]] = None)

Removes rows (satisfying conditions) from table_name

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

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

class dffml.db.base.Condition(column, operation, value)

property column

Alias for field number 0

property operation

Alias for field number 1

property value

Alias for field number 2

class dffml.db.base.DatabaseContextConstraint