Hello,
I don't know if I am doing somthing wrong or if I found a bug. I can't
insert to a certain table called "sub_pos".
The ticket I get when I try to insert to this table in appadmin is
this:
Traceback (most recent call last):
File "/home/macco/Programme/web2py/gluon/restricted.py", line 98, in
restricted
exec ccode in environment
File "/home/macco/Programme/web2py/applications/angebotstool/
controllers/default.py", line 30, in <module>
File "/home/macco/Programme/web2py/gluon/globals.py", line 74, in
<lambda>
self._caller = lambda f: f()
File "/home/macco/Programme/web2py/applications/angebotstool/
controllers/default.py", line 14, in submission
form=SQLFORM(db.sub_pos,fields=['id_submission','id_position'])
File "/home/macco/Programme/web2py/gluon/sqlhtml.py", line 356, in
__init__
inp = self.widgets.options.widget(field, default)
File "/home/macco/Programme/web2py/gluon/sqlhtml.py", line 115, in
widget
options = field.requires.options()
File "/home/macco/Programme/web2py/gluon/validators.py", line 248,
in options
self.build_set()
File "/home/macco/Programme/web2py/gluon/validators.py", line 235,
in build_set
records = self.dbset.select(*self.fields, **dd)
File "/home/macco/Programme/web2py/gluon/sql.py", line 1836, in
select
(cache_model, time_expire) = attributes['cache']
ValueError: too many values to unpack
The db.py was created by the the model builder:
dbOBJECT = SQLDB("sqlite://dbOBJECT.db")
"""
Table definition
"""
dbOBJECT.define_table("customer",
SQLField("name", "string", notnull=True, default=None),
SQLField("address", "text", notnull=True, default=None))
dbOBJECT.customer.name.requires=IS_NOT_EMPTY()
dbOBJECT.customer.address.requires=IS_NOT_EMPTY()
"""
Table definition
"""
dbOBJECT.define_table("submission",
SQLField("name", "string", notnull=True, default=None),
SQLField("description", "text", notnull=True, default=None),
SQLField("id_customer", dbOBJECT.customer))
dbOBJECT.submission.id_customer.requires=IS_IN_DB(dbOBJECT,
dbOBJECT.customer.id, '%(name)s')
dbOBJECT.submission.name.requires=IS_NOT_EMPTY()
dbOBJECT.submission.description.requires=IS_NOT_EMPTY()
"""
Table definition
"""
dbOBJECT.define_table("category",
SQLField("cat_id", "integer", notnull=True, default=None),
SQLField("name", "string", notnull=True, default=None))
dbOBJECT.category.id.requires=IS_NOT_EMPTY()
dbOBJECT.category.name.requires=IS_NOT_EMPTY()
"""
Table definition
"""
dbOBJECT.define_table("position",
SQLField("name", "string", notnull=True, default=None),
SQLField("description", "text", notnull=True, default=None),
SQLField("price", "double", notnull=True, default=None),
SQLField("id_category", dbOBJECT.category))
dbOBJECT.position.id_category.requires=IS_IN_DB(dbOBJECT,
dbOBJECT.category.cat_id, '%(name)s')
dbOBJECT.position.name.requires=IS_NOT_EMPTY()
dbOBJECT.position.description.requires=IS_NOT_EMPTY()
"""
Table definition
"""
dbOBJECT.define_table("sub_pos",
SQLField("id_position", dbOBJECT.position),
SQLField("id_submission", dbOBJECT.submission))
dbOBJECT.sub_pos.id_position.requires=IS_IN_DB(dbOBJECT,
dbOBJECT.position.id, '%(name)s')
dbOBJECT.sub_pos.id_submission.requires=IS_IN_DB(dbOBJECT,
dbOBJECT.submission.id, '%(name)s')
"""
Relations between tables (remove fields you don't need from requires)
"""
dbOBJECT.submission.id_customer.requires=IS_IN_DB(dbOBJECT,
'customer.id','customer.name','customer.address')
dbOBJECT.position.id_category.requires=IS_IN_DB(dbOBJECT,
'category.id','category.name')
dbOBJECT.sub_pos.id_position.requires=IS_IN_DB(dbOBJECT,
'position.id','position.name','position.description','position.price','position.id_category')
dbOBJECT.sub_pos.id_submission.requires=IS_IN_DB(dbOBJECT,
'submission.id','submission.name','submission.description','submission.id_customer')
The problematic is table is sub_pos, it has two foreign keys. I have
absolutly no clue where the problem could come from.
By the way, how can I supress the automatic id creation?
Rockin regards,
Marco
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
