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 [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.
