jr,r-ceZdZUdZdZdZdejfdejfgZ de d<dd d fd Z e dd Z d dd Z d dd ZxZS)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_internalsN)type_c jt|tjg|i|||n4|jr|jdj nt j}t|tr8t|j|j|jdznd|_yt||_y)aConstruct 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. Nrr ) dimensions) super__init__rcomma_opr4r5sqltypesNULLTYPE isinstanceARRAY item_typer:)selfr4r7kw main_type __class__s r+r<zarray.__init__s ++Boolean)rCr(kwargss r+containszARRAY.Comparator.containsrs<<%X=M=M<N Nr-cN|jt|tjS)zBoolean expression. Test if elements are a proper subset of the elements of the argument array expression. rp)rrr r>rsrCr(s r+ contained_byzARRAY.Comparator.contained_by}s'<<e1A1A  r-cN|jt|tjS)zuBoolean expression. Test if array has elements in common with an argument array expression. rp)rrrr>rsrws r+overlapzARRAY.Comparator.overlaps<<HEnum native_enumrJs r+_against_native_enumzARRAY._against_native_enums- t~~x}} 5 +** r-c~jj|j|ydddfd }|S)Nc,ddj|dS)NzARRAY[z, ])join)elementss r+to_strz'ARRAY.literal_processor..to_strsDIIh/02 2r-cDj|j}|SrH)_apply_item_processorr:)valueinner item_procrCrs r+processz(ARRAY.literal_processor..processs'..y$//6ELr-)rzIterable[typing_Any]r[str)rSequence[typing_Any]r[r)rB dialect_implliteral_processor)rCdialectrrrs` @@r+rzARRAY.literal_processorsCNN//8JJ     3  r-ctjj|j| dfd }|S)NcP||Sj|jtSrH)rr:listrrrCs r+rz%ARRAY.bind_processor..processs/} 119dootr-)rOptional[Sequence[typing_Any]]r[zOptional[list[typing_Any]])rBrbind_processor)rCrrrs` @r+rzARRAY.bind_processorsCNN//8GG   1  ' r-cjj|j|| dfd }jr(|t j ddfd  dfd }|S)Nc|||Sj|jjr tStSrH)rr:rktuplerrs r+rz'ARRAY.result_processor..processsG} 11OO!]]E 15 r-z^{(.*)}$cZj|jd}t|S)Nr )matchgroup_split_enum_values)rrpatterns r+handle_raw_stringz1ARRAY.result_processor..handle_raw_strings' e,2215)%00r-cT||St|tr |S|SrH)r@r)rrsuper_rps r+rz'ARRAY.result_processor..processsA= L !%-&e,r-)rrr[r)rrr[ list[str])rBrresult_processorrrecompile)rCrcoltyperrrrrs` @@@@r+rzARRAY.result_processors}NN//8II W  '  +   $ $Hjj-G 1 + / r-)FNF)rBz_TypeEngineArgument[_T]rkr\r:z Optional[int]rlr\)r[r\)rrr[z#Optional[_LiteralProcessorType[_T]])rrr[z2Optional[_BindProcessorType[Sequence[typing_Any]]])rrrobjectr[z*_ResultProcessorType[Sequence[typing_Any]])r]r^r_r`r<r>rAr|r#comparator_factoryrmemoized_propertyrrrrrIr-r+rArAsET$(" 1)*1)1)" 1)  1)f!NX^^..r2!NF$    ,( ;&**)/* 3*r-rAcfd|vr|r|jdSgS|jdd}|jdd}g}tjd|}d}|D]T}|dk(r| } |r"|j|jdd0|j tj d |V|S) N",z\"z _$ESC_QUOTE$_z\\\z(")Fz ([^\s,]+),?)splitreplacerappendextendfindall) array_stringtextresult on_quotes in_quotestoks r+rrs ,*6|!!#&>B>    7D <<t $D F&II #:% I  MM#++os; < MM"**^S9 :  Mr-)r(rZr)z_ColumnExpressionArgument[_T]r*rr[r{)rrr[r)5 __future__rrtypingrrZrrrrr r rr r rrr>rsqlr sql.visitorsrengine.interfacesr sql._typingrr sql.elementsrrsql.expressionr sql.operatorsrsql.selectabler sql.type_apirrrr r! util.typingr"r#eqr0ExpressionClauseListr2rArrIr-r+rs# $ #!-,82-(/-1254*6# T$ '\\ (  ( * ( ( ( '\\ (  ( * ( ( (_J + +B /_DxHNN2 xvr-