Hi Stifan, > pardon me, which script that you execute? because in the scripts folder > there is 4 scripts for extract the table into models (mysql, oracle, pgsql > and sqlite). and which web2py version did you use and what is your os > environment? please use the script that match with your database backend. > I used extract_sqlite_models.py - which is why I reported the bug about the text saying MySQL. On Windows using Python 2.7 and the database is sqlite.
and for legacy db please take a look at the book in dal chapter > > ref: > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Legacy-databases-and-keyed-tables > Thanks, I've just had a read through the legacy section (it's short), but it's not helped much. As best I can tell from reading that, basically web2py will only be able to use the id column; so I won't be able to query by other columns (which is what I need)? Also, I don't have an auto-incrementing id column in my tables or any primary key in most of them (nor do I particularly want one). I'm still no closer to understanding this I'm afraid. Does this mean there's no good way to use non-web2py tables in web2py? Thanks, Jonathan -- 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.
