我尝试使用IMDbPY中的SQLobject,Python说驱动程序不工作--我运行的是PostgreSQL 9.2。
C:\Users\dom\AppData\Roaming\Python\Scripts>python imdbpy2sql.py -d /imdb -u 'postgres://sid:asdf@host/imdb'
Traceback (most recent call last):
File "imdbpy2sql.py", line 501, in <module>
conn = setConnection(URI, DB_TABLES)
File "C:\Users\dom\AppData\Roaming\Python\Python27\site-packages\imdb\parser\sql\objectadapter.py", line 185, in setConnection
conn = connectionForURI(uri, **kw)
File "C:\Users\dom\AppData\Roaming\Python\Python27\site-packages\sqlobject\dbconnection.py", line 1004, in connectionForURI
connCls = self.dbConnectionForScheme(scheme)
File "C:\Users\dom\AppData\Roaming\Python\Python27\site-packages\sqlobject\dbconnection.py", line 1021, in dbConnectionForScheme
% (scheme, ', '.join(self.schemeBuilders.keys())))
AssertionError: No SQLObject driver exists for 'postgres (only sqlite, sapdb, postgresql, firebird, maxdb, rdbhost, sybase, interbase, psycopg, mysql, mssql, postgres)我再次尝试安装它,而activepython显示它已经安装了:
C:\Users\dom\AppData\Roaming\Python\Scripts>pypm install sqlobject skipping "sqlobject"; already installed at "%APPDATA%\Python" (2.7)
关于让imdbpy2sql.py/SQLobject工作有什么想法吗?
发布于 2013-11-19 21:49:04
使用不带引号(!)的DB URI。
发布于 2015-01-06 03:43:51
很晚,但从imdb2py文档中可以看到:
其他必需模块显然SQLObject和SQLAlchemy只能通过您需要安装的其他特定模块/包访问数据库(例如:用于MySQL的'mysql-python‘,用于PostgreSQL的’MySQL‘,等等)。
你试过安装这些软件了吗?
https://stackoverflow.com/questions/17883196
复制相似问题