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