[web2py] Re: Creating an app with an already existing database

2011-02-25 Thread mart
thanks for the info! :) The interesting thing is... using DAL and SQLite from script (no web) works really great, and I don't know if I changed anything along the way (at least that I remember), but it seems that once the scripts are done I can not keep using the DB (which is fine because every cyc

Re: [web2py] Re: Creating an app with an already existing database

2011-02-25 Thread Vasile Ermicioi
I changed mysql script for generating models to generate models from a sqlite database an example: from command line extract_sqlite_models.py storage.sqlite models.py first parameter is database path, second is output file for models extract_sqlite_models.py Description: Binary data

Re: [web2py] Re: Creating an app with an already existing database

2011-02-25 Thread Marin Pranjic
I guess the post he quoted? On Fri, Feb 25, 2011 at 1:25 AM, mart wrote: > what solved the matter ? > > On Feb 24, 6:52 pm, Eduardo wrote: > > Thank you all. That solves the matter. > > > > Eduardo > > > > On Feb 24, 8:31 pm, Vasile Ermicioi wrote: > > > > > > Please note I would like to use s

[web2py] Re: Creating an app with an already existing database

2011-02-25 Thread mart
yeah... I'm just not seeing it :) I think I had expectations (like, the "miracle solution is:__"... then: "Thank you all. That solves the matter. ") LOL - On Feb 25, 3:14 am, Marin Pranjic wrote: > I guess the post he quoted? > > On Fri, Feb 25, 2011 at 1:25 AM, mart wrote: > > what solved

[web2py] Re: Creating an app with an already existing database

2011-02-24 Thread mart
what solved the matter ? On Feb 24, 6:52 pm, Eduardo wrote: > Thank you all. That solves the matter. > > Eduardo > > On Feb 24, 8:31 pm, Vasile Ermicioi wrote: > > > > Please note I would like to use sqlite, not mysql. > > > if you have many tables use mysql just to generate you models, then you

[web2py] Re: Creating an app with an already existing database

2011-02-24 Thread Eduardo
Thank you all. That solves the matter. Eduardo On Feb 24, 8:31 pm, Vasile Ermicioi wrote: > > Please note I would like to use sqlite, not mysql. > > if you have many tables use mysql just to generate you models, then you can > use generated models with your sqlite database

[web2py] Re: Creating an app with an already existing database

2011-02-24 Thread mart
I would really love to see how you do it and any results you have (if you don't mind?)... because nothing seems to be working for me with regard to this :( (note: I am doing this with dal.py as script, outside of the web2py web environment - everything else is working great , except the most import

Re: [web2py] Re: Creating an app with an already existing database

2011-02-24 Thread Vasile Ermicioi
> > Please note I would like to use sqlite, not mysql. if you have many tables use mysql just to generate you models, then you can use generated models with your sqlite database

[web2py] Re: Creating an app with an already existing database

2011-02-24 Thread Anthony
On Thursday, February 24, 2011 5:18:05 PM UTC-5, Eduardo wrote: > > Alright, clarifying the question: I understand I can edit db.py and > add the sqlite file form there; my question is: will an already > populated db be affected (reset) when I define the table with > db.define_table()? See t

Re: [web2py] Re: Creating an app with an already existing database

2011-02-24 Thread Vasile Ermicioi
> > will an already > populated db be affected (reset) when I define the table with > db.define_table()? set migrate=False and db structure will stay the same

[web2py] Re: Creating an app with an already existing database

2011-02-24 Thread Eduardo
Please note I would like to use sqlite, not mysql. Eduardo On Feb 24, 7:18 pm, Eduardo wrote: > Alright, clarifying the question: I understand I can edit db.py and > add the sqlite file form there; my question is: will an already > populated db be affected (reset) when I define the table with >

[web2py] Re: Creating an app with an already existing database

2011-02-24 Thread Eduardo
Alright, clarifying the question: I understand I can edit db.py and add the sqlite file form there; my question is: will an already populated db be affected (reset) when I define the table with db.define_table()? Eduardo On Feb 24, 6:51 pm, Eduardo wrote: > Hello, > > How can I create an app usi