j+~SSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SS KJ r SS KJ r SS KJ r S S KJ r S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJ r S SK!J"r" Sr#S&Sjr$"SS\5r"SS \5r%"S!S"\%5r&"S#S$\%5r'g%)') annotations)Any)Optional)ext)_OnConflictConstraintT)_OnConflictIndexElementsT)_OnConflictIndexWhereT)_OnConflictSetT)_OnConflictWhereT)util) coercions)roles)schema)_DMLTableArgument)_exclusive_against) _generative)ColumnCollection)ReadOnlyColumnCollectionInsert) ClauseElement)KeyedColumnElement)alias)Self)rinsertrc[U5$)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)tables _/var/www/reloj-farallon/venv/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/dml.pyrr%s" %=c\rSrSrSrSrSr\RS Sj5r \ "SSS0S9r \ \ SSS jj55r \ \ SSS jj55rS rg )r9zPostgreSQL-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. postgresqlFc>[URSS9R$)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!r'Insert.excludedFs6TZZj1999r"_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)msgsNc*[XX4U5UlU$)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. If present, can be a literal SQL string or an acceptable expression for 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` )OnConflictDoUpdater,)r* constraintindex_elements index_whereset_wheres r!on_conflict_do_updateInsert.on_conflict_do_updateks z$6  5$   r"c([XU5UlU$)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` )OnConflictDoNothingr,r*r0r1r2s r!on_conflict_do_nothingInsert.on_conflict_do_nothings@$7  $   r")r,)returnz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]NNNNN) r0r r1r r2r r3r r4r r<rNNN)r0r r1r r2r r<r)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cachermemoized_propertyr'r_on_conflict_exclusiverr5r:__static_attributes__r"r!rr9s%M : ?::80 !$0 .248.2 $#' >*>2>, >  > ! > >>@.248.2 !*!2!, !  !!r"cV\rSrSr%SrS\S'S\S'S\S'S S S jjrS rg )OnConflictClauser%z Optional[str]constraint_targetr inferred_target_elementsr inferred_target_whereclauseNcUbY[U[5(dD[U[R[R 45(a[ US5=(d UnUbUb [S5e[U[5(aXlSUl SUl O[U[R5(a+URnURSRS5nOb[U[R 5(aURnUR nO*URnURSRS5nUbSUlX l X0l gUcS=Ul=Ul Ul gg)Nr(z8'constraint' and 'index_elements' are mutually exclusiver%r4) isinstancestrr ConstraintrExcludeConstraintgetattr ValueErrorrMrNrOIndex expressionsdialect_optionsgetr)r4r9s r!__init__OnConflictClause.__init__sb  !j#..:""C$9$9:44%Z8FJ  !) N*c**)3&04-370J 55!+!7!7(88FJJ J(=(=>>!+!3!3(.. !+!3!3(88FJJ   %%)D ",: )/: ,   D " T%B0 r")rMrNrOr>)r0r r1r r2r )r?r@rArBrD__annotations__r[rHrIr"r!rKrKsK$$$77!77.248.2 ,*,2,, ,,r"rKc\rSrSrSrSrg)r8i r:rIN)r?r@rArB__visit_name__rHrIr"r!r8r8 s-Nr"r8cP^\rSrSrSrSSU4SjjjrSrU=r$)r/i r5c>[TU]UUUS9 URcURc [ S5e[ U[ 5(aU(d [ S5eO,[ U[5(a [ U5nO [ S5eUR5VVs/sH,upg[R"[RU5U4PM. snnUl XPlgs snnf)N)r0r1r2zVEither 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)superr[rNrMrVrQdictritemsrexpectr DMLColumnRoleupdate_values_to_setupdate_whereclause) r*r0r1r2r3r4keyvalue __class__s r!r[OnConflictDoUpdate.__init__s !)#    ) ) 1&&.D  dD ! ! !MNN . / /:D$ #jjl% *   e113 7 ?*% !#( % s3C )rgrhr=) r0r r1r r2r r3r r4r )r?r@rArBr_r[rH __classcell__)rks@r!r/r/ sS,N.248.2 $#' &(*&(2&(, &(  &( ! &(&(r"r/N)r rr<r)( __future__rtypingrrr_typingr r r r r rsqlrrr sql._typingrsql.baserrrrsql.dmlrStandardInsert sql.elementsrrsql.expressionr util.typingr__all__rrKr8r/rIr"r!r{s#,/,%',*#(0/).# (W^Wt3}3l.*.)())(r"