The problem is discussed here: https://groups.google.com/forum/#!topic/web2py/klspqXpha4E
On Thursday, 5 December 2013 05:04:17 UTC-6, Loïc wrote: > > Hello all- > > I have the same problem as the one explained here > :https://groups.google.com/forum/?fromgroups#!topic/web2py/klspqXpha4E > But as I have more specific informations, I start a new thread... > > *My Model (simplified) : * > db.define_table('page', > Field('parent', 'reference page', label=T('Parent')), > Field('title', unique=True, notnull=True, label=T('Title'))) > > db.page.parent.requires = IS_EMPTY_OR(IS_IN_DB(db, db.page.id, '%(title)s' > , zero=T('<Empty>'))) > pageSelector = HierarchicalSelect(db, db.page, db.page.title, db.page.rank > ) > db.page.parent.widget = pageSelector.widget > > The goal of the HierarchicalSelect widget is to have a "tree-view" of all > my pages. More elegant than the default selector > > *My Controller (simplified)* > def edit_page(): > page = db.page(request.args(0)) > crud.settings.update_deletable = False > form = crud.update(db.page,page,next=URL('show_page', args=page.id)) > return dict(form=form) > > From 2.8.2 update, when I update a page, I get an error : > <class 'sqlite3.IntegrityError'> foreign key constraint failed > > This error *occurs only when I update a page and select "<Empty>" value > for the "parent" field.* > When I *remove the two following lines of my model definition, everything > works fine* > pageSelector = HierarchicalSelect(db, db.page, db.page.title, db.page.rank > ) > db.page.parent.widget = pageSelector.widget > > > So the error seems to be in my HierarchicalSelect class. > *Here is the code : * > class HierarchicalSelect(object): > def __init__(self, db, table_name, title_field, order_field): > self.options=[] > self.db = db > self.tablename = table_name > self.fieldname = None > self.title = title_field > self.order = order_field > self.type = None > self.rows=None > self.hierarchyseparator = XML(" "*4) > > def _childs_list(self, field, depth): > path = self.hierarchyseparator*depth > > path += self.hierarchyseparator > self.options.append((field['id'], path+field[self.title])) > [self._childs_list(child, (depth+1)) for child in self.rows.find( > lambda row: row.parent == field.id)] > > def widget(self, field, value): > self.fieldname = field.name > self.type = field.type > self.rows = self.db(self.tablename).select(orderby=self.order) > self.options.append(("", T('<Empty>'))) #add root node > > [self._childs_list(field,0) for field in self.rows.find(lambda row > : row.parent < 1)] > opt=[OPTION(name, _value=key) for key,name in self.options] > sel = SELECT(opt,_id="%s_%s" % (self.tablename, self.fieldname), > _class="generic-widget", > _name=self.fieldname, > value=value) > return sel > > *HTML generated with the default SELECT helper for the first option (the > option that causes error)* > > <select class="generic-widget" id="page_parent" name="parent"><option > value=""><Aucun></option> > > > *HTML generated with my Widget* *for the first option (the option that causes > error)* > <select class="generic-widget" id="page_parent" name="parent"><option > value=""><Aucun></option> > > > The HTML seems to be the same, so I don't understand what's wrong with my > widget... > > > Can anybody help me with that? > Thank you > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
