Re: [sqlalchemy] 'unique' exception not translated by sqlalchemy
On Monday, March 25, 2019 at 6:00:28 AM UTC-4, Simon King wrote: SQLAlchemy normally wraps all DBAPI exceptions in its own exception > classes. If that's not working for you, could you show an example that > we can run to reproduce the problem? In addition, please share the versions of SqlAlchemy and Sqlite you are using. The correct behavior is as you expect and Simon confirmed- you should see a `sqlalchemy.exc.IntegrityError` raised, which wraps the underlying `sqlite3.IntegrityError`. The most likely issues for what you experience are: 1. a mistake in your code 2. an old version of a library 3. a breaking change in a library -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] 'unique' exception not translated by sqlalchemy
On Mon, Mar 25, 2019 at 8:04 AM wrote: > > I'm trying to use UNIQUE on a column in a table, catching exception in order > to determine conflict. > > Problem is that the exception I'm getting is sqlite3.IntegrityError. This is > not a SqlAlchemy exception, and its a problem since sqlite is temporary. > I expected to get a ORM/SA exception, that will be the same with different > engines. > > (also sqlite goes bonkers after it happens, requiring transaction rollback) > > I know I can query first, but that makes using the UNIQUE designation kind of > moot. SQLAlchemy normally wraps all DBAPI exceptions in its own exception classes. If that's not working for you, could you show an example that we can run to reproduce the problem? Simon -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
[sqlalchemy] 'unique' exception not translated by sqlalchemy
I'm trying to use UNIQUE on a column in a table, catching exception in order to determine conflict. Problem is that the exception I'm getting is sqlite3.IntegrityError. This is not a SqlAlchemy exception, and its a problem since sqlite is temporary. I expected to get a ORM/SA exception, that will be the same with different engines. (also sqlite goes bonkers after it happens, requiring transaction rollback) I know I can query first, but that makes using the UNIQUE designation kind of moot. -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.