[Modeling-cvs] ProjectModeling/Modeling/tests/testPackages/StoreEmployees pymodel_StoreEmployees.py,NONE,1.1.2.1

[<sbi...@us...>]

Update of /cvsroot/modeling/ProjectModeling/Modeling/tests/testPackages/StoreEmployees
In directory sc8-pr-cvs1:/tmp/cvs-serv4394/tests/testPackages/StoreEmployees

Added Files:
      Tag: brch-0_9pre7-1-PyModel
	pymodel_StoreEmployees.py 
Log Message:
Added tests/testPackages/StoreEmployees/pymodel_StoreEmployees.py and
updated StoreEmployees/__init__.py: now loads the model from the
PyModel


--- NEW FILE: pymodel_StoreEmployees.py ---
#! /usr/bin/env python
'''
A sample Pythonic OO-RDB Model 
(re-expressing testPackages/StoreEmployees/model_StoreEmployees.xml) --
A PyModel must define a global variable called 'model', that is of type Model
'''

from Modeling.PyModel import *

##
# Set preferred defaults for this model (when different from 
# standard defaults, or if we want to make things explicit)

AFloat.defaults['precision'] = 10
AFloat.defaults['scale'] = 10
AString.defaults['width'] = 30

RToOne.defaults['delete'] = 'nullify'
RToOne.defaults['multiplicity'] = [0,1] 
#RToOne.defaults['sourceAttribute'] = RToOne.attNameFromRel # 'fk'+destEnt+destAtt+count
#RToOne.defaults['destinationAttribute'] = 'id'

RToMany.defaults['delete'] = 'cascade'
RToMany.defaults['multiplicity'] = [0,None]
#RToMany.defaults['sourceAttribute'] = 'id'
#RToMany.defaults['destinationAttribute'] = RToMany.attNameFromRel # fk+destEnt+sourceAtt+count

# Note that Relation.attNameFromRel is a callable, that calculates the att
# name from the indicated pieces (where count to distinguish between multiple
# relations between same source and target

Entity.defaults['properties'] = [
  APrimaryKey('id', isClassProperty=0, isRequired=1, doc='Primary key!')
]

##

_connDict = {'database': 'STORE_EMPLOYEES'}
model = Model('StoreEmployees',adaptorName='Postgresql',
              connDict=_connDict)
model.doc = ' ... '
model.version='0.1'
model.entities = [

  #
  Entity('Store',
         properties=[ AString('corporateName', isRequired=1), ],
         ),

  Entity('Employee',
         properties=[ AString('lastName',isRequired=1,usedForLocking=1,
                              width=20),
                      AString('firstName', isRequired=1, width=50,
                              usedForLocking=1),
                      ]
         ),
  Entity('SalesClerk', parent='Employee',
         properties=[ AString('storeArea', width=20) ]
         ),
  
  Entity('Executive', parent='Employee',
         properties=[ AString('officeLocation', width=5) ]
         ),
  
  Entity('Address',
         properties=[ AString('street', width=80), 
                      AString('zipCode', width=10), 
                      AString('town'),
                      ]
         ),
  
  Entity('Mark',
         properties=[ AInteger('month', isRequired=1), 
                      AInteger('mark', isRequired=1),
                      ]
         )
  
  ]
model.associations=[
  Association('Mark', 'Executive',
              relations=['executive', 'marks'],
              keys=['FK_Executive_id', 'id']),
  Association('Address', 'Employee',
              relations=['toEmployee', 'toAddresses'],
              keys=['fkEmployeeId', 'id']),
  Association('Store', 'Employee',
              relations=['employees', 'toStore'],
              keys=['fkStoreId', 'id']),
  ]
if __name__ == '__main__':
  model.build()
  #print model.validate()
  #print model.toXML()
  # plus whatever ...

##