I am working with an existing database (MySQL - Prestashop).
On some tables, auto-incrementation for primary key is not used. And I am not able to set it, because it goes against the logic of the application. I know, wired, but...
Is it possible to force SQLObject to insert id manually?
PsMessageReaded(id = myId, idEmployee=3, dateAdd = tStamp)
When I am trying it, I am getting following error:
self._executeRetry(conn, c, q)
File "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/mysql/mysqlconnection.py", line 129, in _executeRetry
sqlobject.dberrors.ProgrammingError: Column 'id_message' specified twice
id_message is the name of the primary key column in the table:
_connection = connection
idName = 'id_message'
fromDatabase = True
Thanks for your comments