Hello,
First time using sqlalchemy against a table with triggers and it doesn't
seem usable. Can anyone confirm or deny my situation as a bug, or
enlighten me to my user error?
First I ran into this issue:
ERROR:root:Database Error
Traceback (most recent call last):
*File my_code...*
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 645, in commit
self.transaction.commit()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 313, in commit
self._prepare_impl()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 297, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 1547, in flush
self._flush(objects)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 1616, in _flush
flush_context.execute()
File
"/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line
328, in execute
rec.execute(self)
File
"/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line
472, in execute
uow
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py",
line 2220, in _save_obj
execute(statement, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1399, in execute
params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1532, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1640, in _execute_context
context)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1633, in _execute_context
context)
File
"/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line
330, in do_execute
cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) ('42000', "[42000] [FreeTDS][SQL
Server]The target table 'a_table_name' of the DML statement cannot have any
enabled triggers if the statement contains an OUTPUT clause without INTO
clause. (334) (SQLPrepare)") 'INSERT INTO a_table_name (column_1, column_2,
column_3, column_4) OUTPUT inserted.the_id VALUES (?, ?, ?, ?)' ('123000',
2, None, None)
I managed to track this down to
http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#triggers
So, I did that only to find myself with this error, which seems like a bug,
rather then a limitation.
ERROR:root:Database Error
Traceback (most recent call last):
*File my_code...*
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 645, in commit
self.transaction.commit()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 313, in commit
self._prepare_impl()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 297, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 1547, in flush
self._flush(objects)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
line 1616, in _flush
flush_context.execute()
File
"/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line
328, in execute
rec.execute(self)
File
"/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line
472, in execute
uow
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py",
line 2220, in _save_obj
execute(statement, params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1399, in execute
params)
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1532, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1652, in _execute_context
context.post_exec()
File
"/usr/local/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/pyodbc.py",
line 195, in post_exec
self._lastrowid = int(row[0])
TypeError: int() argument must be a string or a number, not 'NoneType'
I couldn't figure out any solution to this problem. I did try setting
use_scope_identity to False, which not only seemed like a bad idea, but
yielded absolutely no effect on the error (I passed this as a keyword
argument to create_engine). Any ideas?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/c7eYQzrxbkMJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
