Hello,
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:
table content:
id,
name,
parentid(ForeignKey('content')),
permissions,
owner(many-to-many to table users)
table article:
id,
title,
summary,
category (many-to-many to table articlecategories)
table fileondisk:
id,
path,
mimetype
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
table identifier.
Maybe even my way of thinking is plain wrong.
Can someone please enlighten me?
Thanks in advance!
Thomas
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
