hello web2py users, I am looking for specifics when it comes to creating additional tables within a sub-directory of MODELS !
I am making significant progress on my app ! and I know that I will certainly have an overhead issue because in my db.py file I have about 20 tables defined and some tables have more than 20 fields in them ! My approach was to build the app.. simply with no consideration for performance .. but as I am moving along ... considering how far I have gone ... it is time that I do go back and move a few things around. I really need to avoid the load of all these tables from the start and few variables that are only pertinent to specific tables in there ! .. so I'm thinking to only keep the auth_user table in my db.py file with certain important global variables ( it is safe to assume that it is the only table that will need to be loaded throughout ) The other tables, I want to move them to sub directories below the MODELS with their corresponding controller names in the CONTROLLERS and corresponding VIEWS ! As soon as I have started ... I get the error : <class '_mysql_exceptions.OperationalError'> (1005, "Can't create table .......bla bla bla .. My Question or concern is this : when using sub directories in MODELS, Do I need to redo these instructions ? from (....) import ( ..*..) Aren't they loaded already from db.py ? ... what do I need to declare before defining the tables I want in the MODELS/directoryname/file.py for example ? what does the file.py in MODELS sub directory look like, I have looked at various examples, even in the book, and even throughout the threads here and could not find any suitable example please enlighten me ... please advise thank you --
