*he=@%SrSSKrSSKrSSKJr SSKJrJrJr SSK J r SSK J r Sr S S S S S SSSSSSSSSS.r\R"S\R \R"-S9r\R&\S'"SS5rS#S\S\S\\ SS44S jjrS!\S\\4S"jrg)$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\rSrSrSrSrS\SS4SjrS\S \S\\4S jr \ S \ S\ 4S j5r \ S \ S\ 4S j5r\ S\S\\4Sj5r\ S\S\ 4Sj5r\ S\S\4Sj5rSS\ S\\4SjjrS\4SjrSrg)MySQLScriptSplitterEzBreaks 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:XlSUlSUl0Ulg)z Constructor.N)_code _single_stmts_mappable_stmts_re_sql_split_stmts)selfrs R/var/www/auris/envauris/lib/python3.13/site-packages/mysql/connector/_scripting.py__init__MySQLScriptSplitter.__init__Ns 486:<> code delimiterc/nX R;aSU;a [S5eUR5Vs/sH&n[R XDR 55PM( nn[ R"SRU5UR-5URU'URURU5H-nUR5nU(dMURU5 M/ U$s snf)z Split code context by delimiter.\z5The backslash (\) character is not a valid delimiter.r)) r$rdecodeDELIMITER_RESERVED_SYMBOLSgetencoderecompilejoin_regex_sql_split_stmtssplitstripappend)r%r*r+snippetschardelimiter_patternsnippet snippet_strips r&_split_statement$MySQLScriptSplitter._split_statementUs 44 4 !$L &,,.!.D+..t[[]C. !35***+d.I.II3D $ $Y /// :@@FG#MMOM} .G !s-C4r:cL[R"[U55SS;$)z;Validates whether `char` is a white-space character or not.r>Z unicodedatacategorychrr:s r&is_white_space_char'MySQLScriptSplitter.is_white_space_charm###CI.q1U::r)cL[R"[U55SS;$)z7Validates whether `char` is a control character or not.r>CrBrFs r&is_control_char#MySQLScriptSplitter.is_control_charrrIr)stringc0[R"SU5$)z6Split `string` by any control character or whitespace.s[\s\x00-\x1f\x7f-\x9f])r2r6)rNs r&$split_by_control_char_or_white_space8MySQLScriptSplitter.split_by_control_char_or_white_spacewsxx2F;;r)c<[R"[U5SL$)zBValidates whether `code` has the delimiter command pattern or not.N)r2searchrr*s r& has_delimiter!MySQLScriptSplitter.has_delimiter|syy*D1==r)cS[S[S[4SjnS[S[4SjnS[S[S[4Sjn[S5nSupV[ S 5[ S 5[ S 5pnU[ U5:GaUGcS n U"US S X5(aSn O(U"USS 5(aSn OU"US S X5(aSn U GbFU S;a6U[ U5:a&XU:waUS- nU[ U5:a XU:waMOFUS-[ U5:a/XUS-S:wa$US- nUS-[ U5:a XUS-S:waM$US- n[ [ U 55Hn UR5 M U(a[RUS5(d[RUS5(aUUR5 U(a>[RUS5(aM6[RUS5(aMUGMUcXX4;aXnOUb XXg1;aS nURX5 US- nU[ U5:aGM[U5$)aPRemove 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_charrc|US:H=(a1 [RU5=(d [RU5$)Ns--)rrLrGrXrYs r& is_dash_style:MySQLScriptSplitter.remove_comments..is_dash_styles5E>#33F;C&::6B r)c US:H$)N#)rXs r& is_hash_style:MySQLScriptSplitter.remove_comments..is_hash_styles D= r)cLUS:H=(a U[S5[S51;$)Ns/*!r)ordr[s r& is_c_style7MySQLScriptSplitter.remove_comments..is_c_styles#E>HfSXs3x4H&H Hr)r))rN '"N--#z/*)rlrnrs*/) bytesintbool bytearrayrelenrangepoprrLrGr8) r*r\rarfbufi literal_ctx line_break single_quote double_quotestyle_s r&remove_comments#MySQLScriptSplitter.remove_commentssV<      ! !4 ! Ie IS IT In 14TCHc#h, #d)m" RS4733 E"3rs8,,EBC$'22 E$ +#d)m:0EFA #d)m:0E !ec$i/DQUOu4LFA !ec$i/DQUOu4LQ"3u:. /+;;CGDD.BB3r7KK +;;CGDD.BB3r7KK"tw<2N'N"g (TW8Q-Q" JJtw  FAG#d)mJSzr)rcURb UR$/Ul[n/nSnU(a[RURS9nO URn[ R "[US9Hn[ R"[U5(alURU5SnUR5 URRURSRU5US95 Xv[U5S/p2OURU5 UnM U(a8URRURSRU5US95 UR$)aSplits 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)rT)patternrNr )r*r+)r"DEFAULT_DELIMITERrrr!r2r6rrSrPrvextendr>r4rtr8)r%rr+rwprevr*currnext_delimiters r& split_script MySQLScriptSplitter.split_scriptsI0    )%% % %  &66DJJ6GD::DHH%6tDDyy*D11"&!J!J4!PQR!S ""))))tyy~)S "0s>7J7L2M1N3 4 D1E6     % %%%499S>Y%O !!!r)c8URRS5$)Nutf-8)r!r.)r%s r&__repr__MySQLScriptSplitter.__repr__ szz  ))r))r!r#r$r")T)__name__ __module__ __qualname____firstlineno____doc__r5rpr'listr> staticmethodrqrrrGrLrPrUrrstrr__static_attributes__r`r)r&rrEs X?5?T?Uue0;#;$;;;c;d;;E>d>>QeQQQfI"DI"DKI"V*#*r)rsql_code map_resultsrc ## [RU5(dU(d[[/5US9v g[US9nUR 5nU(d[[S/5SS9v gU(d%[[U5SR U5S9v gSnS[ U55nUHOnXd:a([SR X4U5[X4U5S9v [X6[X6/5S9v US -nMQ U[U5:a;[SR X4[U55[X4[U55S9v gg7f) aOBreaks 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)rr)s; rc3\# UH"upUSSR5S:XdMUv M$ g7f)NsCALL )upper).0jstmts r& (split_multi_statement..js*W&671$r(..:Jh:VQQ&6s, ,)rrr)rrUr rrr4 enumeratert)rrtokstmtsrx partition_idsrs r&split_multi_statementr$sNL  , ,X 6 6{ #b RR  2C    E #se CPP #uV[[5G    AWi&6WM  5$"(++eaj"9!&uqz!2  #(z1B   E 3u:~ $kk%CJ*?@"5SZ#89  sEEscriptc[R"S[RU5[RS9nU(a[ US5S:wa [ /5$[ UVs/sHo"SRS5PM sn5$s snf)aPScans 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. s2LOCAL\s+INFILE\s+(["'])((?:\\\1|(?:(?!\1)).)*)(\1))rrNrrrr)r2findallrr IGNORECASErtrr.)rmatchesmatchs r&get_local_infile_filenamesrsrjjJ"226:mmG c'!*o*Ry @u(//'*@ AA@s%B )F)rr2rC collectionsrtypingrrrerrorsrtypesr rr/r3r MULTILINErPattern__annotations__rrprrrrrr`r)r&rs:? --"',               E " M --",, &!2::D\*\*BZ Z Z #T4/0Z zBuBsBr)