sqlalchemy.dialects.mysql.reflection.MySQLTableDefinitionParser

class documentation

class MySQLTableDefinitionParser(object):

Parses the results of a SHOW CREATE TABLE statement.

Method	`__init__`	Undocumented
Method	`_add_option_regex`	Undocumented
Method	`_add_option_string`	Undocumented
Method	`_add_option_word`	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_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.
Method	`parse`	Undocumented
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_key`	Undocumented
Instance Variable	`_re_key_version_sql`	Undocumented
Instance Variable	`_re_keyexprs`	Undocumented
Instance Variable	`_re_partition`	Undocumented
Instance Variable	`dialect`	Undocumented
Instance Variable	`preparer`	Undocumented

def __init__(self, dialect, preparer):

Undocumented

def _add_option_regex(self, directive, regex):

Undocumented

def _add_option_string(self, directive):

Undocumented

def _add_option_word(self, directive):

Undocumented

def _describe_to_create(self, table_name, columns):

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.

Parameters
table_name	Undocumented
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):

Extract column details.

Falls back to a 'minimal support' variant if full parse fails.

Parameters
line	Any column-bearing line from SHOW CREATE TABLE
state	Undocumented

def _parse_constraints(self, line):

Parse a KEY or CONSTRAINT line.

Parameters
line	A line of SHOW CREATE TABLE output

def _parse_keyexprs(self, identifiers):

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

def _parse_table_name(self, line, state):

Extract the table name.

Parameters
line	The first line of SHOW CREATE TABLE
state	Undocumented

def _parse_table_options(self, line, state):

Build a dictionary of all reflected table-level options.

Parameters
line	The final line of SHOW CREATE TABLE output.
state	Undocumented

def _prep_regexes(self):

Pre-compile regular expressions.

def parse(self, show_create, charset):

Undocumented

_optional_equals: str =

Undocumented

_pr_name =

Undocumented

_pr_options: list =

Undocumented

_re_ck_constraint =

Undocumented

_re_column =

Undocumented

_re_column_loose =

Undocumented

_re_columns: list =

Undocumented

_re_csv_int =

Undocumented

_re_csv_str =

Undocumented

_re_fk_constraint =

Undocumented

_re_key =

Undocumented

_re_key_version_sql =

Undocumented

_re_keyexprs =

Undocumented

_re_partition =

Undocumented

dialect =

Undocumented

preparer =

Undocumented