Just for the record, here is the model I ended up with, and it works as
expected, producing about 30 report lines/second.
====================
class Contacts(ActiveMapper):
class mapping:
ACCOUNTNO = column(String(20), unique=True)
COMPANY = column(String(40))
CONTACT = column(String(40))
LASTNAME = column(String(15))
DEPARTMENT = column(String(35))
TITLE = column(String(35))
SECR = column(String(20))
PHONE1 = column(String(25))
PHONE2 = column(String(25))
PHONE3 = column(String(25))
FAX = column(String(25))
EXT1 = column(String( 6))
EXT2 = column(String( 6))
EXT3 = column(String( 6))
EXT4 = column(String( 6))
ADDRESS1 = column(String(40))
ADDRESS2 = column(String(40))
CITY = column(String(30))
STATE = column(String(20))
ZIP = column(String(10))
COUNTRY = column(String(20))
DEAR = column(String(20))
SOURCE = column(String(20))
KEY1 = column(String(20))
KEY2 = column(String(20))
KEY3 = column(String(20))
KEY4 = column(String(20))
KEY5 = column(String(20))
STATUS = column(String(3))
NOTES = column(String(10))
CREATEBY = column(String( 8))
OWNER = column(String( 8))
LASTUSER = column(String( 8))
LASTDATE = column(String( 8))
LASTTIME = column(String( 5))
RECID = column(String(15), primary_key=True)
actions_id = column(String(15),
foreign_key=ForeignKey('actions.RECID'))
actions = one_to_one('Actions', colname='action_id',
backref='contacts')
class Actions(ActiveMapper):
class mapping:
ACCOUNTNO = column(String(20), index=True)
CALLBACKON = column(String(25))
CALLBACKAT = column(String(8))
LASTCONTON = column(String(25))
LASTCONTAT = column(String(8))
LASTATMPON = column(String(25))
LASTATMPAT = column(String(8))
MEETDATEON = column(String(25))
MEETTIMEAT = column(String(8))
COMMENTS = column(String(65))
PREVRESULT = column(String(65))
NEXTACTION = column(String(65))
RECID = column(String(15), primary_key=True)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
