-ha%SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SS KJ r SS K J r SS KJr SS KJr SS KJr Sr"SS\ 5r \"\ SS5r"SS\5r"SS\5r"SS\5rg))ext)util) coercions)roles)schema)_exclusive_against) _generative)ColumnCollection)Insert) ClauseElement)alias)public_factory)r insertc\rSrSrSrSrSr\RS5r \ "SSS0S9r \ \ S S j55r \ \ SS j55rS rg )r zPostgreSQL-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. .. versionadded:: 1.1 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)rtablecolumns)selfs wC:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\site-packages\sqlalchemy/dialects/postgresql/dml.pyrInsert.excluded(s2TZZj1999_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)msgsNc([XX4U5Ulg)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). .. versionadded:: 1.1 .. seealso:: :ref:`postgresql_insert_on_conflict` N)OnConflictDoUpdater)r constraintindex_elements index_whereset_wheres ron_conflict_do_updateInsert.on_conflict_do_updateKs~$6  5$  rc&[XU5Ulg)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. .. versionadded:: 1.1 .. seealso:: :ref:`postgresql_insert_on_conflict` N)OnConflictDoNothingrrr!r"r#s ron_conflict_do_nothingInsert.on_conflict_do_nothings>$7  $  r)rNNNNNNNN)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cachermemoized_propertyrr _on_conflict_exclusiver r&r+__static_attributes__rrr r s %M ::40 !$0   ? ? B@D  rr z.dialects.postgresql.insertz.dialects.postgresql.Insertc"\rSrSrSrSSjrSrg)OnConflictClauserNcUbc[U[R5(dD[U[R[ R 45(a[US5=(d UnUbUb [S5e[U[R5(aXl SUl SUl O[U[R5(a+URnURSRS5nOb[U[ R 5(aUR nUR"nO*UR nURSRS5nUbSUl X l X0l gUcS=Ul =Ul Ul gg)Nrz8'constraint' and 'index_elements' are mutually exclusiverr%) isinstancer string_typesr ConstraintrExcludeConstraintgetattr ValueErrorconstraint_targetinferred_target_elementsinferred_target_whereclauseIndex expressionsdialect_optionsgetrr%r*s r__init__OnConflictClause.__init__so  !j$*;*;<<""C$9$9:BB%Z8FJ  !) N*d&7&788)3&04-370J 55!+!7!7(88FJJ J(=(=>>!+!3!3(.. !+!3!3(88FJJ   %%)D ",: )/: ,  48 8D " 8-0 r)rDrErFr.)r/r0r1r2r4rKr8r9rrr;r;s $(8rr;c\rSrSrSrSrg)r)r+r9N)r/r0r1r2__visit_name__r8r9rrr)r)s-Nrr)c:^\rSrSrSrSU4SjjrSrU=r$)r r&c>[[U] UUUS9 URcURc [ S5e[ U[5(aU(d [ S5eO,[ U[5(a [U5nO [ S5eUR5VVs/sH,upg[R"[RU5U4PM. snnUlXPlgs snnf)N)r!r"r#zVEither 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 rKrErDrCr>dictr itemsrexpectr DMLColumnRoleupdate_values_to_setupdate_whereclause) rr!r"r#r$r%keyvalue __class__s rrKOnConflictDoUpdate.__init__s  $0!)# 1   ) ) 1&&.D  dD ! ! !MNN . / /:D$ #jjl% *   e113 7 ?*% !#( % s!3C$)rXrYr-)r/r0r1r2rOrKr8 __classcell__)r\s@rr r s#,N  &(&(rr N)rrsqlrrrsql.baser r r sql.dmlr StandardInsert sql.elementsr sql.expressionrutil.langhelpersr__all__rr;r)r r9rrrhs}*#(/)#. V ^V r  )+H  +8}+8\.*.)())(r