Massimo,
Congratulations on an extremely impressive product!
I would like to dig a little deeper into the question of attaching to
existing databases. I have a fairly large Oracle database with many
tables. I would like to 'attach' the web2py framework to this
database (I would probably need to define as many as 50 tables, some
with hundreds of fields). A brief review of the syntax would indicate
that it could be possible to utilize (consume) the DDL for a table,
and generate the python code definition for the table. Once this
utility was available for one database, others should be fairly simple
to adapt. I am particularly interested in consuming Oracle tables.
Much of the information is likely within your epydocs link and
possibly the book, but is there a design document for a database table
class?
I'd be interested in your thoughts as to problems and potential.
Thank you very much,
Stan
On Oct 15, 11:58 am, mdipierro <[EMAIL PROTECTED]> wrote:
> web2py ONLY talks to the tabase engine in SQL and SQL does not prove a
> means to query for table structure.
>
> If you want to access an existing table you can, if and only if the
> table has an ID field. You need to (re)define the table with
> migrate=False. You do not need to define the entire database. You only
> need define those tables that you need and those fields of the tables
> that you plan to access (excluding ID).
>
> Massimo
>
> On Oct 15, 10:49 am, JorgeRpo <[EMAIL PROTECTED]> wrote:
>
>
>
> > What if I want to use web2py to modify data from some other running
> > app (php Drupal, for instance). Do I need to define all the model? or
> > is there some kind of tool to figure it out..
>
> > On Oct 15, 10:20 am, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > > In every case you need to choose a master application.
> > > If you use SQLite, the master app will do
>
> > > db=SQLDB('sqlite://stoarge.db')
> > > db.define_table(.....)
>
> > > the other apps will do
>
> > > db=SQLDB('sqlite://../../masterapp/databases/stoarge.db')
> > > db.define_table(.....,migrate=False) #### important!
>
> > > If you use anything other than SQlite, db=SQLDB(....) should all use
> > > the same connection string to the same database engine.
>
> > > The master needs to define all tables, the other apps need to define
> > > only the tables the use.
>
> > > Different browser render pages differently. Most of the
> > > inconsistencies are dues to the use of JS, invalid CSS or invalid
> > > HTML. You can test for valid HTML and CSS using w3c validation pages
> > > online.
>
> > > Massimo
>
> > > On Oct 15, 9:26 am, tommy <[EMAIL PROTECTED]> wrote:
>
> > > > How does web2py application to access the database in other
> > > > application? We have three applicaitons, two web applications
> > > > developed by web2py, and another application developed by python.
> > > > Three applications try to access one database. I don't know how to
> > > > setup the database in which application. Can someone help me?
>
> > > > By the way, here is my another issue. My web pages look good when I
> > > > use firefox, but when I use IE to browse the pages, the pages looks
> > > > mess. Any idea?- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
