I'm designing a content management system for personal use, and I'm going
to use cherrypy and SQLObject.
I want to represent the structure of the website in a tree form, with one table
that has generic information about a 'webobject', and for each type of
'webobject' another table that has object-specific data.
To get an idea here is a database layout as illustration:
owner(many-to-many to table users)
category (many-to-many to table articlecategories)
It would be very convenient to have SQLObject return an object which has all
the data of the 'webobject' in it. However I don't know if this is possible
(even in plain sql, that is), this would involve placing a subquery in the
Maybe even my way of thinking is plain wrong.
Can someone please enlighten me?
Thanks in advance!
Op Sun, 11 Jun 2006 16:18:35 +0200, schreef thouters:
I'm sorry, I didn't mean to ask a stupid question.
For some reason I spent last evenings staring myself blind on
the main sqlobject documentation,
and looked over the Inheritance wiki entry.
As soon as I sent previous message, I read the inheritance article
that was just one browser window down the list.