[Zope-DB] Re: zsql question

Nick Bower nicholas.bower at jrc.it
Fri Oct 8 10:45:29 EDT 2004


Charlie Clark wrote:
> you should always check your data in a PythonScript and only call an ZSQL 
> methods when your checks have been met. This makes signalling errors 
> easier. However, you should also make sure your database enforces this kind 
> of data integrity through constraints:
> 
> CONSTRAINT NOT NULL(ipAddress)

I strongly agree,  on both accounts.  Logic needs to be put in python 
validators, and enforced through schema constraints, foreign keys, etc etc.



More information about the Zope-DB mailing list