
    ,h:M                      S r SSKJr  SSKrSSKrSSKrSSK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  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  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  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   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%  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+  S S$KJ,r,  S S%K-J.r.  S S&K-J/r/  S S'K-J0r0  S S(K-J1r1  S S$K-J,r2  S S)K3J4r4  S S*K5J6r6  S S+K7J8r8  S S,K7J9r9  S S-K7J:r:  S S.K;J<r<  S S/K=J>r>  S S0K=J?r?  \	R.                  (       a  SS1K@JArA  SS2KJBrB  SS3KJCrC  SS4KJDrD  SS5KJErE  SS6KJFrF  SS7KJGrG  SS8KJHrH  SS9KJIrI  SS:KJJrJ  SS;KJKrK  SS<KJLrL  SS=KJMrM  SS>KJNrN  SS?KOJPrP  SS@KQJRrR  S SAK)JSrS  S SBK+JTrT  S SCK+JUrU  S SDK-JVrV  S SEK7JWrW  S SFK7JXrX  S SGK7JYrY  S SHKZJ[r[  S SIKZJ\r\  S SJK;J]r]  S SKK^J_r_  S SLK`Jara  S SMK`Jbrb  S SNK`Jcrc  \R                  " SO\R                  \R                  -  5      rg\h" \!5      u  rirjrkrlrm " SP SQ\#5      rn " SR SS\n5      ro " ST SU\%5      rp\p\nlq        g)Va  Default implementations of per-dialect sqlalchemy.engine classes.

These are semi-private implementation classes which are only of importance
to database dialect authors; dialects will usually use the classes here
as the base class for their own corresponding classes.

    )annotationsN)perf_counter)Any)Callable)cast)Dict)List)Mapping)MutableMapping)MutableSequence)Optional)Sequence)Set)Tuple)Type)TYPE_CHECKING)Union   )characteristics)cursor)
interfaces)
Connection)
CacheStats)DBAPICursor)Dialect)ExecuteStyle)ExecutionContext)
ObjectKind)ObjectScope   )event)exc)pool)util)compiler)dml)
expression)type_api)is_tuple_type)_NoArg)DDLCompiler)InsertmanyvaluesSentinelOpts)SQLCompiler)quoted_name)Final)Literal)
ModuleType)Engine)ResultFetchStrategy)_CoreMultiExecuteParams)_CoreSingleExecuteParams)_DBAPICursorDescription)_DBAPIMultiExecuteParams)_DBAPISingleExecuteParams)_ExecuteOptions)_MutableCoreSingleExecuteParams)_ParamStyle)ConnectArgsType)DBAPIConnection)IsolationLevel)Row)URL)_ListenerFnType)Pool)PoolProxiedConnection)
Executable)Compiled)Linting)ResultColumnsEntry)DMLState)
UpdateBase)BindParameter)Column)_BindProcessorType)_ResultProcessorType)
TypeEnginez	\s*SELECTc                  z   \ rS rSr% Sr\R                  r\R                  r	\R                  r\R                  rSrSrSrSrSrSr\R*                  R,                  rSrS\S'   SrS\S'   S	r\rSrSrSr Sr!Sr"Sr#Sr$Sr%Sr&Sr'Sr(Sr)Sr*Sr+Sr,Sr-Sr.Sr/Sr0Sr1Sr2Sr3\4Rj                  " \6Rn                  " 5       \6Rp                  " 5       S
.5      r9\4Rj                  " \4Rt                  \4Rv                  " S5      \4Rv                  " S5      \4Rt                  \4Rt                  \4Rt                  \4Rx                  S.5      r=S\S'   Sr>Sr?Sr@SrAS\S'   SrBS\S'   SrCS\S'   SrDS\S'   SrESrF0 rGS\S'   SrHSrI SrJ SrK SrL SrMSrNS\S'   SrOS\S'   \PR                  rRS\S'   S rSS!\S"'   S#rTSrUSrVSrWSrXSrYSrZS\S$'   Sr[Sr\Sr]S%r^\4R                  " S&S'S(9SSSSSSS\`R                  S\b" \R                  5      S4                       SjS) jj5       rd\e\4R                  " S*S+5      S, 5       5       rg\4R                  S- 5       ri\4R                  S. 5       rjSrkSrl\4R                  SkS/ j5       rm\4R                  S0 5       rnSlS1 jro\4R                  S2 5       rp\4R                  S3 5       rq\eS4 5       rr\eS5 5       rs\tSmS6 j5       ruSmS7 jrv\tS8 5       rwSnS9 jrxSoS: jrySpS; jrzS< r{S= r|S> r}SqS? jr~        SrS@ jrSsSA jrStSB jrSuSC jr      SvSD jr      SwSE jrSF rSG rSH rSI rSJ rSK rSL r\4R                  SM 5       rSxSN jrSxSO jrSP rSQ rSR rSS rST rSqSU jrSqSV jrSqSW jr        SySX jr\4GR0                  SY 5       rSZ rS[ rS\ rS] rS^ rS_ rS` rSa rSb rSc rSd rSe rSf rSg rSh rSirg)zDefaultDialectv   z!Default implementation of DialectTFNzOptional[Set[Any]]include_set_input_sizesexclude_set_input_sizesr   )isolation_levellogging_tokendebug)pool_timeoutecho	echo_poolpool_recycle	pool_sizemax_overflowfutureMapping[str, Any]engine_config_typesdefaulti'  Optional[int]#_user_defined_max_identifier_lengthzOptional[str]rT   max_index_name_lengthmax_constraint_name_lengthz<MutableMapping[Type[TypeEngine[Any]], Type[TypeEngine[Any]]]colspecsnamedDEFAULTbooluse_insertmanyvalues!use_insertmanyvalues_wo_returningr,   "insertmanyvalues_implicit_sentineli  intinsertmanyvalues_page_sizei  default_schema_namezutf-8)1.4a  The :paramref:`_sa.create_engine.empty_in_strategy` keyword is deprecated, and no longer has any effect.  All IN expressions are now rendered using the "expanding parameter" strategy which renders a set of boundexpressions, or an "empty set" SELECT, at statement executiontime.)ro   zThe :paramref:`_sa.create_engine.server_side_cursors` parameter is deprecated and will be removed in a future release.  Please use the :paramref:`_engine.Connection.execution_options.stream_results` parameter.)empty_in_strategyserver_side_cursorsc                   U(       a1  U R                   (       d  [        R                  " SU -  5      eSU l        [	        U SS5      (       a6  [
        R                  " SS5        [        R                  R                  U l
        SU l        S U l        X0l        Ub  Xl        O:U R                  b  U R                  R                  U l        OU R                  U l        U R                  S;   U l        U R!                  U 5      U l        X l        [	        U SS 5      nUb,  ['        [(        [*        R,                     U R.                  5      nOU R0                  nU" U 5      =U l        U l        Ub  XPl        X`l        U R6                  (       a  U R6                  U l        Xpl        Xl        U	b  Xl        U[@        RB                  La  Xl"        g g )	Nz/Dialect %s does not support server side cursorsTuse_setinputsizesFzoThe dialect-level use_setinputsizes attribute is deprecated.  Please use bind_typing = BindTyping.SETINPUTSIZES2.0)qmarkformatnumericnumeric_dollartype_compiler)#supports_server_side_cursorsr"   ArgumentErrorrq   getattrr$   warn_deprecatedr   
BindTypingSETINPUTSIZESbind_typing
positional_ischemadbapi
paramstyledefault_paramstyleprepareridentifier_preparer_on_connect_isolation_levelr   r   r%   GenericTypeCompilerry   type_compiler_clstype_compiler_instancesupports_native_booleanrb   max_identifier_lengthlabel_lengthcompiler_lintingri   r*   NO_ARGrm   )selfr   rT   r   implicit_returningr   r   r   rm   ri   r   rq   kwargslegacy_tt_callablett_callables                  Q/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/engine/default.py__init__DefaultDialect.__init__  s   H 44''EL  ,0(4,e44  9 	  *44BBD
!(OZZ#"jj33DO"55DO// .
 
 $(==#6 +:($T?DA)X112""K
 00K;Ft;LL#d&8".+B(3H03388 & ) 0+(<%%V]]:.H+ ;    rt   z]full_returning is deprecated, please use insert_returning, update_returning, delete_returningc                f    U R                   =(       a    U R                  =(       a    U R                  $ N)insert_returningupdate_returningdelete_returningr   s    r   full_returningDefaultDialect.full_returningx  s.     !! &%%&%%	
r   c                @    U R                   =(       a    U R                  $ )a  Default implementation for insert_executemany_returning, if not
otherwise overridden by the specific dialect.

The default dialect determines "insert_executemany_returning" is
available if the dialect in use has opted into using the
"use_insertmanyvalues" feature. If they haven't opted into that, then
this attribute is False, unless the dialect in question overrides this
and provides some other implementation (such as the Oracle Database
dialects).

r   ri   r   s    r   insert_executemany_returning+DefaultDialect.insert_executemany_returning  s     $$B)B)BBr   c                @    U R                   =(       a    U R                  $ )al  Default implementation for
insert_executemany_returning_deterministic_order, if not otherwise
overridden by the specific dialect.

The default dialect determines "insert_executemany_returning" can have
deterministic order only if the dialect in use has opted into using the
"use_insertmanyvalues" feature, which implements deterministic ordering
using client side sentinel columns only by default.  The
"insertmanyvalues" feature also features alternate forms that can
use server-generated PK values as "sentinels", but those are only
used if the :attr:`.Dialect.insertmanyvalues_implicit_sentinel`
bitflag enables those alternate SQL forms, which are disabled
by default.

If the dialect in use hasn't opted into that, then this attribute is
False, unless the dialect in question overrides this and provides some
other implementation (such as the Oracle Database dialects).

r   r   s    r   4insert_executemany_returning_sort_by_parameter_orderCDefaultDialect.insert_executemany_returning_sort_by_parameter_order  s    * $$B)B)BBr   c                h    U R                   c  [        R                  " SU  S35      eU R                   $ )NDialect z\ does not have a Python DBAPI established and cannot be used for actual database interaction)r   r"   InvalidRequestErrorr   s    r   loaded_dbapiDefaultDialect.loaded_dbapi  s>    ::))4& !E E  zzr   c                N    U R                   [        R                  R                  L $ r   )r   r   r~   RENDER_CASTSr   s    r   _bind_typing_render_casts(DefaultDialect._bind_typing_render_casts  s    :#8#8#E#EEEr   c                    [        U[        5      (       d,  [        R                  " S[        < S[	        U5      < S35      eg )Nz7The argument passed to Dialect.has_table() should be a z, got z. Additionally, the Dialect.has_table() method is for internal dialect use only; please use ``inspect(some_engine).has_table(<tablename>>)`` for public API use.)
isinstancer   r"   r{   type)r   args     r   _ensure_has_table_connection+DefaultDialect._ensure_has_table_connection  s8    #z**## *4T#Y@  +r   c                    U R                   R                  R                  SS 5      nUc2  [        R                  " SU R
                  < SU R                  < S3SS9  [        U5      $ )Nsupports_statement_cacher   :a   will not make use of SQL compilation caching as it does not set the 'supports_statement_cache' attribute to ``True``.  This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions.  Dialect maintainers should seek to set this attribute to True after appropriate development and testing for SQLAlchemy 1.4 caching support.   Alternatively, this attribute may be set to False which will disable this warning.cprf)code)	__class____dict__getr$   warnnamedriverrh   )r   sscs     r   _supports_statement_cache(DefaultDialect._supports_statement_cache  sU    nn%%))*DdK;II #ii	6  Cyr   c                ,    [         R                  " 5       $ r   )weakrefWeakKeyDictionaryr   s    r   _type_memosDefaultDialect._type_memos  s    ((**r   c                :    U R                   S-   U R                  -   $ )N+)r   r   r   s    r   dialect_description"DefaultDialect.dialect_description  s    yy3,,r   c                    U R                   $ )zTrue if this dialect supports sane rowcount even if RETURNING is
in use.

For dialects that don't support RETURNING, this is synonymous with
``supports_sane_rowcount``.

)supports_sane_rowcountr   s    r    supports_sane_rowcount_returning/DefaultDialect.supports_sane_rowcount_returning  s     ***r   c                8    [        U S[        R                  5      $ )N	poolclass)r|   r#   	QueuePool)clsurls     r   get_pool_classDefaultDialect.get_pool_class  s    sK88r   c                $    U R                  U5      $ r   )r   )r   r   s     r   get_dialect_pool_class%DefaultDialect.get_dialect_pool_class  s    ""3''r   c                    SR                  U R                  R                  S5      SS 5      n [        US-   5        g ! [         a     g f = f)N.r   z
.provision)join
__module__split
__import__ImportError)r   packages     r   load_provisioning DefaultDialect.load_provisioning  sJ    ((3>>//4Qr:;	w-. 		s   > 
A
Ac                0   ^  T R                   b  U 4S jnU$ g )Nc                >   > TR                  U TR                  5        g r   )_assert_and_set_isolation_levelr   )
dbapi_connconn_recr   s     r   builtin_connect:DefaultDialect._builtin_onconnect.<locals>.builtin_connect   s    44 @ @r   )r   )r   r   s   ` r   _builtin_onconnect!DefaultDialect._builtin_onconnect  s    ++7
 #"r   c                T    U R                  U5      U l         U R                  U5      U l         U R                  UR                  R                  5      U l        U R                  (       d  U R                  U5      nU(       a  X l        U R                  (       aJ  U R                  U R                  :  a/  [        R                  " SU R                  U R                  4-  5      eg g ! [         a
    S U l         Nf = f! [         a
    S U l         Nf = f! [         a
    S U l         Nf = f)NzQLabel length of %d is greater than this dialect's maximum identifier length of %d)_get_server_version_infoserver_version_infoNotImplementedError_get_default_schema_namern   get_default_isolation_level
connectiondbapi_connectiondefault_isolation_levelrb   _check_max_identifier_lengthr   r   r"   r{   )r   r   max_ident_lengths      r   
initializeDefaultDialect.initialize	  s(   	,'+'D'D(D$
	,'+'D'D(D$	0+/+K+K%%66,D( 77#@@L-=* !!D$>$>>##3$$d&@&@AB  ? - # 	,'+D$	, # 	,'+D$	, # 	0+/D(	0s3   C% C< *D %C98C9<DDD'&D'c                    g r    r   s    r   
on_connectDefaultDialect.on_connect-  s    r   c                    g)zPerform a connection / server version specific check to determine
the max_identifier_length.

If the dialect's class level max_identifier_length should be used,
can return None.

.. versionadded:: 1.3.9

Nr   r   r   s     r   r   +DefaultDialect._check_max_identifier_length1  s     r   c                $    U R                  U5      $ )a  Given a DBAPI connection, return its isolation level, or
a default isolation level if one cannot be retrieved.

May be overridden by subclasses in order to provide a
"fallback" isolation level for databases that cannot reliably
retrieve the actual isolation level.

By default, calls the :meth:`_engine.Interfaces.get_isolation_level`
method, propagating any exceptions raised.

.. versionadded:: 1.3.22

)get_isolation_levelr   r   s     r   r   *DefaultDialect.get_default_isolation_level=  s     ''
33r   c                B    [         R                  " XR                  5      $ )a  Provide a database-specific :class:`.TypeEngine` object, given
the generic object which comes from the types module.

This method looks for a dictionary called
``colspecs`` as a class or instance-level variable,
and passes on to :func:`_types.adapt_type`.

)r(   
adapt_typere   )r   typeobjs     r   type_descriptorDefaultDialect.type_descriptorM  s     ""7MM::r   c                    U R                   " X4SU0UD6(       d  gU R                  " X4SU0UD6 H  nUS   U:X  d  M    g   g)NschemaFr   T)	has_tableget_indexes)r   r   
table_name
index_namer  kwidxs          r   	has_indexDefaultDialect.has_indexX  sY    ~~jJVJrJ##
+1
57
C 6{j(	
 r   c                ,    X R                   " U40 UD6;   $ r   )get_schema_names)r   r   schema_namer  s       r   
has_schemaDefaultDialect.has_schemac  s     33JE"EEEr   c                ~    [        U5      U R                  :  a$  [        R                  " SXR                  4-  5      eg )Nz7Identifier '%s' exceeds maximum length of %d characters)lenr   r"   IdentifierError)r   idents     r   validate_identifier"DefaultDialect.validate_identifierh  s@    u:222%%I4456  3r   c                :    U R                   R                  " U0 UD6$ r   )r   connect)r   cargscparamss      r   r$  DefaultDialect.connecto  s      ((%;7;;r   c                `    UR                  5       nUR                  UR                  5        / U4$ r   )translate_connect_argsupdatequery)r   r   optss      r   create_connect_args"DefaultDialect.create_connect_argss  s*    ))+CIIDzr   c                   ^ ^^ [        T R                  5      R                  T5      nU(       aB  [        R                  " U4S jU 5       5      m[
        R                  " US5      UU 4S j5       ng g )Nc              3  0   >#    U  H  oTU   4v   M     g 7fr   r   .0r   r,  s     r   	<genexpr>>DefaultDialect.set_engine_execution_options.<locals>.<genexpr>        D/>ttDz"   engine_connectc                *   > TR                  U T5        g r   )_set_connection_characteristics)r   r   r   s    r   set_connection_characteristicsSDefaultDialect.set_engine_execution_options.<locals>.set_connection_characteristics  s    44r   )setconnection_characteristicsintersectionr$   immutabledictr!   listens_for)r   enginer,  supported_namesr:  r   s   ` `  @r   set_engine_execution_options+DefaultDialect.set_engine_execution_optionsy  sn     d==>KK
 151C1C D/>D 2O v'78 9 r   c                   ^ [        U R                  5      R                  T5      nU(       a2  [        R                  " U4S jU 5       5      nU R                  X5        g g )Nc              3  0   >#    U  H  oTU   4v   M     g 7fr   r   r1  s     r   r3  BDefaultDialect.set_connection_execution_options.<locals>.<genexpr>  r5  r6  )r<  r=  r>  r$   r?  r9  )r   r   r,  rB  r   s     `  r    set_connection_execution_options/DefaultDialect.set_connection_execution_options  s\     d==>KK
 151C1C D/>D 2O 00M	 r   c                z   UR                   " 5        VVs/ s H  u  p4X0R                  U   U4PM     nnnUR                  5       (       ac  U VVVs/ s H  u  p6nUR                  (       d  M  X64PM     nnnnU(       a/  [        R
                  " SSR                  S U 5       5      -  5      eUR                  R                  n	U H  u  pznU
R                  XX5        M     UR                  R                  R                  R                  [        R                  " U R                  U5      5        g s  snnf s  snnnf )NzThis connection has already initialized a SQLAlchemy Transaction() object via begin() or autobegin; %s may not be altered unless rollback() or commit() is called first., c              3  *   #    U  H	  u  pUv   M     g 7fr   r   )r2  r   objs      r   r3  ADefaultDialect._set_connection_characteristics.<locals>.<genexpr>  s      Bz)$zs   )itemsr=  in_transactiontransactionalr"   r   r   r   r   set_connection_characteristic_connection_recordfinalize_callbackappend	functoolspartial_reset_characteristics)r   r   r   r   valuecharacteristic_valuesrM  _
trans_objsr   characteristics              r   r9  .DefaultDialect._set_connection_characteristics  s3     /446!
6 2248%@6 	 !

 $$&& %:$9LDq$$ $9  
 --' yy Bz BB	D  &00AA(=$Au88"2 )> 	00BBIId99?K	
3!
s   D0D6,D6c                V    U H#  nU R                   U   nUR                  X5        M%     g r   )r=  reset_characteristic)r   r   r   characteristic_namer]  s        r   rX  %DefaultDialect._reset_characteristics  s0    #2!<<#N //G	 $3r   c                    g r   r   r   r   s     r   do_beginDefaultDialect.do_begin      r   c                $    UR                  5         g r   )rollbackrd  s     r   do_rollbackDefaultDialect.do_rollback  s    !!#r   c                $    UR                  5         g r   )commitrd  s     r   	do_commitDefaultDialect.do_commit  s    !r   c                &    U R                  U5        g r   )do_closerd  s     r   do_terminateDefaultDialect.do_terminate  s    &'r   c                $    UR                  5         g r   )closerd  s     r   rq  DefaultDialect.do_close  s     r   c                Z    [        [        R                  " S5      R                  U S95      $ )Nr   dialect)strr'   selectcompiler   s    r   _dialect_specific_select_one+DefaultDialect._dialect_specific_select_one  s&    :$$Q'///=>>r   c           	     X    U R                  U5      $ ! U R                  R                   a|  nU R                  X!S 5      nU R                  (       aG   [
        R                  " UU USSS9  O-! [        R                   a  nUR                  n S nAOS nAff = fU(       a   S nAge S nAff = f)NFT)is_disconnectinvalidate_pool_on_disconnectis_pre_ping)
do_pingr   Errorr  _has_eventsr   $_handle_dbapi_exception_noconnectionr"   StatementErrorconnection_invalidated)r   r   errr  new_errs        r   _do_ping_w_eventDefaultDialect._do_ping_w_event  s    	<< 011  && 	 ..sdKM	CCC&36;$( )) C$+$B$BMC %	sD    B)#B$A*)B$*B>B
B$B
B$#B$$B)c                    UR                  5       n UR                  U R                  5        UR                  5         g! UR                  5         f = f)NT)r   executer}  ru  )r   r   r   s      r   r  DefaultDialect.do_ping  s@    !((*	NN4<<=LLN LLNs	   > Ac                <    S[         R                  " SSS-  5      -  $ )zCreate a random two-phase transaction ID.

This id will be passed to do_begin_twophase(), do_rollback_twophase(),
do_commit_twophase().  Its format is unspecified.
z	_sa_%032xr   r       )randomrandintr   s    r   
create_xidDefaultDialect.create_xid  s     V^^Aq#v666r   c                N    UR                  [        R                  " U5      5        g r   )r  r'   SavepointClauser   r   r   s      r   do_savepointDefaultDialect.do_savepoint  s    :55d;<r   c                N    UR                  [        R                  " U5      5        g r   )r  r'   RollbackToSavepointClauser  s      r   do_rollback_to_savepoint'DefaultDialect.do_rollback_to_savepoint  s    :??EFr   c                N    UR                  [        R                  " U5      5        g r   )r  r'   ReleaseSavepointClauser  s      r   do_release_savepoint#DefaultDialect.do_release_savepoint  s    :<<TBCr   c              #  X  #    [        [        U5      n[        [        UR                  5      nSnS n	Sn
UR                  nUR
                  nUc   e[        UR                  5      nUR                  R                  SU R                  5      nUR                  (       a  UR                  R                  S0 5      nOS nU(       a  / nUUl        UR                  nOSnS nUR                  UUUUUUU5       GH  nUv   U(       d  M   UR                  U5      nUc   eUR,                  (       Ga=  UR.                  (       Gd+  UR,                  S:  nUR0                  (       a8  U(       a   eUR3                  [5        W[6        R8                  " S5      S	95        M  UR:                  (       d   eUR<                  (       d   eUR,                  nU
(       d  U(       aW  [?        UR<                  UR@                  U* S  5       VVs/ s H%  u  nnURB                  RE                  U US   5      PM'     nnnO8UR<                  S
   RB                  RE                  XR@                  S   S   5      n	Sn
U(       a2  W Vs0 s H$  n[G        S [?        UU* S  U5       5       5      U_M&     nnO:U	(       a  W Vs0 s H  nU	" US   5      U_M     nnOW Vs0 s H	  nUS   U_M     nn[I        U5      [I        URJ                  5      :w  a9  [L        RN                  " S[I        URJ                  5       S[I        U5       S35      e URP                   Vs/ s H  nUU   PM
     nnUR3                  U5        GMw  UR3                  W5        GM     g ! [          aG  nUR#                  U[$        R&                  " UR(                  5      UR*                  S USS9   S nAGNS nAff = fs  snnf s  snf s  snf s  snf s  snf ! [R         a.  n[L        RN                  " SURT                  S
   < S35      UeS nAff = f7f)Nr   Frm   schema_translate_mapT)is_sub_execr   r   )keyr   c              3  H   #    U  H  u  pU(       a  U" U5      OUv   M     g 7fr   r   )r2  valprocs      r   r3  CDefaultDialect._deliver_insertmanyvalues_batches.<locals>.<genexpr>t  s(      "2"IC /3c!;2"s    "zASentinel-keyed result set did not produce correct number of rows z; produced zP.  Please ensure the sentinel column is fully unique and populated in all cases.zACan't match sentinel values in result set to parameter sets; key aT   was not found. There may be a mismatch between the datatype passed to the DBAPI driver vs. that which it returns in a result row.  Ensure the given Python value matches the expected result type *exactly*, taking care to not rely upon implicit conversions which may occur such as when using strings in place of UUID or integer values, etc. )+r   DefaultExecutionContextr-   compiledcompiled_parameters_insertmanyvaluesrh   effective_returningexecution_optionsr   rm   r  _insertmanyvalues_rowssort_by_parameter_order!_deliver_insertmanyvalues_batchesfetchall_for_returningBaseException_handle_dbapi_exceptionsql_util_long_statementreplaced_statementreplaced_parametersnum_sentinel_columnsis_downgradedimplicit_sentinelextendsortedoperator
itemgettersentinel_param_keyssentinel_columnszipdescriptionr   _cached_result_processortupler  batchr"   r   sentinel_valuesKeyErrorargs)r   r   r   	statement
parametersgeneric_setinputsizescontextr  _composite_sentinel_proc_scalar_sentinel_proc_sentinel_proc_initializedr  imvis_returning
batch_sizer  resultr  	imv_batchrowsbecomposite_sentinel_nsccolcursor_descrowrows_by_sentinelsentinel_keysordered_rowskes                                 r   r  0DefaultDialect._deliver_insertmanyvalues_batches  s     .8W%5%56  	! FJ+0"%99(($()E)E$F..22($*I*I

 ((#*#<#<#@#@&$  $( *,F-3G*&)&A&A# ',#F!CC!# 
I O|
"99&AD )))+++I4K4K4K),)A)AA)E&,, $655"4X-@-@-DE ! 2222////33D5-
 9<$'$8$8$*$6$6uv$>9"	89"$4C !$ A A$(+a.!"9"	 5 84 !$ 4 4Q 7"d#;#; $&8&8&<Q&?$ 2
 6:2 * (,, (, " "14$'K1I2"" 
  ## (, ) ,( /KO,KOC1#b':C?4 ) ,( EI+IDSCGSLD(+I+,IOO0DD "55669)//6J5K L("#345 6)) " 2;1J1J(1J -];1J % (* MM,/ MM$'{
 % 66 001M1MN!55$( 7 D8,,, ,J ( $ " "55335771:. AP	P  ""	"s   C>P*NC(P*>,O*A	P*3+OP*,O P*	O%AP*7O/O*O/+P*
O<OP*OP**O//
P'9)P""P''P*c                &    UR                  X#5        g r   )executemanyr   r   r  r  r  s        r   do_executemanyDefaultDialect.do_executemany  s    91r   c                &    UR                  X#5        g r   r  r  s        r   
do_executeDefaultDialect.do_execute  s    y-r   c                &    UR                  U5        g r   r  )r   r   r  r  s       r   do_execute_no_params#DefaultDialect.do_execute_no_params  s    y!r   c                    g)NFr   )r   er   r   s       r   r  DefaultDialect.is_disconnect  s     r   c           
     Z    [        U R                  U5      5      nU Vs/ s H"  o3R                  SS5      R                  5       PM$     nnX$:w  a=  [	        SU R
                  < S[        [        U5      R                  U5      5       35      e[        U5      $ s  snf ! [         a     g f = f)Nr[   r   zi get_isolation_level_values() method should return names as UPPERCASE using spaces, not underscores; got )listget_isolation_level_valuesreplaceupper
ValueErrorr   r  r<  
differencer  r   )r   r   
raw_levelslevelnormalized_levelss        r   _gen_allowed_isolation_levels,DefaultDialect._gen_allowed_isolation_levels  s    	,d==jIJJ
 >H!=GEc3'--/Z  ! . tyym ,, c*o889JKLMO  *++! # 		s   B )B
B*)B*c           
        UR                  SS5      R                  5       nU R                  U5      nU(       a?  X#;  a:  [        R                  " SU< SU R
                  < SSR                  U5       35      eU R                  X5        g )Nr[  r  zInvalid value z1 for isolation_level. Valid isolation levels for z are rK  )r  r  r  r"   r{   r   r   set_isolation_level)r   r   r  _allowed_isolation_levelss       r   r   .DefaultDialect._assert_and_set_isolation_level  s    c3'--/$($F$F%
! &6## 	 *..2ii]%99678:  	  3r   c                   U R                   bH  U R                   S:X  d  U R                   U R                  :X  d   eU R                  XR                   5        g U R                  c   eU R                  UU R                  5        g )N
AUTOCOMMIT)r   r   r   r  s     r   reset_isolation_level$DefaultDialect.reset_isolation_level  s    ++700L@33//00 00<< //;;;00,,r   c                    Uc  g UR                  5       nUR                  5       nX2:X  a  U$ X1:X  a"  U R                  R                  U5      (       d  U$ X!:X  a
  [	        USS9$ U$ )NT)quote)lowerr  r   _requires_quotesr.   r   r   
name_lower
name_uppers       r   normalize_nameDefaultDialect.normalize_name  ss    <ZZ\
ZZ\
# K$$55
&)
  t400 Kr   c                    Uc  g UR                  5       nUR                  5       nX2:X  a  U$ X!:X  a"  U R                  R                  U5      (       d  UnU$ r   )r
  r  r   r  r  s       r   denormalize_nameDefaultDialect.denormalize_name  s[    <ZZ\
ZZ\
# K$$55
&) Dr   c                    U$ r   r   r  s     r   get_driver_connection$DefaultDialect.get_driver_connection  s    r   c                t    [        [        U 5      U5      R                  [        [        U5      R                  L$ r   )r|   r   __code__rP   )r   methods     r   _overrides_default!DefaultDialect._overrides_default"  s0    DJ'00>62;;<	
r   c              +  6  #    / n/ n	[         R                  U;   a6  UR                  U R                  5        U	R                  U R                  5        [         R
                  U;   a6  UR                  U R                  5        U	R                  U R                  5        [         R                  U;   a  UR                  U R                  5        UR                  S0 5      n
U(       a)  U[        R                  L a  U[         R                  L a  UnOv/ nSU0UEn/ n[        R                  U;   a  UR                  U5        [        R                  U;   a  UR                  U	5        U H  n UR                  U" U40 UD65        M     U(       a  [#        U5      nU H$  nU(       a  X;   d  M  XO4n UU" X/4SU0UD64v   M&     g ! [          a     Mj  f = f! [$        R&                   a  nUU
;  a  UU
U'    S nAM_   S nAMe  S nAf[$        R(                   a     M  f = f7f)Nunreflectabler  )r   TABLErU  get_table_namesget_temp_table_namesVIEWget_view_namesget_temp_view_namesMATERIALIZED_VIEWget_materialized_view_namespopr   ANYrg   r  	TEMPORARYr   r<  r"   UnreflectableTableErrorNoSuchTableError)r   single_tbl_methodr   kindr  filter_namesscoper  	names_fnstemp_names_fnsr  namesname_kwfnsfntabler  r  s                     r   _default_multi_reflect%DefaultDialect._default_multi_reflect(  s     	t#T112!!$";";<??d"T001!!$":":;''4/T==> 3 (
& !EE.2.GC""e+

9%$$-

>*LLJ!:'!:;  |,L E5#8o)&6<@B 	  + " 22 1-/-0c* 0++ sf   E#H&F?>%H'H+G:H?
G	HGHH$G;/H;HHHHc                >    U R                   " U R                  U40 UD6$ r   )r6  get_table_optionsr   r   r  s      r   get_multi_table_options&DefaultDialect.get_multi_table_optionsq  (    **""J
24
 	
r   c                >    U R                   " U R                  U40 UD6$ r   )r6  get_columnsr:  s      r   get_multi_columns DefaultDialect.get_multi_columnsv       **4+;+;ZN2NNr   c                >    U R                   " U R                  U40 UD6$ r   )r6  get_pk_constraintr:  s      r   get_multi_pk_constraint&DefaultDialect.get_multi_pk_constrainty  r=  r   c                >    U R                   " U R                  U40 UD6$ r   )r6  get_foreign_keysr:  s      r   get_multi_foreign_keys%DefaultDialect.get_multi_foreign_keys~  s(    **!!:
13
 	
r   c                >    U R                   " U R                  U40 UD6$ r   )r6  r  r:  s      r   get_multi_indexes DefaultDialect.get_multi_indexes  rB  r   c                >    U R                   " U R                  U40 UD6$ r   )r6  get_unique_constraintsr:  s      r   get_multi_unique_constraints+DefaultDialect.get_multi_unique_constraints  s(    **''
79
 	
r   c                >    U R                   " U R                  U40 UD6$ r   )r6  get_check_constraintsr:  s      r   get_multi_check_constraints*DefaultDialect.get_multi_check_constraints  s(    **&&

68
 	
r   c                >    U R                   " U R                  U40 UD6$ r   )r6  get_table_commentr:  s      r   get_multi_table_comment&DefaultDialect.get_multi_table_comment  r=  r   )r   r   rb   r   r   r   r   rn   r   rm   r   r   r   r   rq   r   r   ry   r   ri   )r   zOptional[_ParamStyle]rT   zOptional[IsolationLevel]r   zOptional[ModuleType]r   zLiteral[True]r   Optional[bool]r   ra   r   ra   rm   zUnion[_NoArg, int]ri   rZ  r   rF   rq   rh   r   r   )returnr1   )r   r   r[  None)r   r@   r[  z
Type[Pool])r[  zOptional[_ListenerFnType])r   r   r[  r\  )r[  zOptional[Callable[[Any], Any]]r   )r   r   r  rz  r  r   r[  rh   )r   rz  r[  r\  )r%  r   r&  r   r[  r=   )r   r@   r[  r<   )rA  r2   r,  r^   r[  r\  )r   r   r,  r^   r[  r\  )r   r=   r[  rh   )r  	Exceptionr   zCUnion[pool.PoolProxiedConnection, interfaces.DBAPIConnection, None]r   z Optional[interfaces.DBAPICursor]r[  rh   )__name__r   __qualname____firstlineno____doc__r%   r-   statement_compilerr+   ddl_compilerr   r   IdentifierPreparerr   supports_altersupports_commentssupports_constraint_commentsinline_commentsr   div_is_floordivr   r~   NONEr   rR   __annotations__rS   default_sequence_baser  execute_sequence_formatsupports_schemassupports_viewssupports_sequencessequences_optional"preexecute_autoincrement_sequencessupports_identity_columnspostfetch_lastrowidfavor_returning_over_lastrowid#insert_null_pk_still_autoincrementsr   r   update_returning_multifromdelete_returning_multifromr   cte_follows_insertsupports_native_enumr   supports_native_uuidreturns_native_bytes#non_native_boolean_check_constraintsupports_simple_order_by_labeltuple_in_valuesr$   r?  r   IsolationLevelCharacteristicLoggingTokenCharacteristicr=  asintbool_or_strasboolr_   supports_native_decimalr   r   rb   rT   rc   rd   r   supports_sane_multi_rowcountre   r   supports_default_valuessupports_default_metavaluedefault_metavalue_tokensupports_empty_insertsupports_multivalues_insertri   rj   r,   NOT_SUPPORTEDrk   rm   insertmanyvalues_max_parameterssupports_is_distinct_fromrz   rq   supports_for_update_ofr   rn   requires_name_normalizeis_asynchas_terminate$_legacy_binary_type_literal_encodingdeprecated_paramsr*   r   rl   
NO_LINTINGr   property
deprecatedr   memoized_propertyr   r   update_executemany_returningdelete_executemany_returningr   r   r   r   r   r   r   classmethodr   r   r   r   r   r   r   r   r  r  r  r!  r$  r-  rC  rH  r9  rX  re  rj  rn  rr  rq  r}  r  r  r  r  r  r  r  r  r  r  r  memoized_instancemethodr  r   r  r  r  r  r  r6  r;  r@  rE  rI  rL  rP  rT  rX  __static_attributes__r   r   r   rP   rP   v   su   +!--''L 44**HN#( O#O'',,K26/626/6  $N).& %%*"*/'!&!& #  *.'%)"O!%!3!3.KKM,GGI	
" .2-?-? JJ$$W-))'2 JJ JJkk	

.* 
 $D !9='=%)O])
 ,0=/044!#' MOHJO #:!&<'
 !."'!&$&.3%t3 	%22 '(D  '+*&+# $#(  #)-- $HM
 ,3(	

* -148&*,026/3&*9?/3 %((;(;$<$)PI)PI 2PI $	PI
 *PI "0PI  -PI $PI %7PI -PI "PI "PI PI'&PId 	__	-

 
 
C C 
C C, $) #( 	  
F F
 
 & 
+ + - - + + 9 9(  
"H
4 	;	F$F36F>AF	F
<$5	"
N$
N,=
N	
N
<H$"(! 
? ?.7=GDj(X2."
 1 
 
!!, ",$4$"4"
GR

O



O




r   rP   c                      \ rS rSr\R
                  r\R                  r\R                  r
\R                  rSrSrSrSrSrSrSrSrSrSrSrSrg)StrCompileDialecti  TFr   N)r^  r   r_  r`  r%   StrSQLCompilerrb  r+   rc  StrSQLTypeCompilerr   rd  r   r   r   r   r   rs  rp  rq  rr  r   r  r~  r  r   r   r   r  r    sr    !00''L 33**H# $).&""&%)"r   r  c                     \ rS rSr% SrSrSrSrSrSr	\
R                  rS\S'   SrS\S'   SrS\S	'   SrS
\S'   \R$                  rS\S'   \R*                  rSrS\S'   SrSrSrSrSrSrS\S'   SrS\S'   \R>                  " 5       r S\S'    \!r"S\S'   S\S'   S\S'   S\S'   S\S'   S \S!'   S"\S#'   S$\S%'   \#" S&\R$                  5      r$Sr%S'\S('   S)r&S*\S+'   \'            SZS, j5       r(\'\)RT                  4                   S[S- jj5       r+\'              S\S. j5       r,\'          S]S/ j5       r-S^S0 jr.\/S1 5       r0\Rb                  S2 5       r2\Rb                  S3 5       r3\Rb                  S_S4 j5       r4\Rb                  S_S5 j5       r5\Rb                  S6 5       r6 S`       SaS7 jjr7\Rb                  S8 5       r8S9 r9SbS: jr:S; r;SbS< jr<SbS= jr=S> r>S? r?S@ r@SA rASB rBSC rC\R                  ScSD j5       rE\/SE 5       rFSF rGSG rHSH rISI rJSJ rK\Rb                  SK 5       rLSL rMSM rNSN rOSO rP  SdSP jrQSQ rRSR rSSrTSS\ST'    SeSU jrUSV rVSW rWSX rXSYrYg)fr  i  Fr   execute_styleNzOptional[Compiled]r  zAOptional[Tuple[List[ResultColumnsEntry], bool, bool, bool, bool]]result_column_structzOptional[Sequence[Row[Any]]]returned_default_rowsr9   r  zOptional[Executable]invoked_statementra   	_rowcountzOptional[Callable[[str], str]]_translate_colnamezMapping[str, List[str]]_expanded_parametersr   root_connectionrC   _dbapi_connectionr   ry  rz  unicode_statementr   r   z%List[_MutableCoreSingleExecuteParams]r  r7   r  &Optional[Sequence[BindParameter[Any]]]extracted_parametersr^   zOptional[List[Tuple[Any, ...]]]r  r   rl   _num_sentinel_colsc                4   U R                  U 5      nX&l        X6l        UR                  Ul        U=Ul        nSUl        XFl        [        U5      Ul        UR                  (       aJ  UR                  R                  S0 5      nUR                  R                  n	U	" UR                  U5      Ul        UR                  Ul        UR                  5       Ul        / Ul        UR"                  (       a  UR%                  5       /Ul        U$ UR(                  /Ul        U$ )zCInitialize execution context for an ExecutableDDLElement
construct.Tr  )__new__r  r  ry  r  isddlr  rz  r  r  r   r   _render_schema_translatesr  create_cursorr   r  r   rm  r  _empty_dict_params)
r   ry  r   r   r  compiled_ddlr   r  r  rsts
             r   	_init_ddl!DefaultExecutionContext._init_ddl  s    {{3)!1!))#//
!2!$X((#'#9#9#=#=&$  ##==C%(&&(<&D" //((*#% &>>@ADO   $667DOr   c
                V   U R                  U 5      n
X*l        X:l        UR                  U
l        Xl        Xzl        XZl        Xl        XJl        UR                  UR                  UR                  UR                  UR                  4U
l        UR                  =U
l        nUR                   =U
l        nUR"                  =U
l        nUR$                  U
l        U(       d  U(       d  U(       Gaa  UR(                  R*                  n[,        (       a  [/        U[0        5      (       d   eSU
l        [5        UR6                  5      =U
l        n[5        UR:                  5      =U
l        nU(       a  UR>                  (       a  SU
l         U(       a	  U(       a   eU(       d  U(       Ga  URB                  (       Ga  U(       aI  U
R                  RD                  (       d.  [F        RH                  " SU
R                  RJ                   S35      eU(       aZ  URL                  (       aI  U
R                  RN                  (       d.  [F        RH                  " SU
R                  RJ                   S35      eU(       aB  U
R                  RP                  (       a'  URR                  (       d  [F        RH                  " S5      eU(       aI  U
R                  RT                  (       d.  [F        RH                  " SU
R                  RJ                   S35      eU(       aI  U
R                  RV                  (       d.  [F        RH                  " SU
R                  RJ                   S35      eU(       d  URY                  USS	9/U
l-        O[]        U5       VVs/ s H  u  nnURY                  USUUS
9PM     snnU
l-        [_        U5      S:  aw  U
R                  (       aQ  URR                  (       a@  [`        Rb                  U
l2        URR                  nURf                  b  URh                  U
l5        O[`        Rl                  U
l2        URn                  U
l8        U
Rs                  5       U
l:        U
R                  Rv                  (       d  U
R                  Rx                  (       a  U
R{                  5         UR|                  nUnUR~                  (       d  UR                  (       a  U
R                  (       a  [F        RH                  " S5      eUR                  U
RZ                  S   5      nUR*                  U
l8        UR                  U
lD        [        U5      nUR                  UR                  5        UR                  nO*UR                  (       a  U
R                  R                  nOSnUR                  (       aJ  U
R                  R                  S0 5      nUR                  R                  nU" U
Rp                  U5      U
l8        U
Rp                  U
l        UR                  (       al  / nUc   eU
RZ                   HL  nU Vs/ s H  nUU;   a  UU   " UU   5      OUU   PM     nnUR                  UR                  U5      5        MN     UU
lP        U
$ / nUR                  nU
RZ                   H  nU(       a;  U Vs0 s H-  nUR                  UU5      UU;   a  UU   " UU   5      OUU   _M/     n nO*U Vs0 s H  nUUU;   a  UU   " UU   5      OUU   _M     n nUR                  U 5        M     UU
lP        U
$ s  snnf s  snf s  snf s  snf )z6Initialize execution context for a Compiled construct.Tr   z] with current server capabilities does not support INSERT..RETURNING when executemany is usedz} with current server capabilities does not support INSERT..RETURNING with deterministic row ordering when executemany is usedznStatement does not have "insertmanyvalues" enabled, can't use INSERT..RETURNING with executemany in this case.z] with current server capabilities does not support UPDATE..RETURNING when executemany is usedz] with current server capabilities does not support DELETE..RETURNING when executemany is usedF)r  escape_names)r  _group_numberr  r   NzL'literal_execute' or 'expanding' parameters can't be used with executemany()r   r  )Rr  r  r  ry  r  r  r  	cache_hitr  _result_columns_ordered_columns_textual_ordered_columns_ad_hoc_textual_loose_column_name_matchingr  isinsertisupdateisdeleteisplaintextis_textcompile_stater  r   r   rI   is_crudrh   
_returning_is_explicit_returningr   _is_implicit_returning_supplemental_returning_is_supplemental_returningfor_executemanyr   r"   r   r   _sort_by_parameter_orderr   ri   r  r  r  construct_paramsr  	enumerater  r   INSERTMANYVALUESr  r  r  r  EXECUTEMANYstringr  r  r   insert_prefetchupdate_prefetch_process_execute_defaults_bind_processorsliteral_execute_paramspost_compile_paramsr  #_process_parameters_for_postcompileparameter_expansionr  dictr*  
processorspositiontupr   r  r   r   r  rU  rm  r  escaped_bind_names)!r   ry  r   r   r  r  r  r  r  r  r   iiiuid_dml_statementieriirgrpmr  r  flattened_processorsexpanded_stater  r  r  core_positional_parameterscompiled_paramsr  l_paramcore_dict_parametersescaped_namesd_params!                                    r   _init_compiled&DefaultExecutionContext._init_compiled  s    {{3)!1!))$8!!2 "!2 $$%%--$$00%
! &...%...&///++s$22<<M}!-<<<<DL04]5M5M0NND'#04++1 D'# }<<26/ $$s 8 8 8dllGG11"4<<#C#C"D EE E  %>> LL]]11"4<<#C#C"D E3 3  99$66114 
  I I11"4<<#C#C"D EE E 
 !J!J11"4<<#C#C"D EE E  )))=!& * (D$ (
3( 4FC ))!&"%)=	 *  4(D$ :"==X%?%?)5)F)FD&"44C++7252J2J/)5)A)AD&!)((*==((DMM,I,I**,..
  	 **h.J.J--. 
 &II((+N
 &4%=%=D"(6(J(JD%#'
#3  ''(A(AB(44K  --33KK((#'#9#9#=#=&$  ##==C%(&&(<&D" // IK&***#'#;#;  +&  + "66 -S1/#2FG,S12  +  & +1133G< $< 9DOF C EG $77M $(#;#;  $3 $3C &))#s3"&:: 15oc6JK!0!56
 $3  G $3 $3C "&:: 15oc6JK!0!56
 $3   %++G4) $<, 3DO{(\&2s   8\#\4\!$\&c                   U R                  U 5      nX'l        X7l        UR                  Ul        SUl        XGl        U(       dE  UR                  R                  (       a  UR                  5       /Ul        O}UR                  /Ul        Oj[        US   UR                  5      (       a  Xgl        OE[        US   [        5      (       a  Xgl        O&U Vs/ s H  oR                  U5      PM     snUl        [        U5      S:  a  [        R                  Ul        U=Ul        Ul        UR%                  5       Ul        U$ s  snf )z8Initialize execution context for a string SQL statement.Tr   r   )r  r  r  ry  r  r  r   rm  r  r  r   r  r  r   r  r  r  r  r  r   )	r   ry  r   r   r  r  r  r   ps	            r   _init_statement'DefaultExecutionContext._init_statement  s	    {{3)!1!))!2||&&#*#B#B#D"E#'#:#:";
1w'F'FGG(O
1t,,(O =G<Fq//2JDO z?Q!-!9!9D2;;/((*s   D;c                    U R                  U 5      nX%l        X5l        UR                  Ul        XEl        UR                  5       Ul        U$ )z;Initialize execution context for a ColumnDefault construct.)r  r  r  ry  r  r  r   )r   ry  r   r   r  r   s         r   _init_default%DefaultExecutionContext._init_default&  sF     {{3)!1!))!2((*r   c                   U R                   c  g[        5       nU R                  nU R                   R                  nUc   eU[        L a  SX-
  4-  $ U[
        L a  SX-
  4-  $ U[        L a  SX-
  4-  $ U[        L a.  SU R                  ;   a  SU R                  S   X-
  4-  $ SX-
  4-  $ U[        L a2  SU R                  R                  U R                  R                  X-
  4-  $ g	)
Nzraw sqlzno key %.5fszcached since %.4gs agozgenerated in %.5fs_cache_disable_reasonzcaching disabled (%s) %.5fs zcaching disabled %.5fsz,dialect %s+%s does not support caching %.5fsunknown)r  r   r  	_gen_timeNO_CACHE_KEY	CACHE_HIT
CACHE_MISSCACHING_DISABLEDr  NO_DIALECT_SUPPORTry  r   r   )r   nowchgen_times       r   _get_cache_stats(DefaultExecutionContext._get_cache_stats:  s   == n^^==**###!S^$5559_+s~.???:'3>*;;;##&$*@*@@5**+BCN9  
 03>2CCC%%A!!##E   r   c                \    U R                   [        R                  [        R                  4;   $ r   )r  r   r  r  r   s    r   r  #DefaultExecutionContext.executemany\  s,    !!$$))&
 
 	
r   c                    U R                   (       a  U R                   R                  $ SU R                  ;   a2  U R                  R                  R                  U R                  S   5      $ U R                  R                  $ )Nr  )r  r   r  ry  r   _with_schema_translater   s    r   r   +DefaultExecutionContext.identifier_preparerc  se    ====)))#t'='==<<33JJ&&'=>  <<333r   c                .    U R                   R                  $ r   )r  rA  r   s    r   rA  DefaultExecutionContext.enginen  s    ##***r   c                    [         (       a!  [        U R                  [        5      (       d   eU R                  R                  $ r   )r   r   r  r-   	postfetchr   s    r   postfetch_cols&DefaultExecutionContext.postfetch_colsr  s.    =dmm[9999}}&&&r   c                    [         (       a!  [        U R                  [        5      (       d   eU R                  (       a  U R                  R
                  $ U R                  (       a  U R                  R                  $ g)Nr   )r   r   r  r-   r  r  r  r  r   s    r   prefetch_cols%DefaultExecutionContext.prefetch_colsx  sO    =dmm[9999====000]]==000r   c                :    U R                   R                  SS5      $ )Nno_parametersF)r  r   r   s    r   r  %DefaultExecutionContext.no_parameters  s    %%))/5AAr   c                @   U R                   nSU R                  ;   a:  U R                  R                  S0 5      nU R                  R                  nU" X5      nU(       d8  U R
                  R                  (       a  U R
                  R                  5       nO0 nUR                  U R                  XU S9  U R                  R                  5       nUb  US   nOSnUbE  UR                  U R
                  U R                  R                  S   S   5      n	U	(       a  U	" U5      $ U$ )zExecute a string statement on the current cursor, returning a
scalar result.

Used to fire off sequences, default phrases, and "select lastrowid"
types of statements individually or in the context of a parent INSERT
or UPDATE statement.

r  )r  Nr   r   )r  r  r   r   r  ry  r   rm  _cursor_executer   fetchoner  r  )
r   stmttype_r  connr  r  r  rr  s
             r   _execute_scalar'DefaultExecutionContext._execute_scalar  s    ##!T%;%;;#'#9#9#=#=&$  **DDCt2D||&&!\\AAC

T[[$DIkk""$?AAA11dkk55a8;D Awr   c                    U R                   $ r   )r  r   s    r   r   "DefaultExecutionContext.connection  s    ###r   c                   U R                   R                  (       d  gU R                   R                  (       a  U R                  R	                  SS5      =(       a    U R
                  =(       a.    [        U R
                  R                  [        R                  5      =(       d    U R
                  (       + =(       d.    [        U R
                  R                  [        R                  5      =(       a2    U R                  =(       a    [        R                  U R                  5      nU$ U R                  R	                  SS5      nU$ )NFstream_resultsT)ry  rz   rq   r  r   r  r   r  r'   
Selectable
TextClauser  SERVER_SIDE_CURSOR_REmatch)r   use_server_sides     r   _use_server_side_cursor/DefaultExecutionContext._use_server_side_cursor  s    ||88<<++"4488 $   Ot}}66
8M8MN !MM) % MM33Z5J5JL ..L .33D4J4JK * 	 #4488 %O r   c                6   U R                   R                  (       ah  U R                  R                  SS5      (       d0  U R                   R                  (       a,  U R                  5       (       a  SU l        U R                  5       $ SU l        U R                  5       $ )Nr&  FT)	ry  rz   r  r   rq   r,  _is_server_sidecreate_server_side_cursorcreate_default_cursorr   s    r   r  %DefaultExecutionContext.create_cursor  sw     LL55&&**+;UCCLL444466 $(D 1133#(D --//r   c                "    UR                  5       $ r   )fetchall)r   r   s     r   r  .DefaultExecutionContext.fetchall_for_returning  s      r   c                6    U R                   R                  5       $ r   )r  r   r   s    r   r1  -DefaultExecutionContext.create_default_cursor  s    %%,,..r   c                    [        5       er   r   r   s    r   r0  1DefaultExecutionContext.create_server_side_cursor  s    !##r   c                    g r   r   r   s    r   pre_exec DefaultExecutionContext.pre_exec  rg  r   c                    [        S5      e)Nz,This dialect does not support OUT parametersr9  )r   r1  s     r   get_out_parameter_values0DefaultExecutionContext.get_out_parameter_values  s    !:
 	
r   c                    g r   r   r   s    r   	post_exec!DefaultExecutionContext.post_exec  rg  r   c                :    UR                  U R                  U5      $ )zReturn a 'result processor' for a given type as present in
cursor.description.

This has a default implementation that dialects can override
for context-sensitive result type handling.

)r  ry  )r   r  colnamecoltypes       r   get_result_processor,DefaultExecutionContext.get_result_processor  s     --dllGDDr   c                .    U R                   R                  $ )a  return self.cursor.lastrowid, or equivalent, after an INSERT.

This may involve calling special cursor functions, issuing a new SELECT
on the cursor (or a new one), or returning a stored value that was
calculated within post_exec().

This function will only be called for dialects which support "implicit"
primary key generation, keep preexecute_autoincrement_sequences set to
False, and when no explicit id value was bound to the statement.

The function is called once for an INSERT statement that would need to
return the last inserted primary key for those dialects that make use
of the lastrowid concept.  In these cases, it is called directly after
:meth:`.ExecutionContext.post_exec`.

)r   	lastrowidr   s    r   get_lastrowid%DefaultExecutionContext.get_lastrowid  s    " {{$$$r   c                    g r   r   )r   r  s     r   handle_dbapi_exception.DefaultExecutionContext.handle_dbapi_exception  rg  r   c                `    U R                   b  U R                   $ U R                  R                  $ r   )r  r   rowcountr   s    r   rQ   DefaultExecutionContext.rowcount  s&    >>%>>!;;'''r   c                    U R                   S L$ r   )r  r   s    r   _has_rowcount%DefaultExecutionContext._has_rowcount#  s    ~~T))r   c                .    U R                   R                  $ r   )ry  r   r   s    r   r   .DefaultExecutionContext.supports_sane_rowcount'  s    ||222r   c                .    U R                   R                  $ r   )ry  r  r   s    r   r  4DefaultExecutionContext.supports_sane_multi_rowcount*  s    ||888r   c                   U R                   nU R                  c2  UR                  SS5      (       a  U R                  R                  U l        U R
                  (       d  U R                  (       a  U R                  5       nSnOUR                  SS 5      nU R                  =(       d    UR                  SS5      nU R                  nU(       a>  U[        R                  L a+  [        R                  " U R                  U R                   5      nUR                  =(       d    U R                  R                  nUc  [        R                  n[        R                   " XU5      nU R"                  nU(       aA  U R$                  (       d0  ['        [(        U5      R*                  (       a  U R-                  U5        UR.                  U l        U(       a  UR1                  U5      nU$ )Npreserve_rowcountF	yield_perr&  )r  r  r   r   rQ  r  r  _setup_dml_or_text_resultr/  cursor_fetch_strategy_cursor_DEFAULT_FETCHBufferedRowCursorFetchStrategyalternate_cursor_descriptionr  _NO_CURSOR_DQLCursorResultr  r  r   r-   has_out_parameters_setup_out_parameters_soft_closedr\  )r   exec_optr  ypsrstrategycursor_descriptionr  s           r   _setup_result_proxy+DefaultExecutionContext._setup_result_proxy-  s`   ))>>!hll3F&N&N![[11DN<<4<<335FBk40B%%N6F)NB11Hh'"8"88"AAKK!7!7 55 +;;**  ")"11))$:LMF== JJ[(+>>&&v."//%%b)Fr   c                   [        [        U R                  5      nUR                  R	                  5        VVs/ s H  u  p4UR
                  (       d  M  X44PM     nnn0 n[        U VVs/ s H  u  p4UPM	     snnU R                  U VVs/ s H  u  p4UPM	     snn5      5       H  u  pxUR                  n	U	R                  U R                  5      n
U
R                  U R                  R                  5      nU
R                  U R                  U5      nUb  U" U5      nXUR                  '   M     Xal        g s  snnf s  snnf s  snnf r   )r   r-   r  
bind_namesrO  
isoutparamr  r?  r   dialect_implry  get_dbapi_typer   result_processorr  out_parameters)r   r  r  paramr   out_bindparamsru  	bindparam	raw_valuer  	impl_type
dbapi_typert  s                r   rf  -DefaultExecutionContext._setup_out_parametersW  s'   T]]3  (2288:
: UM: 	 

 $'&45n{uUn5)))78+%8%
 I NNE**4<<8I"11$,,2K2KLJ(99j   +,Y7	,59==)%
  !//
 68s   D5D5)D;

Ec                `   [        [        U R                  5      nU R                  nU R                  (       a  U R
                  [        R                  L aE  UR                  (       a4  [        R                  " U R                  U R                  UR                  S9nUR                  (       a  U R                  5       U l        U R"                  (       a>  U[        R$                  L a+  [        R&                  " U R                  U R(                  5      nU[        R*                  L a  S nO)UR                  =(       d    U R                  R,                  nUc  [        R*                  nO@U R.                  (       a/  U R
                  [        R                  L d   eUSU R.                  *  n[        R0                  " XU5      nU R                  (       a  U R2                  (       a  UR5                  5       nXPl        U R9                  XE5      U l        UR:                  R<                  (       d   eU R>                  (       a  URA                  U5        U$ URC                  5          U$ U RD                  (       d  URC                  5         U$ U R2                  (       a  UR5                  5       nU(       a  XPl        [G        U5      U l$        U R>                  (       a  URA                  U5        OURC                  5         UR:                  R<                  (       d   e U$ UR:                  R<                  (       d:  U RH                  c  U R                  RJ                  U l$        URC                  5         U$ U RL                  (       d  U RN                  (       a(  U RH                  c  U R                  RJ                  U l$        U$ )N)initial_bufferalternate_descriptionr   )(r   r-   r  r^  r  r  r   r  r  r_   FullyBufferedCursorFetchStrategyr   r  rb  rt  _setup_ins_pk_from_lastrowidinserted_primary_key_rowsr/  r`  ra  r  _NO_CURSOR_DMLr  r  rd  r  allr  %_setup_ins_pk_from_implicit_returning	_metadatareturns_rowsr  _rewind_soft_closer  r  r  rQ  r  r  )r   r  rk  rl  r  r  s         r   r]  1DefaultExecutionContext._setup_dml_or_text_results  s   T]]3(,(B(B==""l&C&CC00"CCKK#'#>#> !== ++557 . H0F0F$F==T33H w---!% 55 +;;** 
 %--H$$%%)F)FFFF "4T,,," -4,@,@.-
 ==**zz|-1* >>vL . ''4444
 22NN4(J G &&(F E 00""$B 3 ((::<D-1* YDN..t$""$ ##0000  !!.. ~~%!%!5!5   ]]dmm~~%!%!5!5r   c                "    U R                  5       $ r   )_setup_ins_pk_from_emptyr   s    r   r  1DefaultExecutionContext.inserted_primary_key_rows  s    
 ,,..r   c                    [        [        U R                  5      R                  nU R	                  5       nU" X R
                  S   5      /$ )Nr   )r   r-   r  +_inserted_primary_key_from_lastrowid_getterrK  r  )r   getterrJ  s      r   r  4DefaultExecutionContext._setup_ins_pk_from_lastrowid  sG    

5
5 	 &&(	y":":1"=>??r   c                    [        [        U R                  5      R                  nU R                   Vs/ s H  o!" S U5      PM     sn$ s  snf r   )r   r-   r  r  r  )r   r  rv  s      r   r  0DefaultExecutionContext._setup_ins_pk_from_empty  sG    

5
5 	 261I1IJ1ItU#1IJJJs   Ac                    U(       d  / $ [        [        U R                  5      R                  nU R                  n[        X$5       VVs/ s H  u  pVU" XV5      PM     snn$ s  snnf r   )r   r-   r  +_inserted_primary_key_from_returning_getterr  r  )r   r  r  r  r  r  rv  s          r   r  =DefaultExecutionContext._setup_ins_pk_from_implicit_returning  sc    I

5
5 	 22 25T1K
1K:3F31K
 	
 
s   A c                    U R                   =(       d    U R                  =(       a-    [        [        [        U R
                  5      R                  5      $ r   )r  r  rh   r   r-   r  r  r   s    r   lastrow_has_defaults,DefaultExecutionContext.lastrow_has_defaults  s7    . 
Ddmm,665
 	
r   c                
  ^^	^
^^ U R                   (       d  U R                  (       a  g[        [        U R                  5      nUR                  5       nUc  gU R                  nUR                  (       aG  [        U5      nUR                  R                  X R                  U R                  U R                  U 5        UR                  (       a  UR                  mOSmUR                  (       a4  UR                   =(       d    S Vs/ s H  nXAR"                  U   4PM     nnO/UR$                  R'                  5        VVs/ s H  u  pdXF4PM
     nnn/ nU GH   u  nmTUR(                  ;   a  M  X@R*                  ;   a  [-        TR.                  5      (       aZ  [1        TR.                  R2                  5      mUT   m
UR5                  UU
UU4S j[7        U R*                  U   5       5       5        M  UR9                  TS5      m	UR5                  UU	U4S jU R*                  U    5       5        M  UR9                  TS5      m	Tb  TR9                  XD5      OUnUR;                  UT	TR.                  45        GM#     U$ s  snf s  snnf )aS  Given a cursor and ClauseParameters, prepare arguments
in order to call the appropriate
style of ``setinputsizes()`` on the cursor, using DB-API types
from the bind parameter's ``TypeEngine`` objects.

This method only called by those dialects which set the
:attr:`.Dialect.bind_typing` attribute to
:attr:`.BindTyping.SETINPUTSIZES`.  Python-oracledb and cx_Oracle are
the only DBAPIs that requires setinputsizes(); pyodbc offers it as an
option.

Prior to SQLAlchemy 2.0, the setinputsizes() approach was also used
for pg8000 and asyncpg, which has been changed to inline rendering
of casts.

Nr   c              3     >#    U  H@  u  pTb  TR                  X"5      OUTUT-     TR                  R                  UT-     4v   MB     g 7fr   )r   r   types)r2  r  	paramnamerx  dbtypesr  nums      r   r3  CDefaultExecutionContext._prepare_set_input_sizes.<locals>.<genexpr>K  s[      ./NC $6#A !3 6 6y L%.#C#I.%NN00s;/s   AAc              3  j   >#    U  H(  nTb  TR                  X5      OUTTR                  4v   M*     g 7fr   )r   r   )r2  r  rx  dbtyper  s     r   r3  r  [  sC      . *HI $6#A !3 6 6y L%."%NN *Hs   03)r  r  r   r-   r  _get_set_input_sizes_lookupry  r  r  dispatchdo_setinputsizesr   r  r  r  r   r  bindsrp  rO  r  r  r)   r   r  r  r  r  r   rU  )r   r  
inputsizesry  r  rO  rx  generic_inputsizesescaped_namer  r  r  r  s         `  @@@@r   _prepare_set_input_sizes0DefaultExecutionContext._prepare_set_input_sizes  sN   & ::T]]399;
,, j)J--KK$ &&!)!<!<!% $//5255C nnS)*5  E '/&9&9&?&?&A&ANI  &A  
 FH#NCH;;;/// 00inn223C(3G&-- . /8 55c:/.  (^^It<F&-- . *.)B)B3)G.  $	48 *5 '**34  #))!69>>:[ $b "!y
s   I:=I?c                    UR                   (       a  U R                  X#5      $ UR                  (       a  Xl        UR	                  U 5      $ UR
                  (       a  U R                  XU5      $ UR                  $ r   )is_sequencefire_sequenceis_callablecurrent_columnr   is_clause_element_exec_default_clause_element)r   columnr`   r  s       r   _exec_default%DefaultExecutionContext._exec_defaultv  sd    %%g55   #);;t$$&&44VeLL ;;r   c           	     l   UR                   (       d"  [        R                  " UR                  U5      nOUR                  n[        R                  " U5      R                  U R                  S9nUR                  5       nUR                  nUR                  (       aS  U R                  R                  UR                  =(       d    S Vs/ s H  nX;   a  Xx   " Xh   5      OXh   PM     sn5      n	O&U Vs0 s H  nUX;   a  Xx   " Xh   5      OXh   _M     n	nU R                  [        U5      X9S9$ s  snf s  snf )Nrx  r   )r  )_arg_is_typedr'   type_coercer   r{  r|  ry  r  r  r   rm  r  r!  rz  )
r   r  r`   r  default_argr  r  r  r  r  s
             r   r  4DefaultExecutionContext._exec_default_clause_element  sC    $$$00eDK!++K$$[199$,,9O"335..
==  (339r9  : , #(<=,12  :	J" + +C ( OO$89(-.
 +   ##M5 $ 
 	
%s   D,1 D1z"Optional[_CoreSingleExecuteParams]current_parametersc                  ^^  U R                   mU R                  nUc   eTc   e [        S[        [        U R                  5      R                  5      nUc   eU(       a  [        R                  " U5      (       a  UR                  (       a  UR                  (       a5  UR                  S-   mUR                  R                  TUR                     0nOUR                  TUR                     0nSmUR                   c   eUR                   R#                  5       nUR%                  UU4S jU 5       5        U$ T$ ! [         a    [        R                  " S5      ef = f)a  Return a dictionary of parameters applied to the current row.

This method can only be used in the context of a user-defined default
generation function, e.g. as described at
:ref:`context_default_functions`. When invoked, a dictionary is
returned which includes entries for each column/value pair that is part
of the INSERT or UPDATE statement. The keys of the dictionary will be
the key value of each :class:`_schema.Column`,
which is usually synonymous
with the name.

:param isolate_multiinsert_groups=True: indicates that multi-valued
 INSERT constructs created using :meth:`_expression.Insert.values`
 should be
 handled by returning only the subset of parameters that are local
 to the current column default invocation.   When ``False``, the
 raw parameters of the statement are returned including the
 naming convention used in the case of multi-valued INSERT.

.. versionadded:: 1.2  added
   :meth:`.DefaultExecutionContext.get_current_parameters`
   which provides more functionality over the existing
   :attr:`.DefaultExecutionContext.current_parameters`
   attribute.

.. seealso::

    :attr:`.DefaultExecutionContext.current_parameters`

    :ref:`context_default_functions`

zdget_current_parameters() can only be invoked in the context of a Python side column default functionrH   r   r   c              3  :   >#    U  H  oTS UT4-     4v   M     g7f)z%s_m%dNr   )r2  r  indexr  s     r   r3  ADefaultExecutionContext.get_current_parameters.<locals>.<genexpr>	  s%      FJsjS%L!89:ds   )r  r  AttributeErrorr"   r   r   r-   r  r  r&   r  _has_multi_parameters_is_multiparam_columnr  originalr  _dict_parameterskeysr*  )r   isolate_multiinsert_groupsr  r  dr  r  r  s         @@r   get_current_parameters.DefaultExecutionContext.get_current_parameters  sH   B
	*00J((F %%%)))[$--8FF
 (((&]++33++q(__((*VZZ*@AZZFJJ!78 11=== 11668DHH FJ  H=  	))C 	s   D9 9!Ec                j    UR                   c  g U R                  XR                   UR                  5      $ r   )r`   r  r   r   r  s     r   get_insert_default*DefaultExecutionContext.get_insert_default		  s*    >>!%%fnnfkkJJr   c                j    UR                   c  g U R                  XR                   UR                  5      $ r   )onupdater  r   r  s     r   get_update_default*DefaultExecutionContext.get_update_default	  s*    ??"%%foov{{KKr   c                   [        [        U R                  5      nUR                  nSnUR                  (       a;  UR                   Vs/ s H#  nUU" U5      UR
                  U R                  4PM%     nnONUR                  (       a;  UR                   Vs/ s H#  nUU" U5      UR                  U R                  4PM%     nnO/ nU R                   Hc  nX`l        U HT  u  nnu  ppnU(       a  X6U'   US-  nM  U	(       a  XU'   M*  U
(       a  X@l        U" U 5      Xg'   MC  U" U5      nUc  MP  XU'   MV     Me     U ?g s  snf s  snf )Nr   r   )r   r-   r  _within_exec_param_key_getterr  _default_description_tupler  r  _onupdate_description_tupler  r  r  r  )r   r  
key_gettersentinel_countercprefetch_recsrv  	param_keyr   	is_scalarr  is_sentinelfallbackr  s                 r   r  1DefaultExecutionContext._process_execute_defaults	  sj   T]]3;;
## "11 2A qM00++	 2  M %% "11 2A qM11++	 2  M M--E&+# :'7)$$)$'*)$ *+''*4yE$"1+C+.i(  ., #Ys   *D9*D>)!r  r  r  r  r/  r  r  r  rg  r  r  r  r  r  r   ry  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  )ry  r   r   r   r   rC   r  r9   r  r+   r[  r   )ry  r   r   r   r   rC   r  r9   r  r-   r  r4   r  rD   r  r  r  r   r[  r   )ry  r   r   r   r   rC   r  r9   r  rz  r  r7   r[  r   )
ry  r   r   r   r   rC   r  r9   r[  r   )r[  rz  )r[  zOptional[Sequence[Column[Any]]]r   )r  rz  r  zOptional[TypeEngine[Any]]r  z#Optional[_DBAPISingleExecuteParams]r[  r   )r[  r   )r[  rl   )r[  z0Optional[List[Tuple[str, Any, TypeEngine[Any]]]])T)Zr^  r   r_  r`  r  r  r  r  r  r  r   EXECUTEr  rk  r  r  r  r$   
EMPTY_DICTr  r_  r`  r^  r  r  r  r  r/  rg  r  r  r?  r  r  r  r   r  r  r  r  r  r   r  r  r  r  r  r  r  r  r   rA  r  r  r  r!  r   r,  r  r  r1  r0  r<  r?  rB  rG  rK  rN  non_memoized_propertyrQ  rT  r   r  rm  rf  r]  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r   r   r   r  r    s   HHHGGE"."6"6M<6#'H ' 	    ;?7>)-8#22.2+2""!&OL#I}#
 :>6=484F4F4H1H I,,>>((@@14??C>B;B** * 0	*
 +* "* 
* *X  !+ ; ;cc c 0	c
 +c c ,c &c Ec c 
c cJ '' ' 0	'
 +' ' -' 
' 'R   0	
 + 
 & D 
 
 
4 4 
+ + 
' '
 
  
B B ;?	,, ), 8	,
 
,\ 
$ $:0$!/$

E%& 
(  ( * *39(T/8pd 
/ /@K


i"	9i"V%
N >B:A0BHKL4$r   r  )rra  
__future__r   rV  r  r  retimer   typingr   r   r   r   r	   r
   r   r   r   r   r   r   r   r   r   r    r   r   r_  r   baser   r   r   r   r   r   
reflectionr   r   r!   r"   r#   r$   sqlr%   r&   r'   r(   r  sql._typingr)   sql.baser*   sql.compilerr+   r,   r-   sql.elementsr.   util.typingr/   r0   r  r1   r2   r3   r4   r5   r6   r7   r8   r9   r:   r;   r<   r=   r>   r  r?   r   r@   rA   rB   rC   rD   rE   rF   rG   sql.dmlrH   rI   rJ   
sql.schemarK   sql.type_apirL   rM   rN   r|  IUNICODEr)  r  r   r  r  r  r  rP   r  r  execution_ctx_clsr   r   r   <module>r     s{   #    	         ! "              " #  $ ( " #         " '  & 7 & &  !	 +34345+;'++*', '&1"$,#13) 

<

1BC  	]
W ]
@!* *0[$. [$|$ $;  r   