On Tue, Mar 08, 2011 at 11:26:19AM -0800, Mark McWiggins wrote:
> I'm a new SQLObject user ...
Welcome!
> I have this table:
>
> CREATE TABLE zipcode (
> zip integer PRIMARY KEY,
> city text,
> -- and so forth ...
>
> with Python representing it:
>
> class zipcode(SQLObject):
> class sqlmeta:
> fromDatabase = True
> idName = 'zip'
>
> But when I try to create rows with:
>
> for myzip in range(1,99999):
> z = zipcode(zip = myzip, city = 'zipcity' + str(myzip))
>
> I get an error
>
> File
> "/usr/local/lib/python2.4/site-packages/SQLObject-1.1dev_r4347-py2.4.egg\
> /sqlobject/main.py", line 1099, in set
> raise TypeError, "%s.set() got an unexpected keyword argument %s" %
> (self._\
> _class__.__name__, name)
> TypeError: zipcode.set() got an unexpected keyword argument zip
In SQLObject the primary key is always called 'id'.
for myzip in range(1, 99999):
z = zipcode(id=myzip, city='zipcity' + str(myzip))
Oleg.
--
Oleg Broytman http://phdru.name/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
