[Modeling-users] fetching problem

[Yannick G. <yan...@sa...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,
  I have a really simple model with one entity.  I can insert from it but I
can't fetch.  Here it is, normalized with xmlpp :

<?xml version='1.0' encoding='iso-8859-1'?>

<model
  adaptorName='MySQL'
  connectionDictionary="{}"
  name='Autogen'
  packageName='Autogen'
>
  <entity
    className='PROJECT'
    externalName='PROJECT'
    isAbstract='0'
    isReadOnly='0'
    moduleName='PROJECT'
    name='PROJECT'
    parentEntity=''
    typeName=''
  >
    <primaryKey
      attributeName='projectId'
     />
    <attribute
      columnName='activ_status_id'
      defaultValue='0'
      displayLabel=''
      externalType='INTEGER'
      isClassProperty='1'
      isRequired='1'
      name='activStatusId'
      precision='0'
      scale='0'
      type='int'
      width='5'
     />
    <attribute
      columnName='project_code'
      defaultValue=''
      displayLabel=''
      externalType='varchar'
      isClassProperty='1'
      isRequired='1'
      name='projectCode'
      precision='0'
      scale='0'
      type='string'
      width='30'
     />
    <attribute
      columnName='project_id'
      defaultValue='0'
      displayLabel=''
      externalType='INTEGER'
      isClassProperty='0'
      isRequired='1'
      name='projectId'
      precision='0'
      scale='0'
      type='int'
      width='5'
     />
    <attribute
      columnName='project_note'
      defaultValue=''
      displayLabel=''
      externalType='varchar'
      isClassProperty='1'
      isRequired='1'
      name='projectNote'
      precision='0'
      scale='0'
      type='string'
      width='100'
     />
  </entity>
</model>

I can easily insert with this code snipet :

 from Autogen.PROJECT import PROJECT
 from Modeling.EditingContext import EditingContext

 CODE = "55-00m"
 DESC = "Wash the dishes..."

 if __name__ == '__main__':
     ec = EditingContext()
     proj = PROJECT()
     proj.setProjectCode(CODE)
     proj.setProjectNote(DESC)
     proj.setActivStatusId(18)

     ec.insertObject(proj)
     ec.saveChanges()

     print "done !"

But I can't fetch any value, the following code :

 from Modeling.EditingContext import EditingContext
 from Modeling.FetchSpecification import FetchSpecification
 from Autogen.PROJECT import PROJECT

 ec = EditingContext()
 fetchSpec=FetchSpecification(entityName='PROJECT')
 projects = ec.objectsWithFetchSpecification(fetchSpec)

Raises a weird UnboundLocalError :

Traceback (most recent call last):
  File "<stdin>", line 14, in ?
  File "/usr/lib/python2.2/site-packages/Modeling/EditingContext.py", line
1063, in objectsWithFetchSpecification
    return
self.parentObjectStore().objectsWithFetchSpecification(aFetchSpecification,
anEditingContext)
  File "/usr/lib/python2.2/site-packages/Modeling/ObjectStoreCoordinator.py",
line 421, in objectsWithFetchSpecification
    return store.objectsWithFetchSpecification(aFetchSpecification,
anEditingContext)
  File "/usr/lib/python2.2/site-packages/Modeling/DatabaseContext.py", line
1441, in objectsWithFetchSpecification
    object=channel.fetchObject()
  File "/usr/lib/python2.2/site-packages/Modeling/DatabaseChannel.py", line
217, in fetchObject
    object=cd.createInstanceWithEditingContext(ec)
  File "/usr/lib/python2.2/site-packages/Modeling/EntityClassDescription.py",
line 177, in createInstanceWithEditingContext
    theClass=self.classForInstances()
  File "/usr/lib/python2.2/site-packages/Modeling/EntityClassDescription.py",
line 161, in classForInstances
    theClass=classForEntity(self._entity)
  File "/usr/lib/python2.2/site-packages/Modeling/EntityClassDescription.py",
line 488, in classForEntity
    retClass=getattr(module, className, None)
UnboundLocalError: local variable 'module' referenced before assignment


The model passes all the validations, what could I have possibly done wrong ?


- --
Yannick Gingras
Byte Gardener, Savoir-faire Linux inc.
(514) 276-5468
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+VP5Erhy5Fqn/MRARAiwUAJ4iNHXMPWedtSdt+WBV69tyY++ObwCghzEX
ChFXvP9TY3qVHMQWgQIfROE=
=k7Cz
-----END PGP SIGNATURE-----