The query Module

Utility to generate SQL query based on a YAML query specification

fqn(t)[source]

class Query(user_request, connection)[source]

Class providing the API to generate SQL from a user request

sql: Generated SQL

execute()[source]

prepare()[source]

Generates SQL. Result is stored as a class member sql

Returns:: None

find_tables(column: str, tables: Dict) → List[str][source]

generate_select(variables: Dict) → str[source]

collect_tables(source: Dict, tables: Dict, result: Dict)[source]

generate_from(variables: Dict, aux: Dict, source: Dict) → str[source]

generate_where(variables: Dict, tables: Dict, used_tables: Set) → str[source]

all_tables(variables: Dict) → Set[source]

reduce_tables(variables: Dict) → bool[source]

generate_order_by(request: dict) → str[source]

generate(system, user) -> (<class 'str'>, typing.List)[source]