I don't know if this will work for your usecase, but we handle a few similar situations with a nested transaction/savepoints. if an ntegrity error is raised on insert, an update is issued instead.
on conflicts it takes longer than your ideal method, but it's much faster than selecting the record/merging and is currently supported by sqlalchemy. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
