Databases
StackOverflow2013
Postsdbo
POSQLAlchemy IntegrityError
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQLAlchemy IntegrityError
    primarykey
    data
    text
    <p>I'm having a problem using SQLAlchemy with PySide(PyQt). I'm trying to pop-up a <code>QtGui.QDialog</code>, but when I do this SQLAlchemy throws an exception:</p> <pre><code>Traceback (most recent call last): File "C:\Python27\lib\site-packages\preo\preodb\dbviewandmodel.py", line 32, in rowCount return len(self.rows()) File "C:\Python27\lib\site-packages\preo\preodb\dbviewandmodel.py", line 30, in rows return self.tableobj.query.all() File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\query.py", line 1579, in all return list(self) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\query.py", line 1688, in __iter__ self.session._autoflush() File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\session.py", line 862, in _autoflush self.flush() File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\session.py", line 1388, in flush self._flush(objects) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\session.py", line 1469, in _flush flush_context.execute() File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\unitofwork.py", line 302, in execute rec.execute(self) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\unitofwork.py", line 446, in execute uow File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\orm\mapper.py", line 1878, in _save_obj execute(statement, params) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\engine\base.py", line 1191, in execute params) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\engine\base.py", line 1271, in _execute_clauseelement return self.__execute_context(context) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\engine\base.py", line 1302, in __execute_context context.parameters[0], context=context) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\engine\base.py", line 1401, in _cursor_execute context) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\engine\base.py", line 1394, in _cursor_execute context) File "C:\Python27\lib\site-packages\sqlalchemy-0.6.6-py2.7.egg\sqlalchemy\engine\default.py", line 299, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (IntegrityError) ('23000', "[23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UQ__users__F3DBC5720DAF0CB0'. Cannot insert duplicate key in object 'dbo.users'. (2627) (SQLExecDirectW); [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (3621)") u'INSERT INTO users (username, fullname, email, passwordmd5) OUTPUT inserted.id VALUES (?, ?, ?, ?)' (None, None, None, None) </code></pre> <p>This is particularly troubling because I have no code, anywhere, that even attempts to insert records into SQL; I am only ever attempting to query data from the database. In fact, my DB model is read-only with respect to what PySide/PyQt are doing (i.e., I'm using a <code>QtGui.QTableView</code> model/view and there is no <code>insertRows</code> function in that model).</p> <p>I have no idea what's going on or how to solve it - again, I have no code to modify SQL records at all, but still SQLAlchemy attempts to be inserting blank records into one of my SQL tables. All I can see, in the background, is the <code>QTableView</code> data model is querying the database A LOT. It just seems that when I popup this <code>QDialog</code> (which does have some code in it to query some table column) this error is thrown. Oddly, this isn't consistent, sometime the popup appears first before the exception, sometimes the popup appears after the exception. Under normal circumstances, the <code>QTableView</code> data model works great, just not when I popup this dialog (and ironically, the popup isn't using any <code>QTableView</code> at all, just standard widgets like QLineEdit, QTextEdit, etc.)</p> <p>If it helps, I'm using Python 2.7 with SQLAlchemy 0.6.6 (also with Elixir 0.7.1), and PySide 1.0.0 (and PyQt4 4.8.3). I'm on Windows 7 using SQL 2008 R2 (Express). And yes, I've tried rebooting the PC, but the problem still occurs after a reboot. I'm reluctant to post more code because I have a lot of it in this particular project and I can't nail down the problem anything specific.</p> <p>I'm hoping someone might know of oddities in SQLAlchemy and/or PyQt that might be related to this. I'm also hoping I can continue using SQLAlchemy as I have a large data model built; I'm reluctant, at this point, to abandon this and use PyQt's SQL features.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBen
    1. USRaceyman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThe select statement might not be doing anything, but something is probably happening to the session before the query. When the query runs, it flushes any changes still to be made (such as inserting a user). Can we see the rest of the "dbviewandmodel.py" file?
      singulars
      1. POSQLAlchemy IntegrityError
      1. USMark Hildreth
    2. COI still was not doing any database modifications of any kind when this is happening (no inserts, no edits on any data in that database), just querying data. I think I've found a way of NOT making this crash happen (not really a fix, more like, I can get it to not happen by not doing something specific). I'll add an answer as it's a bit long winded.
      singulars
      1. POSQLAlchemy IntegrityError
      1. USRaceyman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload