Hi,
  I wonder if anyone can help with the below stack-trace.  The code in 
question works perfectly under Windows to MSSQL with the following 
connection string (params omitted):

ENGINE = sa.create_engine('mssql://DBSERVER/DB?trusted_connection=yes')


but something becomes an array when the same code is run in linux with the 
following connection string (params omitted):

ENGINE = 
> sa.create_engine('mssql+pyodbc://USER:PASS@DBSERVER_IP:PORT/DB?driver=FreeTDS;TDS_Version=8.0')


Both strings can be used to run queries without a problem.


Thanks for any information!

stack below:

[. . .]
self.db.session.commit()
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py",
 
line 150, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
 
line 790, in commit
    self.transaction.commit()
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
 
line 392, in commit
    self._prepare_impl()
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
 
line 372, in _prepare_impl
    self.session.flush()
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
 
line 2004, in flush
    self._flush(objects)
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
 
line 2122, in _flush
    transaction.rollback(_capture_exception=True)
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py",
 
line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/session.py",
 
line 2086, in _flush
    flush_context.execute()
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py",
 
line 373, in execute
    rec.execute(self)
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py",
 
line 532, in execute
    uow
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py",
 
line 170, in save_obj
    mapper, table, update)
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py",
 
line 630, in _emit_update_statements
    lambda rec: (
  File 
"/home/tpierson/theano_env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py",
 
line 459, in _collect_update_commands
    value, state.committed_state[propkey]):
ValueError: The truth value of an array with more than one element is 
ambiguous. Use a.any() or a.all()

-- 
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 http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to