this is only half of a question. what is the completed interface
youd like to see on the Content class, whereby i want the title in a
certain language?
the solution, since it seems youre looking for something eager, would
involve just making a relation to load in all the titles represented
in the lang_str table for the "title" attribute, which would be named
something "hidden" like "_title", then implementing some interface on
Content that pulls from that already-loaded (or lazily-loaded) pool
of title fields.
to make it more efficient to pull the title of a certain language
from this relation, you can subsitutite your own dictionary-like
object which has an "append" method for the "_title" attribute that
hashes based on the incoming language, as the mapper adds data to it.
On Mar 22, 2006, at 8:24 AM, Florian Boesch wrote:
A simple problem. Multi-language support.
Say I have content which can have a title in different languages.
So I have a
content = Table('content', engine,
Column('id', Integer, Sequence('content_seq'), primary_key=True))
so I also have a
lang = Table('lang', engine,
Column('id', Integer, Sequence('lang_seq'), primary_key=True),
Column('name', String(255))
this contains things like VALUES('de') etc.
lang_str = Table('lang_str', engine,
Column('lang_id', Integer, ForeignKey('lang.id')),
Column('content_id', Integer, ForeignKey('content.id')),
Column('value', String(2048)))
The problem is with the mapper and the relation to the title.
class Content(object): pass
contents = mapper(Content, content)
contents.add_property('title', ...?
etc. now the two questions.
a) How do I make a relation that gives me the lang_str.value as
it's value so
I do not have to write somecontent.title.value
b) How do I make the relation "customizable", i.e. I do not have to
do many
relations for each language I want support for (no
mycontent.title_de.value,
mycontent.title_en.value etc.?
I do know how to customize for a fixed value via the secondaryjoin
of relation,
but I'm uncliear how I can parametrize this. (for that matter, I
could of
course write a member to my class who does this, but then I loose
eager-loading
for titles...)
Cheers,
Florian
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the
live webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?
cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
