Ë
    ¹ûàg8u  ã                   óö   — d dl Z d dlZd dlmZ d dlmZ d dlmZmZ d dl	m
Z
 d dlmZmZmZ d dlmZmZmZmZ d dlmZ d d	lmZ d d
lmZ d dlmZmZ d dlmZ d dlm Z  ddl!m"Z" ddl#m$Z$m%Z%m&Z&  G d„ de
«      Z'y)é    N)Ú	lru_cache)Úsettings)ÚDatabaseErrorÚNotSupportedError)ÚBaseDatabaseOperations)Úsplit_tzname_deltaÚstrip_quotesÚtruncate_name)Ú	AutoFieldÚExistsÚExpressionWrapperÚLookup)ÚRawSQL)Ú	WhereNode)Útimezone)Úforce_bytesÚ	force_str)Úcached_property)Ú_lazy_re_compileé   )ÚDatabase)ÚBulkInsertMapperÚ	InsertVarÚOracle_datetimec            
       ó  ‡ — e Zd Zddddddddddœ	Zi ej
                  ¥ddi¥Zd	Zd
ZdddedœZd„ Z	 e
d«      Zd„ ZdId„Z e
d«      Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ ZdId„Zˆ fd„Zd„ Zd„ Zd„ Zd „ Zd!„ Zd"„ Zd#„ Zed$„ «       Z ed%„ «       Z!d&„ Z"d'„ Z#d(„ Z$d)„ Z%d*„ Z&d+„ Z'dId,„Z(d-„ Z)d.„ Z*d/„ Z+d0„ Z,d1„ Z-d2„ Z.d3„ Z/d4„ Z0d5„ Z1e2d6„ «       Z3d7d7d8œd9„Z4d:„ Z5d;„ Z6d<„ Z7dJd=„Z8d>„ Z9d?„ Z:d@„ Z;dKdA„Z<ˆ fdB„Z=dC„ Z>dD„ Z?dE„ Z@ˆ fdF„ZAdG„ ZBdH„ ZCˆ xZDS )LÚDatabaseOperations)lýÿÿÿÿgí] ì   ÿgí] )lûÿÿÿÿÏ9V ì   ÿÏ9V )r   r   )r   r   )iayþÿiŸ† )	ÚSmallIntegerFieldÚIntegerFieldÚBigIntegerFieldÚPositiveBigIntegerFieldÚPositiveSmallIntegerFieldÚPositiveIntegerFieldÚSmallAutoFieldr   ÚBigAutoFieldÚ
differenceÚMINUSaï  
DECLARE
    table_value integer;
    seq_value integer;
    seq_name user_tab_identity_cols.sequence_name%%TYPE;
BEGIN
    BEGIN
        SELECT sequence_name INTO seq_name FROM user_tab_identity_cols
        WHERE  table_name = '%(table_name)s' AND
               column_name = '%(column_name)s';
        EXCEPTION WHEN NO_DATA_FOUND THEN
            seq_name := '%(no_autofield_sequence_name)s';
    END;

    SELECT NVL(MAX(%(column)s), 0) INTO table_value FROM %(table)s;
    SELECT NVL(last_number - cache_size, 0) INTO seq_value FROM user_sequences
           WHERE sequence_name = seq_name;
    WHILE table_value > seq_value LOOP
        EXECUTE IMMEDIATE 'SELECT "'||seq_name||'".nextval%(suffix)s'
        INTO seq_value;
    END LOOP;
END;
/zNVARCHAR2(2000)z
NUMBER(11)z
NUMBER(19)z	NUMBER(5))r   r&   r%   Ú	TextFieldc                 ó6   — | j                  d«      }d|› d|› d�S )NÚ	cache_keyzSELECT z FROM %s ORDER BY z( OFFSET %%s ROWS FETCH FIRST 1 ROWS ONLY©Ú
quote_name)Úselfr+   s     úb/var/www/skyplay_api_hub/venv/lib/python3.12/site-packages/django/db/backends/oracle/operations.pyÚcache_key_culling_sqlz(DatabaseOperations.cache_key_culling_sqlH   s/   € Ø—O‘O KÓ0ˆ	à�i�[ð !à!�{Ð"JðLð	
ó    z[A-Z_]+c                 ó  — d|› d�}d }|dk(  rd}nj|dk(  r	d|› d�}d}n\|dk(  rd}nT|d	k(  rd
}nL|dk(  rd}nD|j                  «       }| j                  j                  |«      st        d|›�«      ‚d|› d|› d�|fS |g |¢|‘­fS )NzTO_CHAR(ú, %s)Úweek_dayÚDÚiso_week_dayz	 - 1, %s)ÚweekÚIWÚquarterÚQÚiso_yearÚIYYYzInvalid loookup type: zEXTRACT(z FROM ú))ÚupperÚ_extract_format_reÚ	fullmatchÚ
ValueError)r.   Úlookup_typeÚsqlÚparamsÚextract_sqlÚextract_params         r/   Údate_extract_sqlz#DatabaseOperations.date_extract_sqlS   sÉ   € Ø    UÐ+ˆØˆØ˜*Ò$à‰MØ˜NÒ*Ø$ S E¨Ð3ˆKØ‰MØ˜FÒ"à ‰MØ˜IÒ%Ø‰MØ˜JÒ&Ø"‰Mà%×+Ñ+Ó-ˆKØ×*Ñ*×4Ñ4°[ÔAÜ Ð#9¸+¸Ð!IÓJÐJà˜k˜]¨&°°°QÐ7¸Ð?Ð?ØÐ4˜fÐ4 mÑ4Ð4Ð4r1   c                 ó¦   — | j                  |||«      \  }}d }|dv r|j                  «       }n|dk(  rd}n|dk(  rd}nd|› d�|fS d|› d�g |¢|‘­fS )	N©ÚyearÚmonthr9   r:   r7   r8   úTRUNC(r=   r3   ©Ú_convert_sql_to_tzr>   ©r.   rB   rC   rD   ÚtznameÚtrunc_params         r/   Údate_trunc_sqlz!DatabaseOperations.date_trunc_sqlk   s‚   € Ø×-Ñ-¨c°6¸6ÓB‰ˆˆVàˆØÐ+Ñ+Ø%×+Ñ+Ó-‰KØ˜IÒ%Ø‰KØ˜FÒ"Ø‰Kà˜C˜5 �? FÐ*Ð*Ø˜�u˜EÐ"Ð$: fÐ$:¨kÑ$:Ð:Ð:r1   z^[\w/:+-]+$c                 ó4   — t        |«      \  }}}|r|› |› �S |S ©N)r   )r.   rP   ÚsignÚoffsets       r/   Ú_prepare_tzname_deltaz(DatabaseOperations._prepare_tzname_delta   s)   € Ü1°&Ó9Ñˆ��fÙ$*�$�˜�xÐ Ð6°Ð6r1   c                 ó$  — t         j                  r|s||fS | j                  j                  |«      st	        d|z  «      ‚| j
                  j                  |k7  r5| j
                  j                  }| j                  |«      }d|› d|› d|› d�|fS ||fS )NzInvalid time zone name: %szCAST((FROM_TZ(z, 'z') AT TIME ZONE 'z') AS TIMESTAMP))r   ÚUSE_TZÚ
_tzname_reÚmatchrA   Ú
connectionÚtimezone_namerW   )r.   rC   rD   rP   Úfrom_timezone_nameÚto_timezone_names         r/   rN   z%DatabaseOperations._convert_sql_to_tzƒ   s¨   € Ü—’¡FØ˜�;ÐØ�‰×$Ñ$ VÔ,ÜÐ9¸FÑBÓCÐCð �?‰?×(Ñ(¨FÒ2Ø!%§¡×!>Ñ!>ÐØ#×9Ñ9¸&ÓAÐà    SÐ);Ð(<ð =Ø$Ð%Ð%5ð7àðð ð
 �Fˆ{Ðr1   c                 ó>   — | j                  |||«      \  }}d|› d�|fS )NrL   r=   ©rN   )r.   rC   rD   rP   s       r/   Údatetime_cast_date_sqlz)DatabaseOperations.datetime_cast_date_sql•   s-   € Ø×-Ñ-¨c°6¸6ÓB‰ˆˆVØ˜�u˜Aˆ Ð&Ð&r1   c                 óZ   — | j                  |||«      \  }}d|› d�}d|› d|› d�g |¢|¢­fS )Nz+TO_TIMESTAMP(CONCAT('1900-01-01 ', TO_CHAR(z0, 'HH24:MI:SS.FF')), 'YYYY-MM-DD HH24:MI:SS.FF')z
CASE WHEN z IS NOT NULL THEN z ELSE NULL ENDra   )r.   rC   rD   rP   Úconvert_datetime_sqls        r/   Údatetime_cast_time_sqlz)DatabaseOperations.datetime_cast_time_sql™   s`   € ð ×-Ñ-¨c°6¸6ÓB‰ˆˆVà9¸#¸ð ?*ð +ð 	ð
 ˜˜Ð/Ð0DÐ/EÀ^ÐTØˆfÐ�vÑð
ð 	
r1   c                 ón   — | j                  |||«      \  }}|dk(  rd|› d�|fS | j                  |||«      S ©NÚsecondzFLOOR(EXTRACT(SECOND FROM z)))rN   rG   )r.   rB   rC   rD   rP   s        r/   Údatetime_extract_sqlz'DatabaseOperations.datetime_extract_sql¦   sK   € Ø×-Ñ-¨c°6¸6ÓB‰ˆˆVØ˜(Ò"à/°¨u°BÐ7¸Ð?Ð?Ø×$Ñ$ [°#°vÓ>Ð>r1   c                 óà   — | j                  |||«      \  }}d }|dv r|j                  «       }n5|dk(  rd}n-|dk(  rd}n%|dk(  rd}n|dk(  rd	}n|d
k(  rd|› d�|fS d|› d�|fS d|› d�g |¢|‘­fS )NrI   r9   r:   r7   r8   ÚhourÚHH24ÚminuteÚMIÚdayrL   r=   úCAST(ú	 AS DATE)r3   rM   rO   s         r/   Údatetime_trunc_sqlz%DatabaseOperations.datetime_trunc_sql­   sº   € Ø×-Ñ-¨c°6¸6ÓB‰ˆˆVàˆØÐ+Ñ+Ø%×+Ñ+Ó-‰KØ˜IÒ%Ø‰KØ˜FÒ"Ø‰KØ˜FÒ"Ø ‰KØ˜HÒ$Ø‰KØ˜EÒ!Ø˜C˜5 �? FÐ*Ð*ð ˜3˜%˜yÐ)¨6Ð1Ð1Ø˜�u˜EÐ"Ð$: fÐ$:¨kÑ$:Ð:Ð:r1   c                 óB   — |dk(  rd|› d�|fS | j                  |||«      S rg   )rG   )r.   rB   rC   rD   s       r/   Útime_extract_sqlz#DatabaseOperations.time_extract_sqlÂ   s3   € Ø˜(Ò"à/°¨u°BÐ7¸Ð?Ð?Ø×$Ñ$ [°#°vÓ>Ð>r1   c                 ó†   — | j                  |||«      \  }}d }|dk(  rd}n|dk(  rd}n|dk(  rd|› d�|fS d|› d	�g |¢|‘­fS )
Nrk   rl   rm   rn   rh   rp   rq   rL   r3   ra   rO   s         r/   Útime_trunc_sqlz!DatabaseOperations.time_trunc_sqlÈ   sv   € ð ×-Ñ-¨c°6¸6ÓB‰ˆˆVØˆØ˜&Ò Ø ‰KØ˜HÒ$Ø‰KØ˜HÒ$à˜3˜%˜yÐ)¨6Ð1Ð1Ø˜�u˜EÐ"Ð$: fÐ$:¨kÑ$:Ð:Ð:r1   c                 óÈ  •— t         ‰| �  |«      }|j                  j                  «       }|dv r|j	                  | j
                  «       nÕ|dk(  r|j	                  | j                  «       n´|dk(  r|j	                  | j                  «       n“|dk(  r,t        j                  r~|j	                  | j                  «       nb|dk(  r|j	                  | j                  «       nA|dk(  r|j	                  | j                  «       n |dk(  r|j	                  | j                  «       |j                  j                  r,|j	                  |dk(  r| j                  n| j                   «       |S )N)Ú	JSONFieldr)   ÚBinaryFieldÚBooleanFieldÚDateTimeFieldÚ	DateFieldÚ	TimeFieldÚ	UUIDField)ÚsuperÚget_db_convertersÚoutput_fieldÚget_internal_typeÚappendÚconvert_textfield_valueÚconvert_binaryfield_valueÚconvert_booleanfield_valuer   rY   Úconvert_datetimefield_valueÚconvert_datefield_valueÚconvert_timefield_valueÚconvert_uuidfield_valueÚempty_strings_allowedÚconvert_empty_bytesÚconvert_empty_string)r.   Ú
expressionÚ
convertersÚinternal_typeÚ	__class__s       €r/   r€   z$DatabaseOperations.get_db_converters×   s5  ø€ Ü‘WÑ.¨zÓ:ˆ
Ø"×/Ñ/×AÑAÓCˆØÐ6Ñ6Ø×Ñ˜d×:Ñ:Õ;Ø˜mÒ+Ø×Ñ˜d×<Ñ<Õ=Ø˜nÒ,Ø×Ñ˜d×=Ñ=Õ>Ø˜oÒ-Ü�ŠØ×!Ñ! $×"BÑ"BÕCØ˜kÒ)Ø×Ñ˜d×:Ñ:Õ;Ø˜kÒ)Ø×Ñ˜d×:Ñ:Õ;Ø˜kÒ)Ø×Ñ˜d×:Ñ:Ô;ð ×"Ñ"×8Ò8Ø×Ñà  MÒ1ð ×(Ò(à×.Ñ.ôð
 Ðr1   c                 óZ   — t        |t        j                  «      r|j                  «       }|S rT   )Ú
isinstancer   ÚLOBÚread©r.   ÚvaluerŽ   r\   s       r/   r„   z*DatabaseOperations.convert_textfield_valueô   s    € Ü�eœXŸ\™\Ô*Ø—J‘J“LˆEØˆr1   c                 ól   — t        |t        j                  «      rt        |j	                  «       «      }|S rT   )r“   r   r”   r   r•   r–   s       r/   r…   z,DatabaseOperations.convert_binaryfield_valueù   s%   € Ü�eœXŸ\™\Ô*Ü §
¡
£Ó-ˆEØˆr1   c                 ó$   — |dv rt        |«      }|S )N)r   r   )Úboolr–   s       r/   r†   z-DatabaseOperations.convert_booleanfield_valueþ   s   € Ø�F‰?Ü˜“KˆEØˆr1   c                 ó^   — |�*t        j                  || j                  j                   «      }|S rT   )r   Ú
make_awarer\   r–   s       r/   r‡   z.DatabaseOperations.convert_datetimefield_value  s)   € ØÐÜ×'Ñ'¨¨t¯©×/GÑ/GÓHˆEØˆr1   c                 óZ   — t        |t        j                  «      r|j                  «       }|S rT   )r“   r   Ú	TimestampÚdater–   s       r/   rˆ   z*DatabaseOperations.convert_datefield_value  ó"   € Ü�eœX×/Ñ/Ô0Ø—J‘J“LˆEØˆr1   c                 óZ   — t        |t        j                  «      r|j                  «       }|S rT   )r“   r   rž   Útimer–   s       r/   r‰   z*DatabaseOperations.convert_timefield_value  r    r1   c                 ó4   — |�t        j                  |«      }|S rT   )ÚuuidÚUUIDr–   s       r/   rŠ   z*DatabaseOperations.convert_uuidfield_value  s   € ØÐÜ—I‘I˜eÓ$ˆEØˆr1   c                 ó   — | €dS | S ©NÚ © ©r—   rŽ   r\   s      r/   r�   z'DatabaseOperations.convert_empty_string  s   € à�]ˆrÐ-¨Ð-r1   c                 ó   — | €dS | S )Nr1   r©   rª   s      r/   rŒ   z&DatabaseOperations.convert_empty_bytes  s   € à�mˆsÐ.¨Ð.r1   c                  ó   — y)Nz DEFERRABLE INITIALLY DEFERREDr©   ©r.   s    r/   Údeferrable_sqlz!DatabaseOperations.deferrable_sql#  s   € Ø/r1   c                 ó’   — g }|D ]6  }|j                  «       }|g k(  rt        d«      ‚|j                  |d   «       Œ8 t        |«      S )Nz¾The database did not return a new row id. Probably "ORA-1403: no data found" was raised internally but was hidden by the Oracle OCI library (see https://code.djangoproject.com/ticket/28859).r   )Ú	get_valuer   rƒ   Útuple)r.   ÚcursorÚreturning_paramsÚcolumnsÚparamr—   s         r/   Úfetch_returned_insert_columnsz0DatabaseOperations.fetch_returned_insert_columns&  s\   € ØˆØ%ò 	%ˆEØ—O‘OÓ%ˆEð ˜Š{Ü#ðDóð ð �N‰N˜5 ™8Õ$ð	%ô �W‹~Ðr1   c                  ó   — y rT   r©   r­   s    r/   Úno_limit_valuez!DatabaseOperations.no_limit_value6  ó   € Ør1   c                 ó|   — | j                  ||«      \  }}dj                  d„ |rd|z  nd |rd|z  nd fD «       «      S )Nú c              3   ó$   K  — | ]  }|r|–— Œ
 y ­wrT   r©   )Ú.0rC   s     r/   ú	<genexpr>z6DatabaseOperations.limit_offset_sql.<locals>.<genexpr>;  s   è ø€ ò 
àñ ô ñ
ùs   ‚zOFFSET %d ROWSzFETCH FIRST %d ROWS ONLY)Ú_get_limit_offset_paramsÚjoin)r.   Úlow_markÚ	high_markÚfetchrV   s        r/   Úlimit_offset_sqlz#DatabaseOperations.limit_offset_sql9  sT   € Ø×5Ñ5°hÀ	ÓJ‰ˆˆvØ�x‰xñ 
ñ 06Ð! FÒ*¸4Ù8=Ð+¨eÒ3À4ðô
ó 
ð 	
r1   c                 óª  — |j                   }|r¸t        |t        t        f«      r5t	        t
        j                  |«      «      D ��ci c]  \  }}d|› �|“Œ }}}n6t        |t
        «      r&|j                  «       D ��ci c]  \  }}d|› �|“Œ }}}t        |t        d¬«      D ]"  }|j                  |t        ||   d¬«      «      }Œ$ |S c c}}w c c}}w )Nz:argú:T)ÚkeyÚreverseÚreplace)Úerrors)Ú	statementr“   r±   ÚlistÚ	enumerateÚdictÚfromkeysÚitemsÚsortedÚlenrÉ   r   )	r.   r²   rC   rD   rË   Úirµ   rÇ   Úvals	            r/   Úlast_executed_queryz&DatabaseOperations.last_executed_queryD  s×   € ð ×$Ñ$ˆ	ñ Ü˜&¤5¬$ -Ô0ä6?ÄÇÁÈfÓ@UÓ6V÷Ù*2¨!¨U�d˜1˜#�J Ñ%ð�ò ô ˜F¤DÔ)Ø;A¿<¹<»>×J©Z¨c°3˜A˜c˜U˜) S™.ÐJ�ÑJÜ˜f¬#°tÔ<ò �Ø%×-Ñ-Øœ 6¨#¡;°yÔAó‘	ðð Ðùóùó Ks   ÁC	Á=Cc                 óˆ   — | j                  |t        |«      |«      }|j                  d|z  «       |j                  «       d   S )Nz"%s".currvalr   )Ú_get_sequence_namer	   ÚexecuteÚfetchone)r.   r²   Ú
table_nameÚpk_nameÚsq_names        r/   Úlast_insert_idz!DatabaseOperations.last_insert_idX  s>   € Ø×)Ñ)¨&´,¸zÓ2JÈGÓTˆØ�‰�~¨Ñ/Ô0Ø�‰Ó  Ñ#Ð#r1   c                 ó"   — |dv ry|dk7  r|dv ryy)N)ÚiexactÚ	icontainsÚistartswithÚ	iendswithz	UPPER(%s)Úisnull)ry   r)   zDBMS_LOB.SUBSTR(%s)ú%sr©   )r.   rB   r�   s      r/   Úlookup_castzDatabaseOperations.lookup_cast]  s*   € ØÐMÑMØØ˜(Ò" }ð 9
ñ (
ð )Ør1   c                  ó   — y)Niè  r©   r­   s    r/   Úmax_in_list_sizez#DatabaseOperations.max_in_list_sizeg  r¹   r1   c                  ó   — y)Né   r©   r­   s    r/   Úmax_name_lengthz"DatabaseOperations.max_name_lengthj  ó   € Ør1   c                  ó   — y)NÚNULLr©   r­   s    r/   Úpk_default_valuez#DatabaseOperations.pk_default_valuem  s   € Ør1   c                 ó   — |S rT   r©   )r.   Úxs     r/   Úprep_for_iexact_queryz(DatabaseOperations.prep_for_iexact_queryp  s   € Øˆr1   c                 ó(   — |€y|j                  «       S r§   )r•   ©r.   r—   s     r/   Úprocess_clobzDatabaseOperations.process_clobs  s   € Øˆ=ØØ�z‰z‹|Ðr1   c                 óÄ   — |j                  d«      s.|j                  d«      sdt        || j                  «       «      z  }|j	                  dd«      }|j                  «       S )Nú"z"%s"ú%ú%%)Ú
startswithÚendswithr
   rê   rÉ   r>   )r.   Únames     r/   r-   zDatabaseOperations.quote_namex  sS   € ð
 �‰˜sÔ#¨D¯M©M¸#Ô,>ØœM¨$°×0DÑ0DÓ0FÓGÑGˆDð �|‰|˜C Ó&ˆØ�z‰z‹|Ðr1   c                 ó(   — |dk(  rd}d|z  S d}d|z  S )NÚregexz'c'z'i'zREGEXP_LIKE(%%s, %%s, %s)r©   )r.   rB   Úmatch_options      r/   Úregex_lookupzDatabaseOperations.regex_lookup…  s.   € Ø˜'Ò!Ø ˆLð +¨\Ñ9Ð9ð !ˆLØ*¨\Ñ9Ð9r1   c           	      ó†  — |syg }g }|D ]x  }|j                  | j                  |j                  j                  j                  «      ›d| j                  |j
                  «      ›�«       |j                  t        |«      «       Œz ddj                  |«      ›ddj                  dgt        |«      z  «      ›�t        |«      fS )N)r¨   r©   ú.z
RETURNING ú, z INTO rä   )
rƒ   r-   ÚmodelÚ_metaÚdb_tableÚcolumnr   rÀ   rÒ   r±   )r.   ÚfieldsÚfield_namesrD   Úfields        r/   Úreturn_insert_columnsz(DatabaseOperations.return_insert_columnsŒ  s²   € ÙØØˆØˆØò 	,ˆEØ×Ñð —O‘O E§K¡K×$5Ñ$5×$>Ñ$>Õ?Ø—O‘O E§L¡LÔ1ðôð �M‰Mœ) EÓ*Õ+ñ	,ð �I‰I�kÕ"Ø�I‰I�t�fœs 6›{Ñ*Ô+ð
ô �‹=ðð 	r1   c                 óÖ   — | j                   j                  «       5 }|r|j                  d||f«       n|j                  d|f«       |j                  «       cd d d «       S # 1 sw Y   y xY w)NaÒ  
                    SELECT
                        user_tables.table_name, rcons.constraint_name
                    FROM
                        user_tables
                    JOIN
                        user_constraints cons
                        ON (user_tables.table_name = cons.table_name
                        AND cons.constraint_type = ANY('P', 'U'))
                    LEFT JOIN
                        user_constraints rcons
                        ON (user_tables.table_name = rcons.table_name
                        AND rcons.constraint_type = 'R')
                    START WITH user_tables.table_name = UPPER(%s)
                    CONNECT BY
                        NOCYCLE PRIOR cons.constraint_name = rcons.r_constraint_name
                    GROUP BY
                        user_tables.table_name, rcons.constraint_name
                    HAVING user_tables.table_name != UPPER(%s)
                    ORDER BY MAX(level) DESC
                    a:  
                    SELECT
                        cons.table_name, cons.constraint_name
                    FROM
                        user_constraints cons
                    WHERE
                        cons.constraint_type = 'R'
                        AND cons.table_name = UPPER(%s)
                    )r\   r²   rØ   Úfetchall)r.   rÚ   Ú	recursiver²   s       r/   Ú__foreign_key_constraintsz,DatabaseOperations.__foreign_key_constraintsŸ  sn   € Ø�_‰_×#Ñ#Ó%ð '	%¨ÙØ—‘ðð*   Ð,õ-ð2 —‘ðð  �Môð —?‘?Ó$÷O'	%÷ '	%ò '	%ús   ›:AÁA(c                 ó:   —  t        d¬«      | j                  «      S )Ni   )Úmaxsize)r   Ú,_DatabaseOperations__foreign_key_constraintsr­   s    r/   Ú_foreign_key_constraintsz+DatabaseOperations._foreign_key_constraintsÉ  s   € ð &Œy Ô% d×&DÑ&DÓEÐEr1   F)Úreset_sequencesÚallow_cascadec                óf  — |sg S |D �ch c]  }|j                  «       ’Œ }}t        «       }|D ]C  }| j                  ||¬«      D ]+  \  }}	|r|j                  |«       |j                  ||	f«       Œ- ŒE |D ��	cg c]µ  \  }}	|j	                  d«      ›d|j	                  d«      ›d|j                  | j                  |«      «      ›d|j	                  d«      ›d|j	                  d«      ›d|j                  | j                  |	«      «      ›d|j	                  d«      ›d|j	                  d«      ›d	�‘Œ· c}	}|D �cg c]I  }|j	                  d
«      ›d|j	                  d«      ›d|j                  | j                  |«      «      ›d	�‘ŒK c}z   |D ��	cg c]‘  \  }}	|j	                  d«      ›d|j	                  d«      ›d|j                  | j                  |«      «      ›d|j	                  d«      ›d|j	                  d«      ›d|j                  | j                  |	«      «      ›d	�‘Œ“ c}	}z   }
|rg| j                  j                  j                  «       D �cg c]  }|d   j                  «       |v r|‘Œ }}|
j                  | j                  ||«      «       |
S c c}w c c}	}w c c}w c c}	}w c c}w )N)r  ÚALTERr»   ÚTABLEÚDISABLEÚ
CONSTRAINTÚKEEPÚINDEXú;ÚTRUNCATEÚENABLEÚtable)r>   Úsetr  ÚaddÚSQL_KEYWORDÚ	SQL_FIELDr-   r\   ÚintrospectionÚsequence_listÚextendÚsequence_reset_by_name_sql)r.   ÚstyleÚtablesr  r  r  Útruncated_tablesÚconstraintsÚforeign_tableÚ
constraintrC   ÚsequenceÚ	sequencess                r/   Ú	sql_flushzDatabaseOperations.sql_flushÏ  s�  € ÙØˆIà7=Ö>¨e˜EŸK™K�MÐ>ÐÐ>Ü“eˆð
 ò 	=ˆEØ-1×-JÑ-JØ ð .Kó .ò =Ñ)�˜zñ !Ø$×(Ñ(¨Ô7Ø—‘ °
Ð ;Õ<ñ=ð	=ð( *5÷ñ &�E˜:ð ×%Ñ% gÕ.Ø×%Ñ% gÕ.Ø—O‘O D§O¡O°EÓ$:Õ;Ø×%Ñ% iÕ0Ø×%Ñ% lÕ3Ø—O‘O D§O¡O°JÓ$?Õ@Ø×%Ñ% fÕ-Ø×%Ñ% gÕ.ò
óð* .öð ð	 ×%Ñ% jÕ1Ø×%Ñ% gÕ.Ø—O‘O D§O¡O°EÓ$:Õ;ò	òñðB *5÷ñ &�E˜:ð ×%Ñ% gÕ.Ø×%Ñ% gÕ.Ø—O‘O D§O¡O°EÓ$:Õ;Ø×%Ñ% hÕ/Ø×%Ñ% lÕ3Ø—O‘O D§O¡O°JÓ$?Õ@òóñ/"ð 	ñJ ð !%§¡× =Ñ =× KÑ KÓ MöàØ˜GÑ$×*Ñ*Ó,Ð0@Ñ@ò ðˆIð ð �J‰J�t×6Ñ6°u¸iÓHÔIØˆ
ùòw ?ùóùòùóùòs    ‰JÁ9B:JÄ:AJ#ÆBJ(ÉJ.c           	      óF  — g }|D ]™  }| j                  |d   «      }| j                  |d   «      }| j                  |d   xs d«      }| j                  |||t        |«      t        |«      | j                  j
                  j                  dœz  }|j                  |«       Œ› |S )Nr  r  Úid©Úno_autofield_sequence_namer  r  rÚ   Úcolumn_nameÚsuffix)Ú_get_no_autofield_sequence_namer-   Ú_sequence_reset_sqlr	   r\   ÚfeaturesÚbare_select_suffixrƒ   )	r.   r(  r/  rC   Úsequence_infor4  r  r  Úquerys	            r/   r'  z-DatabaseOperations.sequence_reset_by_name_sql  s²   € ØˆØ&ò 	ˆMØ)-×)MÑ)MØ˜gÑ&ó*Ð&ð —O‘O M°'Ñ$:Ó;ˆEØ—_‘_ ]°8Ñ%<Ò%DÀÓEˆFØ×,Ñ,Ø.HØØ Ü*¨5Ó1Ü+¨FÓ3ØŸ/™/×2Ñ2×EÑEñ0ñ ˆEð �J‰J�uÕð	ð ˆ
r1   c                 óê  — g }| j                   }|D ]ß  }|j                  j                  D ]Ä  }t        |t        «      sŒ| j                  |j                  j                  «      }| j                  |j                  j                  «      }| j                  |j                  «      }	|j                  ||||	t        |«      t        |	«      | j                  j                  j                  dœz  «        Œß Œá |S )Nr3  )r8  r  Úlocal_fieldsr“   r   r7  r  r-   r  rƒ   r	   r\   r9  r:  )
r.   r(  Ú
model_listÚoutputr<  r  Úfr4  r  r  s
             r/   Úsequence_reset_sqlz%DatabaseOperations.sequence_reset_sql#  sß   € ØˆØ×(Ñ(ˆØò 	ˆEØ—[‘[×-Ñ-ò �Ü˜a¤Õ+Ø15×1UÑ1UØŸ™×,Ñ,ó2Ð.ð !ŸO™O¨E¯K©K×,@Ñ,@ÓA�EØ!Ÿ_™_¨Q¯X©XÓ6�FØ—M‘MØà:TØ%*Ø&,Ü*6°uÓ*=Ü+7¸Ó+?Ø&*§o¡o×&>Ñ&>×&QÑ&Qññô
ñ ñ)ð	ð, ˆr1   c                  ó   — yr§   r©   r­   s    r/   Ústart_transaction_sqlz(DatabaseOperations.start_transaction_sql>  rë   r1   c                 óV   — |rd| j                  |«      z  S d| j                  |«      z  S )NzUSING INDEX TABLESPACE %szTABLESPACE %sr,   )r.   Ú
tablespaceÚinlines      r/   Útablespace_sqlz!DatabaseOperations.tablespace_sqlA  s-   € ÙØ.°·±ÀÓ1LÑLÐLà" T§_¡_°ZÓ%@Ñ@Ð@r1   c                 ó   — |S )zô
        Transform a date value to an object compatible with what is expected
        by the backend driver for date columns.
        The default implementation transforms the date to text, but that is not
        necessary for Oracle.
        r©   ró   s     r/   Úadapt_datefield_valuez(DatabaseOperations.adapt_datefield_valueG  s	   € ð ˆr1   c                 óè   — |€yt        j                  |«      rFt        j                  r+t        j                  || j
                  j                   «      }nt        d«      ‚t        j                  |«      S )aE  
        Transform a datetime value to an object compatible with what is expected
        by the backend driver for datetime columns.

        If naive datetime is passed assumes that is in UTC. Normally Django
        models.DateTimeField makes sure that if USE_TZ is True passed datetime
        is timezone aware.
        NzNOracle backend does not support timezone-aware datetimes when USE_TZ is False.)	r   Úis_awarer   rY   Ú
make_naiver\   rA   r   Úfrom_datetimeró   s     r/   Úadapt_datetimefield_valuez,DatabaseOperations.adapt_datetimefield_valueP  sd   € ð ˆ=Øô ×Ñ˜UÔ#Ü�ŠÜ ×+Ñ+¨E°4·?±?×3KÑ3KÓL‘ä ð'óð ô
 ×,Ñ,¨UÓ3Ð3r1   c           	      ó  — |€y t        |t        «      r t        j                  j                  |d«      S t	        j
                  |«      rt        d«      ‚t        ddd|j                  |j                  |j                  |j                  «      S )Nz%H:%M:%Sz5Oracle backend does not support timezone-aware times.il  r   )r“   ÚstrÚdatetimeÚstrptimer   rL  rA   r   rk   rm   rh   Úmicrosecondró   s     r/   Úadapt_timefield_valuez(DatabaseOperations.adapt_timefield_valuei  sw   € Øˆ=Øä�eœSÔ!Ü×$Ñ$×-Ñ-¨e°ZÓ@Ð@ô ×Ñ˜UÔ#ÜÐTÓUÐUäØ�!�Q˜Ÿ
™
 E§L¡L°%·,±,À×@QÑ@Qó
ð 	
r1   c                 ó   — |S rT   r©   )r.   r—   Ú
max_digitsÚdecimal_placess       r/   Úadapt_decimalfield_valuez+DatabaseOperations.adapt_decimalfield_valuex  s   € Øˆr1   c                 ó2  •— |\  }}|dk(  rddj                  |«      z  S |dk(  rddj                  |«      z  S |dk(  rd||dœz  S |d	k(  rd
||dœz  S |dk(  rd||dœz  S |dk(  rddj                  |«      z  S |dk(  rt        d«      ‚t        ‰| �  ||«      S )Nrø   zMOD(%s)ú,ú&z
BITAND(%s)ú|z"BITAND(-%(lhs)s-1,%(rhs)s)+%(lhs)s)ÚlhsÚrhsz<<z(%(lhs)s * POWER(2, %(rhs)s))z>>z"FLOOR(%(lhs)s / POWER(2, %(rhs)s))ú^z	POWER(%s)ú#z'Bitwise XOR is not supported in Oracle.)rÀ   r   r   Úcombine_expression)r.   Ú	connectorÚsub_expressionsr^  r_  r‘   s        €r/   rb  z%DatabaseOperations.combine_expression{  sÎ   ø€ Ø"‰ˆˆSØ˜ÒØ˜sŸx™x¨Ó8Ñ8Ð8Ø˜#ÒØ #§(¡(¨?Ó";Ñ;Ð;Ø˜#ÒØ7À#ÈcÑ:RÑRÐRØ˜$ÒØ2¸SÈÑ5MÑMÐMØ˜$ÒØ7À#ÈcÑ:RÑRÐRØ˜#ÒØ §¡¨/Ó!:Ñ:Ð:Ø˜#ÒÜ#Ð$MÓNÐNÜ‰wÑ)¨)°_ÓEÐEr1   c                 ót   — | j                  «       dz
  }dt        t        |«      |«      j                  «       z  S )z‹
        Manually created sequence name to keep backward compatibility for
        AutoFields that aren't Oracle identity columns.
        é   z%s_SQ)rê   r
   r	   r>   )r.   r  Úname_lengths      r/   r7  z2DatabaseOperations._get_no_autofield_sequence_name�  s7   € ð
 ×*Ñ*Ó,¨qÑ0ˆØœ¤|°EÓ':¸KÓH×NÑNÓPÑPÐPr1   c                 óz   — |j                  d||g«       |j                  «       }|€| j                  |«      S |d   S )Nzš
            SELECT sequence_name
            FROM user_tab_identity_cols
            WHERE table_name = UPPER(%s)
            AND column_name = UPPER(%s)r   )rØ   rÙ   r7  )r.   r²   r  rÛ   Úrows        r/   r×   z%DatabaseOperations._get_sequence_name•  sJ   € Ø�‰ð+ð
 �GÐô	
ð �o‰oÓˆØ>A¸kˆt×3Ñ3°EÓ:ÐUÈsÐSTÉvÐUr1   c           
      óÚ  — |D �cg c]=  }|r9t         j                  j                  t        |d|«      j	                  «       d«      ‘Œ? }}g }|D ]„  }g }t        |«      D ],  \  }}	||   r||   |	z  }	|s|	›d|›�}	|j                  |	«       Œ. | j                  j                  j                  }
|j                  d|
› �dj                  |«      z  «       Œ† ddj                  |«      z  S c c}w )NÚtarget_fieldrä   z col_z	SELECT %sr  zSELECT * FROM (%s)z UNION ALL )r   ÚtypesÚgetÚgetattrr‚   rÍ   rƒ   r\   r9  r:  rÀ   )r.   r  Úplaceholder_rowsr	  Úfield_placeholdersr<  ri  ÚselectrÓ   Úplaceholderr6  s              r/   Úbulk_insert_sqlz"DatabaseOperations.bulk_insert_sql¡  s	  € ð
  ö	
ð Ùô	 ×"Ñ"×&Ñ&Ü˜˜~¨uÓ5×GÑGÓIÈ4õð
Ðð 
ð ˆØ#ò 	CˆCØˆFÜ"+¨C£.ò 	+‘��;à˜!’9Ø"4°QÑ"7¸+Ñ"E�Kñ Ú1<¹aÐ"@�KØ—‘˜kÕ*ð	+ð —_‘_×-Ñ-×@Ñ@ˆFØ�L‰L˜9 V HÐ-°·	±	¸&Ó0AÑAÕBð	Cð" $ m×&8Ñ&8¸Ó&?Ñ?Ð?ùò3
s   …AC(c                 óh   •— |dk(  r|\  }}|\  }}g |¢|¢­}d|›d|›d�|fS t         ‰	| �  |||«      S )Nr|   zNUMTODSINTERVAL(TO_NUMBER(z - z	), 'DAY'))r   Úsubtract_temporals)
r.   r�   r^  r_  Úlhs_sqlÚ
lhs_paramsÚrhs_sqlÚ
rhs_paramsrD   r‘   s
            €r/   ru  z%DatabaseOperations.subtract_temporals½  sY   ø€ Ø˜KÒ'Ø"%ÑˆG�ZØ"%ÑˆG�ZØ/�zÐ/ JÑ/‰Fâ@GÊÐQØðð ô ‰wÑ)¨-¸¸cÓBÐBr1   c                 ót   — |r,| j                   j                  j                  t        |«      z  S t        |«      S )z5Oracle restricts the number of parameters in a query.)r\   r9  Úmax_query_paramsrÒ   )r.   r  Úobjss      r/   Úbulk_batch_sizez"DatabaseOperations.bulk_batch_sizeÈ  s.   € áØ—?‘?×+Ñ+×<Ñ<ÄÀFÃÑKÐKÜ�4‹yÐr1   c                 óä   — t        |t        t        t        f«      ryt        |t        «      r'|j
                  r| j                  |j                  «      S t        |t        «      r|j
                  ryy)z}
        Oracle supports only EXISTS(...) or filters in the WHERE clause, others
        must be compared with True.
        TF)	r“   r   r   r   r   ÚconditionalÚ0conditional_expression_supported_in_where_clauserŽ   r   )r.   rŽ   s     r/   r€  zCDatabaseOperations.conditional_expression_supported_in_where_clauseÎ  sa   € ô
 �j¤6¬6´9Ð"=Ô>ØÜ�jÔ"3Ô4¸×9OÒ9OØ×HÑHØ×%Ñ%óð ô �j¤&Ô)¨j×.DÒ.DØØr1   rT   )F)NN)EÚ__name__Ú
__module__Ú__qualname__Úinteger_field_rangesr   Úset_operatorsr8  Ú"cast_char_field_without_max_lengthÚcast_data_typesr0   r   r?   rG   rR   rZ   rW   rN   rb   re   ri   rr   rt   rv   r€   r„   r…   r†   r‡   rˆ   r‰   rŠ   Ústaticmethodr�   rŒ   r®   r¶   r¸   rÄ   rÕ   rÝ   rå   rç   rê   rî   rñ   rô   r-   rÿ   r
  r  r   r  r0  r'  rB  rD  rH  rJ  rO  rU  rY  rb  r7  r×   rs  ru  r}  r€  Ú__classcell__)r‘   s   @r/   r   r      sÌ  ø„ ð
 9Ø3ØFØ#;Ø%5Ø 0Ø)Ø0ØCñ
Ðð TÐ-×;Ñ;ÐS¸\È7ÑS€MðÐð2 *;Ð&à!Ø$Ø%Ø7ñ	€Oò
ñ *¨*Ó5Ðò5ó0;ñ$ " .Ó1€Jò7òò$'ò
ò?ò;ò*?ó;ôò:ò
ò
òò
ò
ò
ð
 ñ.ó ð.ð ñ/ó ð/ò0òò ò	
òò($ó
òòòòòò
ò:òò&(%ðT ñFó ðFð
 ;@Èuô ?òBò&ò6óAòò4ò2
óôFò$Qò
Vò@ô8	Còör1   r   )(rR  r¤   Ú	functoolsr   Údjango.confr   Ú	django.dbr   r   Ú"django.db.backends.base.operationsr   Údjango.db.backends.utilsr   r	   r
   Údjango.db.modelsr   r   r   r   Údjango.db.models.expressionsr   Údjango.db.models.sql.wherer   Údjango.utilsr   Údjango.utils.encodingr   r   Údjango.utils.functionalr   Údjango.utils.regex_helperr   Úbaser   Úutilsr   r   r   r   r©   r1   r/   ú<module>r˜     sM   ðÛ Û Ý å  ß 6Ý Eß TÑ Tß IÓ IÝ /Ý 0Ý !ß 8Ý 3Ý 6å ß ?Ñ ?ôFÐ/õ Fr1   