?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/mysql/connector/__pycache__/_scripting.cpython-39.pyc
???????
a ��Jhe= � @ s� U d Z ddlZddlZddlmZ ddlmZmZmZ ddl m Z ddl m Z dZ d d d d d dddddddddd�ZejdejejB d�Zejed< G dd � d �Zd$eeee ddf d �d d �Zeee d!�d"d#�ZdS )%z8Classes and methods utilized to work with MySQL Scripts.� N)�deque)�Deque� Generator�Optional� )�InterfaceError)�MySQLScriptPartition� ;s \$s \^s \?s \(s \)s \[s \]s \{s \}s \.s \|s \+s \-s \*)�$�^�?�(�)�[�]�{�}�.�|�+�-�*sA (delimiter\s+)(?=(?:[^"'`]*(?:"[^"]*"|'[^']*'|`[^`]*`))*[^"'`]*$))�flags�DELIMITER_PATTERNc @ s� e Zd ZdZdZedd�dd�Zeeee d�dd �Ze e e d �d d ��Z e e e d �d d��Z e eee d�dd��Ze ee d�dd��Ze eed�dd��Zd e ee d�dd�Zed�d d �ZdS ) �MySQLScriptSplitterz�Breaks 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 (?=(?:[^"'`]*(?:"[^"]*"|'[^']*'|`[^`]*`))*[^"'`]*$)N)� sql_script�returnc C s || _ d| _d| _i | _dS )z Constructor.N)�_code� _single_stmtsZ_mappable_stmts�_re_sql_split_stmts)�selfr � r! �O/home/agenciai/.local/lib/python3.9/site-packages/mysql/connector/_scripting.py�__init__N s z MySQLScriptSplitter.__init__)�code� delimiterr c C s| g }|| j vrLd|v r td��dd� |�� D �}t�d�|�| j �| j |< | j | �|�D ]}|�� }|r\|� |� q\|S )z Split code context by delimiter.� \z5The backslash (\) character is not a valid delimiter.c S s g | ]}t �||�� ��qS r! )�DELIMITER_RESERVED_SYMBOLS�get�encode)�.0�charr! r! r" � <listcomp>^ s �z8MySQLScriptSplitter._split_statement.<locals>.<listcomp>� ) r r �decode�re�compile�join�_regex_sql_split_stmts�split�strip�append)r r$ r% ZsnippetsZdelimiter_patternZsnippetZ snippet_stripr! r! r" �_split_statementU s" ��� z$MySQLScriptSplitter._split_statement)r+ r c C s t �t| ��d dv S )z;Validates whether `char` is a white-space character or not.r > �Z�� unicodedata�category�chr�r+ r! r! r" �is_white_space_charm s z'MySQLScriptSplitter.is_white_space_charc C s t �t| ��d dv S )z7Validates whether `char` is a control character or not.r > �Cr8 r< r! r! r" �is_control_charr s z#MySQLScriptSplitter.is_control_char)�stringr c C s t �d| �S )z6Split `string` by any control character or whitespace.s [\s\x00-\x1f\x7f-\x9f])r/ r3 )r@ r! r! r" �$split_by_control_char_or_white_spacew s z8MySQLScriptSplitter.split_by_control_char_or_white_space)r$ r c C s t �t| �duS )zBValidates whether `code` has the delimiter command pattern or not.N)r/ �searchr �r$ r! r! r" � has_delimiter| s z!MySQLScriptSplitter.has_delimiterc C s� t ttd�dd�}t td�dd�}t ttd�dd�}td �}d \}}td �td �td � }}} |t| �k �r�|du �r�d} ||dd� | | �r�d} n0||dd� �r�d} n||dd� | | �r�d} | du�r�| dv r�|t| �k r�| | |kr�|d7 }q�n:|d t| �k �r0| ||d � dk�r0|d7 }q�|d7 }tt| ��D ]} |�� �qD|r`t� |d ��svt� |d �r`|�� �qTq`|du �r�| | || fv �r�| | }n |du�r�| | ||hv �r�d}|� | | � |d7 }q`t |�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_str�b_charr c S s | dkot �|�pt �|�S )Ns --)r r? r= �rE rF r! r! r" � is_dash_style� s �z:MySQLScriptSplitter.remove_comments.<locals>.is_dash_style)rE r c S s | dkS )N� #r! )rE r! r! r" � is_hash_style� s z:MySQLScriptSplitter.remove_comments.<locals>.is_hash_stylec S s | dko|t d�t d�hvS )Ns /*�!r )�ordrG r! r! r" � is_c_style� s z7MySQLScriptSplitter.remove_comments.<locals>.is_c_styler- )r N� �'�"N����--����#z/*)rR rT r � s */) �bytes�int�bool� bytearrayrL �len�range�popr r? r= r5 ) r$ rH rJ rM �buf�iZ literal_ctxZ line_breakZ single_quoteZ double_quote�style�_r! r! r" �remove_comments� sL ( � � z#MySQLScriptSplitter.remove_commentsT)ra r c C s� | j dur| j S g | _ t}g }d}|r6tj| jd�}n| j}tjt|d�D ]j}t�t|�r�| � |�d }|� � | j � | j d� |�|d�� ||t|�d� g }}n |�|� |}qJ|r�| j � | j d� |�|d�� | 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- rC )�patternr@ r � )r$ r% )r �DEFAULT_DELIMITERr ra r r/ r3 r rB rA r\ �extendr6 r1 rZ r5 )r ra r% r] �prevr$ �currZnext_delimiterr! r! r" � split_script� s0 � �z MySQLScriptSplitter.split_script)r c C s | j �d�S )N�utf-8)r r. )r r! r! r" �__repr__ s z MySQLScriptSplitter.__repr__)T)�__name__� __module__� __qualname__�__doc__r2 rV r# �listr6 � staticmethodrW rX r= r? rA rD ra rh �strrj r! r! r! r" r E s SKr F)�sql_code� map_resultsr c c s( t �| �s$|s$ttg �| d�V dS t | d�}|�� }|sRttdg�dd�V dS |srtt|�d�|�d�V dS d}dd� t|�D �}|D ]X}||kr�td�|||� �t|||� �d �V t|| t|| g�d �V |d }q�|t|�k �r$td�||t|�� �t||t|�� �d �V dS ) 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 s s* | ]"\}}|d d� � � dkr|V qd S )N� s CALL )�upper)r* �j�stmtr! r! r" � <genexpr>j r- z(split_multi_statement.<locals>.<genexpr>)ru rt r )r rD r r rh r1 � enumeraterZ )rr rs �tokZstmtsr^ Z partition_idsrx r! r! r" �split_multi_statement$ s@ & ���� ��r} )�scriptr c C sF t jdt�| �t jd�}|r,t|d �dkr4tg �S tdd� |D ��S )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))rb r@ r r � c S s g | ]}|d � d��qS )r ri )r. )r* �matchr! r! r" r, � r- z.get_local_infile_filenames.<locals>.<listcomp>)r/ �findallr ra � IGNORECASErZ r )r~ �matchesr! r! r" �get_local_infile_filenames� s �r� )F)rn r/ r9 � collectionsr �typingr r r �errorsr �typesr rd r' r0 r� � MULTILINEr �Pattern�__annotations__r rV rX r} rq r� r! r! r! r" �<module> sF � � b � � ]
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????