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 <dbname> 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 and postgres can't handle. i never fully understood what postgres means by database and schema, so i hope i'm not leading you down the wrong path.
I don't use the numeric type, so i can't offer much help there, sorry. cfh On May 17, 1:41 pm, Jean Guy <jean...@gmail.com> wrote: > 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 in web2py actually... > So I looking around to find the better way to work around (ex.: validator > and string type)... > > Johny > > 2010/5/14 howesc <how...@umich.edu> > > > Johny, > > > Perhaps i mis-understand....but 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 can connect to the database and read and write > > data. or am i missing something? > > > christian > > > On May 14, 10:21 am, Jean6uy <jean...@gmail.com> wrote: > > > Hi, > > > > I googled a lot on this topic before send this email. > > > > I am kind of postgresql newbie and of course also with web2py. > > > > I have already designed a database with PGAdminIII that respond to my > > > need that has already around 50 tables with many foreign key > > > relationship. I use schemas to group my tables... > > > > I need to manage all the constaints at the database level for > > > conformity questions and audit of database by authority agencies... I > > > will keep track of any modifications done in the database with > > > triggers to allow to keep the history of modifications in the > > > database. So I will have a second set of 50 tables... > > > > Now I need a GUI to let lambda user populate the database, so I am > > > looking at all python framework (Django, web2py, ...) to find the one > > > that will handle the job with ease and flexibility... > > > > Web2py seems a good choice for the task... But like Django, it create > > > table in public schema when used with postgresql (public.TABLE)... > > > > This post pointed out many of the requirements of data centric > > > application needs that are not yet fully implemented in web python > > > frameworks in general : > > > >http://it.toolbox.com/blogs/database-soup/stuff-id-love-to-see-from-d... > > > > I find here (http://nxsy.org/using-postgresql-schemas-with-sqlalchemy- > > > and-elixir) that it could be possible to use PostgreSQL Schema with > > > Elixir and SQL Alchemy. What I understand is that the DAL is the > > > equivalent of SQL Alchemy... I try this : > >http://www.web2py.com/AlterEgo/default/show/189. > > > But it seems to me that it's only a way to let use the synthaxe of SQL > > > Alchemy in web2py models since SQL Alchemy is not installed. > > > > Is the explanation here can let me use SQL Alchemy instead of the > > > DAL :http://www.web2py.com/AlterEgo/default/show/150??? > > > > Can I use Elixir to allow web2py understand the postgresql schema? > > > > Is it planed to implement the management of postgresql schema in the > > > DAL as seems to suggest the answer of reingart in this post : > >http://it.toolbox.com/blogs/database-soup/stuff-id-love-to-see-from-d... > > > > Please forgive me my dreadful english (thank to google translate) > > > > Thanks > > > > Johny