y3 d dl Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ dd lm Z dd
lmZ
dd lm Z G d d
e Z
e j G d de ZdZddZd ZdS ) N )_EnumeratedValues)SET)DATETIME)TIME) TIMESTAMP )log)types)utilc e Zd ZdZd ZdS )ReflectedStatez;Stores raw information about a SHOW CREATE TABLE statement.c Z g | _ i | _ d | _ g | _ g | _ g | _ d S N)columns
table_options
table_namekeysfk_constraintsck_constraints)selfs x/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mysql/reflection.py__init__zReflectedState.__init__ s5 N)__name__
__module__ __qualname____doc__r r r r r s) EE! ! ! ! !r r c ^ e Zd ZdZd Zd Zd Zd Zd Zd Z d Z
d Z d
Z d Z
d Zd
Zd ZdS )MySQLTableDefinitionParserz4Parses the results of a SHOW CREATE TABLE statement.c J || _ || _ | d S r )dialectpreparer
_prep_regexes)r r# r$ s r r z#MySQLTableDefinitionParser.__init__$ s(
r c t }||_ t j d| D ]5}| d| j j z r| || <| d r| || h|dk ro| d r| || |s|
| \ }}|t j d|z |dk r|j
| |dk r |j | |d k r |j | 57|S )
Nz\r?\nz z) )zCREATE zUnknown schema content: %rkey
fk_constraint
ck_constraint)r charsetresplit
startswithr$
initial_quote
_parse_column_parse_table_options_parse_table_name_parse_constraintsr warnr appendr r )r show_creater+ statelinetype_specs r parsez MySQLTableDefinitionParser.parse) s
HX{33 Dtdm&A ABB
""4//// &&
))$6666 ++
&&tU3333
" 5 5d ; ; t=I :T ABBBBe^^J%%d++++o--(//5555o--(//5555 r c | j | }|r| }| |d |d< |d rY| j |d }|r7| d r | d |d< |d r)| j |d d |d< d|fS | j | }|r| }| j |d |d< d | |d D |d< d | |d
D |d
< d |fS | j | }|r| }d |fS | j | }|rd
|fS d|fS )zaParse a KEY or CONSTRAINT line.
:param line: A line of SHOW CREATE TABLE output
r version_sqlparserr r( tablec g | ]
}|d S r r .0cs r
zAMySQLTableDefinitionParser._parse_constraints..f s O O OaQqT O O Or localc g | ]
}|d S rA r rB s r rE zAMySQLTableDefinitionParser._parse_constraints..g s) ! r foreignr) r* partitionN)
_re_keymatch groupdict_parse_keyexprs_re_key_version_sqlr$ unformat_identifiers_re_fk_constraint_re_ck_constraint
_re_partition)r r8 mr: m2s r r3 z-MySQLTableDefinitionParser._parse_constraintsI s
L t $ $ ;;==D # 2 24 ? C CDOM"
>-33D 4GHH >",,..2 >%'\\^^H%=DNH~
!% !C!CN" ""X $;
" ( ( . . );;==D M > >tG} M MDM O O4+?+?W
+N+N O O ODM " 2 24 ? C C DO #D( (
" ( ( . . );;==D"D( (
$ $T * * % $ $ d|r c | j \ }}| | }|r% || d |_ dS dS )zZExtract the table name.
:param line: The first line of SHOW CREATE TABLE
nameN)_pr_namerK groupr )r r8 r7 regexcleanuprS s r r2 z,MySQLTableDefinitionParser._parse_table_name{ sT w KK 8 &wqwwv 7 7E 8 8r c i }|r|dk rn|dd }| j D ]\ }}| | }|s | d | d } }|r || } | || < | d| }dD ]}
| |
d | D ] \ } } | |j | j j d| < dS )zBuild a dictionary of all reflected table-level options.
:param line: The final line of SHOW CREATE TABLE output.
r' N directiveval )auto_incrementzdata directoryzindex directory_)
_pr_optionssearchrX lowersubpopitemsr r# rV )
r r8 r7 options rest_of_linerY rZ rS r\ valuenopeoptr] s
r r1 z/MySQLTableDefinitionParser._parse_table_options s+
;ts{{ 7L"&"2
;
;wLL .. #$77;#7#7 5 + #GENNE-2 ))* $yy\ : : K $ $D KKd # # # #
J JHCFIE 4<+<+<+. s HHHAQHHHr fsp)unsignedzerofill)r+ collateretrieve_as_bitwisenullablenotnullNOT NULLautoincr
autoincrementdefaultNULLcomment\\\'' generated)sqltext persistenceSTORED persistedcomputed)rV typer r )
_re_columnrK rL _re_column_looser r4 r#
ischema_namesKeyErrorsqltypesNullType _re_csv_strfindall _re_csv_int
issubclassr r r re getr
_strip_valuesr Integerreplacedictupdater r5 )r r8 r7 r: rS rV r9 argscol_type type_argstype_kwkw
type_instancecol_kwr r r r r col_ds r r0 z(MySQLTableDefinitionParser._parse_column s O ! !$ ' ' %;;==D DLL%++D11A
%{{}} $V I4t; < < < FF| N IEL M M M L$y/4;Te )|1%8HH ) ) ) II@EtttL
(HHH ) <42::II
!W^^RC (0066IIHH)9)A)A$)G)GHHHI h4 ; < < 2
2!* q!1!1* # #BxxE""
# " ( ' 'BxxE""
' "2h h 1 2 2 6)7 BBI(C((
6R9__15-. )7w77
"z 88Iu % % 3 3!&F: 88J & & ,&*F? # #
("2
3
3 ,&+F? # ((9d++ f G((9d++ oofd33;;D#FFG((;'' G,,,H //I$(1X(=%!)F: M7G
V
U#####s C 1DDc
g }|D ]
fddD \ }}}}}dg} | | j | | | |s| d |rd|v rn| d r@| d r+| d | | nr|d k r+| d | | nA| d | d
| d d z |r| | | d | d
d| j | z d | dg S )a 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.
c g | ]
}| S r r )rC irows r rE zBMySQLTableDefinitionParser._describe_to_create.. s* : : : A: : :r )r r r| r_ timestampCDEFAULTr z'%s'rp r r^ zCREATE TABLE %s (
z,
z
) )r5 r$ quote_identifierr. r join) r r r bufferrV r rz r extrar8 r s @r _describe_to_createz.MySQLTableDefinitionParser._describe_to_create
s * *C: : : : /: : : 6T8Xw 5D KK
66t<< = = = KK ! ! !
( J'''
E#w.. ((55
E':L:L; ;
E KK ***KK(((( &&KK ***KK((((KK ***KK d)C)C CDDD
# E""" MM#((4.. ) ) ) )ww *m44Z@@A
6""
r c 6 | j | S )z8Unpack '"col"(2),"col" ASC'-ish strings into components.) _re_keyexprsr )r identifierss r rM z*MySQLTableDefinitionParser._parse_keyexprs? s ((555r c g | _ g | _ | j j }t t dd | j j || j | fD }t d|z | j j | _
t d|z | _ t d | _
t d | _ t d|z | _ t d|z | _ t d |z | _ t d
| _ | }d |d < t d
|z | _ t d|z | _ t d | _ t. D ]}| | dD ]}| | | dd | dd | dd dS )z Pre-compile regular expressions.)iqfqesc_fqc 6 g | ]}t j | S r )r, escape)rC ss r rE z.O s0 IaLL r zM^CREATE (?:\w+ +)?TABLE +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +\($zW(?:(?:%(iq)s((?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)(?:\((\d+)\))?(?: +(ASC|DESC))?(?=\,|$))+z \x27(?:\x27\x27|[^\x27])*\x27z\d+a %(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P\w+)(?:\((?P(?:\d+|\d+,\d+|(?:'(?:''|[^'])*',?)+))\))?(?: +(?PUNSIGNED))?(?: +(?PZEROFILL))?(?: +CHARACTER SET +(?P[\w_]+))?(?: +COLLATE +(?P[\w_]+))?(?: +(?P(?:NOT )?NULL))?(?: +DEFAULT +(?P(?:NULL|'(?:''|[^'])*'|[\-\w\.\(\)]+(?: +ON UPDATE [\-\w\.\(\)]+)?)))?(?: +(?:GENERATED ALWAYS)? ?AS +(?P\(.*\))? ?(?PVIRTUAL|STORED)?)?(?: +(?PAUTO_INCREMENT))?(?: +COMMENT +'(?P(?:''|[^'])*)')?(?: +COLUMN_FORMAT +(?P\w+))?(?: +STORAGE +(?P\w+))?(?: +(?P.*))?,?$z %(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P\w+)(?:\((?P(?:\d+|\d+,\d+|\x27(?:\x27\x27|[^\x27])+\x27))\))?.*?(?P(?:NOT )NULL)?aX (?:(?P\S+) )?KEY(?: +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)?(?: +USING +(?P\S+))? +\((?P.+?)\)(?: +USING +(?P\S+))?(?: +KEY_BLOCK_SIZE *[ =]? *(?P\S+))?(?: +WITH PARSER +(?P\S+))?(?: +COMMENT +(?P(\x27\x27|\x27([^\x27])*?\x27)+))?(?: +/\*(?P.+)\*/ +)?,?$z+\!\d+ (?: *WITH PARSER +(?P\S+) *)?z"RESTRICT|CASCADE|SET NULL|NOACTIONona, CONSTRAINT +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +FOREIGN KEY +\((?P[^\)]+?)\) REFERENCES +(?P%(iq)s[^%(fq)s]+%(fq)s(?:\.%(iq)s[^%(fq)s]+%(fq)s)?) +\((?P[^\)]+?)\)(?: +(?PMATCH \w+))?(?: +ON DELETE (?P%(on)s))?(?: +ON UPDATE (?P%(on)s))?z[ CONSTRAINT +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +CHECK +\((?P.+)\),?z (?:.*)(?:SUB)?PARTITION(?:.*))ENGINETYPEAUTO_INCREMENTAVG_ROW_LENGTHz
CHARACTER SETzDEFAULT CHARSETCHECKSUMCOLLATEDELAY_KEY_WRITE
INSERT_METHODMAX_ROWSMIN_ROWS PACK_KEYS
ROW_FORMATKEY_BLOCK_SIZEUNIONz
\([^\)]+\)
TABLESPACEz.*? STORAGE DISK RAID_TYPEz4\w+\s+RAID_CHUNKS\s*\=\s*\w+RAID_CHUNKSIZE\s*=\s*\w+N) _re_columnsra r$ final_quoter zipr/ _escape_identifier _pr_compile_unescape_identifierrW _re_compiler r r r r rJ rN copyrP rQ rR _options_of_type_string_add_option_string_add_option_word_add_option_regex)r _finalquotesr options r r% z(MySQLTableDefinitionParser._prep_regexesD s * &
3
88@@
$
DFL
M M .
(
9;A
B
''GHH 'v.. &
* +
4 !,
- 06
6!
!
#
$/ >$
$
[[]]74!,
5 8:
: "
"
$ "-
% (*
*"
"
))I J J
. , ,F # #F + + + +
* *F"
! !& ) ) ) ) w
666 |-@AAA C
r z(?:\s*(?:=\s*)|\s+)c dt j | d| j d}| j t |d d S )N(?Pr' z '(?P(?:[^']|'')*?)'(?!')c V | dd dd S )Nr r r rp )r )rt s r z?MySQLTableDefinitionParser._add_option_string.. s$ 64!8!8!@!@s!K!K r r, r _optional_equalsra r5 r r r\ rY s r r z-MySQLTableDefinitionParser._add_option_string sg Ii ! ! !
KK
r c dt j | d| j d}| j t | d S )Nr r' z (?P\w+)r r s r r z+MySQLTableDefinitionParser._add_option_word sQ Ii ! ! !
E 2 233333r c dt j | d| j d|d}| j t | d S )Nr r' z(?Pr r s r r z,MySQLTableDefinitionParser._add_option_regex sX Ii ! ! ! EE
E 2 233333r N)r r r r r r; r3 r2 r1 r0 r rM r% r r r r r r r r! r! s >>
@0 0 0 d 8 8 8J J J:e$ e$ e$N3
3
3
j6 6 6
n
n
n
` .
4 4 44 4 4 4 4r r! )COMMENTzDATA DIRECTORYzINDEX DIRECTORYPASSWORD
CONNECTIONc $ t | |fS )z1Prepare a 2-tuple of compiled regex and callable.)r )rY rZ s r r r s
((r c Z t j | t j t j z S )z)Compile a string to regex, I and UNICODE.)r, compileIUNICODE)rY s r r r s :eRTBJ . / //r r )r,
enumeratedr r r r r r r^ r
r r objectr class_loggerr! r r r r r r r sB
) ) ) ) ) ) ! ! ! ! ! ! ! ! ! ! !V ! ! ! m4 m4 m4 m4 m4 m4 m4 m4` ) ) ) ) 0 0 0 0 0r