The new DAL will allow this. I am working on it but it is a complex thing and I do not know for sure when it will be done. I hope in one month. I cannot take a patch to do this in the current DAL because it would break a lot of stuff. Sorry.
There must be a way to define an alias (or a view) in Oracle. That may be an easier solution. On Dec 22, 10:17 am, Alexey Nezhdanov <[email protected]> wrote: > Sorry for double posting. While this would be an ideal - it is clearly not > supported atm. But may be I can somehow emulate it by, say, initialising > table with the usual way and then doing something like > db.inet.var1.var2='rad....@inet' ? > If there is any coding needed - that's ok too, I can submit a patch (just > like before). > > On Tue, Dec 22, 2009 at 7:15 PM, Alexey Nezhdanov <[email protected]> wrote: > > I do not know actually as I am not the Oracle expert (or even regular > > user). Will find out tomorrow. > > Suppose - I can't - can you give any clue how to make an alias in web2py? > > The ideal would be something like this: > > > db.define_table('inet', internal_name='rad....@inet', > > > Field('ip','string',length=16), > > migrate=False > > ) > > > On Tue, Dec 22, 2009 at 5:47 PM, mdipierro <[email protected]>wrote: > > >> No. "." and "@" are not allowed in table names. Can you alias in > >> Orcale? > > >> On Dec 22, 12:15 am, Alexey Nezhdanov <[email protected]> wrote: > >> > Hello. > >> > I've googled this group for my problem, but didn't find the answer. > >> > It seems that problem was mentioned once [1] [2], but I do not know if > >> any > >> > solution was done. > > >> > I need to connect to existing database so things like 'schemas are not > >> > portable' are not really acceptable - I should be able to connect, > >> period. > >> > What is worse - there are actually two servers - DB2 and Oracle. I do > >> not > >> > have direct access to DB2 database and have to connect through Oracle. > >> > So the sql query looks like this: > > >> > SELECT ip FROM rad....@inet > > >> > so here is scheme RAD, table NAS at the 'INET' DB2 database. > > >> > web2py refuses me to do this: > > >> > db.define_table('rad....@inet', > >> > Field('ip','string',length=16), > >> > migrate=False > >> > ) > > >> > So what should I do? Is there any way out? > >> > Thanks > > >> > [1] > >>http://groups.google.com/group/web2py/search?group=web2py&q=oracle+ta... > >> > [2] > >>http://groups.google.com/group/web2py/browse_thread/thread/3c27af0533... > > >> > -- > >> > Regards > >> > Alexey Nezhdanov > > >> -- > >> Regards > > > Alexey > > -- You received this message because you are subscribed to the Google Groups "web2py-users" 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.
