a
    •˜ëjŒ`  ã                
   @  sÞ  d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlm	Z	 d d	lm
Z
 d d
lmZ d dlmZ d dlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ e�rddlmZ ddlmZ ddlmZ G dd„ dƒZG dd„ dƒZ dZ!e	dd d!d"œd#d$„ƒZ"e	dDdd%d&d"œd'd$„ƒZ"dEdd(d)d"œd*d$„Z"dd+d,œd-d.„Z#d/d0d1œd2d3„Z$ddd4œd5d6„Z%d7d8d9d:d;d<d=d>d?d@œ	Z&e 'dA (dBdC„ e&D ƒ¡¡Z)dS )Fé    )ÚannotationsN)ÚAny)ÚCallable)ÚDict)ÚList)ÚOptional)Úoverload)ÚSequence)ÚTuple)ÚTYPE_CHECKING)ÚUnioné   )ÚENUM)ÚSET)ÚDATETIME)ÚTIME)Ú	TIMESTAMPé   )Útypes)Úutil)ÚLiteral)ÚMySQLDialect)ÚMySQLIdentifierPreparer)ÚReflectedColumnc                   @  s(   e Zd ZU dZded< ddœdd„ZdS )	ÚReflectedStatez;Stores raw information about a SHOW CREATE TABLE statement.úOptional[str]ÚcharsetÚNone©Úreturnc                 C  s(   g | _ i | _d | _g | _g | _g | _d S ©N)ÚcolumnsÚtable_optionsÚ
table_nameÚkeysÚfk_constraintsÚck_constraints)Úself© r(   úc/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/reflection.pyÚ__init__)   s    zReflectedState.__init__N)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ú__annotations__r*   r(   r(   r(   r)   r   $   s   
r   c                   @  s  e Zd ZdZdddœdd„Zddd	d
œdd„Zdddœdd„Zdddœdd„Zdd	ddœdd„Zdd	ddœdd„Z	dd	ddœdd„Z
dd	ddœdd„Zdddd œd!d"„Zdd#d$œd%d&„Zdd'œd(d)„Zd*Zddd+œd,d-„Zddd+œd.d/„Zddd+œd0d1„Zdddd2œd3d4„Zd5S )6ÚMySQLTableDefinitionParserz4Parses the results of a SHOW CREATE TABLE statement.r   r   )ÚdialectÚpreparerc                 C  s   || _ || _|  ¡  d S r    )r1   r2   Ú_prep_regexes)r'   r1   r2   r(   r(   r)   r*   5   s    z#MySQLTableDefinitionParser.__init__Ústrr   r   )Úshow_creater   r   c                 C  s   t ƒ }||_t d|¡D ]â}| d| jj ¡r<|  ||¡ q| d¡rT|  ||¡ q|dkr^q| d¡rv|  	||¡ qd|v rŒ|  
||¡ q|s’q|  |¡\}}|d u r¸t d| ¡ q|dkrÎ|j |¡ q|d	krä|j |¡ q|d
kr|j |¡ qq|S )Nz\r?\nz  z) ú)zCREATE Ú	PARTITIONzUnknown schema content: %rÚkeyÚfk_constraintÚck_constraint)r   r   ÚreÚsplitÚ
startswithr2   Úinitial_quoteÚ_parse_columnÚ_parse_table_optionsÚ_parse_table_nameÚ_parse_partition_optionsÚ_parse_constraintsr   Úwarnr$   Úappendr%   r&   )r'   r5   r   ÚstateÚlineÚtype_Úspecr(   r(   r)   Úparse<   s4    

z MySQLTableDefinitionParser.parseÚbool)Úsqlr   c                 C  s   t | j |¡ƒS r    )rK   Ú_re_is_viewÚmatch)r'   rL   r(   r(   r)   Ú_check_view`   s    z&MySQLTableDefinitionParser._check_viewz‚Union[Tuple[None, str], Tuple[Literal['partition'], str], Tuple[Literal['ck_constraint', 'fk_constraint', 'key'], Dict[str, str]]])rG   r   c                 C  s:  | j  |¡}|rŠ| ¡ }|  |d ¡|d< |d rb| j |d ¡}|rb| ¡ d rb| ¡ d |d< |d r‚| j |d ¡d |d< d|fS | j |¡}|rö| ¡ }| j |d ¡|d< dd„ |  |d	 ¡D ƒ|d	< d
d„ |  |d ¡D ƒ|d< d|fS | j |¡}|�r| ¡ }d|fS | j	 |¡}|�r2d|fS d|fS )zaParse a KEY or CONSTRAINT line.

        :param line: A line of SHOW CREATE TABLE output
        r!   Zversion_sqlÚparserr   r8   Útablec                 S  s   g | ]}|d  ‘qS ©r   r(   ©Ú.0Úcr(   r(   r)   Ú
<listcomp>†   ó    zAMySQLTableDefinitionParser._parse_constraints.<locals>.<listcomp>Úlocalc                 S  s   g | ]}|d  ‘qS rR   r(   rS   r(   r(   r)   rV   ‡   s   Zforeignr9   r:   Ú	partitionN)
Ú_re_keyrN   Ú	groupdictÚ_parse_keyexprsÚ_re_key_version_sqlr2   Zunformat_identifiersÚ_re_fk_constraintÚ_re_ck_constraintÚ_re_partition)r'   rG   ÚmrI   Úm2r(   r(   r)   rC   c   s@    ÿþÿ
z-MySQLTableDefinitionParser._parse_constraintsr   )rG   rF   r   c                 C  s,   | j \}}| |¡}|r(|| d¡ƒ|_dS )zZExtract the table name.

        :param line: The first line of SHOW CREATE TABLE
        ÚnameN)Ú_pr_namerN   Úgroupr#   )r'   rG   rF   ÚregexÚcleanupra   r(   r(   r)   rA   ›   s    

z,MySQLTableDefinitionParser._parse_table_namec                 C  s°   i }|rn|dkrn|}| j D ]R\}}| |¡}|s2q| d¡| d¡ }}	|rT||	ƒ}	|	|| ¡ < | d|¡}qdD ]}
| |
d¡ qr| ¡ D ]\}}||jd| jj	|f < qŒdS )zƒBuild a dictionary of all reflected table-level options.

        :param line: The final line of SHOW CREATE TABLE output.
        r6   Ú	directiveÚvalÚ )Úauto_incrementzdata directoryzindex directoryNú%s_%s)
Ú_pr_optionsÚsearchre   ÚlowerÚsubÚpopÚitemsr"   r1   rc   )r'   rG   rF   ÚoptionsZrest_of_linerf   rg   ra   rh   ÚvalueZnopeÚoptri   r(   r(   r)   r@   ¦   s     
z/MySQLTableDefinitionParser._parse_table_optionsc                 C  sÊ  i }|d d … }|  d¡s$|  d¡r2|dd … }q| jD �]\}}| |¡}|r8d|jvr\q8| d¡}| ¡ }|dk}	|dks„|	�r
| dd	¡}| d
d	¡}|	r¶| d¡r¶|d d… }| jj	dkrð| d¡rðd|v säd|v säd|v rð|d d… }d| jj	|f }
|||
< n,| dd¡}| d¡}|�r.||ƒ}|||<  �q>q8| 
¡ D ]~\}}d| jj	 }d| jj	 }||k�sz||k�r¬||jv�r’||j|< nd|j| |f |j|< n||jd| jj	|f < �qFd S )Nú(ú r   r7   rh   ZsubpartitionrY   z) */rj   ú,r6   éÿÿÿÿZmariadbZMAXVALUEZMINVALUEÚENGINEz%s_%s_definitionsÚ_ri   z%s_partition_definitionsz%s_subpartition_definitionsz%s, %srl   )r=   rm   rn   Úpatternre   ro   ÚreplaceÚendswithr1   rc   rr   r"   )r'   rG   rF   rs   Únew_linerf   rg   ra   rh   Zis_subpartitionZdefsrt   ru   ri   Zpart_defZsubpart_defr(   r(   r)   rB   À   sV    

ÿþý

þz3MySQLTableDefinitionParser._parse_partition_optionsc                 C  sì  d}| j  |¡}|r&| ¡ }d|d< n | j |¡}|rF| ¡ }d|d< |s\t d| ¡ dS |d srt d| ¡ |d |d |d	   }}}z| jj| }W n* tyÈ   t d
||f ¡ t	j
}Y n0 |du sÚ|dkràg }	n@|d dk�r
|d dk�r
| j |¡}	ndd„ | j |¡D ƒ}	i }
t|tttfƒ�rJ|	�rJ|	 d¡|
d< dD ]}| |d¡�rNd|
|< �qNdD ] }| |d¡�rp|| |
|< �qpt|ttfƒ�rÈt|	ƒ}	t|tƒ�rÈd|	v �rÈd|
d< ||	i |
¤Ž}i }d|d< | dd¡dk�rüd|d< | dd¡dk�rd|d< | dd¡�r.d|d< nt|t	jƒ�rDd|d< | dd¡}|dk�r^d}| dd¡}|du�r|t|ƒ}| d¡}|du�rÂt|d�}| d ¡}|du�rº|d!k|d"< ||d#< t||||d$�}| |¡ |j |¡ dS )%z­Extract column details.

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

        :param line: Any column-bearing line from SHOW CREATE TABLE
        NTÚfullFzUnknown column definition %rz-Incomplete reflection of column definition %rrc   ZcoltypeÚargz*Did not recognize type '%s' of column '%s'rj   r   ú'ry   c                 S  s   g | ]}t |ƒ‘qS r(   ©Úint)rT   Úvr(   r(   r)   rV   "  rW   z<MySQLTableDefinitionParser._parse_column.<locals>.<listcomp>Zfsp)ZunsignedZzerofill)r   ZcollateZretrieve_as_bitwiseÚnullableZnotnullúNOT NULLZnotnull_generatedZautoincrZautoincrementÚdefaultÚNULLÚcommentÚ	generated)ÚsqltextZpersistenceZSTOREDÚ	persistedÚcomputed)rc   Útyperˆ   rŠ   )Ú
_re_columnrN   r[   Ú_re_column_looser   rD   r1   Zischema_namesÚKeyErrorÚsqltypesZNullTypeÚ_re_csv_strÚfindallÚ_re_csv_intÚ
issubclassr   r   r   rq   Úgetr   r   Ú_strip_valuesZIntegerÚcleanup_textÚdictÚupdater!   rE   )r'   rG   rF   rI   ra   rc   rH   ÚargsÚcol_typeZ	type_argsZtype_kwÚkwZtype_instanceZcol_kwrˆ   rŠ   rŒ   rŽ   r�   Zcol_dr(   r(   r)   r?   ú   sŒ    

ÿ







ÿ
z(MySQLTableDefinitionParser._parse_columnz-Sequence[Tuple[str, str, str, str, str, str]])r#   r!   r   c           
        s  g }|D ]ä‰ ‡ fdd„dD ƒ\}}}}}dg}	|	  | j |¡¡ |	  |¡ |sX|	  d¡ |rÎd|v rfnh| d¡r�| d¡r�|	  d	¡ |	  |¡ n>|d
kr®|	  d	¡ |	  |¡ n |	  d	¡ |	  d| dd¡ ¡ |rÜ|	  |¡ |  d |	¡¡ qd d| j |¡ d |¡dg¡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                 3  s   | ]}ˆ | V  qd S r    r(   )rT   Úi©Úrowr(   r)   Ú	<genexpr>v  s   zAMySQLTableDefinitionParser._describe_to_create.<locals>.<genexpr>)r   r   é   é   é   rw   r‡   rk   Ú	timestampÚCÚDEFAULTr‰   z'%s'r‚   ú''rj   zCREATE TABLE %s (
z,
z
) )rE   r2   Zquote_identifierr=   r}   Újoin)
r'   r#   r!   Úbufferrc   rž   r†   rˆ   ÚextrarG   r(   r¡   r)   Ú_describe_to_created  sD    
ÿ

ÿ




ÿúÿz.MySQLTableDefinitionParser._describe_to_createz$List[Tuple[str, Optional[int], str]])Úidentifiersr   c                 C  s   dd„ | j  |¡D ƒS )z8Unpack '"col"(2),"col" ASC'-ish strings into components.c                 S  s(   g | ] \}}}||rt |ƒnd |f‘qS r    rƒ   )rT   ZcolnameÚlengthÚ	modifiersr(   r(   r)   rV   ¢  s   ÿz>MySQLTableDefinitionParser._parse_keyexprs.<locals>.<listcomp>)Ú_re_keyexprsr•   )r'   r¯   r(   r(   r)   r\   �  s
    ÿþz*MySQLTableDefinitionParser._parse_keyexprsr   c              	   C  sH  g | _ | jj}ttddd„ | jj|| j |¡fD ƒƒƒ}td| | jjƒ| _	t
dƒ| _t
d| ƒ| _t
dƒ| _t
dƒ| _t
d	| ƒ| _t
d
| ƒ| _t
d| ƒ| _t
dƒ| _| ¡ }d|d< t
d| ƒ| _t
d| ƒ| _t
dƒ| _tD ]}|  |¡ qædD ]}|  |¡ qúdD ]}|  |¡ �q|  dd¡ |  dd¡ |  dd¡ dS )z Pre-compile regular expressions.)ZiqZfqZesc_fqc                 S  s   g | ]}t  |¡‘qS r(   ©r;   Úescape)rT   Úsr(   r(   r)   rV   µ  s   ÿz<MySQLTableDefinitionParser._prep_regexes.<locals>.<listcomp>zM^CREATE (?:\w+ +)?TABLE +%(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +\($z^CREATE(?! TABLE)(\s.*)?\sVIEWzW(?:(?:%(iq)s((?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)(?:\((\d+)\))?(?: +(ASC|DESC))?(?=\,|$))+z\x27(?:\x27\x27|[^\x27])*\x27z\d+a¸    %(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P<coltype>\w+)(?:\((?P<arg>(?:\d+|\d+,\d+|(?:'(?:''|[^'])*',?)+))\))?(?: +(?P<unsigned>UNSIGNED))?(?: +(?P<zerofill>ZEROFILL))?(?: +CHARACTER SET +(?P<charset>[\w_]+))?(?: +COLLATE +(?P<collate>[\w_]+))?(?: +(?P<notnull>(?:NOT )?NULL))?(?: +DEFAULT +(?P<default>(?:NULL|'(?:''|[^'])*'|\(.+?\)|[\-\w\.\(\)]+(?: +ON UPDATE [\-\w\.\(\)]+)?)))?(?: +(?:GENERATED ALWAYS)? ?AS +(?P<generated>\(.*\))? ?(?P<persistence>VIRTUAL|STORED)?(?: +(?P<notnull_generated>(?:NOT )?NULL))?)?(?: +(?P<autoincr>AUTO_INCREMENT))?(?: +COMMENT +'(?P<comment>(?:''|[^'])*)')?(?: +COLUMN_FORMAT +(?P<colfmt>\w+))?(?: +STORAGE +(?P<storage>\w+))?(?: +(?P<extra>.*))?,?$zŸ  %(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P<coltype>\w+)(?:\((?P<arg>(?:\d+|\d+,\d+|\x27(?:\x27\x27|[^\x27])+\x27))\))?.*?(?P<notnull>(?:NOT )NULL)?aX    (?:(?P<type>\S+) )?KEY(?: +%(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)?(?: +USING +(?P<using_pre>\S+))? +\((?P<columns>.+?)\)(?: +USING +(?P<using_post>\S+))?(?: +KEY_BLOCK_SIZE *[ =]? *(?P<keyblock>\S+))?(?: +WITH PARSER +(?P<parser>\S+))?(?: +COMMENT +(?P<comment>(\x27\x27|\x27([^\x27])*?\x27)+))?(?: +/\*(?P<version_sql>.+)\*/ *)?,?$z+\!\d+ (?: *WITH PARSER +(?P<parser>\S+) *)?z/RESTRICT|CASCADE|SET NULL|NO ACTION|SET DEFAULTÚonaJ    CONSTRAINT +%(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +FOREIGN KEY +\((?P<local>[^\)]+?)\) REFERENCES +(?P<table>%(iq)s[^%(fq)s]+%(fq)s(?:\.%(iq)s[^%(fq)s]+%(fq)s)?) +\((?P<foreign>(?:%(iq)s[^%(fq)s]+%(fq)s(?: *, *)?)+)\)(?: +(?P<match>MATCH \w+))?(?: +ON DELETE (?P<ondelete>%(on)s))?(?: +ON UPDATE (?P<onupdate>%(on)s))?z[  CONSTRAINT +%(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +CHECK +\((?P<sqltext>.+)\),?z(?:.*)(?:SUB)?PARTITION(?:.*))rz   ZTYPEZAUTO_INCREMENTZAVG_ROW_LENGTHzCHARACTER SETzDEFAULT CHARSETZCHECKSUMZCOLLATEZDELAY_KEY_WRITEZINSERT_METHODZMAX_ROWSZMIN_ROWSZ	PACK_KEYSZ
ROW_FORMATZKEY_BLOCK_SIZEZSTATS_SAMPLE_PAGES)úPARTITION BYúSUBPARTITION BYÚ
PARTITIONSÚSUBPARTITIONSr7   ZSUBPARTITIONZUNIONz
\([^\)]+\)Z
TABLESPACEz.*? STORAGE DISKZ	RAID_TYPEz4\w+\s+RAID_CHUNKS\s*\=\s*\w+RAID_CHUNKSIZE\s*=\s*\w+N)rm   r2   Zfinal_quoter›   Úzipr>   Z_escape_identifierÚ_pr_compileZ_unescape_identifierrd   Ú_re_compilerM   r²   r”   r–   r�   r‘   rZ   r]   Úcopyr^   r_   r`   Ú_options_of_type_stringÚ_add_option_stringÚ_add_option_wordÚ_add_partition_option_wordÚ_add_option_regex)r'   Z_finalÚquotesrŸ   Úoptionr(   r(   r)   r3   ©  sŽ    þ
ýþþÿÿý
þÿ

éÿüÿ
öÿÿ

öÿüÿ
þz(MySQLTableDefinitionParser._prep_regexesz(?:\s*(?:=\s*)|\s+))rh   r   c                 C  s*   dt  |¡| jf }| j t|tƒ¡ d S )Nz0(?P<directive>%s)%s'(?P<val>(?:[^']|'')*?)'(?!'))r;   r´   Ú_optional_equalsrm   rE   r¼   rš   ©r'   rh   rf   r(   r(   r)   rÀ   k  s
    þz-MySQLTableDefinitionParser._add_option_stringc                 C  s(   dt  |¡| jf }| j t|ƒ¡ d S )Nz(?P<directive>%s)%s(?P<val>\w+)©r;   r´   rÆ   rm   rE   r¼   rÇ   r(   r(   r)   rÁ   r  s
    þz+MySQLTableDefinitionParser._add_option_wordc                 C  sp   |dks|dkr&dt  |¡| jf }n6|dks6|dkrLdt  |¡| jf }ndt  |¡f }| j t|ƒ¡ d S )Nr·   r¸   z((?<!\S)(?P<directive>%s)%s(?P<val>\w+.*)rº   r¹   z&(?<!\S)(?P<directive>%s)%s(?P<val>\d+)z(?<!\S)(?P<directive>%s)(?!\S)rÈ   rÇ   r(   r(   r)   rÂ   y  s    þþz5MySQLTableDefinitionParser._add_partition_option_word)rh   rf   r   c                 C  s*   dt  |¡| j|f }| j t|ƒ¡ d S )Nz(?P<directive>%s)%s(?P<val>%s)rÈ   rÇ   r(   r(   r)   rÃ   ˆ  s    ýz,MySQLTableDefinitionParser._add_option_regexN)r+   r,   r-   r.   r*   rJ   rO   rC   rA   r@   rB   r?   r®   r\   r3   rÆ   rÀ   rÁ   rÂ   rÃ   r(   r(   r(   r)   r0   2   s$   $8:j9 Ar0   )ÚCOMMENTzDATA DIRECTORYzINDEX DIRECTORYZPASSWORDZ
CONNECTIONr4   zCallable[[str], str]z,Tuple[re.Pattern[Any], Callable[[str], str]])rf   rg   r   c                 C  s   d S r    r(   ©rf   rg   r(   r(   r)   r¼   š  s    r¼   r   zTuple[re.Pattern[Any], None]c                 C  s   d S r    r(   rÊ   r(   r(   r)   r¼      s    zOptional[Callable[[str], str]]z6Tuple[re.Pattern[Any], Optional[Callable[[str], str]]]c                 C  s   t | ƒ|fS )z1Prepare a 2-tuple of compiled regex and callable.)r½   rÊ   r(   r(   r)   r¼   ¦  s    zre.Pattern[Any])rf   r   c                 C  s   t  | t jt jB ¡S )z)Compile a string to regex, I and UNICODE.)r;   ÚcompileÚIÚUNICODE)rf   r(   r(   r)   r½   ®  s    r½   zSequence[str]z	List[str])Úvaluesr   c                 C  s\   g }| D ]N}|dd… dks,|dd… dkrL|dd…   |d d |d ¡}| |¡ q|S )zStrip reflected values quotesr   r   ú"r‚   ry   r¤   )r}   rE   )rÎ   Zstrip_valuesÚar(   r(   r)   r™   ´  s      r™   )Úraw_textr   c                 C  s&   d| v rt  tdd„ | ¡} |  dd¡S )Nú\c                 S  s   t | d  S )Nr   )Ú_control_char_map)rµ   r(   r(   r)   Ú<lambda>Ã  rW   zcleanup_text.<locals>.<lambda>rª   r‚   )r;   rp   Ú_control_char_regexpr}   )rÑ   r(   r(   r)   rš   ¿  s    ýrš   rÒ   ú úúú	Ú
úúú)	z\\z\0z\az\bz\tz\nz\vz\fz\rú|c                 c  s   | ]}t  |¡V  qd S r    r³   )rT   Úkr(   r(   r)   r£   Ö  rW   r£   )N)N)*Ú
__future__r   r;   Útypingr   r   r   r   r   r   r	   r
   r   r   Z
enumeratedr   r   r   r   r   r   rj   r“   r   Zutil.typingr   Úbaser   r   Zengine.interfacesr   r   r0   r¿   r¼   r½   r™   rš   rÓ   rË   r«   rÕ   r(   r(   r(   r)   Ú<module>   sj       c	 ÿ ÿ÷ÿ