Re: Query Builder internals

"Jukka Zitting" <[email protected]> wrote:

> Hi,

Hi,
 
> > Document what exactly?
> > The idea of multilang content being served absolutely transparent way?
> > That is clear for everybody I think.
> 
> I wouldn't be so sure about that being so clear. What I'm interested
> here are answers to at least the following questions:

Yes , but you ask implementation which should be changed for this idea.

> 1) Are all MultiLang tables named "<tablename>_i"?
Yes.

> 2) Do all MultiLang tables use the "sid" column to refer to the main object id?
Yes.

> 3) Do all MultiLang tables use the "lang" column to refer to the language?
Yes.

> 4) Are duplicate (sid, lang) values allowed in MultiLang tables?
No. If exist , it means bug.

> 5) Does a MultiLang object always have a lang 0 record?
Always. ( Like Chuck Norris. :)

> 6) Do all MultiLang tables use the "sitegroup" column?
Yes. But it's not mandatory IMO.

> 7) Should the "sitegroup" value always be the same as the sitegroup of
> the main object?
I think that ML "content" doesn't have to be SG aware.

> 8) Can different language versions of an object have different parameters?
If you think about higher level API then there are parameters. The same like objects.
If you change lang they can be different. Parameters are multilanged so it's hard
to say about different parameters for different versions.

> 10) How the possible MultiLang parameters are accessed?
As non multilang. 

> 11) Can different language versions of an object have different attachments?
The same as parameters.

> 12) How the possible MultiLang attachments are accessed?
As non multilang.

It also depends if you ask about getting parameters or attachments for all langs.

> 13) Do the MultiLang _i records have their own metadata fields?
No, because this is "part"  of an object. Not object itself.

> 14) How the possible MultiLang metadata fields are accessed?
> 15) Can MultiLang properties be links to other records?
Yes.
 
> I could of course make educated guesses about the
> correct answers for those questions,

I did.
And I am more happy when there's more discussion on dev then expectation.

Piotras