我试图在没有根权限的计算机上运行python脚本。为此,我使用Python2.7设置了一个virtualenv
,然后添加了需要并行Python和SQLAlchemy的两个包。运行脚本时出现以下错误:
(virtPython)thaddeus:recipes ab940$ python2.7 matchIngsParallel.py
Starting pp with 8 workers
Reading ingredients into dictionary
Traceback (most recent call last):
File "matchIngsParallel.py", line 65, in <module>
for synonym, parentIng in session.query(IngSyn.synonym, IngSyn.parentIng):
File "build/bdist.macosx-10.6-intel/egg/sqlalchemy/orm/query.py", line 2227, in __iter__
File "build/bdist.macosx-10.6-intel/egg/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
File "build/bdist.macosx-10.6-intel/egg/sqlalchemy/engine/base.py", line 1449, in execute
File "build/bdist.macosx-10.6-intel/egg/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
File "build/bdist.macosx-10.6-intel/egg/sqlalchemy/engine/base.py", line 1698, in _execute_context
File "build/bdist.macosx-10.6-intel/egg/sqlalchemy/engine/base.py", line 1691, in _execute_context
File "build/bdist.macosx-10.6-intel/egg/sqlalchemy/engine/default.py", line 331, in do_execute
sqlalchemy.exc.OperationalError: (OperationalError) no such table: ingSyns u'SELECT "ingSyns".synonym AS "ingSyns_synonym", "ingSyns"."parentIng" AS "ingSyns_parentIng" \nFROM "ingSyns"' ()
似乎所有的东西都被正确地导入,但是数据库没有被正确地访问。在
脚本如下:
^{pr2}$(此代码缩短,但包含错误发生的位置)
assignDB
如下所示:
然后是类定义。在
不过,我在其他电脑上也试过了。我很困惑到底出了什么问题!在
脚本可以访问数据库,但是它中似乎没有表。我想您是从另一台机器复制脚本的,您是否也复制了SQLite数据库文件^{cd1>}?
相关问题 更多 >
编程相关推荐