packaging sqlalchemy 0.7.2 (mysql) does not include MySQLdb

[sebastianelsner@…]

I have been trying to package a sqlalchemy 0.7.2 program, which accesses a MySQL data source, with the latest PyInstaller? trunk (rev. 1571). PyInstaller? fails to include MySQLdb. Works fine with sqlalchemy 0.6.8. Workaround is to include MySQLdb explicitly.

[matysek]

This is because pyinstaller hook for sqlalchemy includes modules

sqlalchemy.databases.*

However, for 0.7 it should include also modules

sqlalchemy.dialects.*

because there was a module name change in sqlalchemy.

[matysek]

I tried to fix it in r1572. Let us know if it works for you.

I also noticed that there are some statements like

__import__('MySQLdb')

and I'm not sure if pyinstaller would handle that automatically.

[anonymous]

The fix did not work for me. I will try and investigate further next weekend.

[matysek]

In that case we need to somehow directly find out what DB python modules (like MySQLdb, psycopg2) sqlalchemy uses and try to bundle them with packaged app.

[matysek]

sqlalchemy 0.6+ allows to use multiple drivers to connect to one DB systems. Every driver has its own module (like sqlalchemy.dialects.mysql.mysqldb or 'sqlalchemy.dialects.mysql.pyodbc).

We would have to get the driver module names for all databases with code similar to:

driver_name = sqlalchemy.dialects.mysql.mysqldb.dialects.dbapi.__name__

and add driver_name to the importhooks for sqlalchemy.

[matysek]

• ​sqlalchemy 0.6 changes
• ​sqlalchemy 0.7 changes

[arakimaru@…]

see http://www.pyinstaller.org/ticket/408

[matysek]

Fixed in r1581.