sqlalchemy.dialects.mysql.reflection.MySQLTableDefinitionParser

class documentation

class MySQLTableDefinitionParser: (source)

Parses the results of a SHOW CREATE TABLE statement.

Method	`__init__`	Undocumented
Method	`parse`	Undocumented
Instance Variable	`dialect`	Undocumented
Instance Variable	`preparer`	Undocumented
Method	`_add_option_regex`	Undocumented
Method	`_add_option_string`	Undocumented
Method	`_add_option_word`	Undocumented
Method	`_add_partition_option_word`	Undocumented
Method	`_check_view`	Undocumented
Method	`_describe_to_create`	Re-format DESCRIBE output as a SHOW CREATE TABLE string.
Method	`_parse_column`	Extract column details.
Method	`_parse_constraints`	Parse a KEY or CONSTRAINT line.
Method	`_parse_keyexprs`	Unpack '"col"(2),"col" ASC'-ish strings into components.
Method	`_parse_partition_options`	Undocumented
Method	`_parse_table_name`	Extract the table name.
Method	`_parse_table_options`	Build a dictionary of all reflected table-level options.
Method	`_prep_regexes`	Pre-compile regular expressions.
Class Variable	`_optional_equals`	Undocumented
Instance Variable	`_pr_name`	Undocumented
Instance Variable	`_pr_options`	Undocumented
Instance Variable	`_re_ck_constraint`	Undocumented
Instance Variable	`_re_column`	Undocumented
Instance Variable	`_re_column_loose`	Undocumented
Instance Variable	`_re_columns`	Undocumented
Instance Variable	`_re_csv_int`	Undocumented
Instance Variable	`_re_csv_str`	Undocumented
Instance Variable	`_re_fk_constraint`	Undocumented
Instance Variable	`_re_is_view`	Undocumented
Instance Variable	`_re_key`	Undocumented
Instance Variable	`_re_key_version_sql`	Undocumented
Instance Variable	`_re_keyexprs`	Undocumented
Instance Variable	`_re_partition`	Undocumented

def __init__(self, dialect, preparer): (source) ¶

Undocumented

def parse(self, show_create, charset): (source) ¶

Undocumented

dialect = (source) ¶

Undocumented

preparer = (source) ¶

Undocumented

def _add_option_regex(self, directive, regex): (source) ¶

Undocumented

def _add_option_string(self, directive): (source) ¶

Undocumented

def _add_option_word(self, directive): (source) ¶

Undocumented

def _add_partition_option_word(self, directive): (source) ¶

Undocumented

def _check_view(self, sql: str) -> bool: (source) ¶

Undocumented

def _describe_to_create(self, table_name, columns): (source) ¶

Re-format DESCRIBE output as a SHOW CREATE TABLE string. DESCRIBE is a much simpler reflection and is sufficient for reflecting views for runtime use. This method formats DDL for columns only- keys are omitted. :param columns: A sequence of DESCRIBE or SHOW COLUMNS 6-tuples. SHOW FULL COLUMNS FROM rows must be rearranged for use with this function.

def _parse_column(self, line, state): (source) ¶

Extract column details. Falls back to a 'minimal support' variant if full parse fails. :param line: Any column-bearing line from SHOW CREATE TABLE

def _parse_constraints(self, line): (source) ¶

Parse a KEY or CONSTRAINT line. :param line: A line of SHOW CREATE TABLE output

def _parse_keyexprs(self, identifiers): (source) ¶

Unpack '"col"(2),"col" ASC'-ish strings into components.

def _parse_partition_options(self, line, state): (source) ¶

Undocumented

def _parse_table_name(self, line, state): (source) ¶

Extract the table name. :param line: The first line of SHOW CREATE TABLE

def _parse_table_options(self, line, state): (source) ¶

Build a dictionary of all reflected table-level options. :param line: The final line of SHOW CREATE TABLE output.