Problem with SQLAlchemy

[Roger Alexander]

Hi,

I having trouble creating a Windows executable (I'm doing this on
Windows XP) that requires SQLAlchemy. The executable is created, but
when I invoke the program, I get the following:

PS C:\ddt\tools> python .\retrieve_sample_data.py --host 10.202.13.61
1 test_db15
PS C:\ddt\tools> copy C:\pyinstaller\retrieve_sample_data\dist
\retrieve_sample_data.exe
PS C:\ddt\tools> .\retrieve_sample_data.exe --help
Traceback (most recent call last):
File "<string>", line 7, in <module>
File "C:\tmp\pyinstaller-1.5\iu.py", line 455, in importHook
ImportError: No module named sqlalchemy
PS C:\ddt\tools> .\retrieve_sample_data.exe --help
Traceback (most recent call last):
File "<string>", line 7, in <module>
File "C:\tmp\pyinstaller-1.5\iu.py", line 455, in importHook
ImportError: No module named sqlalchemy

There is a warnings file produced (below) that lists 203 warnings, may
of which are complaints that various sqlalchemy modules cannot be
found.

Note that the python program runs just fine when executed by the
Python interpreter (2.7.1).

Any suggestions?

Thanks,

Roger Alexander.

-------

W: no module named org (delayed import by xml.sax)
W: no module named sqlalchemy.sql.type_coerce (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.mssql (top-level import by
sqlalchemy)
W: no module named pyodbc (delayed import by
sqlalchemy.dialects.access.base)
W: no module named sqlalchemy.engine.Engine (delayed import by
sqlalchemy.events)
W: no module named pwd (delayed, conditional import by distutils.util)
W: no module named sqlalchemy.databases.sqlite (top-level import by
sqlalchemy)
W: no module named Carbon (delayed import by plistlib)
W: no module named sqlalchemy.sql.join (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.oracle (top-level import by
sqlalchemy)
W: no module named pwd (top-level import by shutil)
W: no module named java (conditional import by xml.sax._exceptions)
W: no module named pwd (top-level import by tarfile)
W: no module named sqlalchemy.sql.literal (top-level import by
sqlalchemy)
W: no module named readline (delayed import by pdb)
W: no module named sqlalchemy.engine.create_engine (top-level import
by sqlalchemy)
W: no module named sqlalchemy.sql.asc (top-level import by sqlalchemy)
W: no module named sqlalchemy.databases.drizzle (top-level import by
sqlalchemy)
W: no module named grp (top-level import by tarfile)
W: no module named termios (top-level import by getpass)
W: no module named sqlalchemy.databases.maxdb (top-level import by
sqlalchemy)
W: no module named java (delayed import by platform)
W: no module named sqlalchemy.sql.between (top-level import by
sqlalchemy)
W: no module named rourl2path (conditional import by urllib)
W: no module named Sybase (delayed import by
sqlalchemy.dialects.sybase.pysybase)
W: no module named sqlalchemy.util.threading (top-level import by
sqlalchemy.util.queue)
W: no module named com (delayed import by
sqlalchemy.dialects.oracle.zxjdbc)
W: no module named sqlalchemy.sql.tuple_ (top-level import by
sqlalchemy)
W: no module named cx_Oracle (delayed import by
sqlalchemy.dialects.oracle.cx_oracle)
W: no module named _dummy_threading (top-level import by
dummy_threading)
W: no module named sqlalchemy.create_engine (delayed, conditional
import by sqlalchemy.schema)
W: no module named sqlalchemy.sql.union_all (top-level import by
sqlalchemy)
W: no module named fcntl (conditional import by subprocess)
W: no module named sqlalchemy.databases.access (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.sybase (top-level import by
sqlalchemy)
W: no module named AES (delayed, conditional import by archive)
W: no module named sqlalchemy.databases.mysql (top-level import by
sqlalchemy)
W: no module named org (top-level import by copy)
W: no module named fcntl (top-level import by tempfile)
W: no module named sqlalchemy.sql.union (top-level import by
sqlalchemy)
W: no module named readline (delayed, conditional import by cmd)
W: no module named sqlalchemy.MetaData (top-level import by
sqlalchemy.dialects.mssql.information_schema)
W: no module named sqlalchemy.sql.bindparam (top-level import by
sqlalchemy.dialects.sybase.base)
W: no module named sqlalchemy.util.threading (top-level import by
sqlalchemy.pool)
W: no module named sqlalchemy.sql.desc (top-level import by
sqlalchemy)
W: no module named sqlalchemy.util.symbol (top-level import by
sqlalchemy.sql.operators)
W: no module named mysql (delayed, conditional import by
sqlalchemy.dialects.mysql.mysqlconnector)
W: no module named sqlalchemy.sql.modifier (top-level import by
sqlalchemy)
W: no module named sqlalchemy.Column (top-level import by
sqlalchemy.dialects.mssql.information_schema)
W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.zxJDBC)
W: no module named _xmlplus (top-level import by xml)
W: no module named sqlalchemy.util.pickle (top-level import by
sqlalchemy.types)
W: no module named sqlalchemy.util.asbool (top-level import by
sqlalchemy.connectors.pyodbc)
W: no module named sqlalchemy.sql.and_ (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.or_ (top-level import by sqlalchemy)
W: no module named java (delayed import by
sqlalchemy.dialects.oracle.zxjdbc)
W: no module named mx (delayed import by sqlalchemy.connectors.mxodbc)
W: no module named ctypes.cdll (delayed import by ctypes.util)
W: no module named sqlalchemy.sql.insert (top-level import by
sqlalchemy)
W: no module named sqlalchemy.util.chop_traceback (top-level import by
sqlalchemy.pool)
W: no module named sqlalchemy.databases.postgresql (top-level import
by sqlalchemy)
W: no module named sqlalchemy.sql.text (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.text (top-level import by
sqlalchemy.dialects.sybase.base)
W: no module named MacOS (delayed import by platform)
W: no module named sqlalchemy.sql.except_ (top-level import by
sqlalchemy)
W: no module named pwd (delayed import by getpass)
W: no module named sqlalchemy.sql.not_ (top-level import by
sqlalchemy)
W: no module named EasyDialogs (conditional import by getpass)
W: no module named gestalt (delayed import by platform)
W: no module named sqlalchemy.sql.subquery (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.select (top-level import by
sqlalchemy.dialects.mssql.base)
W: no module named sqlalchemy.sql.distinct (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.func (top-level import by
sqlalchemy)
W: no module named xmlparse (top-level import by pyexpat)
W: no module named sqlalchemy.sql.extract (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.exists (top-level import by
sqlalchemy)
W: no module named posix (conditional import by os)
W: no module named sqlalchemy.sql.text (top-level import by
sqlalchemy.dialects.informix.base)
W: no module named sqlalchemy.sql.outerjoin (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.bindparam (top-level import by
sqlalchemy)
W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.mysqldb)
W: no module named vms_lib (delayed, conditional import by platform)
W: no module named sqlalchemy.util.memoized_property (top-level import
by sqlalchemy.pool)
W: no module named sqlalchemy.databases.informix (top-level import by
sqlalchemy)
W: no module named grp (top-level import by shutil)
W: no module named pwd (delayed, conditional import by posixpath)
W: no module named org (top-level import by pickle)
W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.mxodbc)
W: no module named sqlalchemy.sql.except_all (top-level import by
sqlalchemy)
W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.pyodbc)
W: no module named sqlalchemy.sql.alias (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.literal_column (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.cast (top-level import by
sqlalchemy)
W: no module named _scproxy (conditional import by urllib)
W: no module named mysql (delayed import by
sqlalchemy.dialects.mysql.mysqlconnector)
W: no module named posix (delayed, conditional import by iu)
W: no module named win32com.gen_py (conditional import by win32com)
W: no module named sqlalchemy.sql.over (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.intersect (top-level import by
sqlalchemy)
W: no module named pysqlite2 (delayed import by
sqlalchemy.dialects.sqlite.pysqlite)
W: no module named sqlalchemy.sql.select (top-level import by
sqlalchemy)
W: no module named win32com.client._get_good_object_ (top-level import
by win32com.client.util)
W: no module named xmltok (top-level import by pyexpat)
W: no module named sqlalchemy.sql.delete (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.firebird (top-level import by
sqlalchemy)
W: no module named postgresql (delayed import by
sqlalchemy.dialects.postgresql.pypostgresql)
W: no module named _emx_link (conditional import by os)
W: no module named mx (top-level import by psycopg2)
W: no module named sqlalchemy.sql.case (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.update (top-level import by
sqlalchemy)
W: no module named com (delayed import by
sqlalchemy.connectors.zxJDBC)
W: no module named sqlalchemy.engine.engine_from_config (top-level
import by sqlalchemy)
W: no module named mx (delayed, conditional import by
sqlalchemy.connectors.mxodbc)
W: no module named SOCKS (top-level import by ftplib)
W: no module named sqlalchemy.sql.null (top-level import by
sqlalchemy)
W: no module named sqlalchemy.Table (top-level import by
sqlalchemy.dialects.mssql.information_schema)
W: no module named sqlalchemy.sql.collate (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.intersect_all (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.outparam (top-level import by
sqlalchemy)
W: delayed exec statement detected at line 0 - bdb (c:\Python27\lib
\bdb.pyc)
W: delayed eval hack detected at line 0 - bdb (c:\Python27\lib
\bdb.pyc)
W: delayed eval hack detected at line 0 - bdb (c:\Python27\lib
\bdb.pyc)
W: delayed __import__ hack detected at line 0 - optparse (c:
\Python27\lib\optparse.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.pg8000 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\pg8000.pyc)
W: delayed conditional __import__ hack detected at line 0 -
pkg_resources (c:\Python27\lib\site-packages\pkg_resources.pyc)
W: delayed conditional exec statement detected at line 0 -
pkg_resources (c:\Python27\lib\site-packages\pkg_resources.pyc)
W: delayed conditional __import__ hack detected at line 0 -
pkg_resources (c:\Python27\lib\site-packages\pkg_resources.pyc)
W: delayed __import__ hack detected at line 0 - pkg_resources (c:
\Python27\lib\site-packages\pkg_resources.pyc)
W: delayed conditional __import__ hack detected at line 0 - doctest (c:
\Python27\lib\doctest.pyc)
W: delayed exec statement detected at line 0 - doctest (c:
\Python27\lib\doctest.pyc)
W: delayed conditional __import__ hack detected at line 0 - doctest (c:
\Python27\lib\doctest.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.oracle
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\oracle\__init__.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.informix.informixdb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\informix
\informixdb.pyc)
W: __all__ is built strangely at line 0 - tokenize (c:\Python27\lib
\tokenize.pyc)
W: __all__ is built strangely at line 0 - tokenize (c:\Python27\lib
\tokenize.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.mysql.pymysql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mysql
\pymysql.pyc)
W: delayed __import__ hack detected at line 0 - pickle (c:
\Python27\lib\pickle.pyc)
W: delayed __import__ hack detected at line 0 - pickle (c:
\Python27\lib\pickle.pyc)
W: top-level exec statement detected at line 0 - sqlalchemy.sql.util
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\sql\util.pyc)
W: top-level exec statement detected at line 0 - sqlalchemy.sql.util
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\sql\util.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.sybase
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\sybase\__init__.pyc)
W: delayed __import__ hack detected at line 0 - encodings (c:
\Python27\lib\encodings\__init__.pyc)
W: __all__ is built strangely at line 0 -
sqlalchemy.dialects.postgresql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\__init__.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.mssql (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\dialects\mssql\__init__.pyc)
W: __all__ is built strangely at line 0 - dummy_threading (c:
\Python27\lib\dummy_threading.pyc)
W: __all__ is built strangely at line 0 - dis (c:\Python27\lib
\dis.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.firebird
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\firebird\__init__.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.databases (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\databases\__init__.pyc)
W: delayed __import__ hack detected at line 0 -
win32com.server.policy (c:\Python27\lib\site-packages\win32com\server
\policy.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.drizzle
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\drizzle\__init__.pyc)
W: __all__ is built strangely at line 0 - hashlib (c:\Python27\lib
\hashlib.pyc)
W: __all__ is built strangely at line 0 - __main__ (c:\Python27\lib
\site-packages\psycopg2\__init__.py)
W: __all__ is built strangely at line 0 - sqlalchemy.engine (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\engine\__init__.pyc)
W: delayed exec statement detected at line 0 -
win32com.client.dynamic (c:\Python27\lib\site-packages\win32com\client
\dynamic.pyc)
W: delayed conditional eval hack detected at line 0 - warnings (c:
\Python27\lib\warnings.pyc)
W: delayed conditional __import__ hack detected at line 0 - warnings
(c:\Python27\lib\warnings.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\psycopg2.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\psycopg2.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\psycopg2.pyc)
W: delayed __import__ hack detected at line 0 - email (c:\Python27\lib
\email\__init__.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.connectors.mysqldb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\mysqldb.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.connectors.mysqldb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\mysqldb.pyc)
W: delayed __import__ hack detected at line 0 - ctypes (c:
\Python27\lib\ctypes\__init__.pyc)
W: delayed __import__ hack detected at line 0 - ctypes (c:
\Python27\lib\ctypes\__init__.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.mysql (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\dialects\mysql\__init__.pyc)
W: __all__ is built strangely at line 0 - psycopg2 (c:\Python27\lib
\site-packages\psycopg2\__init__.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.sql (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\sql\__init__.pyc)
W: delayed __import__ hack detected at line 0 - pkgutil (c:
\Python27\lib\pkgutil.pyc)
W: delayed conditional __import__ hack detected at line 0 - pkgutil (c:
\Python27\lib\pkgutil.pyc)
W: delayed conditional exec statement detected at line 0 - iu (C:
\pyinstaller\iu.pyc)
W: delayed conditional exec statement detected at line 0 - iu (C:
\pyinstaller\iu.pyc)
W: delayed exec statement detected at line 0 - pdb (c:\Python27\lib
\pdb.pyc)
W: delayed conditional eval hack detected at line 0 - pdb (c:
\Python27\lib\pdb.pyc)
W: delayed eval hack detected at line 0 - pdb (c:\Python27\lib
\pdb.pyc)
W: delayed conditional eval hack detected at line 0 - pdb (c:
\Python27\lib\pdb.pyc)
W: delayed eval hack detected at line 0 - pdb (c:\Python27\lib
\pdb.pyc)
W: delayed eval hack detected at line 0 - sqlalchemy.util.langhelpers
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\util\langhelpers.pyc)
W: delayed exec statement detected at line 0 -
sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc)
W: __all__ is built strangely at line 0 - collections (c:\Python27\lib
\collections.pyc)
W: delayed exec statement detected at line 0 - collections (c:
\Python27\lib\collections.pyc)
W: delayed conditional __import__ hack detected at line 0 -
unittest.main (c:\Python27\lib\unittest\main.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.firebird.kinterbasdb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\firebird
\kinterbasdb.pyc)
W: delayed __import__ hack detected at line 0 - sqlalchemy.engine.url
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\engine\url.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\dialects\__init__.pyc)
W: delayed exec statement detected at line 0 - cgi (c:\Python27\lib
\cgi.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.mysql.oursql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mysql
\oursql.pyc)
W: delayed conditional __import__ hack detected at line 0 -
unittest.loader (c:\Python27\lib\unittest\loader.pyc)
W: delayed conditional __import__ hack detected at line 0 -
unittest.loader (c:\Python27\lib\unittest\loader.pyc)
W: delayed __import__ hack detected at line 0 - unittest.loader (c:
\Python27\lib\unittest\loader.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.types (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-
win32.egg\sqlalchemy\types.pyc)
W: delayed conditional __import__ hack detected at line 0 -
win32com.client.gencache (c:\Python27\lib\site-packages\win32com\client
\gencache.pyc)
W: delayed __import__ hack detected at line 0 -
win32com.client.gencache (c:\Python27\lib\site-packages\win32com\client
\gencache.pyc)
W: __all__ is built strangely at line 0 - __future__ (c:\Python27\lib
\__future__.pyc)
W: delayed __import__ hack detected at line 0 -
win32com.client.makepy (c:\Python27\lib\site-packages\win32com\client
\makepy.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.mssql.pymssql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mssql
\pymssql.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.connectors.pyodbc (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\pyodbc.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy (c:\Python27\lib
\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\__init__.pyc)
W: delayed __import__ hack detected at line 0 - xml.sax (c:
\Python27\lib\xml\sax\__init__.pyc)
W: __all__ is built strangely at line 0 - psycopg2.extensions (c:
\Python27\lib\site-packages\psycopg2\extensions.pyc)
W: delayed eval hack detected at line 0 - gettext (c:\Python27\lib
\gettext.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.sqlite
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\sqlite\__init__.pyc)

[Roger Alexander]

UPDATE:

Okay, I've managed to solve the problem with SQLAlchemy (pathing
problem), but now I am getting an error message when I invoke the
executable stating that "ImportError: No module named
psycopyg2._psycopg". I added this module to the list of hidden imports
in hook-psycopg2.py, but nothing changed.

What am I missing here??

[Hartmut Goebel]

Am 16.05.2011 21:03, schrieb Roger Alexander:
> Okay, I've managed to solve the problem with SQLAlchemy (pathing
> problem), but now I am getting an error message when I invoke the
> executable stating that "ImportError: No module named
> psycopyg2._psycopg". I added this module to the list of hidden imports
> in hook-psycopg2.py, but nothing changed.

psycopyg2._psycopg is no hidden import, but clearly stated in psycopg2/__init__.py. Thus adding to the hidden imports will not help.

The source of your problem must lay somewhere else.

--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP

Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consult.de

Monatliche Kolumne: http://www.cissp-gefluester.de/
Goebel Consult mit Mitglied bei http://www.7-it.de

[Roger Alexander]

>
> psycopyg2._psycopg is no hidden import, but clearly stated in psycopg2/__init__.py. Thus adding to the hidden imports will not help.
>
> The source of your problem must lay somewhere else.

Okay, so I've reinstalled pyinstaller 1.5 (after removing the prior
instllation and created the following barebones Python program that
compiles and runs just fine under the interpreter:

from sqlalchemy import *


engine = create_engine(
'postgresql://some+d...@10.102.31.99:5432/test_db15',
use_native_unicode=False )

engine.echo = False

print "Engine created"


Both SQLAlchemy and psycopg2 are installed in c:\Python2.7\Lib\site-
packages as shown (which is where their respective installers placed
them by default):

Directory of C:\Python27\Lib\site-packages

05/03/2011 02:34 PM <DIR> psycopg2
02/28/2011 03:01 AM 1,611 psycopg2-2.4-py2.7.egg-info

05/16/2011 10:15 AM <DIR> SQLAlchemy-0.7b4-py2.7-
win32.egg


I have packaged it into an executable using pyinstaller 1.5 using the
following commands

python --onefile Makespec.py c:\ddt\tools\psy-test.py
python Build.py psy-test\psy-test.spec

which produces an executable and a warnings file (below). When the
executable is invoked, the following is produced:

C:\pyinstaller-1.5\psy-test\dist>psy-test.exe

Traceback (most recent call last):

File "<string>", line 11, in <module>
File "psy-test\build\pyi.win32\psy-test\outPYZ1.pyz/
sqlalchemy.engine", line 263, in create_engine

File "psy-test\build\pyi.win32\psy-test\outPYZ1.pyz/
sqlalchemy.engine.strategies", line 64, in create
File "psy-test\build\pyi.win32\psy-test\outPYZ1.pyz/
sqlalchemy.dialects.postgresql.psycopg2", line
262, in dbapi
File "C:\pyinstaller-1.5\iu.py", line 455, in importHook
raise ImportError, "No module named %s" % fqname
ImportError: No module named psycopg2


So, what do I need to tell pyinstaller to get this to work? Any
assistance is greatly appreciated!

Thanks.

Roger Alexander.

W: no module named sqlalchemy.sql.type_coerce (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.mssql (top-level import by
sqlalchemy)
W: no module named pyodbc (delayed import by
sqlalchemy.dialects.access.base)
W: no module named sqlalchemy.engine.Engine (delayed import by
sqlalchemy.events)

W: no module named sqlalchemy.databases.sqlite (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.join (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.oracle (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.literal (top-level import by
sqlalchemy)

W: no module named sqlalchemy.engine.create_engine (top-level import
by sqlalchemy)
W: no module named sqlalchemy.sql.asc (top-level import by sqlalchemy)
W: no module named sqlalchemy.databases.drizzle (top-level import by
sqlalchemy)

W: no module named sqlalchemy.databases.maxdb (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.between (top-level import by
sqlalchemy)

W: no module named Sybase (delayed import by
sqlalchemy.dialects.sybase.pysybase)
W: no module named sqlalchemy.util.threading (top-level import by
sqlalchemy.util.queue)
W: no module named com (delayed import by
sqlalchemy.dialects.oracle.zxjdbc)
W: no module named sqlalchemy.sql.tuple_ (top-level import by
sqlalchemy)
W: no module named cx_Oracle (delayed import by
sqlalchemy.dialects.oracle.cx_oracle)

W: no module named sqlalchemy.create_engine (delayed, conditional
import by sqlalchemy.schema)
W: no module named sqlalchemy.sql.union_all (top-level import by
sqlalchemy)

W: no module named sqlalchemy.databases.access (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.sybase (top-level import by
sqlalchemy)

W: no module named sqlalchemy.databases.mysql (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.union (top-level import by
sqlalchemy)

W: no module named sqlalchemy.MetaData (top-level import by
sqlalchemy.dialects.mssql.information_schema)
W: no module named sqlalchemy.sql.bindparam (top-level import by
sqlalchemy.dialects.sybase.base)
W: no module named sqlalchemy.util.threading (top-level import by
sqlalchemy.pool)
W: no module named sqlalchemy.sql.desc (top-level import by
sqlalchemy)
W: no module named sqlalchemy.util.symbol (top-level import by
sqlalchemy.sql.operators)
W: no module named mysql (delayed, conditional import by
sqlalchemy.dialects.mysql.mysqlconnector)
W: no module named sqlalchemy.sql.modifier (top-level import by
sqlalchemy)
W: no module named sqlalchemy.Column (top-level import by
sqlalchemy.dialects.mssql.information_schema)
W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.zxJDBC)

W: no module named sqlalchemy.util.pickle (top-level import by
sqlalchemy.types)
W: no module named sqlalchemy.util.asbool (top-level import by
sqlalchemy.connectors.pyodbc)
W: no module named sqlalchemy.sql.and_ (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.or_ (top-level import by sqlalchemy)
W: no module named java (delayed import by
sqlalchemy.dialects.oracle.zxjdbc)
W: no module named mx (delayed import by sqlalchemy.connectors.mxodbc)

W: no module named sqlalchemy.sql.insert (top-level import by
sqlalchemy)
W: no module named sqlalchemy.util.chop_traceback (top-level import by
sqlalchemy.pool)
W: no module named sqlalchemy.databases.postgresql (top-level import
by sqlalchemy)
W: no module named sqlalchemy.sql.text (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.text (top-level import by
sqlalchemy.dialects.sybase.base)

W: no module named sqlalchemy.sql.except_ (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.not_ (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.subquery (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.select (top-level import by
sqlalchemy.dialects.mssql.base)
W: no module named sqlalchemy.sql.distinct (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.func (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.extract (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.exists (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.text (top-level import by
sqlalchemy.dialects.informix.base)
W: no module named sqlalchemy.sql.outerjoin (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.bindparam (top-level import by
sqlalchemy)
W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.mysqldb)

W: no module named sqlalchemy.util.memoized_property (top-level import
by sqlalchemy.pool)
W: no module named sqlalchemy.databases.informix (top-level import by
sqlalchemy)

W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.mxodbc)
W: no module named sqlalchemy.sql.except_all (top-level import by
sqlalchemy)
W: no module named sqlalchemy.connectors.Connector (top-level import
by sqlalchemy.connectors.pyodbc)
W: no module named sqlalchemy.sql.alias (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.literal_column (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.cast (top-level import by
sqlalchemy)

W: no module named mysql (delayed import by
sqlalchemy.dialects.mysql.mysqlconnector)

W: no module named sqlalchemy.sql.over (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.intersect (top-level import by
sqlalchemy)
W: no module named pysqlite2 (delayed import by
sqlalchemy.dialects.sqlite.pysqlite)
W: no module named sqlalchemy.sql.select (top-level import by
sqlalchemy)

W: no module named sqlalchemy.sql.delete (top-level import by
sqlalchemy)
W: no module named sqlalchemy.databases.firebird (top-level import by
sqlalchemy)
W: no module named postgresql (delayed import by
sqlalchemy.dialects.postgresql.pypostgresql)

W: no module named sqlalchemy.sql.case (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.update (top-level import by
sqlalchemy)
W: no module named com (delayed import by
sqlalchemy.connectors.zxJDBC)
W: no module named sqlalchemy.engine.engine_from_config (top-level
import by sqlalchemy)
W: no module named mx (delayed, conditional import by
sqlalchemy.connectors.mxodbc)

W: no module named sqlalchemy.sql.null (top-level import by
sqlalchemy)
W: no module named sqlalchemy.Table (top-level import by
sqlalchemy.dialects.mssql.information_schema)
W: no module named sqlalchemy.sql.collate (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.intersect_all (top-level import by
sqlalchemy)
W: no module named sqlalchemy.sql.outparam (top-level import by
sqlalchemy)

W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.pg8000 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\pg8000.pyc)

W: __all__ is built strangely at line 0 - sqlalchemy.dialects.oracle
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\oracle\__init__.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.informix.informixdb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\informix
\informixdb.pyc)

W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.mysql.pymysql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mysql
\pymysql.pyc)

W: top-level exec statement detected at line 0 - sqlalchemy.sql.util
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\sql\util.pyc)
W: top-level exec statement detected at line 0 - sqlalchemy.sql.util
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\sql\util.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.sybase
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\sybase\__init__.pyc)

W: __all__ is built strangely at line 0 -
sqlalchemy.dialects.postgresql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\__init__.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects.mssql (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\dialects\mssql\__init__.pyc)

W: __all__ is built strangely at line 0 - sqlalchemy.dialects.firebird
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\firebird\__init__.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.databases (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\databases\__init__.pyc)

W: __all__ is built strangely at line 0 - sqlalchemy.dialects.drizzle
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\dialects\drizzle\__init__.pyc)

W: __all__ is built strangely at line 0 - sqlalchemy.engine (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\engine\__init__.pyc)

W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\psycopg2.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\psycopg2.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql
\psycopg2.pyc)
W: delayed __import__ hack detected at line 0 -

sqlalchemy.connectors.mysqldb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\mysqldb.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.connectors.mysqldb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\mysqldb.pyc)

W: __all__ is built strangely at line 0 - sqlalchemy.dialects.mysql (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\dialects\mysql\__init__.pyc)

W: __all__ is built strangely at line 0 - sqlalchemy.sql (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\sql\__init__.pyc)

W: delayed eval hack detected at line 0 - sqlalchemy.util.langhelpers
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\util\langhelpers.pyc)
W: delayed exec statement detected at line 0 -
sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc)
W: delayed conditional __import__ hack detected at line 0 -
sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc)

W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.firebird.kinterbasdb (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\firebird
\kinterbasdb.pyc)
W: delayed __import__ hack detected at line 0 - sqlalchemy.engine.url
(c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg
\sqlalchemy\engine\url.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy.dialects (c:
\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\dialects\__init__.pyc)

W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.mysql.oursql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mysql
\oursql.pyc)
W: delayed conditional __import__ hack detected at line 0 -

sqlalchemy.types (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-
win32.egg\sqlalchemy\types.pyc)

W: delayed __import__ hack detected at line 0 -
sqlalchemy.dialects.mssql.pymssql (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mssql
\pymssql.pyc)
W: delayed __import__ hack detected at line 0 -
sqlalchemy.connectors.pyodbc (c:\Python27\lib\site-packages
\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\pyodbc.pyc)
W: __all__ is built strangely at line 0 - sqlalchemy (c:\Python27\lib
\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy
\__init__.pyc)

[Hartmut Goebel]

Am 17.05.2011 19:06, schrieb Roger Alexander:
> So, what do I need to tell pyinstaller to get this to work? Any
> assistance is greatly appreciated!

Do be honest: I do not know ;-)

Can you please check if psycopg2 is included in the .exe (using
ArchiveViewer.py). I assume it is not.
No please check if it is contained in the .exe if you are using this
test program:

from sqlalchemy import *
import psycopg2