On Mon, May 11, 2009 at 12:33 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> More than this I would prefer to have
>
> db.define_table('mytable',
>> SQLField(...),
>> ...
>> actual_filename='myapp_mytable',
>> field_prefix=None',
>> )
>
> The problems are:
> - This requires many small changes to sql.py and, if done, needs to
> lots of testing.
> - This requires introducing one more lookup table to map real name
> into virtual names and it will slow down the building of sql
> expressions
> - So far we tried to be as close as possible to the actual DB. This
> would be a (minor) change of phylosophy.
> - If done, this has to be done for gql as well.
>
> I think this should be done by only as part of a major more modular
> refactoring of sql.py. If we hack this in sql.py will become too
> complex to manage.
I think it is not so complex. What if we modify SQL to "SELECT ...
FROM tabel AS my_new_name"? The problem is that I don't know GQL... is
there a "AS" like in SQL?
> On May 11, 9:20 am, Álvaro Justen [Turicas] <alvarojus...@gmail.com>
> wrote:
>> Hi,
>> sometimes we use prefixes to identify tables, like:
>> myapp_mytable
>> I use it because I have only one DB per site - and one site can have
>> multiple apps.
>> But is very painful to do db.myapp_mytable.somefield.
>> So, I request a new feature:
>> db.define_table('myapp_mytable',
>> shortcut='mytable',
>> SQLField(...),
>> ...
>> )
>>
>> So I can use both db.mytable and db.myapp_mytable.
>> Ok, I can do:
>> db.mytable = db.myapp_mytable
>> But it don't work in SQLRows when I search more than one table.
>>
>> Massimo, what do you think?
--
Álvaro Justen
Peta5 - Telecomunicações e Software Livre
21 3021-6001 / 9898-0141
http://www.peta5.com.br/
--~--~---------~--~----~------------~-------~--~----~
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
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
