The Domain Class

Domain is a Python module dedicated to generation of various SQL required for manipulation with data in certain knowledge domain

See

class Domain(spec, name)

CREATE = 'CREATE TABLE {flag} {name}'

set_sloppy()

create_table(name) → str

init() → None

list_columns(table) → list

list_source_columns(table) → list

has_hard_linked_children(table) → bool

has(key: str) → bool

get(key: str) → Optional[str]

fqn(table)

ufqn(table)

find(table: str, root=None) → Optional[dict]

find_dependent(table: str) → Dict

drop(table, connection) → list

spillover_table(table, definition)

append_ddl(table: str, ddl: str)

skip(table: str)

classmethod get_select_from(definition) → Optional[List[Identifier]]

add_column_indices(table: str, columns: List)

ddl_for_node(node, parent=None) → None

add_multi_column_indices(table: str, definition: Dict)

generate_insert_from_select(table: str, limit: Optional[int] = None) → str

is_populate_on_create(table) → bool

create_object_from(table, definition, features, obj_type) → str

map_selected_columns(selected_columns: List[Identifier], cdef: Dict, pdef: Dict) → List[Dict]

create_true_table(table, features) → str

need_index(column) → bool

get_index_ddl(table, column) -> (<class 'str'>, <class 'bool'>)

add_index_by_ddl(table: str, ddl: str)

get_multi_column_index_ddl(table: str, name: str, definition: dict) → str

add_index(table: str, name: str, definition: dict)

static is_array(column) → bool

static is_generated(column)

extract_generation_code(column, other_columns, qualifier)

static get_column_type(column) → str

static has_column_spec(column) → bool

column_spec(column) → str

view_column_spec(column, table, table_fqn) → str

find_mapped_column_name(column1, table2) → str

view_column_joined(source, table) → str

static list_identifiers(table)

matches(create_statement, list_of_tables) → bool

create(connection, list_of_tables=None)

gen_insert_on_validation_failure(table, target, columns, conditions) → List[str]

gen_update_quality(table, reasons: List[str]) → str

add_fk_validation(table, pk, action, target, columns, pt, fk_columns)

classmethod parse_wildcard_column_spec(s: str) → Optional[Tuple[str, str, List, str]]

classmethod is_column_wildcard(name: str)

classmethod get_columns(definition: Dict)

classmethod get_columns_as_dict(definition: Dict) → Dict