Since August we had many improvements in sql.py that were not reflected into dal.py. web2py is still using sql.py and it will be a little while before we move to dal.py
On Oct 2, 9:05 pm, DenesL <[email protected]> wrote: > Hi Ivan, > > mysql is not one of the supported DBs for keyed tables: > only DB2, MSSQL, Ingres, and Informix have been added as > perhttp://groups.google.com/group/web2py/browse_thread/thread/db150376b0... > > Adding support for mysql should be fairly easy but the required steps > under point (E) in the post above have changed. > In step 1 open dal.py instead of sql.py and look for the MySQLAdapter > class instead of SQL_DIALECTS. > Add appropriate entries for keys 'reference TK' and 'reference TFK' > following the entries in one of the adapters that already have support > for keyed tables, e.g. MSSQLAdapter. > Step 2 seems to be unnecessary with dal.py, but maybe Massimo can > clarify. > Step 3 is still very important ;) > > Denes.
