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 >
