[storm] Dynamically changing OR mapping question with aliases

[akira]

Hi Stuart, I read about that when I looked up schemas, but I discarded 
it because I did not know how to set that using Storm. Could you post a 
code snippet?

Thanks

Stuart Bishop wrote:
> akira wrote:
>   
>> Ok, I´ll explain again :-) I have to develop a multilingual site, all 
>> the content and link are coming from tables that I have separated by 
>> language into schemas
>> example:
>>
>> en.content # table for English content
>> de.content # table for German content
>>
>> so depending on what the user chooses, the right database would be 
>> chosen and consecutively the right data would be displayed, I just do:
>>
>> Link.__storm_table__ = session.userlang
>>
>> Then I can make queries on the database
>>
>> was that clear?
>>     
>
>   
>>>> Is this the proper way to do this?
>>>>         
>
> It may be much simpler for you to change the search path at the start of the
> transaction by issuing the following statement manually:
>    SET search_path = de,public
>
> You can then just refer to 'Content', and know that on that particular
> connection you will be accessing the German content.
>
>