dr_data.sql package

Module contents

class dr_data.sql.Sql

Bases: object

Class that contains all of the SQL to execute

static build_column_constraints(table_schema_name, table_name, column_name)

Query that gets the column constraints :return: query string :rtype: str

static build_columns_query(table_schema_name, table_name)

Query that gets all columns by schema and table names :return: query string :rtype: str

static build_insertion_table_order()

Query that gets the insertion order of the database :return: query string :rtype: str

static build_populate_insert(table_name, columns)

Query that inserts table data :return: query string :rtype: str

static build_random_row(columns, table)

Query that gets a random row from a table :return: query string :rtype: str

static build_random_row_where(columns, table, query)

Query that gets random row from a table with a where statement :return: query string :rtype: str

static build_tables_query(table_schema_name)

Query that gets all table schema based off table schem. :return: query string :rtype: str

static build_values_from_type(type)

Query that gets values from type :return: query string :rtype: str