mg 6JSSKJr SSKrSSKJr SSKJr SSKJr SSKJr SSKJ r SS KJ r S S K J r S S K Jr S S KJr S SKJr S SKJr \"S\S9r\R(4Sjr\R(4Sjr"SS\R,\5r"SS\ R05rSrg)) annotationsN)Any)Optional)TypeVar) CONTAINED_BY)CONTAINS)OVERLAP)types)util) expression) operators)_TypeEngineArgument_T)boundc$URX5$)zbA synonym for the ARRAY-level :meth:`.ARRAY.Comparator.any` method. See that method for details. )anyotherarrexproperators l/Users/Alptekin/Desktop/izin_takip/venv/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/array.pyrr ;;u ''c$URX5$)zbA synonym for the ARRAY-level :meth:`.ARRAY.Comparator.all` method. See that method for details. )allrs rAllr'rrc\^\rSrSrSrSrSrSrU4Sjr\ S5r S Sjr S Sjr S r U=r$) array0aA 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 ``type_`` keyword argument is passed:: array(["foo", "bar"], type_=CHAR) 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` postgresqlTc >URSS5n[TU]"[R/UQ70UD6 UR Vs/sHoDR PM snUlUbUO/UR(aURSO[Rn[U[5(a6[URURbURS-OSS9Ulg[U5Ulgs snf)Ntype_rr) dimensions)popsuper__init__rcomma_opclausestype _type_tuplesqltypesNULLTYPE isinstanceARRAY item_typer&)selfr+kwtype_argarg main_type __class__s rr)array.__init__ns66'4( ++O>O  i ' '##!++7((1, DIi(DI%>sC2cU4$Nr3s r_select_iterablearray._select_iterables wrc U(dU[RLa#[R"SUUUURSS9$[ UVs/sHnUR XSUS9PM sn5$s snf)NT)_compared_to_operatorr$_compared_to_typeunique)_assume_scalarr$)rgetitemr BindParameterr,r _bind_param)r3robjrDr$os rrGarray._bind_params X):)::++&."&))   ! !$$ D%!  sA)cU[R[R[R4;a[R "U5$U$r;)rany_opall_oprErGrouping)r3againsts r self_grouparray.self_groups9 y'')9)99;L;LM M&&t, ,Kr)r-r,)FNr;)__name__ __module__ __qualname____firstlineno____doc____visit_name__stringify_dialect inherit_cacher)propertyr>rGrP__static_attributes__ __classcell__)r8s@rr r 0sC6pN$M)0*rr c\rSrSrSrSSSjjr"SS\RR5r\r \ S5r \ S5r S r \RS 5rS rS rS rSrg)r1a PostgreSQL ARRAY type. The :class:`_postgresql.ARRAY` type is constructed in the same way as the core :class:`_types.ARRAY` type; a member type is required, and a number of dimensions is recommended if the type is to be used for more than one dimension:: from sqlalchemy.dialects import postgresql mytable = Table( "mytable", metadata, Column("data", postgresql.ARRAY(Integer, dimensions=2)), ) The :class:`_postgresql.ARRAY` type provides all operations defined on the core :class:`_types.ARRAY` type, including support for "dimensions", indexed access, and simple matching such as :meth:`.types.ARRAY.Comparator.any` and :meth:`.types.ARRAY.Comparator.all`. :class:`_postgresql.ARRAY` class also provides PostgreSQL-specific methods for containment operations, including :meth:`.postgresql.ARRAY.Comparator.contains` :meth:`.postgresql.ARRAY.Comparator.contained_by`, and :meth:`.postgresql.ARRAY.Comparator.overlap`, e.g.:: mytable.c.data.contains([1, 2]) Indexed access is one-based by default, to match that of PostgreSQL; for zero-based indexed access, set :paramref:`_postgresql.ARRAY.zero_indexes`. Additionally, the :class:`_postgresql.ARRAY` type does not work directly in conjunction with the :class:`.ENUM` type. For a workaround, see the special type at :ref:`postgresql_array_of_enum`. .. container:: topic **Detecting Changes in ARRAY columns when using the ORM** The :class:`_postgresql.ARRAY` type, when used with the SQLAlchemy ORM, does not detect in-place mutations to the array. In order to detect these, the :mod:`sqlalchemy.ext.mutable` extension must be used, using the :class:`.MutableList` class:: from sqlalchemy.dialects.postgresql import ARRAY from sqlalchemy.ext.mutable import MutableList class SomeOrmClass(Base): # ... data = Column(MutableList.as_mutable(ARRAY(Integer))) This extension will allow "in-place" changes such to the array such as ``.append()`` to produce events which will be detected by the unit of work. Note that changes to elements **inside** the array, including subarrays that are mutated in place, are **not** detected. Alternatively, assigning a new array value to an ORM element that replaces the old one will always trigger a change event. .. seealso:: :class:`_types.ARRAY` - base array type :class:`_postgresql.array` - produces a literal array value. Nc[U[5(a [S5e[U[5(aU"5nXlX lX0lX@lg)auConstruct an ARRAY. E.g.:: Column("myarray", ARRAY(Integer)) Arguments are: :param item_type: The data type of items of this array. Note that dimensionality is irrelevant here, so multi-dimensional arrays like ``INTEGER[][]``, are constructed as ``ARRAY(Integer)``, not as ``ARRAY(ARRAY(Integer))`` or such. :param as_tuple=False: Specify whether return results should be converted to tuples from lists. DBAPIs such as psycopg2 return lists by default. When tuples are returned, the results are hashable. :param dimensions: if non-None, the ARRAY will assume a fixed number of dimensions. This will cause the DDL emitted for this ARRAY to include the exact number of bracket clauses ``[]``, and will also optimize the performance of the type overall. Note that PG arrays are always implicitly "non-dimensioned", meaning they can store any number of dimensions no matter how they were declared. :param zero_indexes=False: when True, index values will be converted between Python zero-based and PostgreSQL one-based indexes, e.g. a value of one will be added to all index values before passing to the database. zUDo not nest ARRAY types; ARRAY(basetype) handles multi-dimensional arrays of basetypeN)r0r1 ValueErrorr,r2as_tupler& zero_indexes)r3r2rar&rbs rr)ARRAY.__init__sON i ' '?  i & &! I" $(rc*\rSrSrSrSrSrSrSrg)ARRAY.Comparatori!aDefine 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 HUR[U[RS9$)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 r.Boolean)r3rkwargss rcontainsARRAY.Comparator.contains+s<<%X=M=M<N NrcHUR[U[RS9$)zlBoolean expression. Test if elements are a proper subset of the elements of the argument array expression. rg)rirr.rjr3rs r contained_byARRAY.Comparator.contained_by4s'<<e1A1A  rcHUR[U[RS9$)z]Boolean expression. Test if array has elements in common with an argument array expression. rg)rir r.rjros roverlapARRAY.Comparator.overlap<s<<H.to_str]sDIIh/02 2rcD>TRUTTRT5nU$r;)_apply_item_processorr&)valueinner item_procr3rs rprocess(ARRAY.literal_processor..process`s'..y$//6ELr)r2 dialect_implliteral_processor)r3dialectrrrs` @@rrARRAY.literal_processorVsANN//8JJ     3  rcl^^TRRU5RU5mUU4SjnU$)NcR>UcU$TRUTTR[5$r;)rr&rzrrr3s rr%ARRAY.bind_processor..processms-} 119dootr)r2rbind_processor)r3rrrs` @rrARRAY.bind_processorhs1NN//8GG   rc^^^^^TRRU5RX5mUU4SjnTR(a%Um[R "S5mU4SjmUU4SjnU$)Nc>UcU$TRUTTRTR(a [5$[5$r;)rr&ratuplerzrs rr'ARRAY.result_processor..process|sE} 11OO!]]E 15 rz^{(.*)}$cZ>TRU5RS5n[U5$)Nr)matchgroup_split_enum_values)rrpatterns rhandle_raw_string1ARRAY.result_processor..handle_raw_strings' e,2215)%00rc`>UcU$T"[U[5(a T"U55$U5$r;)r0str)rrsuper_rps rrrsB= L !%--&e,r)r2rresult_processorrrecompile)r3rcoltyperrrrrs` @@@@rrARRAY.result_processorwsYNN//8II     $ $Hjj-G 1 r)rar&r2rb)FNF)r2z_TypeEngineArgument[Any]raboolr&z Optional[int]rbr)rRrSrTrUrVr)r.r1rucomparator_factoryrZrwr{rr memoized_propertyrrrrr[r<rrr1r1sET$(" 1)+1)1)" 1)  1)fNX^^..NB$    $ $rr1cSU;aU(aURS5$/$URSS5nURSS5n/n[R"SU5nSnUHbnUS:Xa U(+nMU(a#URURSS55 M<UR [R "S U55 Md U$) N",z\"z _$ESC_QUOTE$_z\\\z(")Fz ([^\s,]+),?)splitreplacerappendextendfindall) array_stringtextresult on_quotes in_quotestoks rrrs ,*6|!!#&>B>    7D <<t $D F&II #:% I  MM#++os; < MM"**^S9 :  Mr) __future__rrtypingrrrrrr r r r.r sqlr sql._typingrreqrExpressionClauseListr r1rr<rrrs# #!. T"+("+(sJ + +B /sluHNNupr