Hi list,

How can I represent in SQLObject a specialization:

  tables:

      media

      dinamicMedia
      staticMedia
      remoteMedia

  A media may be (exclusivelly) either dinamicMedia or staticMedia or
remoteMedia. I have a field named title and mediatype in the media object.
Acording to the field mediaType (which can assume DM, SM or RM -
DinamicMedia, StaticMedia and RemoteMedia respectively) I need tow get the
data in the write table when I load the media data. For exemple, I want all
medias which title contains the keyword "rock". My objects are defined as
follows:

class Media(SQLObject):

   title = StringCol(length=40)
   mediatype = StringCol(length=2)
   ... *other fields*

class DinamicMedia(SQLObject):

   media = ForeignKey('Media')
   ... *other fields*

class StaticMedia(SQLObject):

   media = ForeignKey('Media')
   ... *other fields*

class RemoteMedia(SQLObject):

   media = ForeignKey('Media')
   ... *other fields*

Thank you in advance. Any suggestion/clue will be greatfully accepted!

Cheers,
Leandro
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to