[web2py] Re: Postgresql Schema in Web2py

2010-05-17 Thread howesc
i *think* that it will work with you existing schema. I have postgres setup with 2 databases ( i think that is the right term - i pass the - d option to the psql command), and web2py works fine with them. I do all my database migrations manually as well since there are certain upgrades web2py a

Re: [web2py] Re: Postgresql Schema in Web2py

2010-05-17 Thread Jean Guy
That way, the DAL or web2py (I don't know the exact wording to use) will be able to put data in my table that allready exist in the postgresql schema where they are? An other problem that I am facing is that I use numeric(length, nb decimal) type of postgresql that type not seems to be supported i

[web2py] Re: Postgresql Schema in Web2py

2010-05-14 Thread howesc
Johny, Perhaps i mis-understandbut you have all your tables already created in postgres right? if so, then you can just define your model in web2py using the DAL, but set migrate=false for each table. Then you define the tables yourself (and have complete control over that part), but the DAL

[web2py] Re: Postgresql Schema in Web2py

2010-05-14 Thread Mengu
you can install sqlalchemy and use it with web2py. and i recommend using declarative bases: http://www.sqlalchemy.org/docs/ormtutorial.html#creating-table-class-and-mapper-all-at-once-declaratively but remember, if you use sqlalchemy you won't be able to use the built- in auth and crud systems.