Hello Group,

i´m getting now deeper into this sqlobject and turbogears stuff.


i have now made my legacy model in a separate file. it now looks like:

class Teilnehmer(SQLObject):
    class sqlmeta:
        fromDatabase=True
        idName="NR"

class Gebucht(SQLObject):
        class sqlmeta:
                fromDatabase=True
                idName="NR"



i now want to add the relations between the tables to the model.
for example i want to change classes to:

class Participant(SQLObject):
    buchungsnr = ForeignKey("Booking") # buchungsnr is already defined
and existing
                                                          # in the given
                                                          # schema -
it must not be created again!
    class sqlmeta:
        fromDatabase=True
        idName="NR"

class Booking(SQLObject):
        participants = MultipleJoin("Participant", joinColumn="BUCHUNGSNR")
        class sqlmeta:
                fromDatabase=True
                idName="NR"


would it work like this so that i can do
people = Booking.get(1).participants

without changing *anything* in the metadata?

Thanks for your help!

Kind regards,
Frank
-------------------------------------------------------------------------
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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to