Thanks for the zippy reply, Paul.
I did try your suggestion - that's what triggered the error:
> >o=model.Owner()
that's what triggered the error:
<many lines deleted>
/usr/lib/python2.5/site-packages/SQLObject-0.9.1-py2.5.egg/sqlobject/
converters.py in sqlrepr(obj, db)
234 if converter is None:
235 raise ValueError, "Unknown SQL builtin type: %s
for %s" % \
--> 236 (type(obj), repr(obj))
237 return converter(obj, db)
238 else:
<type 'exceptions.ValueError'>: Unknown SQL builtin type: <type
'classobj'> for <class sqlobject.sqlbuilder.NoDefault at 0x860ca1c>
I thought this was due to basic misunderstanding of how it was
supposed to work, but does it really imply that the class is defined
incorrectly?
The model.py is as follows for your inspection:
============ begin model.py ==================
from datetime import datetime
from turbogears.database import PackageHub
from sqlobject import *
hub = PackageHub('bupc')
__connection__ = hub
# class YourDataClass(SQLObject):
# pass
class Owner(SQLObject):
# title = col header for toolbox view
FirstName = StringCol(length=20,varchar=True,title="FirstName",
dbName="firstname",alternateID=False,default="Joe",unique=False,notNone=True)
LastName =
StringCol(length=30,varchar=True,title="LastName",dbName="lastname",
alternateID=False,default="PhD",unique=False,notNone=True)
UserID =
StringCol(length=15,varchar=True,title="UserID",dbName="userid",
alternateID=False,unique=True,notNone=True)
UciVerified =
BoolCol(title="UciVerified",dbName="UciVerified",default="False")
EmailGiven =
StringCol(length=30,varchar=True,title="EmailGiven",dbName="EmailGiven",
alternateID=False,unique=True,notNone=True)
UciEmail =
StringCol(length=20,varchar=True,title="UciEmail",dbName="UciEmail",
alternateID=False,unique=True,notNone=False)
PhoneNbr =
StringCol(length=15,varchar=True,title="PhoneNbr",dbName="PhoneNbr",
alternateID=False,unique=False,notNone=True)
Password =
StringCol(length=50,varchar=True,title="Password",dbName="Password",
alternateID=False,unique=False,notNone=True)
DateAdded = DateCol(title="DateAdded",dbName="DateAdded",
unique=False, notNone=False, default=datetime.now)
Owner_find = SingleJoin("PCInfo",joinColumn='owner_id_id')
PC_id = ForeignKey("PCInfo",dbName="PC_id")
class PCInfo(SQLObject):
IPNbr = StringCol(length=15,varchar=True,title="IPNbr",
dbName="IPNbr", alternateID=False, unique=True,notNone=True)
HostName = StringCol(length=40, varchar=True, title="HostName",
dbName="HostName", alternateID=False, unique=True,notNone=True)
WinVer =
StringCol(length=20,varchar=True,title="WinVer",dbName="WinVer",
alternateID=False,unique=False,notNone=False)
DHCP = BoolCol(title="DHCP",dbName="DHCP",default="False")
Laptop = BoolCol(title="Laptop",dbName="Laptop",default="False")
Backup_1 = StringCol(length=40,varchar=True,title="Backup_1",
dbName="Backup_1", alternateID=False, unique=False,notNone=True)
Backup_2 = StringCol(length=40,varchar=True,title="Backup_2",
dbName="Backup_2", alternateID=False, unique=False,notNone=False)
Backup_3 = StringCol(length=40,varchar=True,title="Backup_3",
dbName="Backup_3", alternateID=False, unique=False,notNone=False)
============ end model.py ==================
On Dec 13, 2:08 pm, Paul Johnston <[EMAIL PROTECTED]> wrote:
> >model.Owner.set(FirstName=kw["FIRSTNAME"],LastName=kw["LASTNAME"],UserID=kw["USERNAME"],
> >EmailGiven=kw["EMAIL"], PhoneNbr=kw["PHONE"],Password=kw["PASSWORD1"])
>
> myowner = model.Owner()
>
> myowner.set(FirstName=kw["FIRSTNAME"],LastName=kw["LASTNAME"],UserID=kw["USERNAME"],
> EmailGiven=kw["EMAIL"], PhoneNbr=kw["PHONE"],Password=kw["PASSWORD1"])
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
