Re: [SQLObject] Fwd: Reference to one of multiple tables

[Petr J. <pet...@tp...>]

> But your example got me thinking. Is something like the following valid?
> (working example)
> from sqlobject import *
>
> If it is working, then it is (IMHO) valid :D
The DB structure is completely up to you of course. But think twice about
the DB model. When the production data is in the database already, it is a
pain to change the DB structure.


>
>
> But then I should handle the inShelve bool value whenever self.sold or
> self.onLoan are changed.
>

To keep the logic in the database is up to you. Of course you can
automatize it some way (directly in the DB, using DB machinery - computed
columns in the Firebird for example, which is IMHO not the best way to go
but it works)

Or maybe you can try something using:

def _set_soldCarefully(self, value):
    self.sold = True
    self.onLoan = False
    self.inShelve = False

Regards

Petr