/var/opt/nydus/ops/mysql/connector/__pycache__
Edit: /var/opt/nydus/ops/mysql/connector/__pycache__/_scripting.cpython-312.pyc (15700B)
N je= @ U d Z ddlZddlZddlmZ ddlmZmZmZ ddl m
Z
ddl m Z dZ
d d
d d d
ddddddddddZ ej dej ej" z Zej& ed< G d d Z d#d ed ed ee ddf fd Zd!ed ee fd"Zy)$z8Classes and methods utilized to work with MySQL Scripts. N)deque)Deque GeneratorOptional )InterfaceError)MySQLScriptPartition ;s \$s \^s \?s \(s \)s \[s \]s \{s \}s \.s \|s \+s \-s \*)$^?()[]{}.|+-*sA (delimiter\s+)(?=(?:[^"'`]*(?:"[^"]*"|'[^']*'|`[^`]*`))*[^"'`]*$))flagsDELIMITER_PATTERNc e Zd ZdZdZdeddfdZdededee fd Ze d
e
de fd Z e d
e
de fd Z
e d
edee fd Ze dede fd Ze dedefd Zdde dee fdZdefdZy)MySQLScriptSplitterzBreaks a MySQL script into single statements.
It strips custom delimiters and comments along the way, except for comments
representing a MySQL extension or optimizer hint.
s3 (?=(?:[^"'`]*(?:"[^"]*"|'[^']*'|`[^`]*`))*[^"'`]*$)
sql_scriptreturnNc < || _ d| _ d| _ i | _ y)z Constructor.N)_code
_single_stmts_mappable_stmts_re_sql_split_stmts)selfr s K/opt/nydus/tmp/pip-target-a90h98xg/lib/python/mysql/connector/_scripting.py__init__z MySQLScriptSplitter.__init__N s!
486: <> code delimiterc g }|| j vrd|v r t d |j D cg c]& }t j ||j ( }}t
j dj | | j z | j |< | j | j | D ]& }|j }|s|j | ( |S c c}w )z Split code context by delimiter. \z5The backslash (\) character is not a valid delimiter.r' )
r# r decodeDELIMITER_RESERVED_SYMBOLSgetencoderecompilejoin_regex_sql_split_stmtssplitstripappend)r$ r( r) snippetschardelimiter_patternsnippet
snippet_strips r% _split_statementz$MySQLScriptSplitter._split_statementU s D 4 4 4 !$L
& , , .! .D +..tT[[]C .
! 35***+d.I.II3D $ $Y / // :@@FG #MMOM
. G
!s +C&r8 c H t j t | d dv S )z;Validates whether `char` is a white-space character or not.r > Z unicodedatacategorychrr8 s r% is_white_space_charz'MySQLScriptSplitter.is_white_space_charm # ##CI.q1U::r' c H t j t | d dv S )z7Validates whether `char` is a control character or not.r > Cr? rC s r% is_control_charz#MySQLScriptSplitter.is_control_charr rE r' stringc . t j d| S )z6Split `string` by any control character or whitespace.s [\s\x00-\x1f\x7f-\x9f])r0 r4 )rI s r% $split_by_control_char_or_white_spacez8MySQLScriptSplitter.split_by_control_char_or_white_spacew s xx2F;;r' c : t j t | duS )zBValidates whether `code` has the delimiter command pattern or not.N)r0 searchr r( s r%
has_delimiterz!MySQLScriptSplitter.has_delimiter| s yy*D1==r' c F dt dt dt fd}dt dt fd}dt dt dt fd}t d }d\ }}t d t d
t d } }}|t | k r|Qd }
||d
d | | rd}
n ||dd rd}
n ||d
d | | rd}
|
|
dv r3|t | k rh| | |k7 r`|dz
}|t | k rM| | |k7 r nC|dz t | k r-| ||dz dk7 r"|dz
}|dz t | k r | ||dz dk7 r"|dz
}t
t |
D ] } |j |rtt j |d st j |d rD|j |r2t j |d r+t j |d rDc|| | || fv r| | }n
| | | ||hv rd }|j | | |dz
}|t | k rt | S )a Remove MySQL comments which include `--`-style, `#`-style
and `C`-style comments.
A `--`-style comment spans from `--` to the end of the line.
It requires the second dash to be
followed by at least one whitespace or control character
(such as a space, tab, newline, and so on).
A `#`-style comment spans from `#` to the end of the line.
A C-style comment spans from a `/*` sequence to the following `*/`
sequence, as in the C programming language. This syntax enables a
comment to extend over multiple lines because the beginning and
closing sequences need not be on the same line.
**NOTE: Only C-style comments representing MySQL extensions or
optimizer hints are preserved**. E.g.,
```
/*! MySQL-specific code */
/*+ MySQL-specific code */
```
*For Reference Manual- MySQL Comments*, see
https://dev.mysql.com/doc/refman/en/comments.html.
b_strb_charr c h | dk( xr, t j | xs t j | S )Ns --)r rH rD rQ rR s r%
is_dash_stylez:MySQLScriptSplitter.remove_comments.
.is_dash_style s5 E> #33F; C&::6B
r' c | dk( S )N # )rQ s r%
is_hash_stylez:MySQLScriptSplitter.remove_comments..is_hash_style s D= r' c @ | dk( xr |t d t d hvS )Ns /*!r )ordrT s r%
is_c_stylez7MySQLScriptSplitter.remove_comments..is_c_style s# E>HfSXs3x4H&H Hr' r' )r N
'"N--#z/*)rb rd r s */) bytesintbool bytearrayr\ lenrangepopr rH rD r6 ) r( rU rY r] bufi literal_ctx
line_break single_quote double_quotestyle_s r% remove_commentsz#MySQLScriptSplitter.remove_comments s\ < ! !4 ! Ie IS IT I n ;14TCHc#h,L
#d)m" RS473 E"3rs8, E BC$q'2 E$ + #d)mQ:0E FA #d)mQ:0E !ec$i /DQUOu4L FA !ec$i /DQUOu4LQ "3u: . / +;;CGD.BB3r7K +;;CGD.BB3r7K "tAw< 2N'N "1g (T!Wj8Q-Q " JJtAw
FAG #d)mJ Szr' ru c | j | j S g | _ t }g }d}|r!t j | j }n | j }t j t | D ] }t j t | rq| j | d }|j | j j | j dj | | ||t | d g}}n|j | |} |r;| j j | j dj | | | j S )a Splits the given script text into a sequence of individual statements.
The word DELIMITER and any of its lower and upper case combinations
such as delimiter, DeLiMiter, etc., are considered reserved words by
the connector. Users must quote these when included in multi statements
for other purposes different from declaring an actual statement delimiter;
e.g., as names for tables, columns, variables, in comments, etc.
```
CREATE TABLE `delimiter` (begin INT, end INT); -- I am a `DELimiTer` comment
```
If they are not quoted, the statement-mapping will not produce the expected
experience.
See https://dev.mysql.com/doc/refman/8.0/en/keywords.html to know more
about quoting a reserved word.
*Note that comments are always ignored as they are not considered to be
part of statements, with one exeception; **C-style comments representing
MySQL extensions or optimizer hints are preserved***.
Nr' rN )patternrI r )r( r) )r! DEFAULT_DELIMITERr ru r r0 r4 r rM rK rl extendr< r2 rj r6 )r$ ru r) rm prevr( currnext_delimiters r% split_scriptz MySQLScriptSplitter.split_script sJ 0 )%% % % &66DJJ6GD::D HH%6tDD yy*D1 "&!J!J4!PQR!S ""))))tyy~)S "0$s>7J7L2M1N3
4 D1 E6 % %%%499S>Y%O
!!!r' c 8 | j j d S )Nutf-8)r r, )r$ s r% __repr__z MySQLScriptSplitter.__repr__ s zz ))r' )T)__name__
__module__ __qualname____doc__r3 rf r& listr< staticmethodrg rh rD rH rK rO ru r~ strr rX r' r% r r E s X?5 ?T ?U u e 0 ;# ;$ ; ; ;c ;d ; ; E >d > > Qe Q Q QfI"D I"DK I"V*# *r' r sql_code map_resultsr c
# K t j | s|st t g | yt | }|j }|st t dg d y|s(t t | dj | yd}d t
| D }|D ]X }||kD r-t dj ||| t ||| t || t || g |d z }Z |t | k r@t dj ||t | t ||t | yyw)
a Breaks a MySQL script into sub-scripts.
If the given script uses `DELIMITER` statements (which are not recognized
by MySQL Server), the connector will parse such statements to remove them
from the script and substitute delimiters as needed. This pre-processing
may cause a performance hit when using long scripts. Note that when enabling
`map_results`, the script is expected to use `DELIMITER` statements in order
to split the script into multiple query strings.
Args:
sql_code: MySQL script.
map_results: If True, each sub-script is `statement-result` mappable.
Returns:
A generator of typed dictionaries with keys `single_stmts` and `mappable_stmts`.
If mapping disabled and no delimiters detected, it returns a 1-item generator,
the field `single_stmts` is an empty list and the `mappable_stmt` field
corresponds to the unmodified script, that may be mappable.
If mapping disabled and delimiters detected, it returns a 1-item generator,
the field `single_stmts` is a list including all the single statements
found in the script and the `mappable_stmt` field corresponds to the processed
script (delimiters are stripped) that may be mappable.
If maping enabled, the script is broken into mappable partitions. It returns
an N-item generator (as many items as computed partitions), the field
`single_stmts` is a list including all the single statements of the partition
and the `mappable_stmt` field corresponds to the sub-script (partition) that
is guaranteed to be mappable.
Raises:
`InterfaceError` if an invalid delimiter string is found.
) single_stmts
mappable_stmtN)r r' s ;
r c 3 T K | ] \ }}|d d j dk( s | " y w)N s CALL )upper).0jstmts r% z(split_multi_statement..j s+ W&671d$r(..:Jh:VQ&6s (()r r r )r rO r r r~ r2 enumeraterj )r r tokstmtsrn
partition_idsr s r% split_multi_statementr $ sZ L , ,X 6{ #b RR
2C
E #se CPP # u V[[5G
AWi&6WM
q5$"(++eAaj"9!&uQqz!2
# (az1B
E 3u:~ $kk%CJ*? @ "5SZ#8 9
s EEscriptc t j dt j | t j }|rt |d dk7 r t
g S t
|D cg c] }|d j d c} S c c}w )al Scans the MySQL script looking for `filenames` (one for each
`LOCAL INFILE` statement found).
Arguments:
script: a MySQL script that may include one or more `LOCAL INFILE` statements.
Returns:
filenames: a list of filenames (one for each `LOCAL INFILE` statement found).
An empty list is returned if no matches are found.
s2 LOCAL\s+INFILE\s+(["'])((?:\\\1|(?:(?!\1)).)*)(\1))rw rI r r r r )r0 findallr ru
IGNORECASErj r r, )r matchesmatchs r% get_local_infile_filenamesr st jjJ"226:mmG
c'!*o*Ry @u%(//'*@ AA@s !B)F)r r0 r@ collectionsr typingr r r errorsr typesr ry r- r1 r MULTILINEr Pattern__annotations__r rf rh r r r rX r' r% r s : ? - - " ' ,
E *
M
--",,
&! 2:: D\* \*B Z
Z
Z
#T4/0Z
zBu Bs Br'