I'd suggest at least reading the DAL chapter of the book. My advice is that if your project needs to query hundreds of legacy tables, DAL won't help you. On the other end, if you have 20-30 tables is pretty easy to "learn" the syntax and define tables with migrate=False that will avoid creating those tables (because they exist already in your backend) and use those definitions in DAL. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer
On Tuesday, December 24, 2013 2:07:44 PM UTC+1, Giuseppe D'Amico wrote: > > Hi I am a newbie to web2py, I would like to know if there is a way to > build the model of a database at run-time, for my application I have to > connect to a legacy database and making queries on it, thus I thought > that I need to build the model at run-time, I cane connect to the db with > dal and query it about its table, can create the tables, but I do not know > how to add the field to them, somewhere on internet I found append_field, > but when used my script return this error: KeyError: 'append_field' > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.