Feature request - Adding support for INSERT OR UPDATE and INSERT OR IGNORE #391

Activity

1. blunderbuss-gcf

   assigned

   harshachinta

   on Mar 8, 2024
2. product-auto-label

   added

   api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.Issues related to the googleapis/python-spanner-sqlalchemy API.

   on Mar 8, 2024
3. andrew-petukhov commented on Mar 31, 2024

   

   andrew-petukhov

   on Mar 31, 2024

   More actions

   Hello,
   It is possible to use the following statement with no changes to library:
   insert(users).prefix_with("OR IGNORE").values(dict(id=1, name="name1"))
   which will render to
   'INSERT OR IGNORE INTO users (id, name) VALUES (:id, :name)'

   Please notice that this statement is not supported yet in spanner emulator.
4. harshachinta

   assigned

   ankiaga

   and unassigned

   harshachinta

   on Apr 3, 2024
5. olavloite

   added 2 commits that reference this issue on Nov 28, 2024

   feat: add helper function for insert-or-update

   ...

   This issue will close once commit d9350f3 is merged into the 'main' branch.

   d9350f3

   feat: add helper function for insert-or-update

   ...

   This issue will close once commit d76c7d6 is merged into the 'main' branch.

   d76c7d6
6. olavloite

   closed this as completedin #526on Nov 28, 2024
7. olavloite

   closed this as completedin 6ff12econ Nov 28, 2024
8. renovate-bot

   added a commit that references this issue on Nov 28, 2024

   feat: add helper function for insert-or-update (googleapis#526)

   ...

   This issue will close once commit 6ff12ec is merged into the 'main' branch.

   6ff12ec