+ i0^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIH t ^RI H t ^R I H t ^R I H t ^R I Ht^R I Ht^R IHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIH t ^RIH!t!^RIH"t"^RIH#t#^RI$H%t%^RI&H't'R(t(RRlt)!R R]4t!R!R"] 4t*!R#R$]*4t+!R%R&]*4t,R'#))) annotations)Any)List)Optional)Tuple)Union)ext)_OnConflictConstraintT)_OnConflictIndexElementsT)_OnConflictIndexWhereT)_OnConflictSetT)_OnConflictWhereT)util) coercions)roles)schema)_DMLTableArgument)_exclusive_against) _generative)ColumnCollection)ReadOnlyColumnCollectionInsert) ClauseElement) ColumnElement)KeyedColumnElement) TextClause)alias)Selfrc V^8dQhRRRR/#)tablerreturnr)formats"|C:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy/dialects/postgresql/dml.py __annotate__r'*s#c\V4#)aGConstruct a PostgreSQL-specific variant :class:`_postgresql.Insert` construct. .. container:: inherited_member The :func:`sqlalchemy.dialects.postgresql.insert` function creates a :class:`sqlalchemy.dialects.postgresql.Insert`. This class is based on the dialect-agnostic :class:`_sql.Insert` construct which may be constructed using the :func:`_sql.insert` function in SQLAlchemy Core. The :class:`_postgresql.Insert` construct includes additional methods :meth:`_postgresql.Insert.on_conflict_do_update`, :meth:`_postgresql.Insert.on_conflict_do_nothing`. r)r"s&r&insertr**s" %=r(c]tRt^>tRtRtRt]PRRl4t ] !RRR/R7t ] ] RR R ll44t ] ] RR R ll44tRtR #)rzPostgreSQL-specific implementation of INSERT. Adds methods for PG-specific syntaxes such as ON CONFLICT. The :class:`_postgresql.Insert` object is created using the :func:`sqlalchemy.dialects.postgresql.insert` function. postgresqlFcV^8dQhRR/#)r!r#z6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]r$)r%s"r&r'Insert.__annotate__Ls:: ?:r(c D\VPRR7P#)aProvide the ``excluded`` namespace for an ON CONFLICT statement PG's ON CONFLICT clause allows reference to the row that would be inserted, known as ``excluded``. This attribute provides all columns in this row to be referenceable. .. tip:: The :attr:`_postgresql.Insert.excluded` attribute is an instance of :class:`_expression.ColumnCollection`, which provides an interface the same as that of the :attr:`_schema.Table.c` collection described at :ref:`metadata_tables_and_columns`. With this collection, ordinary names are accessible like attributes (e.g. ``stmt.excluded.some_column``), but special names and dictionary method names should be accessed using indexed access, such as ``stmt.excluded["column name"]`` or ``stmt.excluded["values"]``. See the docstring for :class:`_expression.ColumnCollection` for further examples. .. seealso:: :ref:`postgresql_insert_on_conflict` - example of how to use :attr:`_expression.Insert.excluded` excluded)name)rr"columns)selfs&r&r0Insert.excludedKs6TZZj1999r(_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)msgsNc 0V^8dQhRRRRRRRRR R R R /#) r! constraintr index_elementsr index_wherer set_r whererr#rr$)r%s"r&r'r.rsF==*=2=, =  = ! = =r(c *\WW4V4VnV#)a Specifies a DO UPDATE SET action for ON CONFLICT clause. Either the ``constraint`` or ``index_elements`` argument is required, but only one of these can be specified. :param constraint: The name of a unique or exclusion constraint on the table, or the constraint object itself if it has a .name attribute. :param index_elements: A sequence consisting of string column names, :class:`_schema.Column` objects, or other column expression objects that will be used to infer a target index. :param index_where: Additional WHERE criterion that can be used to infer a conditional target index. :param set\_: A dictionary or other mapping object where the keys are either names of columns in the target table, or :class:`_schema.Column` objects or other ORM-mapped columns matching that of the target table, and expressions or literals as values, specifying the ``SET`` actions to take. .. versionadded:: 1.4 The :paramref:`_postgresql.Insert.on_conflict_do_update.set_` parameter supports :class:`_schema.Column` objects from the target :class:`_schema.Table` as keys. .. warning:: This dictionary does **not** take into account Python-specified default UPDATE values or generation functions, e.g. those specified using :paramref:`_schema.Column.onupdate`. These values will not be exercised for an ON CONFLICT style of UPDATE, unless they are manually specified in the :paramref:`.Insert.on_conflict_do_update.set_` dictionary. :param where: Optional argument. An expression object representing a ``WHERE`` clause that restricts the rows affected by ``DO UPDATE SET``. Rows not meeting the ``WHERE`` condition will not be updated (effectively a ``DO NOTHING`` for those rows). .. seealso:: :ref:`postgresql_insert_on_conflict` )OnConflictDoUpdater5)r3r8r9r:r;r<s&&&&&&r&on_conflict_do_updateInsert.on_conflict_do_updateps x$6  5$   r(c(V^8dQhRRRRRRRR/#) r!r8r r9r r:r r#rr$)r%s"r&r'r.s2!!*!2!, !  !r(c (\WV4VnV#)a Specifies a DO NOTHING action for ON CONFLICT clause. The ``constraint`` and ``index_elements`` arguments are optional, but only one of these can be specified. :param constraint: The name of a unique or exclusion constraint on the table, or the constraint object itself if it has a .name attribute. :param index_elements: A sequence consisting of string column names, :class:`_schema.Column` objects, or other column expression objects that will be used to infer a target index. :param index_where: Additional WHERE criterion that can be used to infer a conditional target index. .. seealso:: :ref:`postgresql_insert_on_conflict` )OnConflictDoNothingr5)r3r8r9r:s&&&&r&on_conflict_do_nothingInsert.on_conflict_do_nothings@$7  $   r()r5NNNNNNNN)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cachermemoized_propertyr0r_on_conflict_exclusiverr?rD__static_attributes__r$r(r&rr>s%M ::80 !$0 ==~!!r(cJ]tRt^t$RtR]R&R]R&R]R&R R R lltR tR#) OnConflictClauser,z Optional[str]constraint_targetz.Optional[List[Union[str, schema.Column[Any]]]]inferred_target_elementsz/Optional[Union[ColumnElement[Any], TextClause]]inferred_target_whereclauseNc$V^8dQhRRRRRR/#)r!r8r r9r r:r r$)r%s"r&r'OnConflictClause.__annotate__s(<<*<2<, <r(c <Ve]\V\4'gG\V\P\P 34'd\ VR4;'gTpVeVe \R4h\V\4'dWnRVn RVn M\V\P4'd0VPpVPR,PR4pMg\V\P 4'dVPpVP pM.VPpVPR,PR4pVeRVnVUu.uF(p\"P$!\&P(V4NK* upVn VeV\"P$!\V\P 4'd\&P*M\&P,V4MRVn R#VfR;Vn;Vn Vn R#R#uupi)Nr1z8'constraint' and 'index_elements' are mutually exclusiver,r<) isinstancestrr Constraintr ExcludeConstraintgetattr ValueErrorrTrUrVIndex expressionsdialect_optionsgetr2r<rexpectrDDLConstraintColumnRoleStatementOptionRoleWhereHavingRole)r3r8r9r:columns&&&& r&__init__OnConflictClause.__init__s  !j#..:""C$9$9:44%Z8FFJ  !) N*c**)3&04-370J 55!+!7!7(88FJJ J(=(=>>!+!3!3(.. !+!3!3(88FJJ   %%)D "--,F  !>!>G,-D )*  &j#2G2GHH11"22   ,  D " T%B0 %-s$.H)rTrUrVrG)rHrIrJrKrM__annotations__rirQr$r(r&rSrSs($$$LL"<<r(rSc]tRtRtRtRtR#)rCirDr$N)rHrIrJrK__visit_name__rQr$r(r&rCrCs-Nr(rCcLa]tRtRt$RtR]R&R]R&R RV3RllltR tV;t#) r>i#r?z0List[Tuple[Union[schema.Column[Any], str], Any]]update_values_to_setzOptional[ColumnElement[Any]]update_whereclausec ,V^8dQhRRRRRRRRR R /#) r!r8r r9r r:r r;r r<rr$)r%s"r&r'OnConflictDoUpdate.__annotate__)s<* * ** 2* , *  * ! * r(c ><\SV`VVVR7VPfVPf \ R4h\ V\ 4'dV'g \ R4hM-\ V\4'd \ V4pM \ R4hVP4UUu.uF,wrg\P!\PV4V3NK. uppVn Ve-\P!\PV4VnR#RVnR#uuppi))r8r9r:NzVEither constraint or index_elements, but not both, must be specified unless DO NOTHINGz*set parameter dictionary must not be emptyzqset parameter must be a non-empty dictionary or a ColumnCollection such as the `.c.` collection of a Table object)superrirUrTr_rZdictritemsrrdr DMLColumnRolerorgrp) r3r8r9r:r;r<keyvalue __class__s &&&&&& r&riOnConflictDoUpdate.__init__)s !)#    ) ) 1&&.D  dD ! ! !MNN . / /:D$ #jjl% *   e113 7 ?*% !     U22E :   % s%2D)rorprF) rHrIrJrKrmrkrirQ __classcell__)rzs@r&r>r>#s#,NJJ44* * * r(r>N)rr*)- __future__rtypingrrrrrr _typingr r r r rrsqlrrr sql._typingrsql.baserrrrsql.dmlrStandardInsert sql.elementsrrrrsql.expressionr util.typingr__all__r*rSrCr>r$r(r&rs#,/,%',*#(0/)).&# (V^VrE}EP.*.0 )0 r(