Re: [web2py] Re: Using non-web2py created database

2012-11-08 Thread Michele Comitini
Latest trunk has a little script to help you create a model file from a legacy sqlite3 database. You will have to fine tune some table definition, but it should help. Then you should be able to access your db through the DAL. Note that triggers side effects, if there are any, must be taken into a

[web2py] Re: Using non-web2py created database

2012-11-08 Thread Maurice Ling
OK - I found a solution or hack. 1. put my sqlite database into applications//database folder 2. add this into applications//model/db.py nat = DAL('sqlite://nat_full.db', migrate=False) 3. use "result = nat.executesql(stmt)" whenever I want to run my queries Anyone can comment if this is an app