o
    ¨D®f’  ã                   @  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 erœ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& G dd„ deƒZ'eedƒd(d&d'„ƒZ(dS ))é    )ÚannotationsN)ÚAny)ÚDict)ÚOptional)ÚTYPE_CHECKING)ÚUnion)Úcast)ÚJSON)Úschema)Úsqlé   )Úalter_table)Úformat_table_name)ÚRenameTable)ÚDefaultImplé   )Úutil)Úcompiles)Ú	Inspector)ÚDDLCompiler)ÚCast)ÚClauseElement)ÚColumn)Ú
Constraint)ÚTable)Ú
TypeEngine)ÚBatchOperationsImplc                      sz   e Zd ZdZdZ	 d1dd„Zd2dd„Zd2dd„Zd3dd„Zd4dd„Z	d5d!d"„Z
	d6d7‡ fd&d'„Zd8d-d.„Zd/d0„ Z‡  ZS )9Ú
SQLiteImplÚsqliteFÚbatch_opr   ÚreturnÚboolc                 C  s~   |j D ]9}|d dkr3|d d }t|jtjƒr#t|jjtjƒr# dS t|jtj	j
ƒr2|jjr2 dS q|d dvr< dS qdS )zÿReturn True if the given :class:`.BatchOperationsImpl`
        would need the table to be recreated and copied in order to
        proceed.

        Normally, only returns True on SQLite when operations other
        than add_column are present.

        r   Ú
add_columnr   T)Úcreate_indexÚ
drop_indexF)ÚbatchÚ
isinstanceÚserver_defaultr
   ÚDefaultClauseÚargr   r   r   Úsqla_compatÚComputedÚ	persisted)Úselfr   ÚopÚcol© r0   úK/home/ubuntu/webapp/venv/lib/python3.10/site-packages/alembic/ddl/sqlite.pyÚrequires_recreate_in_batch.   s&   
ÿþÿþ€ÿz%SQLiteImpl.requires_recreate_in_batchÚconstr   c                 C  s.   |j d u r	tdƒ‚|  | ¡rt d¡ d S d S )Nú No support for ALTER of constraints in SQLite dialect. Please refer to the batch mode feature which allows for SQLite migrations using a copy-and-move strategy.z©Skipping unsupported ALTER for creation of implicit constraint. Please refer to the batch mode feature which allows for SQLite migrations using a copy-and-move strategy.)Ú_create_ruleÚNotImplementedErrorr   Úwarn©r-   r3   r0   r0   r1   Úadd_constraintJ   s   
ÿ
ÿÿzSQLiteImpl.add_constraintc                 C  s   |j d u r	tdƒ‚d S )Nr4   )r5   r6   r8   r0   r0   r1   Údrop_constraint[   s
   
ÿÿzSQLiteImpl.drop_constraintÚinspector_columnúColumn[Any]Úmetadata_columnÚrendered_metadata_defaultúOptional[str]Úrendered_inspector_defaultc                 C  sP   |d urt  dd|¡}t  dd|¡}|d ur$t  dd|¡}t  dd|¡}||kS )Nz
^\((.+)\)$z\1z^\"?'(.+)'\"?$)ÚreÚsub)r-   r;   r=   r>   r@   r0   r0   r1   Úcompare_server_defaultc   s   ÿÿÿÿz!SQLiteImpl.compare_server_defaultÚexprc                 C  s<   |sdS t  d|¡rdS t  d|¡rdS t  d|¡rdS dS )a  Determine if a server default is a SQL expression or a constant.

        There are too many assertions that expect server defaults to round-trip
        identically without parenthesis added so we will add parens only in
        very specific cases.

        Fz	^[0-9\.]$z^'.+'$z^\(.+\)$T)rA   Úmatch)r-   rD   r0   r0   r1   Ú-_guess_if_default_is_unparenthesized_sql_expr~   s   
z8SQLiteImpl._guess_if_default_is_unparenthesized_sql_exprÚ	inspectorr   Útabler   Úcolumn_infoúDict[str, Any]ÚNonec                 C  s,   |   | dd ¡¡rd|d f |d< d S d S )NÚdefaultú(%s))rF   Úget)r-   rG   rH   rI   r0   r0   r1   Úautogen_column_reflect“   s
   
ÿýz!SQLiteImpl.autogen_column_reflectr   Úis_server_defaultÚstrc                   s4   t ƒ j|fd|i|¤Ž}|r|  |¡rd|f }|S )NrP   rM   )ÚsuperÚrender_ddl_sql_exprrF   )r-   rD   rP   ÚkwÚstr_expr©Ú	__class__r0   r1   rS       s   ÿÿÿÿþ
zSQLiteImpl.render_ddl_sql_exprÚexistingÚexisting_transferú"Dict[str, Union[TypeEngine, Cast]]Únew_typer   c                 C  s6   |j j|jurt|tƒst|d |ƒ|d< d S d S d S )NrD   )ÚtypeÚ_type_affinityr&   r	   r   )r-   rX   rY   r[   r0   r0   r1   Úcast_for_batch_migrate°   s   ÿÿýz!SQLiteImpl.cast_for_batch_migratec                 C  s   |   ||¡ d S )N)Ú_skip_functional_indexes)r-   Úconn_unique_constraintsÚconn_indexesÚmetadata_unique_constraintsÚmetadata_indexesr0   r0   r1   Úcorrect_for_autogen_constraints¾   s   z*SQLiteImpl.correct_for_autogen_constraints)r   r   r    r!   )r3   r   )
r;   r<   r=   r<   r>   r?   r@   r?   r    r!   )rD   r?   r    r!   )rG   r   rH   r   rI   rJ   r    rK   )F)rD   r   rP   r!   r    rQ   )rX   r<   rY   rZ   r[   r   r    rK   )Ú__name__Ú
__module__Ú__qualname__Ú__dialect__Útransactional_ddlr2   r9   r:   rC   rF   rO   rS   r^   rd   Ú__classcell__r0   r0   rV   r1   r   &   s    





ÿ
r   r   Úelementr   Úcompilerr   r    rQ   c                 K  s"   dt || j| jƒt|| jd ƒf S )Nz%s RENAME TO %s)r   Ú
table_namer
   r   Únew_table_name)rk   rl   rT   r0   r0   r1   Úvisit_rename_tableÈ   s   þro   )rk   r   rl   r   r    rQ   ))Ú
__future__r   rA   Útypingr   r   r   r   r   Ú
sqlalchemyr   r	   r
   r   Úbaser   r   r   Úimplr   Ú r   Úutil.sqla_compatr   Úsqlalchemy.engine.reflectionr   Úsqlalchemy.sql.compilerr   Úsqlalchemy.sql.elementsr   r   Úsqlalchemy.sql.schemar   r   r   Úsqlalchemy.sql.type_apir   Úoperations.batchr   r   ro   r0   r0   r0   r1   Ú<module>   s>    #