
    *h_                        S r SSKrSSKJrJr  SSKJrJrJrJrJ	r	J
r
JrJrJrJrJr  SSKJr  SSKJr  SSKJr  SSKJr  SS	KJrJr  SS
KJr  SSKJr   SSKr SSK!J"r"  SSK#J$r$  SSK%J&r&  SSKJ'r'J(r(J)r)   SSK,J-r-  Sr.SSK/J0r0  SSK1J2r2  SSK3J4r4  SSK5J6r6  SSK7J8r8  SSK9J:r:  SSK;J<r<  \ Rz                  R|                  r>\ Rz                  R~                  r?\ Rz                  R                  r@\ Rz                  R                  rA\ Rz                  R                  rB\(       a  SSKCJDrDJErE  S\S\)4S jrF " S  S!5      rG " S" S#\5      rH " S$ S%\"5      rIg! \* a  r+\" S\+ 35      \+eSr+C+ff = f! \* a    Sr. Nf = f)&a  Django database Backend using MySQL Connector/Python.

This Django database backend is heavily based on the MySQL backend from Django.

Changes include:
* Support for microseconds (MySQL 5.6.3 and later)
* Using INFORMATION_SCHEMA where possible
* Using new defaults for, for example SQL_AUTO_IS_NULL

Requires and comes with MySQL Connector/Python v8.0.22 and later:
    http://dev.mysql.com/downloads/connector/python/
    N)datetimetime)TYPE_CHECKINGAnyDict	GeneratorIteratorListOptionalSequenceSetTupleUnion)settings)ImproperlyConfigured)IntegrityError)BaseDatabaseWrapper)	dateparsetimezone)cached_property)MySQLConvertibleType)MySQLConverter)
HexLiteral)PooledMySQLConnection)ParamsSequenceOrDictTypeRowType
StrOrBytesz&Error loading mysql.connector module: )datetime_to_mysqlTF   )DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)DatabaseValidation)MySQLConnectionAbstractMySQLCursorAbstractvaluereturnc                    [         R                  (       a  [        R                  " U 5      (       aJ  [        R
                  " SU  S3[        5        [        R                  " 5       n[        R                  " X5      n U R                  [        R                  5      R                  SS9n [        (       a  [        U 5      nU$ U R                  S5      $ )zDEquivalent to DateTimeField.get_db_prep_value. Used only by raw SQL.z!MySQL received a naive datetime (z$) while time zone support is active.N)tzinfoz%Y-%m-%d %H:%M:%S.%f)r   USE_TZr   is_naivewarningswarnRuntimeWarningget_default_timezone
make_aware
astimezoneutcreplace	HAVE_CEXTr   strftime)r)   default_timezonemysql_datetimes      S/var/www/auris/envauris/lib/python3.13/site-packages/mysql/connector/django/base.py$adapt_datetime_with_timezone_supportr<   i   s    U##MM3E7 ;6 6
  (<<>''@E  .66 7 
 y 1% 8>>011    c            
       :   \ rS rSrSrSrSS jr\S\\	\
4   S\\	\
4   4S j5       r\S\\\
      S\\\
      4S	 j5       r SS
\	S\\\\
   \\	\
4   4      S\\S      4S jjrS
\	S\\\\
   \\	\
4   4      S\\S      4S jrS\S\4S jrS\\   4S jrSrg)CursorWrapper~   zWrapper around MySQL Connector/Python's cursor class.

The cursor class is defined by the options passed to MySQL
Connector/Python. If buffered option is True in those options,
MySQLCursorBuffered will be used.
)i  i  i  i  r*   Nc                     Xl         g NcursorselfrD   s     r;   __init__CursorWrapper.__init__   s    -3r=   argsc                     U (       d  U $ [        U 5      nU R                  5        H)  u  p#[        U[        5      (       d  M  [	        U5      X'   M+     U$ rB   )dictitems
isinstancer   r<   )rI   new_argskeyr)   s       r;   _adapt_execute_args_dict&CursorWrapper._adapt_execute_args_dict   sG     K:**,JC%** DU K ' r=   c                     U (       d  U $ [        U 5      n[        U 5       H)  u  p#[        U[        5      (       d  M  [	        U5      X'   M+     [        U5      $ rB   )list	enumeraterM   r   r<   tuple)rI   rN   iargs       r;   _adapt_execute_args!CursorWrapper._adapt_execute_args   sJ     K:oFA#x((B3G & Xr=   query)r(   NNc                 n   Sn[        U[        5      (       a  U R                  U5      nOU R                  U5      n U R                  R                  X5      $ ! [        R                  R                   a?  nUR                  S   U R                  ;   a  [        [        UR                  5      6 See SnAff = f)zExecutes the given operation

This wrapper method around the execute()-method of the cursor is
mainly needed to re-raise using different exceptions.
Nr   )rM   rK   rP   rX   rD   executemysql	connectorOperationalErrorrI   codes_for_integrityerrorr   rU   )rF   rZ   rI   rN   excs        r;   r\   CursorWrapper.execute   s     8<dD!!44T:H//5H	;;&&u77// 	xx{d;;;$eCHHo6D@	s   A B45:B//B4c                      U R                   R                  X5      $ ! [        R                  R                   a?  nUR
                  S   U R                  ;   a  [        [        UR
                  5      6 See SnAff = f)zExecutes the given operation

This wrapper method around the executemany()-method of the cursor is
mainly needed to re-raise using different exceptions.
r   N)	rD   executemanyr]   r^   r_   rI   r`   r   rU   )rF   rZ   rI   ra   s       r;   rd   CursorWrapper.executemany   sd    	;;**577// 	xx{d;;;$eCHHo6D@	s    A::A55A:attrc                 .    [        U R                  U5      $ )z%Return an attribute of wrapped cursor)getattrrD   rF   rf   s     r;   __getattr__CursorWrapper.__getattr__   s    t{{D))r=   c                 ,    [        U R                  5      $ )z&Return an iterator over wrapped cursor)iterrD   rF   s    r;   __iter__CursorWrapper.__iter__   s    DKK  r=   rC   )rD   r(   r*   NrB   )__name__
__module____qualname____firstlineno____doc__r`   rG   staticmethodr   strr   rP   r   r   rX   r   r   r\   rd   r   rj   r	   r   ro   __static_attributes__ r=   r;   r?   r?   ~   sO    4 
3,,-
	c''	(
 
 
x 456
	(/0	1
 
"  (/0$s<P7P2QQR
 
)=>	?0 (/0$s<P7P2QQR
 
)=>	?&* * *!(7+ !r=   r?   c                     ^  \ rS rSr% SrSr0 SS_SS_SS	_S
S_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_SS _S!S"_SSS#S$S%SS&S'S(S)S*S+.ErS,rS-S.S/S.S0S1S2S3S4S5S/S/S.S.S6.rS7r	S8S9S:S;S<S=S>.r
S?r\\   \S@'   1 SAkr\R"                  r\r\r\r\r\r\r\r SB\!SC\!SDS?4U 4SE jjr"SF\SD\#4SG jr$SD\%\\!4   4SH jr&SI\%\\!4   SD\'\(SJ4   4SK jr)S`SL jr*SaSM\!SD\+4SN jjr,S`SO jr-SP\#SDS?4SQ jr.SD\#4SR jr/S`SS jr0SaST\\1\      SDS?4SU jjr2SD\#4SV jr3\4\5SD\4SW j5       5       r6\4SD\%\\4   4SX j5       r7\4SD\%\\!4   4SY j5       r8\4SD\!4SZ j5       r9\4SD\:\;S[4   4S\ j5       r<\4SD\=\   4S] j5       r>\?SD\#4S^ j5       r@S_rAU =rB$ )bDatabaseWrapper   z Represent a database connection.r]   	AutoFieldzinteger AUTO_INCREMENTBigAutoFieldzbigint AUTO_INCREMENTBinaryFieldlongblobBooleanFieldbool	CharFieldzvarchar(%(max_length)s)	DateFielddateDateTimeFieldzdatetime(6)DecimalFieldz+numeric(%(max_digits)s, %(decimal_places)s)DurationFieldbigint	FileFieldFilePathField
FloatFieldzdouble precisionIntegerFieldintegerBigIntegerFieldIPAddressFieldzchar(15)GenericIPAddressFieldzchar(39)	JSONFieldjsonzbigint UNSIGNEDzinteger UNSIGNEDzsmallint UNSIGNEDzsmallint AUTO_INCREMENTsmallintlongtextztime(6)zchar(32))NullBooleanFieldOneToOneFieldPositiveBigIntegerFieldPositiveIntegerFieldPositiveSmallIntegerField	SlugFieldSmallAutoFieldSmallIntegerField	TextField	TimeField	UUIDField)	tinyblobblob
mediumblobr   tinytexttext
mediumtextr   r   z= %szLIKE %szLIKE BINARY %szREGEXP BINARY %sz	REGEXP %sz> %sz>= %sz< %sz<= %s)exactiexactcontains	icontainsregexiregexgtgteltlte
startswithendswithistartswith	iendswithzCREPLACE(REPLACE(REPLACE({}, '\\', '\\\\'), '%%', '\%%'), '_', '\_')z"LIKE BINARY CONCAT('%%', {}, '%%')zLIKE CONCAT('%%', {}, '%%')zLIKE BINARY CONCAT({}, '%%')zLIKE CONCAT({}, '%%')zLIKE BINARY CONCAT('%%', {})zLIKE CONCAT('%%', {}))r   r   r   r   r   r   Nisolation_level>   serializableread committedrepeatable readread uncommittedrI   kwargsr*   c                 n  > [         TU ]  " U0 UD6  U R                  R                  S5      nU(       ac  UR                  S[        (       + 5      U l        UR                  S[        5      n[        U[        5      (       d  [        S5      eU" 5       U l	        g [        5       U l	        [        (       + U l        g )NOPTIONSuse_pureconverter_classzXConverter class should be a subclass of mysql.connector.django.base.DjangoMySQLConverter)
superrG   settings_dictgetr7   	_use_pureDjangoMySQLConverter
issubclassProgrammingError	converter)rF   rI   r   optionsr   	__class__s        r;   rG   DatabaseWrapper.__init__K  s    $)&)$$((3$[[]CDN%kk!$O o/CDD&G  -.DN13DN!*]DNr=   rf   c                 <    UR                  S5      (       a  g[        e)Nmysql_isF)r   AttributeErrorri   s     r;   rj   DatabaseWrapper.__getattr___  s    ??:&&r=   c                    SSSSS.nU R                   nUS   (       a  US   US'   US   (       a  US   US'   US	   (       a  US	   US
'   US   R                  S5      (       a	  US   US'   OUS   (       a  US   US'   US   (       a  [        US   5      US'   UR                  S0 5      R                  S5      (       a  US   S   US'   [        R
                  US'   [        R                  R                  R                  R                  /US'    US   R                  5       nUR                  SS 5      nU(       a\  UR                  5       nX@R                  ;  a=  SR                  S [!        U R                  5       5       5      n[#        SU SU S35      eX@l        UR'                  U5        U$ ! [(         a     U$ f = f)Nutf8TF)charsetuse_unicodebufferedconsume_resultsUSERuserNAMEdatabasePASSWORDpasswdHOST/unix_sockethostPORTportr   init_commandraise_on_warningsclient_flagsr   z, c              3   .   #    U  H  nS U S 3v   M     g7f)'Nry   ).0levels     r;   	<genexpr>8DatabaseWrapper.get_connection_params.<locals>.<genexpr>  s      -2O!E7!2Os   z%Invalid transaction isolation level 'z' specified.
Use one of z
, or None.)r   r   intr   r   DEBUGr]   r^   	constants
ClientFlag
FOUND_ROWScopypoplowerisolation_levelsjoinsortedr   r   updateKeyError)rF   r   r   r   r   valid_levelss         r;   get_connection_params%DatabaseWrapper.get_connection_paramsd  s   #	
 ** *62F6N !.v!6F:$,Z8F8 ++C00$1&$9F=!6"*62F6N  v!67F6NY+//??%29%=n%MF>" '/nn"# OO%%00;;"
~
	#I.335G%kk*;TBO"1"7"7"9"*?*??#'99 -289N9N2O- $L /??P Q22>zK  $3 MM'"   		s   BF1 1
F?>F?conn_paramsr'   c                 d    SU;  a	  [         US'   [        R                  R                  " S0 UD6nU$ )Nr   ry   )r   r]   r^   connect)rF   r   cnxs      r;   get_new_connection"DatabaseWrapper.get_new_connection  s3     K/-AK)*oo%%44
r=   c                 8   / nU R                   R                  (       a  UR                  S5        U R                  (       a,  UR                  SU R                  R	                  5        35        U(       a9  U R                  5        nUR                  SR                  U5      5        S S S 5        SU R                  ;   a    U R                  U R                  S   5        g g ! , (       d  f       N?= f! [         a!    U R                  U R                  S   5         g f = f)NzSET SQL_AUTO_IS_NULL = 0z(SET SESSION TRANSACTION ISOLATION LEVEL z; 
AUTOCOMMIT)featuresis_sql_auto_is_null_enabledappendr   upperrD   r\   r   r   set_autocommitr   _set_autocommit)rF   assignmentsrD   s      r;   init_connection_state%DatabaseWrapper.init_connection_state  s    ==44
 9::''--/02
 &tyy56  4---G##D$6$6|$DE .  " G$$T%7%7%EFGs   !C=C. 
C+.(DDnamec                 L    U R                   R                  5       n[        U5      $ rB   )
connectionrD   r?   )rF   r
  rD   s      r;   create_cursorDatabaseWrapper.create_cursor  s    '')V$$r=   c                 R     [         R                  " U 5        g ! [         a     g f = frB   )r   	_rollbackNotSupportedErrorrn   s    r;   r  DatabaseWrapper._rollback  s'    	))$/  		s    
&&
autocommitc                 p    U R                      XR                  l        S S S 5        g ! , (       d  f       g = frB   )wrap_database_errorsr  r  )rF   r  s     r;   r  DatabaseWrapper._set_autocommit  s!    &&)3OO& '&&s   '
5c                 z    U R                  5        nUR                  S5        SSS5        g! , (       d  f       g= f)z
Disable foreign key checks, primarily for use in adding rows with
forward references. Always return True to indicate constraint checks
need to be re-enabled.
zSET foreign_key_checks=0NT)rD   r\   rE   s     r;   disable_constraint_checking+DatabaseWrapper.disable_constraint_checking  s/     [[]fNN56  ]s   ,
:c                     SU R                   sU l         n U R                  5        nUR                  S5        SSS5        Xl         g! , (       d  f       N= f! Xl         f = f)z=
Re-enable foreign key checks after they have been disabled.
FzSET foreign_key_checks=1N)needs_rollbackrD   r\   )rF   r  rD   s      r;   enable_constraint_checking*DatabaseWrapper.enable_constraint_checking  sT     /4T5H5H+^	1&9:  #1  #1s!   A AA 
AA A table_namesc                 
   U R                  5        nUc  U R                  R                  U5      nU H  nU R                  R                  X#5      nU(       d  M'  U R                  R	                  X#5      nU Hm  u  nnnUR                  SU SU SU SU SU SU SU S	U S
35        UR                  5        H(  n	[        SU SU	S    SU SU SU	S    SU SU S35      e   Mo     M     SSS5        g! , (       d  f       g= f)a-  
Check each table name in `table_names` for rows with invalid foreign
key references. This method is intended to be used in conjunction with
`disable_constraint_checking()` and `enable_constraint_checking()`, to
determine if rows with invalid references were entered while constraint
checks were off.
Nz+
                        SELECT REFERRING.`z&`,
                        REFERRING.`z `
                        FROM `z2` as REFERRING
                        LEFT JOIN `zR` as REFERRED
                        ON (
                            REFERRING.`z*` =
                            REFERRED.`zE`
                        )
                        WHERE REFERRING.`z4` IS NOT NULL
                        AND REFERRED.`z"` IS NULL
                        zThe row in table 'z' with primary key 'r   z' has an invalid foreign key: .z contains a value 'r   z.' that does not have a corresponding value in )rD   introspectionr  get_primary_key_columnget_key_columnsr\   fetchallr   )
rF   r  rD   
table_nameprimary_key_column_namekey_columnscolumn_namereferenced_table_namereferenced_column_namebad_rows
             r;   check_constraints!DatabaseWrapper.check_constraints  sh    [[]f""00<<VD)
*.*<*<*S*S+' /"00@@ !	)*NN++B*C D$$/= 1)l +$$9#: ;((3} 5''=&> ?**5 7''=&> ? $*??#4,0 =$$+AJ</M)l!K= 9  '
| ,645Q56a9  $5 ! * ]]s   CC44
Dc                 Z     U R                   R                  5         g! [         a     gf = f)NFT)r  pingErrorrn   s    r;   	is_usableDatabaseWrapper.is_usable  s0    	OO  "   		s    
**c                      g)zDisplay name.MySQLry   ry   r=   r;   display_nameDatabaseWrapper.display_name  s     r=   c                 L    U R                   R                  (       a  SSSS.nU$ 0 $ )z<Mapping of Field objects to their SQL for CHECK constraints.z`%(column)s` >= 0)r   r   r   )r  !supports_column_check_constraints)rF   r,  s     r;   data_type_check_constraints+DatabaseWrapper.data_type_check_constraints  s/     ==::+>(;-@!
 %$	r=   c           	         U R                  5        nUR                  S5        UR                  5       nSSS5        WS   US   US   [        US   5      [        US   5      [        US   5      S	.$ ! , (       d  f       ND= f)
zReturn MySQL server data.a2  
                SELECT VERSION(),
                       @@sql_mode,
                       @@default_storage_engine,
                       @@sql_auto_is_null,
                       @@lower_case_table_names,
                       CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL
            Nr   r               )versionsql_modedefault_storage_enginesql_auto_is_nulllower_case_table_nameshas_zoneinfo_database)temporary_connectionr\   fetchoner   )rF   rD   rows      r;   mysql_server_data!DatabaseWrapper.mysql_server_data+  s     &&(F NN	 //#C )  1vA&)!f $SV&*3q6l%)#a&\
 	
 )(s   "A11
A?c                     U R                  5        nUR                  S5        UR                  5       S   sSSS5        $ ! , (       d  f       g= f)Return MySQL version.zSELECT VERSION()r   N)rF  r\   rG  rE   s     r;   mysql_server_info!DatabaseWrapper.mysql_server_infoF  s:     &&(FNN-.??$Q' )((s	   $?
A.c                     U R                  5       n[        R                  R                  " S0 UD6 nUR                  nSSS5        U$ ! , (       d  f       W$ = f)rL  Nry   )r   r]   r^   r   server_version)rF   configconnrP  s       r;   mysql_versionDatabaseWrapper.mysql_versionM  sN     ++-__$$.v.$.2.A.AN / /.s   A
Ac                     U R                  5        nUR                  S5        UR                  5       nSSS5        [        W(       a  US   R	                  S5      5      $ S5      $ ! , (       d  f       N8= f)zReturn SQL mode.zSELECT @@sql_modeNr   ,ry   )rD   r\   rG  setsplit)rF   rD   rA  s      r;   rA  DatabaseWrapper.sql_modeU  s[     [[]fNN./(H  X8A;$$S)>>2>> ]s   "A%%
A3c                     U R                   nU$ )z1Return True if pure Python version is being used.)r   )rF   anss     r;   r   DatabaseWrapper.use_pure]  s     NN
r=   )r   r   r   r  )r*   NrB   )Crq   rr   rs   rt   ru   vendor
data_types_limited_data_types	operatorspattern_escpattern_opsr   r   rw   __annotations__r   r]   r^   Databaser%   SchemaEditorClassr    client_classr!   creation_classr"   features_classr#   introspection_classr$   	ops_classr&   validation_classr   rG   r   rj   r   r   r   r   r   r  r?   r  r  r  r  r  r
   r,  r1  r   rv   r5  r9  rI  rM  r   r   rS  r   rA  propertyr   rx   __classcell__)r   s   @r;   r{   r{      sf   *F
-/ 	z 		
 	. 	V 	 	E 	 	. 	2 	( 		 	8 	*  	 !" 	V#$ #"#4 2%8.3'9JH
 $#&$ I2 YK824.2,K &*OXc]) H,!L%N%N/"I)+c +S +T +(  
3tCH~ 3jS>	$&??	@G2%# % %4$ 44 4T 10Xd3i-@ 0D 0d4  #    	T#s(^ 	 	 
4S> 
 
4 (3 ( ( uS#X   ?#c( ? ? $  r=   r{   c            	           \ rS rSrSr\SS\S\S\\	   4S jj5       r
\SS\S\S\\   4S jj5       rS\S\\\4   4S	 jrS\S\\\4   4S
 jrS\S\4S jrSrg)r   id  zCustom converter for Django.Nr)   dscr*   c                 L    [         R                  " U R                  S5      5      $ )zHReturn MySQL TIME data type as datetime.time()

Returns datetime.time()
zutf-8)r   
parse_timedecoder)   ro  s     r;   _time_to_python$DjangoMySQLConverter._time_to_pythoni  s     ##ELL$9::r=   c                 @    U (       a  [         R                  " U 5      $ S$ )a  Connector/Python always returns naive datetime.datetime

Connector/Python always returns naive timestamps since MySQL has
no time zone support.

- A naive datetime is a datetime that doesn't know its own timezone.

Django needs a non-naive datetime, but in this method we don't need
to make a datetime value time zone aware since Django itself at some
point will make it aware (at least in versions 3.2.16 and 4.1.2) when
USE_TZ=True. This may change in a future release, we need to keep an
eye on this behaviour.

Returns datetime.datetime()
N)r   _datetime_to_pythonrs  s     r;   rw  (DjangoMySQLConverter._datetime_to_pythonq  s    " =B~11%8KtKr=   c                 $    U R                  U5      $ rB   _str_to_mysqlrF   r)   s     r;   _safestring_to_mysql)DjangoMySQLConverter._safestring_to_mysql      !!%((r=   c                 $    U R                  U5      $ rB   rz  r|  s     r;   _safetext_to_mysql'DjangoMySQLConverter._safetext_to_mysql  r  r=   c                 $    U R                  U5      $ rB   )_bytes_to_mysqlr|  s     r;   _safebytes_to_mysql(DjangoMySQLConverter._safebytes_to_mysql  s    ##E**r=   ry   rB   )rq   rr   rs   rt   ru   rv   bytesr   r   r   rt  r   rw  rw   r   r   r}  r  r  rx   ry   r=   r;   r   r   d  s    & ;u ;3 ;(4. ; ; L5 Ls Lhx>P L L()# )%z8I2J )) )eZ6G0H )+ +5 +r=   r   )Jru   r/   r   r   typingr   r   r   r   r	   r
   r   r   r   r   r   django.confr   django.core.exceptionsr   	django.dbr   django.db.backends.base.baser   django.utilsr   r   django.utils.functionalr   mysql.connector.typesr   mysql.connectorr]   mysql.connector.conversionr   mysql.connector.custom_typesr   mysql.connector.poolingr   r   r   r   ImportErrorerr_mysql_connectorr   r7   clientr    creationr!   r  r"   r!  r#   
operationsr$   schemar%   
validationr&   r^   r0  DatabaseErrorr  r_   r   mysql.connector.abstractsr'   r(   r<   r?   r{   r   ry   r=   r;   <module>r     sI  >  #    ! 7 $ < , 3 6X97=SS2 I " & & 0 * ( *--OO55 ??33 ??33 V2 2Z 2*]! ]!@C) CL)+> )+o  X
!GuM
NTWWX
  Is*    E 7E* E'E""E'*E54E5