Skip to content

bulk_save_objects with IGNORE support? #5374

@perara

Description

@perara

Describe your question
Hi,

I've missed the ability to add IGNORE to the INSERT statement when doing bulk updates. So far I've extracted necessary pieces to make this work locally, but I was wondering if this is something that is welcomed in sqlalchemy. If that is the case I would PR this feature.
Example (if applicable)
bulk_save_objects(....,ignore_error=True)
(also for bulk version of update, insert)

Additional context

Useful links
https://stackoverflow.com/questions/1282025/bulk-insert-mysql-can-i-use-ignore-clause-is-there-a-limit-to-no-of-records#:~:text=Yes%2C%20you%20can%20use%20the,is%20a%20primary%20key)%3A

Have a nice day!

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionissue where a "fix" on the SQLAlchemy side is unlikely, hence more of a usage question

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions