o
    ˜¨Êh 5  ã                   @   sP   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
dS )	é    ©ÚInet)Úsettings)ÚBaseDatabaseOperations©Úsplit_tzname_delta)Ú
OnConflictc                       sp  e Zd ZdZdZeg d¢ƒZddddœZdd	„ Zd
d„ Z	dSdd„Z
dd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ ZdSdd„Zdd „ Zd!d"„ ZdSd#d$„Zd%d&„ Zd'd(„ Zd)d*„ Zd+d,„ Zd-d-d.œd/d0„Zd1d2„ ZdTd3d4„Zd5d6„ Zd7d8„ Zd9d:„ Zd;d<„ Z d=d>„ Z!d?d@„ Z"dAdB„ Z#dCdD„ Z$dEdF„ Z%dGdH„ Z&dUdIdJ„Z'dKdL„ Z(‡ fdMdN„Z)dS‡ fdOdP„	Z*‡ fdQdR„Z+‡  Z,S )VÚDatabaseOperationsÚvarcharÚEXPLAIN)ÚANALYZEÚBUFFERSÚCOSTSÚSETTINGSÚSUMMARYÚTIMINGÚVERBOSEÚWALÚintegerÚbigintÚsmallint)Ú	AutoFieldÚBigAutoFieldÚSmallAutoFieldc                 C   s.   |  ¡ }|dv rd| | j¡ d¡d  S dS )N)ÚGenericIPAddressFieldÚIPAddressFieldÚ	TimeFieldÚ	UUIDFieldzCAST(%%s AS %s)ú(r   ú%s)Úget_internal_typeÚdb_typeÚ
connectionÚsplit)ÚselfÚoutput_fieldÚinternal_type© r'   úZ/var/www/html/env/lib/python3.10/site-packages/django/db/backends/postgresql/operations.pyÚunification_cast_sql   s
   ÿz'DatabaseOperations.unification_cast_sqlc                 C   sT   d|› d�}|}|dkrd|› d�}d}n|dkrd}n|dkr"d	}||g|¢R fS )
NzEXTRACT(%s FROM ú)Úweek_dayz) + 1ÚdowÚiso_week_dayÚisodowÚiso_yearÚisoyearr'   )r$   Úlookup_typeÚsqlÚparamsÚextract_sqlÚextract_paramr'   r'   r(   Údate_extract_sql2   s   z#DatabaseOperations.date_extract_sqlNc                 C   ó*   |   |||¡\}}d|› d�|g|¢R fS ©NúDATE_TRUNC(%s, r*   ©Ú_convert_sql_to_tz©r$   r1   r2   r3   Útznamer'   r'   r(   Údate_trunc_sql@   ó   z!DatabaseOperations.date_trunc_sqlc                 C   s6   t |ƒ\}}}|r|dkrdnd}|› |› |› �S |S )Nú+ú-r   )r$   r=   ÚsignÚoffsetr'   r'   r(   Ú_prepare_tzname_deltaE   s
   z(DatabaseOperations._prepare_tzname_deltac                 C   s4   |rt jr|  |¡}|› d�g |¢|‘R fS ||fS )Nz AT TIME ZONE %s)r   ÚUSE_TZrD   )r$   r2   r3   r=   Útzname_paramr'   r'   r(   r;   L   s   

z%DatabaseOperations._convert_sql_to_tzc                 C   ó"   |   |||¡\}}d|› d�|fS )Nr   z)::dater:   ©r$   r2   r3   r=   r'   r'   r(   Údatetime_cast_date_sqlR   ó   z)DatabaseOperations.datetime_cast_date_sqlc                 C   rG   )Nr   ú)::timer:   rH   r'   r'   r(   Údatetime_cast_time_sqlV   rJ   z)DatabaseOperations.datetime_cast_time_sqlc                 C   sB   |   |||¡\}}|dkrd|› d�ddg|¢R fS |  |||¡S ©NÚsecondzEXTRACT(%s FROM DATE_TRUNC(%s, z)))r;   r6   r<   r'   r'   r(   Údatetime_extract_sqlZ   s   
þz'DatabaseOperations.datetime_extract_sqlc                 C   r7   r8   r:   r<   r'   r'   r(   Údatetime_trunc_sqld   r?   z%DatabaseOperations.datetime_trunc_sqlc                 C   s0   |dkrd|› d�ddg|¢R fS |   |||¡S rM   )r6   )r$   r1   r2   r3   r'   r'   r(   Útime_extract_sqli   s
   
þz#DatabaseOperations.time_extract_sqlc                 C   r7   )Nr9   rK   r:   r<   r'   r'   r(   Útime_trunc_sqlr   s   z!DatabaseOperations.time_trunc_sqlc                 C   ó   dS )Nz DEFERRABLE INITIALLY DEFERREDr'   ©r$   r'   r'   r(   Údeferrable_sqlv   ó   z!DatabaseOperations.deferrable_sqlc                 C   s   |  ¡ S )z˜
        Given a cursor object that has just performed an INSERT...RETURNING
        statement into a table, return the tuple of returned data.
        )Úfetchall)r$   Úcursorr'   r'   r(   Úfetch_returned_insert_rowsy   s   z-DatabaseOperations.fetch_returned_insert_rowsc                 C   s@   d}|dv r|dv rd}n	|dv rd}nd}|dv rd	| }|S )
Nr   )	ÚiexactÚcontainsÚ	icontainsÚ
startswithÚistartswithÚendswithÚ	iendswithÚregexÚiregex)r   r   zHOST(%s))ÚCICharFieldÚCIEmailFieldÚCITextFieldz
%s::citextz%s::text)rZ   r\   r^   r`   z	UPPER(%s)r'   )r$   r1   r&   Úlookupr'   r'   r(   Úlookup_cast€   s   zDatabaseOperations.lookup_castc                 C   s   d S ©Nr'   rT   r'   r'   r(   Úno_limit_valueœ   rV   z!DatabaseOperations.no_limit_valuec                 C   s   |gS rh   r'   )r$   r2   r'   r'   r(   Úprepare_sql_scriptŸ   s   z%DatabaseOperations.prepare_sql_scriptc                 C   s    |  d¡r| d¡r|S d| S )Nú"z"%s")r]   r_   )r$   Únamer'   r'   r(   Ú
quote_name¢   s   zDatabaseOperations.quote_namec                 C   rS   )NzSET TIME ZONE %sr'   rT   r'   r'   r(   Úset_time_zone_sql§   rV   z$DatabaseOperations.set_time_zone_sqlF)Úreset_sequencesÚallow_cascadec                   sd   |sg S ˆ  d¡d ‡ ‡fdd„|D ƒ¡g}|r | ˆ  d¡¡ |r*| ˆ  d¡¡ dd |¡ gS )	NÚTRUNCATEú, c                 3   s    � | ]}ˆ  ˆ  |¡¡V  qd S rh   )Ú	SQL_FIELDrm   )Ú.0Útable©r$   Ústyler'   r(   Ú	<genexpr>²   s   € z/DatabaseOperations.sql_flush.<locals>.<genexpr>zRESTART IDENTITYÚCASCADEz%s;ú )ÚSQL_KEYWORDÚjoinÚappend)r$   rw   Útablesro   rp   Ú	sql_partsr'   rv   r(   Ú	sql_flushª   s   þzDatabaseOperations.sql_flushc              
   C   sR   g }|D ]"}|d }|d pd}|  d| d¡| |  |¡¡| |¡f ¡ q|S )Nru   ÚcolumnÚidz7%s setval(pg_get_serial_sequence('%s','%s'), 1, false);ÚSELECT)r}   r{   Ú	SQL_TABLErm   rs   )r$   rw   Ú	sequencesr2   Úsequence_infoÚ
table_nameÚcolumn_namer'   r'   r(   Úsequence_reset_by_name_sqlº   s   ýÿÿz-DatabaseOperations.sequence_reset_by_name_sqlc                 C   s    |r	d|   |¡ S d|   |¡ S )NzUSING INDEX TABLESPACE %szTABLESPACE %s)rm   )r$   Ú
tablespaceÚinliner'   r'   r(   Útablespace_sqlÍ   s   z!DatabaseOperations.tablespace_sqlc                 C   s®   ddl m} g }| j}|D ]G}|jjD ]@}t||jƒrS| d| d¡| 	||jj
ƒ¡| |j¡| ||jƒ¡| ||jƒ¡| d¡| d¡| 	||jj
ƒ¡f ¡  nqq|S )Nr   )ÚmodelszZ%s setval(pg_get_serial_sequence('%s','%s'), coalesce(max(%s), 1), max(%s) %s null) %s %s;rƒ   zIS NOTÚFROM)Ú	django.dbr�   rm   Ú_metaÚlocal_fieldsÚ
isinstancer   r}   r{   r„   Údb_tablers   r�   )r$   rw   Ú
model_listr�   ÚoutputÚqnÚmodelÚfr'   r'   r(   Úsequence_reset_sqlÓ   s.   
øþÿï€z%DatabaseOperations.sequence_reset_sqlc                 C   ó   |S rh   r'   )r$   Úxr'   r'   r(   Úprep_for_iexact_queryõ   rV   z(DatabaseOperations.prep_for_iexact_queryc                 C   rS   )a–  
        Return the maximum length of an identifier.

        The maximum length of an identifier is 63 by default, but can be
        changed by recompiling PostgreSQL after editing the NAMEDATALEN
        macro in src/include/pg_config_manual.h.

        This implementation returns 63, but can be overridden by a custom
        database backend that inherits most of its behavior from this one.
        é?   r'   rT   r'   r'   r(   Úmax_name_lengthø   s   z"DatabaseOperations.max_name_lengthc                 C   s0   |rdd„ |D ƒ}dd  |¡ g|fS dgg fS )Nc                 S   s   g | ]	}|D ]}|‘qqS r'   r'   )rt   Ú
param_listÚparamr'   r'   r(   Ú
<listcomp>  s    z3DatabaseOperations.distinct_sql.<locals>.<listcomp>zDISTINCT ON (%s)rr   ÚDISTINCT©r|   )r$   Úfieldsr3   r'   r'   r(   Údistinct_sql  s   
zDatabaseOperations.distinct_sqlc                 C   s   |j d ur
|j  ¡ S d S rh   )ÚqueryÚdecode)r$   rX   r2   r3   r'   r'   r(   Úlast_executed_query  s   

z&DatabaseOperations.last_executed_queryc                    s,   |sdS ‡ fdd„|D ƒ}dd  |¡ dfS )N)Ú r'   c                    s,   g | ]}d ˆ   |jjj¡ˆ   |j¡f ‘qS )z%s.%s)rm   r—   r�   r“   r�   ©rt   ÚfieldrT   r'   r(   r¡     s    û
þÿÿz<DatabaseOperations.return_insert_columns.<locals>.<listcomp>zRETURNING %srr   r'   r£   )r$   r¤   Úcolumnsr'   rT   r(   Úreturn_insert_columns  s   
úz(DatabaseOperations.return_insert_columnsc                 C   s*   dd„ |D ƒ}d  dd„ |D ƒ¡}d| S )Nc                 s   s   � | ]}d   |¡V  qdS )rr   Nr£   )rt   Úrowr'   r'   r(   rx   !  s   € z5DatabaseOperations.bulk_insert_sql.<locals>.<genexpr>rr   c                 s   ó   � | ]}d | V  qdS )z(%s)Nr'   )rt   r2   r'   r'   r(   rx   "  ó   € zVALUES r£   )r$   r¤   Úplaceholder_rowsÚplaceholder_rows_sqlÚ
values_sqlr'   r'   r(   Úbulk_insert_sql   s   z"DatabaseOperations.bulk_insert_sqlc                 C   rš   rh   r'   ©r$   Úvaluer'   r'   r(   Úadapt_datefield_value%  rV   z(DatabaseOperations.adapt_datefield_valuec                 C   rš   rh   r'   rµ   r'   r'   r(   Úadapt_datetimefield_value(  rV   z,DatabaseOperations.adapt_datetimefield_valuec                 C   rš   rh   r'   rµ   r'   r'   r(   Úadapt_timefield_value+  rV   z(DatabaseOperations.adapt_timefield_valuec                 C   rš   rh   r'   )r$   r¶   Ú
max_digitsÚdecimal_placesr'   r'   r(   Úadapt_decimalfield_value.  rV   z+DatabaseOperations.adapt_decimalfield_valuec                 C   s   |rt |ƒS d S rh   r   rµ   r'   r'   r(   Úadapt_ipaddressfield_value1  s   z-DatabaseOperations.adapt_ipaddressfield_valuec           	         sF   |dkr|\}}|\}}g |¢|¢R }d||f |fS t ƒ  |||¡S )NÚ	DateFieldz(interval '1 day' * (%s - %s)))ÚsuperÚsubtract_temporals)	r$   r&   ÚlhsÚrhsÚlhs_sqlÚ
lhs_paramsÚrhs_sqlÚ
rhs_paramsr3   ©Ú	__class__r'   r(   rÀ   6  s   z%DatabaseOperations.subtract_temporalsc                    sŠ   i }|r!dd„ |  ¡ D ƒ}| jD ]}| |d ¡}|d ur |||< qtƒ j|fi |¤Ž}|r1||d< |rC|dd dd„ |  ¡ D ƒ¡ 7 }|S )Nc                 S   s"   i | ]\}}|  ¡ |rd nd“qS )ÚtrueÚfalse)Úupper)rt   rl   r¶   r'   r'   r(   Ú
<dictcomp>B  s    ÿÿz;DatabaseOperations.explain_query_prefix.<locals>.<dictcomp>ÚFORMATz (%s)rr   c                 s   r¯   )z%s %sNr'   )rt   Úir'   r'   r(   rx   N  r°   z:DatabaseOperations.explain_query_prefix.<locals>.<genexpr>)ÚitemsÚexplain_optionsÚpopr¿   Úexplain_query_prefixr|   )r$   ÚformatÚoptionsÚextraÚvalid_optionr¶   ÚprefixrÇ   r'   r(   rÒ   >  s    þ
€ z'DatabaseOperations.explain_query_prefixc                    s\   |t jkrdS |t jkr%dd t| j|ƒ¡d dd„ t| j|ƒD ƒ¡f S tƒ  ||||¡S )NzON CONFLICT DO NOTHINGz ON CONFLICT(%s) DO UPDATE SET %srr   c                 S   s   g | ]	}|› d |› �‘qS )z = EXCLUDED.r'   rª   r'   r'   r(   r¡   X  s    ÿÿz=DatabaseOperations.on_conflict_suffix_sql.<locals>.<listcomp>)r   ÚIGNOREÚUPDATEr|   Úmaprm   r¿   Úon_conflict_suffix_sql)r$   r¤   Úon_conflictÚupdate_fieldsÚunique_fieldsrÇ   r'   r(   rÛ   Q  s"   


þÿþ	üz)DatabaseOperations.on_conflict_suffix_sqlrh   )F)NN)-Ú__name__Ú
__module__Ú__qualname__Ú"cast_char_field_without_max_lengthÚexplain_prefixÚ	frozensetrÐ   Úcast_data_typesr)   r6   r>   rD   r;   rI   rL   rO   rP   rQ   rR   rU   rY   rg   ri   rj   rm   rn   r€   r‰   rŒ   r™   rœ   rž   r¥   r¨   r­   r´   r·   r¸   r¹   r¼   r½   rÀ   rÒ   rÛ   Ú__classcell__r'   r'   rÇ   r(   r	   	   s\    ÿý


	

"
r	   N)Úpsycopg2.extrasr   Údjango.confr   Ú"django.db.backends.base.operationsr   Údjango.db.backends.utilsr   Údjango.db.models.constantsr   r	   r'   r'   r'   r(   Ú<module>   s    