sqlite_database.query_builder module

Query Builder

sqlite_database.query_builder.basic_extract(table_creation: str)

basic extraction for table

sqlite_database.query_builder.build_update_data(data: dict[str, Any] | tuple[str, ...], suffix: str = '_set')

Build update data, used to parameterized update data. Suffix is used to make sure there’s no collisions with others. Use this with caution.

sqlite_database.query_builder.combine_keyvals(keydict: dict[str, Any], valuedict: dict[str, Any] | tuple[str, ...])

Combine key dictionary with value dictionary. The first dictionary will only ignore the values while value dict ignore the keys. Mapping[key, _] -> keydict Mapping[_, value] -> valuedict

sqlite_database.query_builder.extract_signature(filter_: dict[str, Signature | ParsedFn | Any] | list[tuple[str, Signature | ParsedFn]] | None | tuple[tuple[str, Signature | ParsedFn], ...] = None, suffix: str = '_check')

Extract filter signature.

sqlite_database.query_builder.extract_single_column(column: Column)

Extract a column class to sqlite column creation query

sqlite_database.query_builder.extract_table(table_creation: str) → list[Column]

Extract SQLite table string

sqlite_database.query_builder.extract_table_creations(columns: Iterable[Column], type_mappings: dict[str, str] | None = None)

Extract columns classes to sqlite table creation query.

sqlite_database.query_builder.fetch_columns(_master_query: _MasterQuery)

Fetch columns of a table. _master_query is originated from select() on sqlite_master table

sqlite_database.query_builder.filter_extraction(string: str, shlexed: list[str])

A function step of table extraction. Used to replace quoted and parens with parameter.

sqlite_database.query_builder.format_paramable(data: dict[str, Any] | tuple[str, ...])

Format a data to parameterized data.