sql alchemy 1.3 python insert ignore for mysql

Question

Is there a way to do 'insert ignore' while using SQL Alchemy 1.3 and posting to MySQL (used to ignore records when record's primary key is already present in the table)?

I've scoured the internet, and it doesn't appear a way to use this fairly basic functionality?

Thank you!

yeah, saw this one, but was hoping there a better new way of doing it — FlyingZebra1, Sep 29 '19 at 22:03

score 0 · Answer 1 · answered Sep 30 '19 at 15:35

Unfortunately the only way I could find to do this was to post each record individually using try/except . slow and painful.

for record in list_of_records:
  try:post_stuff()
  except:pass

.. if anyone has any recommendations on how to do this same thing using bulk insert IGNORE for mysql - that would be greatly appreciated.

sql alchemy 1.3 python insert ignore for mysql

1 Answers1