Hi Tim, it depends on your level of expertise in both Oracle and Python.
On Nov 12, 9:55 am, Tim Korb <jtk...@gmail.com> wrote: > We are considering using Web2Py as one of the front ends for a departmental > database project based on Oracle. Since the Oracle database is > independently managed, we need to turn off migration and use (I assume) the > "legacy table" feature mentioned in Chapter 6 of the book--which is not > currently supported for Oracle. How easy is that to add? Look in gluon/dal.py for class OracleAdapter(BaseAdapter). You have to add two new entries to the "types" dictionary there, one with key 'reference FK' for field level foreign key and another key 'reference TFK' for table. Use the ones in class MSSQLAdapter(BaseAdapter) as a guide. Report back on any problems and will help you along. > I think we will also want to write an "extract_oracle_models.py" script > along the lines of the extract scripts in the Web2Py scripts directory. > Has anyone else done/attempted this? Not that I know of. Denes
