-h~7pSSKrSSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r \R4S jr \R4S jr "S S \R\R5r\R "S SSS9r\R "SSSS9r\R "SSSS9r"SS\R(5rSrg)N)types)util) coercions) expression) operators)rolesc$URX5$)zbA synonym for the ARRAY-level :meth:`.ARRAY.Comparator.any` method. See that method for details. )anyotherarrexproperators yC:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\site-packages\sqlalchemy/dialects/postgresql/array.pyAnyr ;;u ''c$URX5$)zbA synonym for the ARRAY-level :meth:`.ARRAY.Comparator.all` method. See that method for details. )allr s rAllrrrc\^\rSrSrSrSrSrSrU4Sjr\ S5r S Sjr S Sjr S r U=r$) array$a[A 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:: 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:: 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 $>UVs/sH(n[R"[RU5PM* nn[[ U]"U0UD6 UVs/sHoDRPM snUlURSUR(aURSO[R5n[U[5(a6[URURbURS-OSS9Ulg[U5Ulgs snfs snf)Ntype_r) dimensions)rexpectr ExpressionElementRolesuperr__init__type _type_tuplepopsqltypesNULLTYPE isinstanceARRAY item_typer)selfclauseskwcarg main_type __class__s rr#array.__init__\sFM FMI  U88! ros rrAarray._bind_paramws X):)::++&."&))   ! !$$ D%!  sA)cU[R[R[R4;a[R "U5$U$r5)rany_opall_opr?rGrouping)r,againsts r self_grouparray.self_groups9 y'')9)99;L;LM M&&t, ,Kr)r%r$)FNr5)__name__ __module__ __qualname____firstlineno____doc____visit_name__stringify_dialect inherit_cacher#propertyr8rArJ__static_attributes__ __classcell__)r2s@rrr$sC/bN$M).*rrz@>T) precedence is_comparisonz<@z&&c\rSrSrSr"SS\R R5r\rSSjr \ S5r \ S5r S r S r\R S 5rS rS rSrSrg)r*a PostgreSQL ARRAY type. .. versionchanged:: 1.1 The :class:`_postgresql.ARRAY` type is now a subclass of the core :class:`_types.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]) The :class:`_postgresql.ARRAY` type may not be supported on all PostgreSQL DBAPIs; it is currently known to work on psycopg2 only. 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. c*\rSrSrSrSrSrSrSrg)ARRAY.ComparatoraDefine 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)operateCONTAINSr'Boolean)r,r kwargss rcontainsARRAY.Comparator.containss<<%X=M=M<N NrcHUR[U[RS9$)zlBoolean expression. Test if elements are a proper subset of the elements of the argument array expression. r`)rb CONTAINED_BYr'rdr,r s r contained_byARRAY.Comparator.contained_bys'<<e1A1A  rcHUR[U[RS9$)z]Boolean expression. Test if array has elements in common with an argument array expression. r`)rbOVERLAPr'rdrjs roverlapARRAY.Comparator.overlaps<<H# UH nT"U5v M g7fr5r6).0ritemprocs r $ARRAY._proc_array..Rs!;s!(1++ssc3\># UH!nTRUTTbTS- OST5v M# g7fNr) _proc_array)rr collectiondimrr,s rrrVsBA   "C!GD  s),)r{r)tuple)r,arrrrrs` ```rrARRAY._proc_arrayCss ;s)C 1H{ !#a&4-88!!;s!;;;!#& rc[UR[R5=(a URR$r5)r)r+r'Enum native_enumr7s r_against_native_enumARRAY._against_native_enum`s- t~~x}} 5 +** rcU$r5r6)r, bindvalues rbind_expressionARRAY.bind_expressiongsrcl^^TRRU5RU5mUU4SjnU$)NcR>UcU$TRUTTR[5$r5)rrr{value item_procr,s rprocess%ARRAY.bind_processor..processos-} ''9dootr)r+ dialect_implbind_processor)r,dialectrrs` @rrARRAY.bind_processorjs1NN//8GG   rc^^^^^TRRU5RX5mUU4SjnTR(a%Um[R "S5mU4SjmUU4SjnU$)Nc>UcU$TRUTTRTR(a [5$[5$r5)rrrtrr{rs rr'ARRAY.result_processor..process~sE} ''OO!]]E 15 rz^{(.*)}$cZ>TRU5RS5n[U5$r)matchgroup_split_enum_values)rinnerpatterns rhandle_raw_string1ARRAY.result_processor..handle_raw_strings' e,2215)%00rct>UcU$T"[U[R5(a T"U55$U5$r5)r)r string_types)rrsuper_rps rrrsH= L !%):):;;&e,r)r+rresult_processorrrecompile)r,rcoltyperrrrrs` @@@@rrARRAY.result_processorysYNN//8II     $ $Hjj-G 1 r)rtrr+ru)FNF)rLrMrNrOrPr'r*rqcomparator_factoryr#rTrxr|rrrmemoized_propertyrrrrrUr6rrr*r*sDL NX^^.. ND$HM0)d:    $rr*cSU;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)rrr'rsqlrrrr eqrr ClauseList ColumnElementr custom_oprcrirnr*rr6rrrs !"+("+(lJ ! !:#;#;l^   t F""4ATJ   dq ECHNNCLr