That looks certainly like a misconfigured relationship(). Not sure why SQLite
would let it pass through (sqlite is in general extremely liberal), but that's
clearly a literal string passed to a join expression sent to relationship as in
relationship(... primaryjoin=and_(some expression,
"Edge._discriminator=='use'")) or something like that. When using strings
for relationship(), the full expression must be a string, not the components.
On Mar 3, 2011, at 10:55 AM, Michael Naber wrote:
> Last line is invalid t-sql. The ‘==’ should just be ‘=’. I get the problem
> when using mssql but not with sqlite. Saw the bug on sqa version 0.6.6,
> upgraded to 0.7b2 and still having issue. Please let me know if you need more
> info and I'll be happy to provide.
>
> Thanks,
> Michael
>
>
> Traceback (most recent call last):
> File "C:\Program Files\eclipse-SDK-3.6.2-win32\eclipse\dropins\Pydev
> 1.6.5\plugins\org.python.pydev.debug_1.6.5.2011020317\pysrc\pydevd.py", line
> 1133, in <module>
> debugger.run(setup['file'], None, None)
> File "C:\Program Files\eclipse-SDK-3.6.2-win32\eclipse\dropins\Pydev
> 1.6.5\plugins\org.python.pydev.debug_1.6.5.2011020317\pysrc\pydevd.py", line
> 918, in run
> execfile(file, globals, locals) #execute the script
> File "C:\OpsPylonDev\TransformationBA-Trunk\pydev-setup-app.py", line 5, in
> <module>
> SetupCommand('setup-app').run(['development.ini'])
> File
> "C:\Python27\lib\site-packages\pastescript-1.7.3-py2.7.egg\paste\script\appinstall.py",
> line 68, in run
> return super(AbstractInstallCommand, self).run(new_args)
> File
> "C:\Python27\lib\site-packages\pastescript-1.7.3-py2.7.egg\paste\script\command.py",
> line 218, in run
> result = self.command()
> File
> "C:\Python27\lib\site-packages\pastescript-1.7.3-py2.7.egg\paste\script\appinstall.py",
> line 456, in command
> self, config_file, section, self.sysconfig_install_vars(installer))
> File
> "C:\Python27\lib\site-packages\pastescript-1.7.3-py2.7.egg\paste\script\appinstall.py",
> line 598, in setup_config
> mod.setup_app, command, filename, section, vars)
> File
> "C:\Python27\lib\site-packages\pastescript-1.7.3-py2.7.egg\paste\script\appinstall.py",
> line 612, in _call_setup_app
> func(command, conf, vars)
> File "C:\OpsPylonDev\TransformationBA-Trunk\transformationba\websetup.py",
> line 34, in setup_app
> insert_data()
> File
> "C:\OpsPylonDev\TransformationBA-Trunk\transformationba\model\data\__init__.py",
> line 42, in insert_data
> inserter.insert()
> File "transformationba\model\data\inserters\400technology.py", line 23, in
> insert
> csharp_app.create_artifacts()
> File
> "C:\OpsPylonDev\TransformationBA-Trunk\transformationba\model\data\technology_data\csharp_app.py",
> line 65, in create_artifacts
> parent.uses.append(component)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\ext\associationproxy.py",
> line 189, in __get__
> proxy = self._new(_lazy_collection(obj, self.target_collection))
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\ext\associationproxy.py",
> line 233, in _new
> self.collection_class = util.duck_type_collection(lazy_collection())
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\ext\associationproxy.py",
> line 335, in __call__
> return getattr(obj, self.target)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\orm\attributes.py",
> line 162, in __get__
> return self.impl.get(instance_state(instance),dict_)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\orm\attributes.py",
> line 414, in get
> value = self.callable_(state, passive)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\orm\strategies.py",
> line 542, in _load_for_state
> result = q.all()
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\orm\query.py",
> line 1636, in all
> return list(self)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\orm\query.py",
> line 1746, in __iter__
> return self._execute_and_instances(context)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\orm\query.py",
> line 1752, in _execute_and_instances
> close_with_result=True).execute(querycontext.statement, self._params)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\engine\base.py",
> line 1259, in execute
> params)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\engine\base.py",
> line 1392, in _execute_clauseelement
> compiled_sql, distilled_params
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\engine\base.py",
> line 1500, in _execute_context
> context)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\engine\base.py",
> line 1493, in _execute_context
> context)
> File
> "C:\Python27\lib\site-packages\sqlalchemy-0.7b2-py2.7.egg\sqlalchemy\engine\default.py",
> line 325, in do_execute
> cursor.execute(statement, parameters)
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', "[42000]
> [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.
> (102) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL
> Server]Statement(s) could not be prepared. (8180)") u"SELECT edge.id AS
> edge_id, edge.tail_node_id AS edge_tail_node_id, edge.head_node_id AS
> edge_head_node_id, edge._discriminator AS edge__discriminator \nFROM edge
> \nWHERE edge.tail_node_id = ? AND Edge._discriminator=='use'" (69,)
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
