Re: [SQLObject] SQLObject database integrity?

[Jorge G. <jg...@gm...>]

Oleg Broytmann <ph...@ph...> writes:

> On Tue, Nov 07, 2006 at 11:44:14PM +0600, Basil Shubin wrote:
>> class Country(SQLObject):
>> 	title = UnicodeCol()
>> 	town = ForeignKey('Town')
>> 
>> And now the question, how I can prevent from deleting entry from 'town' 
>> table if it's used in a 'country' table?
>
> class Country(SQLObject):
> 	title = UnicodeCol()
> 	town = ForeignKey('Town', cascade=True)
>
>    "cascade" is implemented in the 0.7 brnach for SQLite, Postgres, Sybase,
> MSSQL and MaxDB; in the 0.8 branch also for MySQL.

Shouldn't it be "False"?  I believe that True will cascade the deletion and
when removing the Town it will remove the Country as well.  Setting it to
False should prevent the deletion of any used Towns. 

-- 
Jorge Godoy      <jg...@gm...>