On Sat, Feb 28, 2009 at 2:22 PM, mdipierro <[email protected]> wrote:

>
> I would probably do that but this an aesthetic issue
>
> On Feb 28, 9:27 am, carlo <[email protected]> wrote:
> > My input data are on db2/400 and my output goes into MySql. What is
> > recommended to get two db connections/models in parallel? Two dbs in
> > one db.py model or two distinct model files? I think the latter..
>

You can - remember that model files are read in alphabetic order in case you
have any backward references / foreign keys.


>
> >
> > Another question: as my source db2/400 tables are huge, even 50
> > fields, can I have in my web2py model for any table just the fields I
> > will use or my tables have to be exactly the same as the original?
> > thank you
>

Your model should only need the fields you will access.

REMEMBER:  web2py _assumes_ (and creates a default field) called "id";  if
you have existing tables, and they have different auto-number field names,
you will want to keep this in mind (eg. perhaps create a view which maps
your table's index field into "id" for web2py).


> >
> > carlo
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to