+ }jCv^RIHt^RIt^RIHt^RIHt^RIHt^RIHt^RIH t ^RIH t ^R IH t ^R I H t ^R I Ht^R I Ht^R IHt^RIHt^RIHt^RIH t ^RIHt] 'dU^RIHt^RIHt^RIHt^RIHt^RIHt^RI H!t!^RI"H#t#^RI$H%t%^RI&H't'^RI&H(t(^RI&H)t)^RI&H*t*^RIH+t+^RI,H-t-] !R ]R!7t.] !R"]R!7t/] P`3R#R$llt] P`3R%R&llt1!R'R(]Pd].,4t3!R)R*]Ph].,4t4R+R,lt5R#)-) annotationsN)Any)Iterable)Optional)Sequence) TYPE_CHECKING)TypeVar)Union) CONTAINED_BY)CONTAINS)OVERLAP)types)util) expression) operators)InternalTraversal)Dialect)_ColumnExpressionArgument)_TypeEngineArgument) ColumnElement)Grouping) BindParameter) OperatorType)_SelectIterable)_BindProcessorType)_LiteralProcessorType)_ResultProcessorType) TypeEngine)_TraverseInternalsType)Self_T)bound_CTc(V^8dQhRRRRRRRR/# other typing_Anyarrexprz_ColumnExpressionArgument[_T]operatorrreturnColumnElement[bool])formats"e/home/luca/screen-checking/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/array.py __annotate__r020 ( (  ( * ( ( (c$VPW4#)zbA synonym for the ARRAY-level :meth:`.ARRAY.Comparator.any` method. See that method for details. )anyr'r)r*s&&&r/rr2 ;;u ''r2c(V^8dQhRRRRRRRR/#r%r-)r.s"r/r0r0?r1r2c$VPW4#)zbA synonym for the ARRAY-level :meth:`.ARRAY.Comparator.all` method. See that method for details. )allr5s&&&r/Allr:?r6r2ca]tRt^Lt$RtRtRtR]P3R]P3.t R] R&RR/R V3R lllt ] R R l4tRR RlltRRRlltRtV;t#)arrayaA PostgreSQL ARRAY literal. This is used to produce ARRAY literals in SQL expressions, e.g.:: from sqlalchemy.dialects.postgresql import array from sqlalchemy.dialects import postgresql from sqlalchemy import select, func stmt = select(array([1, 2]) + array([3, 4, 5])) print(stmt.compile(dialect=postgresql.dialect())) Produces the SQL: .. sourcecode:: sql SELECT ARRAY[%(param_1)s, %(param_2)s] || ARRAY[%(param_3)s, %(param_4)s, %(param_5)s]) AS anon_1 An instance of :class:`.array` will always have the datatype :class:`_types.ARRAY`. The "inner" type of the array is inferred from the values present, unless the :paramref:`_postgresql.array.type_` keyword argument is passed:: array(["foo", "bar"], type_=CHAR) When constructing an empty array, the :paramref:`_postgresql.array.type_` argument is particularly important as PostgreSQL server typically requires a cast to be rendered for the inner type in order to render an empty array. SQLAlchemy's compilation for the empty array will produce this cast so that:: stmt = array([], type_=Integer) print(stmt.compile(dialect=postgresql.dialect())) Produces: .. sourcecode:: sql ARRAY[]::INTEGER[] As required by PostgreSQL for empty arrays. .. versionadded:: 2.0.40 added support to render empty PostgreSQL array literals with a required cast. Multidimensional arrays are produced by nesting :class:`.array` constructs. The dimensionality of the final :class:`_types.ARRAY` type is calculated by recursively adding the dimensions of the inner :class:`_types.ARRAY` type:: stmt = select( array( [array([1, 2]), array([3, 4]), array([column("q"), column("x")])] ) ) print(stmt.compile(dialect=postgresql.dialect())) Produces: .. sourcecode:: sql SELECT ARRAY[ ARRAY[%(param_1)s, %(param_2)s], ARRAY[%(param_3)s, %(param_4)s], ARRAY[q, x] ] AS anon_1 .. versionadded:: 1.3.6 added support for multidimensional array literals .. seealso:: :class:`_postgresql.ARRAY` postgresqlclausestyper_traverse_internalstype_Nc$V^8dQhRRRRRR/#)r&r>z Iterable[_T]rAz!Optional[_TypeEngineArgument[_T]]kwr(r-)r.s"r/r0array.__annotate__s(!)!)!)1 !)  !)r2c <\SV`!\P.VO5/VBVeTM>VP'dVP^,P M\ Pp\V\4'd@\VPVPeVP^,M^R7VnR#\V4VnR#)zConstruct an ARRAY literal. :param clauses: iterable, such as a list, containing elements to be rendered in the array :param type\_: optional type. If omitted, the type is inferred from the contents of the array. N) dimensions) super__init__rcomma_opr>r?sqltypesNULLTYPE isinstanceARRAY item_typerF)selfr>rArC main_type __class__s&&$, r/rHarray.__init__s ++]tRtRtRtRRltRRltRRltR tR #) ARRAY.ComparatoriiaDefine comparison operations for :class:`_types.ARRAY`. Note that these operations are in addition to those provided by the base :class:`.types.ARRAY.Comparator` class, including :meth:`.types.ARRAY.Comparator.any` and :meth:`.types.ARRAY.Comparator.all`. c$V^8dQhRRRRRR/#)r&r'r(kwargsr+r,r-)r.s"r/r0ARRAY.Comparator.__annotate__ss) O O# O/9 O  Or2c NVP\V\PR7#)zBoolean expression. Test if elements are a superset of the elements of the argument array expression. kwargs may be ignored by this operator but are required for API conformance.  result_type)operater rJBoolean)rOr'rs&&,r/containsARRAY.Comparator.containsss<<%X=M=M<N Nr2c V^8dQhRRRR/#r&r'r(r+r,r-)r.s"r/r0r~s  j 5H r2c NVP\V\PR7#)zlBoolean expression. Test if elements are a proper subset of the elements of the argument array expression. r)rr rJrrOr's&&r/ contained_byARRAY.Comparator.contained_by~s'<<e1A1A  r2c V^8dQhRRRR/#rr-)r.s"r/r0rs N N N0C Nr2c NVP\V\PR7#)z]Boolean expression. Test if array has elements in common with an argument array expression. r)rr rJrrs&&r/overlapARRAY.Comparator.overlaps<<H.__annotate__s 3 31 3c 3r2c,RRPV4 R2#)zARRAY[z, ])join)rs&r/to_str'ARRAY.literal_processor..to_strsDIIh/02 2r2c V^8dQhRRRR/#)r&valueSequence[typing_Any]r+rr-)r.s"r/r0rs  / C r2cD<SPVSSPS4pV#rU)_apply_item_processorrF)rinner item_procrOrs& r/process(ARRAY.literal_processor..processs'..y$//6ELr2)rN dialect_implliteral_processor)rOrrrrsf& @@r/rARRAY.literal_processorsHNN//8JJ     3   r2c V^8dQhRRRR/#)r&rrr+z2Optional[_BindProcessorType[Sequence[typing_Any]]]r-)r.s"r/r0r}s ;r2c raaSPPV4PV4oRVV3RllpV#)c V^8dQhRRRR/#)r&rOptional[Sequence[typing_Any]]r+zOptional[list[typing_Any]]r-)r.s"r/r0*ARRAY.bind_processor..__annotate__s  1  ' r2cT<VfV#SPVSSP\4#rU)rrFlistrrrOs&r/r%ARRAY.bind_processor..processs/} 119dootr2)rNrbind_processor)rOrrrsf& @r/rARRAY.bind_processors8NN//8GG    r2c$V^8dQhRRRRRR/#)r&rrcoltypeobjectr+z*_ResultProcessorType[Sequence[typing_Any]]r-)r.s"r/r0r}s$***)/* 3*r2c aaaaaSPPV4PW4oRVV3RllpSP'd,Vo\P !R4oRV3RlloRVV3RllpV#)c V^8dQhRRRR/#r&rrr+rr-)r.s"r/r0,ARRAY.result_processor..__annotate__s  '  + r2c<VfV#SPTSSPSP'd \4#\4#rU)rrFr{tuplerrs&r/r'ARRAY.result_processor..processsI} 11OO!]]]E 15 r2z^{(.*)}$c V^8dQhRRRR/#)r&rrr+Sequence[Optional[str]]r-)r.s"r/r0rs 1 1 11H 1r2cZ<SPV4P^4p\V4#))matchgroup_split_enum_values)rrpatterns& r/handle_raw_string1ARRAY.result_processor..handle_raw_strings' e,2215)%00r2c V^8dQhRRRR/#rr-)r.s"r/r0rs  + / r2cd<VfV#S!\V\4'd S!V44#T4#rU)rLr)rrsuper_rps&r/rrsD= L !%--&e,r2)rNrresult_processorrrecompile)rOrrrrrrrsf&& @@@@r/rARRAY.result_processorsmNN//8II      $ $ $Hjj-G 1 1  r2)r{rFrNr|)FNF)rlrmrnrorprHrJrMrr#comparator_factoryrmemoized_propertyrrrrrwr-r2r/rMrMsaEN1)f!NX^^..s3!NF$   (&**r2rMc V^8dQhRRRR/#)r& array_stringrr+rr-)r.s"r/r0r0sS-Dr2cRV9d5V'dVPR4M.Uu.uFpVR8wdTMRNK up#VPRR4pVPRR4p.p\P!RV4pR pVF}pVR8Xd V'*pKV'd$VPVPRR44K>TP \P !R V4Uu.uFpVR8wdTMRNK up4K V#uupiuupi) ",NULLNz\"z _$ESC_QUOTE$_z\\\z(")Fz ([^\s,]+),?)splitreplacerappendextendfindall)rrtextresult on_quotes in_quotestoks& r/rrs  ,2>l((-2E EfA$ &E      7D <<t $D F&II #:% I  MM#++os; < MM ZZ<<fA$.<  M7 ,s DD )6 __future__rrtypingrr(rrrrr r rr r r rrJrsqlr sql.visitorsrengine.interfacesr sql._typingrr sql.elementsrrsql.expressionr sql.operatorsrsql.selectabler sql.type_apirrrrr util.typingr r!r#eqr:ExpressionClauseListr<rMrr-r2r/rs# $ #!-,82-(/-1254*6# T$ e:& '\\ ( '\\ (_J + +B /_DxHNN2 xvr2