+
    i)                       R t ^ RIHt ^ RIt^ RIHt ^ RIHt ^ RIHt ^ RIHt ^ RIH	t	 ^ RIH
t
 ^ R	IHt ^R
IHt ^RIHt ^RIHt ^RIHt ^RIHt ^RIHt ]	'       dC   ^RIHt ^RIHt ^RIHt ^RIHt ^RIHt ^RIHt ^RIHt ^RIHt ^RI H!t! ^RI"H#t# ^RI$H%t% R#t& ! R R]P                  ]PN                  ,          4      t( ! R R]4      t) ! R R ]4      t* ! R! R"]4      t+]+t,R# )$a  

.. dialect:: mysql+mariadbconnector
    :name: MariaDB Connector/Python
    :dbapi: mariadb
    :connectstring: mariadb+mariadbconnector://<user>:<password>@<host>[:<port>]/<dbname>
    :url: https://pypi.org/project/mariadb/

Driver Status
-------------

MariaDB Connector/Python enables Python programs to access MariaDB and MySQL
databases using an API which is compliant with the Python DB API 2.0 (PEP-249).
It is written in C and uses MariaDB Connector/C client library for client server
communication.

Note that the default driver for a ``mariadb://`` connection URI continues to
be ``mysqldb``. ``mariadb+mariadbconnector://`` is required to use this driver.

.. mariadb: https://github.com/mariadb-corporation/mariadb-connector-python

)annotationsN)Any)Optional)Sequence)Tuple)TYPE_CHECKING)Union)UUID)MySQLCompiler)MySQLDialect)MySQLExecutionContext)sql)util)sqltypes)
Connection)ConnectArgsType)DBAPIConnection)DBAPICursor)DBAPIModule)Dialect)IsolationLevel)PoolProxiedConnection)URL)SQLCompiler)_ResultProcessorTypec                  "    ] tR t^AtR R ltRtR# )_MariaDBUUIDc               $    V ^8  d   QhRRRRRR/# )   dialectr   coltypeobjectreturnz#Optional[_ResultProcessorType[Any]] )formats   "ڄC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy/dialects/mysql/mariadbconnector.py__annotate___MariaDBUUID.__annotate__E   s$      )/	,    c                	F    V P                   '       d	   R  R lpV# R R lpV# )c                    V ^8  d   QhRRRR/# r   valuer   r"   r#   )r$   s   "r%   r&   3_MariaDBUUID.result_processor.<locals>.__annotate__J         s s r(   c                j    V e/   \        V R4      '       d   V P                  R4      p \        V 4      p V # Ndecodeascii)hasattrr1   _python_UUIDr,   s   &r%   process._MariaDBUUID.result_processor.<locals>.processJ   s2    $uh// %W 5(/Er(   c                    V ^8  d   QhRRRR/# r+   r#   )r$   s   "r%   r&   r-   T   r.   r(   c                |    V e8   \        V R4      '       d   V P                  R4      p \        \        V 4      4      p V # r0   )r3   r1   strr4   r5   s   &r%   r6   r7   T   s7    $uh// %W 5U 34Er(   )as_uuid)selfr   r    r6   s   &&& r%   result_processor_MariaDBUUID.result_processorE   s%     <<< N Nr(   r#   N)__name__
__module____qualname____firstlineno__r=   __static_attributes__r#   r(   r%   r   r   A   s     r(   r   c                  b   a  ] tR t^^t$ RtR]R&   R R ltR R ltR V 3R	 lltR
 R lt	Rt
V ;t# )&MySQLExecutionContext_mariadbconnectorNzOptional[int]
_lastrowidc                   V ^8  d   QhRR/# r   r"   r   r#   )r$   s   "r%   r&   3MySQLExecutionContext_mariadbconnector.__annotate__a   s     = =; =r(   c                	:    V P                   P                  R R7      # )Fbuffered_dbapi_connectioncursorr<   s   &r%   create_server_side_cursor@MySQLExecutionContext_mariadbconnector.create_server_side_cursora   s    %%,,e,<<r(   c                   V ^8  d   QhRR/# rH   r#   )r$   s   "r%   r&   rI   d   s     < <{ <r(   c                	:    V P                   P                  R R7      # )TrK   rM   rP   s   &r%   create_default_cursor<MySQLExecutionContext_mariadbconnector.create_default_cursord   s    %%,,d,;;r(   c                   V ^8  d   QhRR/# )r   r"   Noner#   )r$   s   "r%   r&   rI   g   s     4 44 4r(   c                	P  < \         SV `  4        V P                  P                  V n        \
        '       d#   \        V P                  \        4      '       g   Q hV P                  '       d<   V P                  P                  '       d   V P                  P                  V n        R # R # R # N)super	post_execrO   rowcount	_rowcountr   
isinstancecompiledr   isinsertpostfetch_lastrowid	lastrowidrF   )r<   	__class__s   &r%   r\   0MySQLExecutionContext_mariadbconnector.post_execg   sk    --=dmm[9999===T]]>>>"kk33DO ?=r(   c                   V ^8  d   QhRR/# )r   r"   intr#   )r$   s   "r%   r&   rI   q   s      s r(   c                	R    \         '       d   V P                  f   Q hV P                  # rZ   )r   rF   rP   s   &r%   get_lastrowid4MySQLExecutionContext_mariadbconnector.get_lastrowidq   s!    =??...r(   )rF   r^   )r?   r@   rA   rB   rF   __annotations__rQ   rU   r\   ri   rC   __classcell__rd   s   @r%   rE   rE   ^   s+     $J$=<4 4 r(   rE   c                      ] tR t^wtRtR# )MySQLCompiler_mariadbconnectorr#   N)r?   r@   rA   rB   rC   r#   r(   r%   ro   ro   w   s    r(   ro   c                    a  ] tR t^{tRtRtRtRtRtRt	Rt
RtRt]t]tRt]P&                  ! ]P*                  ]P.                  ]/4      t]P2                  R R l4       tR V 3R llt]R	 R
 l4       tR V 3R lltR R ltR R lt R R lt!R R lt"R R lt#R V 3R llt$R R lt%R R lt&R"R R llt'R"R R  llt(R!t)V ;t*# )#MySQLDialect_mariadbconnectormariadbconnectorTutf8mb4qmarkc                   V ^8  d   QhRR/# )r   r"   zTuple[int, ...]r#   )r$   s   "r%   r&   *MySQLDialect_mariadbconnector.__annotate__   s          r(   c                	   V P                   '       dj   \        V P                   R 4      '       dN   \        \        P                  ! RV P                   P
                  4       Uu. uF  p\        V4      NK  	  up4      # R# u upi )__version__z(\d+)(?:[-\.]?|$))c   ry   ry   )dbapir3   tuplerefindallrx   rg   )r<   xs   & r%   _dbapi_version,MySQLDialect_mariadbconnector._dbapi_version   sr    :::'$**m<<  ZZ,djj.D.D F   s   !A>c                    V ^8  d   QhRRRR/# )r   kwargsr   r"   rX   r#   )r$   s   "r%   r&   rv      s     	 	 	 	r(   c                	   < \         SV `  ! R/ VB  R V n        V P                  eD   V P                  \
        8  d-   \        RRP                  R \
         4       4      ,          4      hR# R# )rt   Nz?The minimum required version for MariaDB Connector/Python is %s.c              3  8   "   T F  p\        V4      x  K  	  R # 5irZ   )r:   ).0r~   s   & r%   	<genexpr>9MySQLDialect_mariadbconnector.__init__.<locals>.<genexpr>   s     K/J!s1vv/Js   r#   )r[   __init__
paramstylerz   r   mariadb_cpy_minimum_versionNotImplementedErrorjoin)r<   r   rd   s   &,r%   r   &MySQLDialect_mariadbconnector.__init__   si    "6"!::!""%@@)-hhK/JKKL  A "r(   c                   V ^8  d   QhRR/# )r   r"   r   r#   )r$   s   "r%   r&   rv      s     % %[ %r(   c                	    \        R 4      # )mariadb)
__import__)clss   &r%   import_dbapi*MySQLDialect_mariadbconnector.import_dbapi   s    )$$r(   c               (    V ^8  d   QhRRRRRRRR/# )	r   eDBAPIModule.Error
connectionz7Optional[Union[PoolProxiedConnection, DBAPIConnection]]rO   zOptional[DBAPICursor]r"   boolr#   )r$   s   "r%   r&   rv      s3       L &	
 
r(   c                	   < \         SV `  WV4      '       d   R # \        WP                  P                  4      '       d,   \        V4      P                  4       pRV9   ;'       g    RV9   # R# )Tznot connectedzisn't validF)r[   is_disconnectr_   loaded_dbapiErrorr:   lower)r<   r   r   rO   str_erd   s   &&&& r%   r   +MySQLDialect_mariadbconnector.is_disconnect   s[     7 77,,2233FLLNE"e+EE}/EEr(   c                    V ^8  d   QhRRRR/# )r   urlr   r"   r   r#   )r$   s   "r%   r&   rv      s     % %s % %r(   c                	   VP                  4       pVP                  VP                  4       . ROp. ROpV F  p\        P                  ! W%\
        4       K   	  V F  p\        P                  ! W%\        4       K   	  VP                  R^ 4      pV P                  eR    \        V P                  P                  R,           4      P                  P                  pWgP                  ,          pWbR&   . V3#   \        \        3 d    RT n         L"i ; i)connect_timeoutclient_flagz.constants.CLIENTF)r   read_timeoutwrite_timeoutr   port	pool_size)local_infilessl_verify_certsslpool_reset_connectioncompress)translate_connect_argsupdatequeryr   coerce_kw_typerg   r   getrz   r   r?   	constantsCLIENT
FOUND_ROWSAttributeErrorImportErrorsupports_sane_rowcount)r<   r   opts
int_paramsbool_paramskeyr   CLIENT_FLAGSs   &&      r%   create_connect_args1MySQLDialect_mariadbconnector.create_connect_args   s    ))+CII


 C3/ C40 
 hh}a0::!4)JJ''*== )FF  666 #.4x #K0 4.3+4s   AC1 1DDc                    V ^8  d   QhRRRR/# )r   	exceptionr   r"   rg   r#   )r$   s   "r%   r&   rv      s      -> 3 r(   c                	4     VP                   pV#    Rp T# ; i)   )errno)r<   r   rcs   && r%   _extract_error_code1MySQLDialect_mariadbconnector._extract_error_code   s(    	ooB 		B	s    c                    V ^8  d   QhRRRR/# )r   r   r   r"   r:   r#   )r$   s   "r%   r&   rv      s      *  r(   c                	    R # )rs   r#   )r<   r   s   &&r%   _detect_charset-MySQLDialect_mariadbconnector._detect_charset   s    r(   c                    V ^8  d   QhRRRR/# )r   
dbapi_connr   r"   zSequence[IsolationLevel]r#   )r$   s   "r%   r&   rv      s     	
 	
)	
	!	
r(   c                	    R# )SERIALIZABLE)r   zREAD UNCOMMITTEDzREAD COMMITTEDzREPEATABLE READ
AUTOCOMMITr#   r<   r   s   &&r%   get_isolation_level_values8MySQLDialect_mariadbconnector.get_isolation_level_values   s    
 	
r(   c                    V ^8  d   QhRRRR/# )r   r   r   r"   r   r#   )r$   s   "r%   r&   rv      s     + +O + +r(   c                	,    \        VP                  4      # rZ   )r   
autocommitr   s   &&r%   detect_autocommit_setting7MySQLDialect_mariadbconnector.detect_autocommit_setting   s    J))**r(   c               $    V ^8  d   QhRRRRRR/# )r   dbapi_connectionr   levelr   r"   rX   r#   )r$   s   "r%   r&   rv     s)     A A /A8FA	Ar(   c                	T   < VR 8X  d
   RVn         R# RVn         \        SV `	  W4       R# )r   TFN)r   r[   set_isolation_level)r<   r   r   rd   s   &&&r%   r   1MySQLDialect_mariadbconnector.set_isolation_level  s-     L *.'*/'G'(8@r(   c               $    V ^8  d   QhRRRRRR/# r   r   r   xidr   r"   rX   r#   )r$   s   "r%   r&   rv     s!     
 
J 
S 
T 
r(   c           
     	    VP                  \        P                  ! R 4      P                  \        P                  ! RVRR7      4      4       R# )zXA BEGIN :xidr   Tliteral_executeNexecuter   text
bindparams	bindparamr<   r   r   s   &&&r%   do_begin_twophase/MySQLDialect_mariadbconnector.do_begin_twophase  s7    HH_%00eS$?	
r(   c               $    V ^8  d   QhRRRRRR/# r   r#   )r$   s   "r%   r&   rv     s!     

 

j 

s 

t 

r(   c           
     	2   VP                  \        P                  ! R 4      P                  \        P                  ! RVRR7      4      4       VP                  \        P                  ! R4      P                  \        P                  ! RVRR7      4      4       R# )XA END :xidr   Tr   zXA PREPARE :xidNr   r   s   &&&r%   do_prepare_twophase1MySQLDialect_mariadbconnector.do_prepare_twophase  so    HH]#..eS$?	

 	HH&'22eS$?	
r(   c          
     ,    V ^8  d   QhRRRRRRRRRR	/# 
r   r   r   r   r   is_preparedr   recoverr"   rX   r#   )r$   s   "r%   r&   rv     s<     
 

 
 	

 
 

r(   c           
     	B   V'       gL   VP                  \        P                  ! R 4      P                  \        P                  ! RVRR7      4      4       VP                  \        P                  ! R4      P                  \        P                  ! RVRR7      4      4       R# )r   r   Tr   zXA ROLLBACK :xidNr   r<   r   r   r   r   s   &&&&&r%   do_rollback_twophase2MySQLDialect_mariadbconnector.do_rollback_twophase  st     '22MM%dC
 	HH'(33eS$?	
r(   c          
     ,    V ^8  d   QhRRRRRRRRRR	/# r   r#   )r$   s   "r%   r&   rv   2  s<     
 

 
 	

 
 

r(   c           
     	    V'       g   V P                  W4       VP                  \        P                  ! R 4      P	                  \        P
                  ! RVRR7      4      4       R# )zXA COMMIT :xidr   Tr   N)r   r   r   r   r   r   r   s   &&&&&r%   do_commit_twophase0MySQLDialect_mariadbconnector.do_commit_twophase2  sK     $$Z5HH%&11eS$?	
r(   )r   r   )TF)+r?   r@   rA   rB   driversupports_statement_cachesupports_unicode_statementsencodingconvert_unicoder   supports_sane_multi_rowcountsupports_native_decimaldefault_paramstylerE   execution_ctx_clsro   statement_compilersupports_server_side_cursorsr   update_copyr   colspecsr   Uuidr   memoized_propertyr   r   classmethodr   r   r   r   r   r   r   r   r   r   r   r   rC   rl   rm   s   @r%   rq   rq   {   s    F# #'HO!#' " >7#' |<H 
   	 	 % % %N	
+A A



&
 
r(   rq   )r       r   )-__doc__
__future__r   r|   typingr   r   r   r   r   r   uuidr	   r4   baser
   r   r    r   r   r   engine.baser   engine.interfacesr   r   r   r   r   r   r   
engine.urlr   sql.compilerr   sql.type_apir   r   _UUID_RETURNr   rE   ro   rq   r   r#   r(   r%   <module>r     s   , # 	        %   '   )4400,3:!+4 ( 8==!6!67 :-B 2	] 	D
L D
N (r(   