Create the web2py code needed to access your mysql legacy db.

To make this work all the legacy tables you want to access need to
have an "id" field.

This plugin needs:
mysql
mysqldump
installed and globally available.

Under Windows you will probably need to add the mysql executable
directory to the PATH variable,
you will also need to modify mysql to mysql.exe and mysqldump to
mysqldump.exe.
Just guessing here :)

Access your tables with:
legacy_db(legacy_db.mytable.id>0).select()

If the script crashes this is might be due to that fact that the
data_type_map dictionary is incomplete.
Please complete it, improve it and continue.

download 
http://jaguar.biologie.hu-berlin.de/~fkrause/web2py.plugin.legacymysql.w2p
screenshot 
http://jaguar.biologie.hu-berlin.de/~fkrause/screenshot_legacymysql.png

Reply via email to