[TYPO3-core] RFC #16376: Feature: New TYPO3_DB method for select queries that fetch data from up to 3 tables based on RDF like triples

[JoH asenau]

After discussing things with Jigal we came up with another approach for a universal selector of 3 way relations.

It adds optional aliases for each of the tables, that will use defaults in case there is no alias set and the same table name is used twice or more.
It uses JOIN instead of a comma.
It fixes bugs that have still been in version 2.

After all this is NOT just about triples, RDF or SCOTTY related stuff.
This method will enable you to select any kind of 3 way relation, be it an SPO or just MMM.

To give some MMM examples:

person + car + company
person + car + home
car + company + location
person + company + location
car + city + parking lot

Since the MMM table might use the usual TYPO3 fields (like uid, pid, enable fields) as well, this will enable developers/editors to create relations as records of this MMM table without having to add any field or TCA setting to any of the related tables.

So this is nothing that has to be implemented as a new TCA type, since there simply is no TCA type necessary at all.
Of course people can create an additional field in any of the related tables as well and have it point to the MMM table, but this can already be done with the existing methods, since the MMM records can have the necssary UID, when necessary.

I hope this clarified the intention a bit.

Attached is version 3 or better version 1 of the mmm_query.

Cheers

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your gob sometimes!)
Dieter Nuhr, German comedian
Xing: http://contact.cybercraft.de
Twitter: http://twitter.com/bunnyfield
TYPO3 cookbook (2nd edition): http://www.typo3experts.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: exec_SELECT_mmm_query.diff
Type: application/octet-stream
Size: 4850 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20101114/cd3e1625/attachment.obj>