sqlobject-discuss

[SQLObject] How do ForeignKeys work?

[paul <pa...@su...>]

Hi,

I have to classes like so:

CaCert(CertItem):
  SignedCerts = MultipleJoin('Cert')
  ...

Cert(CertItem):
  CA = ForeignKey('CaCert')
  Type = StringCol()
  ...

  def _set_Type(self, value):
   _valid = ['email', 'client', 'object', 'server']
   if value not in _valid:
     raise ValueError('Type must be one of %s' % _valid)
   elif CA.Type not in  ['ca_'+value, 'ca_root']:
     raise ValueError('CA must support cert type %s.' % type)
   self._SO_set_Type(value)
  ...

But instance creation fails:
server_params = {...
sampleRoot = CaCert.new(**server_params)
client_params = {'Type':'email', 'CN':'foo@bar', 'OU':'B17 Corporation',
                      'DaysValid':365, 'email':'foo@bar', 'CA':sampleRoot}
Cert.createTable(ifNotExists=True)
Cert.new(**client_params)

Traceback (most recent call last):
   File "certs.py", line 212, in ?
     testcert = Cert.new(**client_params)
   File "certs.py", line 134, in new
     obj = super(CertItem, cls).new(**kw)
   File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 904, in new
     setattr(inst, name, value)
   File "certs.py", line 148, in _set_Type
     elif CA.Type not in  ['ca_'+value, 'ca_root']:
NameError: global name 'CA' is not defined

I can access the CaCert instance in new(cls, **kw) through kw['CA'] so I could 
do those checks in new but what if one do not need to override new? Is there 
another way to access attributes of CA? Generally, is it possible to do checks 
in the setter methods which depend on other Columns values?

thanks
  Paul

Re: [SQLObject] How do ForeignKeys work?

[Ian B. <ia...@co...>]

paul wrote:
> Hi,
> 
> I have to classes like so:
> 
> CaCert(CertItem):
>  SignedCerts = MultipleJoin('Cert')
>  ...
> 
> Cert(CertItem):
>  CA = ForeignKey('CaCert')
>  Type = StringCol()
>  ...
> 
>  def _set_Type(self, value):
>   _valid = ['email', 'client', 'object', 'server']
>   if value not in _valid:
>     raise ValueError('Type must be one of %s' % _valid)
>   elif CA.Type not in  ['ca_'+value, 'ca_root']:
>     raise ValueError('CA must support cert type %s.' % type)
>   self._SO_set_Type(value)

The bug is here: CA isn't defined (just like the exception says).  Maybe 
you mean self.CA.Type?  That might not work either.

In SQLObject in SVN you could do something like:

def _create(self, id, **kw):
     if kw['CA'].Type not in ['ca_' + kw['Type'], 'ca_root']:
         raise ValueError, ...
     super(Cert, self)._create(id, **kw)

def _set_Type(self, value):
     _value = ...
     if value not in _valid: ...
     if not self._SO_creating and self.CA.Type not in ...:
     self._SO_set_Type(value)

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org

Re: [SQLObject] How do ForeignKeys work?

[paul <pa...@su...>]

Thanks Ian,

Ian Bicking wrote:
> The bug is here: CA isn't defined (just like the exception says).  Maybe 
> you mean self.CA.Type?  That might not work either.
I thought it worked like class vars and instance vars...(you see I don't know 
much about the inner workings of SQLObject ;)

> In SQLObject in SVN you could do something like:
> 
> def _create(self, id, **kw):
>     if kw['CA'].Type not in ['ca_' + kw['Type'], 'ca_root']:
>         raise ValueError, ...
>     super(Cert, self)._create(id, **kw)
> 
> def _set_Type(self, value):
>     _value = ...
>     if value not in _valid: ...
>     if not self._SO_creating and self.CA.Type not in ...:
>     self._SO_set_Type(value)
Will check this.

thanks again,
  Paul