Hi Galaxy Developers
I aim to write a tool that will interact with Postgres database; here is what I wrote to test database connectivity. This script resides in /galaxy-dist/tools/test_tool/ and gets invoked from the front end. However script generate following error: No module named psycopg2.
Here is my code: #!/usr/bin/env python
import os.path import os from galaxy import eggs from galaxy.model import * from sqlalchemy import *
engine = create_engine('postgresql://postgres:@192.168.0.6:5432/galaxy') connection = engine.connect() result_set = connection.execute( "select id from galaxy_user" ) for row in result_set: print row[ 'id' ] connection.close()
Traceback (most recent call last): File "/galaxy-dist/tools/overlapanalysis/db_test.py", line 10, in ? engine = create_engine('postgresql://postgres:@192.168.0.6:5432/galaxy') File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/__init__.py", line 223, in create_engine return strategy.create(*args, **kwargs) File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/strategies.py", line 62, in create dbapi = dialect_cls.dbapi(**dbapi_args) File "/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/databases/postgres.py", line 368, in dbapi import psycopg2 as psycopg ImportError: No module named psycopg2
Thanks for any help. Regards MK