def test_represent_SQLFORM(self): self.db.t0.tt.represent = lambda value: value.capitalize() self.db.t0.tt.writable = False self.db.t0.tt.readable = True form = SQLFORM(self.db.t0) self.assertTrue(b'Web2py' in form.xml()) self.db.t0.tt.represent = lambda value, row: value.capitalize() form = SQLFORM(self.db.t0) self.assertTrue(b'Web2py' in form.xml())
def add_qc(): if 'flash' in request.vars: response.flash= request.vars['flash'] form = SQLFORM(db.episode, fields=['name', 'file', 'video_link', 'is_h', 'is_public', 'allow_qcteam']) if form.process().accepted: try: subs = ssa_parser.importSubsFromSSA(request.vars.file.value) except Exception, e: response.flash = "Errors importing the subs (%s)" % e.message db(db.episode.id == form.vars.id).delete() else: try: subsNb=0 for s in subs: if 'Text' in s and len(s['Text'])>0: actor= None if 'Actor' in s: actor= s['Actor'] db.sub.insert(episode=form.vars.id ,start_time= s['Start'] ,end_time= s['End'] ,style= s['Style'] ,text= s['Text'] ,actor= actor) subsNb+=1 db(db.episode.id == form.vars.id).update(subs_nb=subsNb) except Exception, e: response.flash= "Errors inserting the subs in the database (%s)" % e.message else:
def update(): (db, table) = get_table(request) keyed = hasattr(db[table], '_primarykey') record = None if keyed: key = [f for f in request.vars if f in db[table]._primarykey] if key: record = db( db[table][key[0]] == request.vars[key[0]]).select().first() else: record = db(db[table].id == request.args(2)).select().first() if not record: qry = query_by_table_type(table, db) session.flash = T('record does not exist') redirect(URL('select', args=request.args[:1], vars=dict(query=qry))) if keyed: for k in db[table]._primarykey: db[table][k].writable = False form = SQLFORM(db[table], record, deletable=True, delete_label=T('Check to delete'), ignore_rw=ignore_rw and not keyed, linkto=URL('select', args=request.args[:1]), upload=URL(r=request, f='download', args=request.args[:1])) if form.accepts(request.vars, session): session.flash = T('done!') qry = query_by_table_type(table, db) redirect(URL('select', args=request.args[:1], vars=dict(query=qry))) return dict(form=form, table=db[table])
def contact(): from models.contact import Contact db = application.db(models=[Contact]) form = SQLFORM(db.Contact, _action=URL('experiments', 'default', 'contact')) if form.process(session=application.session).accepted: redirect(URL()) return {'form': form}
def questions(): """ At this stage, the user the following workflow will be implemented: - User adds questions via the drop down or clicks "Add Question" to add a new one. """ table = db["survey_questions"] record = request.args(0) template = db( db.survey_template.id == session.rcvars.survey_template).select( limitby=(0, 1)).first() if not template: session.error = T("No template found!") redirect(URL(r=request, f="template")) if not record: questions_query = (db.survey_template_link.survey_questions_id == db.survey_questions.id) & ( template.id == db.survey_template_link.survey_template_id) record = db(questions_query).select(db.survey_questions.id, limitby=(0, 1)).first() if record: redirect(URL(r=request, f="questions", args=[record.id])) questions_form = SQLFORM(table, record, deletable=True, keepvalues=True) all_questions = db().select(db.survey_question.ALL) output = dict(all_questions=all_questions) # Let's avoid blowing up -- this loads questions try: query = (template.id == db.survey_template_link.survey_template_id) contained_questions = db(query).select(db.survey_question.id) if len(contained_questions) > 0: output.update(contained_questions=contained_questions) else: output.update(contained_questions=contained_questions) except: output.update(contained_questions=[]) pass # this means we didn't pass an id, e.g., making a new section! if questions_form.accepts(request.vars, session, keepvalues=True): questions = request.post_vars.questions if questions: for question in questions: if not has_dupe_questions(template.id, question): db.survey_template_link.insert( survey_template_id=session.rcvars.survey_template, survey_questions_id=questions_form.vars.id, survey_question_id=question) elif questions_form.errors: response.error = T("Please correct all errors.") output.update(form=questions_form) return output
def checkForm(self, table): formnamemodal = "formmodal_%s" % self.key form = SQLFORM(table, formname=formnamemodal, _class="form-horizontal", formstyle='bootstrap-modal', fields=self.fields, kwargs=self.kwargs) if self.script: form.append(SCRIPT(self.script)) if form.process().accepted: command = "jQuery('#%s').modal('hide');" % (self.modal_id) command += self.cmd self.response.flash = self.flash self.response.js = command elif form.errors: self.response.flash = self.errormsg return form
def create(): msg_id = request.args(0) contact = get_contact(auth.user) db.msg_attachment.msg_id.default = msg_id db.msg_attachment.attach_by.default = contact.id form = SQLFORM(db.msg_attachment) if form.accepts(request.vars, session, dbio=False): filename = request.vars.attachment.filename form.vars.filename = filename form.vars.attachment_type = filename[filename.rindex('.') + 1:] msg_attachment_id = db.msg_attachment.insert( **db.msg_attachment._filter_fields(form.vars)) subject = db.msg[msg_id].subject dbutils.log_event(db, user_id=auth.user.id, item_id=msg_attachment_id, table_name='msg_attachment', access='create', details=','.join([subject,filename,msg_id])) session.flash = 'File successfully attached.' redirect(URL('messages','read', args=msg_id)) return dict(form = form)
def checkForm(self, table): formnamemodal = "formmodal_%s" % self.key form = SQLFORM(table, formname=formnamemodal) if form.accepts(self.request.vars, self.session, formname=formnamemodal): options = TAG[''](*[OPTION(v, _value=k, _selected=str(form.vars.id) == str(k)) for (k, v) in self.field.requires.options()]) _cmd = "jQuery('#%s').html('%s');" _cmd += "jQuery('#%s').modal('hide')" command = _cmd % (self.key, options.xml().replace("'", "\'"), self.modal_id ) self.response.flash = 'Se creó el registro' self.response.js = command elif form.errors: self.response.flash = "Controle el formulario" return form
def grid( query, fields=None, field_id=None, left=None, join=None, #! orderby=None, groupby=None, groupfields=None, #! having=None, #! headers={}, searchable=False, #True, sortable=True, paginate=20, pagename="page", #! deletable=False, #! True, editable=True, details=False, #! True, selectable=None, create=False, #!True, csv=False, #!True, links=None, links_in_grid=True, upload='<default>', args=[], user_signature=False, #!True, maxtextlengths={}, maxtextlength=20, onvalidation=None, oncreate=None, onupdate=None, ondelete=None, sorter_icons=(XML('↑'), XML('↓')), ui='web2py', showbuttontext=True, _class="web2py_grid", formname='web2py_grid', search_widget='default', ignore_rw=False, formstyle='table3cols', exportclasses=None, formargs={}, createargs={}, editargs={}, viewargs={}, ): # jQuery UI ThemeRoller classes (empty if ui is disabled) if ui == 'jquery-ui': ui = dict( widget='ui-widget', header='ui-widget-header', content='ui-widget-content', default='ui-state-default', cornerall='ui-corner-all', cornertop='ui-corner-top', cornerbottom='ui-corner-bottom', button='ui-button-text-icon-primary', buttontext='ui-button-text', buttonadd='ui-icon ui-icon-plusthick', buttonback='ui-icon ui-icon-arrowreturnthick-1-w', buttonexport='ui-icon ui-icon-transferthick-e-w', buttondelete='ui-icon ui-icon-trash', buttonedit='ui-icon ui-icon-pencil', buttontable='ui-icon ui-icon-triangle-1-e', buttonview='ui-icon ui-icon-zoomin', ) elif ui == 'web2py': ui = dict( widget='', header='', content='', default='', cornerall='', cornertop='', cornerbottom='', button='button btn', buttontext='buttontext button', buttonadd='icon plus icon-plus', buttonback='icon leftarrow icon-arrow-left', buttonexport='icon downarrow icon-download', buttondelete='icon trash icon-trash', buttonedit='icon pen icon-pencil', buttontable='icon rightarrow icon-arrow-right', buttonview='icon magnifier icon-zoom-in', ) elif not isinstance(ui, dict): raise RuntimeError, 'SQLFORM.grid ui argument must be a dictionary' db = query._db T = current.T request = current.request session = current.session response = current.response wenabled = (not user_signature or (session.auth and session.auth.user)) create = wenabled and create editable = wenabled and editable deletable = wenabled and deletable def url(**b): b['args'] = args + b.get('args', []) b['hash_vars'] = False b['user_signature'] = user_signature return URL(**b) def url2(**b): b['args'] = request.args + b.get('args', []) b['hash_vars'] = False b['user_signature'] = user_signature return URL(**b) referrer = session.get('_web2py_grid_referrer_' + formname, url()) # if not user_signature every action is accessible # else forbid access unless # - url is based url # - url has valid signature (vars are not signed, only path_info) # = url does not contain 'create','delete','edit' (readonly) if user_signature: if not ('/'.join(str(a) for a in args) == '/'.join(request.args) # or # URL.verify(request,user_signature=user_signature, # hash_vars=False) or not ('create' in request.args or 'delete' in request.args or 'edit' in request.args)): session.flash = T('not authorized') redirect(referrer) def gridbutton(buttonclass='buttonadd', buttontext='Add', buttonurl=url(args=[]), callback=None, delete=None, trap=True): if showbuttontext: if callback: return A(SPAN(_class=ui.get(buttonclass)), SPAN(T(buttontext), _title=buttontext, _class=ui.get('buttontext')), callback=callback, delete=delete, _class=trap_class(ui.get('button'), trap)) else: return A(SPAN(_class=ui.get(buttonclass)), SPAN(T(buttontext), _title=buttontext, _class=ui.get('buttontext')), _href=buttonurl, _class=trap_class(ui.get('button'), trap)) else: if callback: return A(SPAN(_class=ui.get(buttonclass)), callback=callback, delete=delete, _title=buttontext, _class=trap_class(ui.get('buttontext'), trap)) else: return A(SPAN(_class=ui.get(buttonclass)), _href=buttonurl, _title=buttontext, _class=trap_class(ui.get('buttontext'), trap)) dbset = db(query) tablenames = db._adapter.tables(dbset.query) #if left!=None: tablenames+=db._adapter.tables(left) if left != None: if isinstance(left, list): for _left in left: tablenames = tablenames + db._adapter.tables(_left) else: tablenames = tablenames + db._adapter.tables(left) if join != None: if isinstance(join, list): for _join in join: tablenames = tablenames + db._adapter.tables(_join) else: tablenames = tablenames + db._adapter.tables(join) tables = [db[tablename] for tablename in tablenames] if not fields: fields = reduce(lambda a, b: a + b, [[field for field in table] for table in tables]) if not field_id: field_id = tables[0]._id columns = [str(field) for field in fields \ if field._tablename in tablenames] if not str(field_id) in [str(f) for f in fields]: fields.append(field_id) table = field_id.table tablename = table._tablename if upload == '<default>': upload = lambda filename: url(args=['download', filename]) if len(request.args) > 1 and request.args[-2] == 'download': stream = response.download(request, db) raise HTTP(200, stream, **response.headers) def buttons(edit=False, view=False, record=None): buttons = DIV( gridbutton('buttonback', 'Back', referrer), _class='form_header row_buttons %(header)s %(cornertop)s' % ui) if edit and (not callable(edit) or edit(record)): args = ['edit', table._tablename, request.args[-1]] buttons.append(gridbutton('buttonedit', 'Edit', url(args=args))) if view: args = ['view', table._tablename, request.args[-1]] buttons.append(gridbutton('buttonview', 'View', url(args=args))) if record and links: for link in links: if isinstance(link, dict): buttons.append(link['body'](record)) elif link(record): buttons.append(link(record)) return buttons formfooter = DIV( _class='form_footer row_buttons %(header)s %(cornerbottom)s' % ui) create_form = update_form = view_form = search_form = None sqlformargs = dict(formargs) if create and len(request.args) > 1 and request.args[-2] == 'new': table = db[request.args[-1]] sqlformargs.update(createargs) create_form = SQLFORM(table, ignore_rw=ignore_rw, formstyle=formstyle, _class='web2py_form', **sqlformargs) create_form.process(formname=formname, next=referrer, onvalidation=onvalidation, onsuccess=oncreate) res = DIV(buttons(), create_form, formfooter, _class=_class) res.create_form = create_form res.update_form = update_form res.view_form = view_form res.search_form = search_form return res elif details and len(request.args) > 2 and request.args[-3] == 'view': table = db[request.args[-2]] record = table(request.args[-1]) or redirect(URL('error')) sqlformargs.update(viewargs) view_form = SQLFORM(table, record, upload=upload, ignore_rw=ignore_rw, formstyle=formstyle, readonly=True, _class='web2py_form', **sqlformargs) res = DIV(buttons(edit=editable, record=record), view_form, formfooter, _class=_class) res.create_form = create_form res.update_form = update_form res.view_form = view_form res.search_form = search_form return res # elif editable and len(request.args)>2 and request.args[-3]=='edit': # table = db[request.args[-2]] # record = table(request.args[-1]) or redirect(URL('error')) # sqlformargs.update(editargs) # update_form = SQLFORM(table, record, upload=upload, ignore_rw=ignore_rw, # formstyle=formstyle, deletable=deletable, # _class='web2py_form', # submit_button=T('Submit'), # delete_label=T('Check to delete'), # **sqlformargs) # update_form.process(formname=formname, # onvalidation=onvalidation, # onsuccess=onupdate, # next=referrer) # res = DIV(buttons(view=details, record=record), # update_form, formfooter, _class=_class) # res.create_form = create_form # res.update_form = update_form # res.view_form = view_form # res.search_form = search_form # return res elif deletable and len( request.args) > 2 and request.args[-3] == 'delete': table = db[request.args[-2]] if ondelete: ondelete(table, request.args[-1]) ret = db(table[table._id.name] == request.args[-1]).delete() return ret exportManager = dict( csv_with_hidden_cols=(ExporterCSV,'CSV (hidden cols)'), csv=(ExporterCSV,'CSV'), xml=(ExporterXML, 'XML'), html=(ExporterHTML, 'HTML'), tsv_with_hidden_cols=\ (ExporterTSV,'TSV (Excel compatible, hidden cols)'), tsv=(ExporterTSV, 'TSV (Excel compatible)')) if not exportclasses is None: exportManager.update(exportclasses) export_type = request.vars._export_type if export_type: order = request.vars.order or '' if sortable: if order and not order == 'None': if order[:1] == '~': sign, rorder = '~', order[1:] else: sign, rorder = '', order tablename, fieldname = rorder.split('.', 1) orderby = db[tablename][fieldname] if sign == '~': orderby = ~orderby table_fields = [f for f in fields if f._tablename in tablenames] if export_type in ('csv_with_hidden_cols', 'tsv_with_hidden_cols'): if request.vars.keywords: try: dbset = dbset( SQLFORM.build_query( fields, request.vars.get('keywords', ''))) rows = dbset.select(cacheable=True) except Exception: response.flash = T('Internal Error') rows = [] else: rows = dbset.select(cacheable=True) else: rows = dbset.select(left=left, orderby=orderby, cacheable=True * columns) if export_type in exportManager: value = exportManager[export_type] clazz = value[0] if hasattr(value, '__getitem__') else value oExp = clazz(rows) filename = '.'.join(('rows', oExp.file_ext)) response.headers['Content-Type'] = oExp.content_type response.headers['Content-Disposition'] = \ 'attachment;filename='+filename+';' raise HTTP(200, oExp.export(), **response.headers) elif request.vars.records and not isinstance(request.vars.records, list): request.vars.records = [request.vars.records] elif not request.vars.records: request.vars.records = [] session['_web2py_grid_referrer_' + formname] = url2(vars=request.vars) console = DIV(_class='web2py_console %(header)s %(cornertop)s' % ui) error = None search_actions = DIV(_class='web2py_search_actions') if create: search_actions.append( gridbutton(buttonclass='buttonadd', buttontext=T('Add'), buttonurl=url(args=['new', tablename]))) console.append(search_actions) # if create: # add = gridbutton( # buttonclass='buttonadd', # buttontext='Add', # buttonurl=url(args=['new',tablename])) # if not searchable: # console.append(add) else: add = '' if searchable: sfields = reduce(lambda a, b: a + b, [[f for f in t if f.readable] for t in tables]) if isinstance(search_widget, dict): search_widget = search_widget[tablename] if search_widget == 'default': search_menu = SQLFORM.search_menu(sfields) search_widget = lambda sfield, url: CAT( add, FORM(INPUT( _name='keywords', _value=request.vars.keywords, _id='web2py_keywords', _onfocus= "jQuery('#w2p_query_fields').change();jQuery('#w2p_query_panel').slideDown();" ), INPUT( _type='submit', _value=T('Search'), _class="btn"), INPUT(_type='submit', _value=T('Clear'), _class="btn", _onclick="jQuery('#web2py_keywords').val('');"), _method="GET", _action=url), search_menu) form = search_widget and search_widget(sfields, url()) or '' console.append(form) keywords = request.vars.get('keywords', '') try: if callable(searchable): subquery = searchable(sfields, keywords) else: subquery = SQLFORM.build_query(sfields, keywords) except RuntimeError: subquery = None error = T('Invalid query') else: subquery = None if subquery: dbset = dbset(subquery) try: if groupby: nrows = len( dbset.select(*groupfields, join=join, left=left, groupby=groupby, having=having, cacheable=True)) elif left or join: nrows = dbset.select('count(*)', join=join, left=left, cacheable=True).first()['count(*)'] # if left or groupby: # c = 'count(*)' # nrows = dbset.select(c,left=left,cacheable=True, # groupby=groupby).first()[c] else: nrows = dbset.count() except: nrows = 0 error = T('Unsupported query') order = request.vars.order or '' if sortable: if order and not order == 'None': if groupby: if str(groupby[0]).find(order) > -1: tablename, fieldname = order.split('~')[-1].split( '.', 1) sort_field = db[tablename][fieldname] exception = sort_field.type in ('date', 'datetime', 'time') if exception: orderby = (order[:1] == '~' and sort_field) or ~sort_field else: orderby = (order[:1] == '~' and ~sort_field) or sort_field else: tablename, fieldname = order.split('~')[-1].split( '.', 1) gfields = str(groupfields[0]).split(",") for gfield in gfields: if len(gfield.split(" AS ")) > 1: if gfield.split(" AS ")[1] == fieldname: if str(gfield.split(" AS ")[0]).find( "SUM") > -1: sort_field = db[tablename][ fieldname].sum() elif str(gfield.split(" AS ")[0]).find( "COUNT") > -1: sort_field = db[tablename][ fieldname].count() elif str(gfield.split(" AS ")[0]).find( "MIN") > -1: sort_field = db[tablename][ fieldname].min() elif str(gfield.split(" AS ")[0]).find( "MAX") > -1: sort_field = db[tablename][ fieldname].max() elif str(gfield.split(" AS ")[0]).find( "LENGTH") > -1: sort_field = db[tablename][ fieldname].len() else: break orderby = (order[:1] == '~' and ~sort_field) or sort_field break else: tablename, fieldname = order.split('~')[-1].split('.', 1) sort_field = db[tablename][fieldname] exception = sort_field.type in ('date', 'datetime', 'time') if exception: orderby = (order[:1] == '~' and sort_field) or ~sort_field else: orderby = (order[:1] == '~' and ~sort_field) or sort_field head = TR(_class=ui.get('header')) if selectable: head.append(TH(_class=ui.get('default'))) for field in fields: if columns and not str(field) in columns: continue if not field.readable: continue key = str(field) header = headers.get( str(field), hasattr(field, 'label') and field.label or key) if sortable: if key == order: key, marker = '~' + order, sorter_icons[0] elif key == order[1:]: marker = sorter_icons[1] else: marker = '' header = A( header, marker, _href=url(vars=dict(keywords=request.vars.keywords or '', order=key)), _class=trap_class()) head.append(TH(header, _class=ui.get('default'))) if links and links_in_grid: for link in links: if isinstance(link, dict): head.append(TH(link['header'], _class=ui.get('default'))) # Include extra column for buttons if needed. include_buttons_column = ( details or editable or deletable or (links and links_in_grid and not all([isinstance(link, dict) for link in links]))) if include_buttons_column: head.insert(0, TH(_class=ui.get('default', ''))) # head.append(TH(_class=ui.get('default'))) paginator = UL() if paginate and paginate < nrows: npages, reminder = divmod(nrows, paginate) if reminder: npages += 1 try: page = int(request.vars.page or 1) - 1 except ValueError: page = 0 limitby = (paginate * page, paginate * (page + 1)) def self_link(name, p): d = dict(page=p + 1) if order: d['order'] = order if request.vars.keywords: d['keywords'] = request.vars.keywords return A(name, _href=url(vars=d), _class=trap_class()) NPAGES = 5 # window is 2*NPAGES if page > NPAGES + 1: paginator.append(LI(self_link('<<', 0))) if page > NPAGES: paginator.append(LI(self_link('<', page - 1))) pages = range(max(0, page - NPAGES), min(page + NPAGES, npages)) for p in pages: if p == page: paginator.append( LI(A(p + 1, _onclick='return false'), _class=trap_class('current'))) else: paginator.append(LI(self_link(p + 1, p))) if page < npages - NPAGES: paginator.append(LI(self_link('>', page + 1))) if page < npages - NPAGES - 1: paginator.append(LI(self_link('>>', npages - 1))) else: limitby = None try: table_fields = [f for f in fields if f._tablename in tablenames] if groupby: rows = dbset.select(*groupfields, join=join, left=left, groupby=groupby, having=having, orderby=orderby, limitby=limitby, cacheable=True) else: rows = dbset.select(join=join, left=left, orderby=orderby, limitby=limitby, cacheable=True, *table_fields) # rows = dbset.select(left=left,orderby=orderby, # groupby=groupby,limitby=limitby, # cacheable=True,*table_fields) except SyntaxError: rows = None error = T("Query Not Supported") if nrows: message = error or T('%(nrows)s records found') % dict(nrows=nrows) console.append(DIV(message, _class='web2py_counter')) if rows: htmltable = TABLE(THEAD(head)) tbody = TBODY() numrec = 0 for row in rows: if numrec % 2 == 0: classtr = 'even' else: classtr = 'odd' numrec += 1 id = row[field_id] #@ReservedAssignment if id: rid = id if callable(rid): ### can this ever be callable? rid = rid(row) tr = TR(_id=rid, _class='%s %s' % (classtr, 'with_id')) else: tr = TR(_class=classtr) if selectable: tr.append( INPUT(_type="checkbox", _name="records", _value=id, value=request.vars.records)) for field in fields: if not str(field) in columns: continue if not field.readable: continue if field.type == 'blob': continue value = row[field] maxlength = maxtextlengths.get(str(field), maxtextlength) if field.represent: try: value = field.represent(value, row) except Exception: try: value = field.represent( value, row[field._tablename]) except Exception: pass elif field.type == 'boolean': value = INPUT(_type="checkbox", _checked=value, _disabled=True) elif field.type == 'upload': if value: if callable(upload): value = A(current.T('file'), _href=upload(value)) elif upload: value = A(current.T('file'), _href='%s/%s' % (upload, value)) else: value = '' if isinstance(value, str): value = truncate_string(value, maxlength) elif not isinstance(value, DIV): value = field.formatter(value) if not include_buttons_column: tr.append(TD(value, _style="padding:10px;")) else: tr.append(TD(value)) row_buttons = TD(_class='row_buttons') if links and links_in_grid: for link in links: if isinstance(link, dict): tr.append(TD(link['body'](row))) else: if link(row): row_buttons.append(link(row)) if include_buttons_column: if details and (not callable(details) or details(row)): row_buttons.append( gridbutton('buttonview', 'View', url(args=['view', tablename, id]))) if editable and (not callable(editable) or editable(row)): row_buttons.append( gridbutton('buttonedit', 'Edit', url(args=['edit', tablename, id]))) if deletable and (not callable(deletable) or deletable(row)): row_buttons.append( gridbutton( 'buttondelete', 'Delete', callback=url(args=['delete', tablename, id]), delete='tr')) #tr.append(row_buttons) tr.insert(0, row_buttons) tbody.append(tr) htmltable.append(tbody) htmltable = DIV(htmltable, _style='width:100%;overflow-x:auto') if selectable: htmltable = FORM(htmltable, INPUT(_type="submit")) if htmltable.process(formname=formname).accepted: # htmltable.vars.records = htmltable.vars.records or [] htmltable.vars.records = htmltable.vars.records if type( htmltable.vars.records) == list else [ htmltable.vars.records ] records = [int(r) for r in htmltable.vars.records] selectable(records) redirect(referrer) else: htmltable = DIV(current.T('No records found')) if csv and nrows: export_links = [] for k, v in sorted(exportManager.items()): label = v[1] if hasattr(v, "__getitem__") else k link = url2(vars=dict(order=request.vars.order or '', _export_type=k, keywords=request.vars.keywords or '')) export_links.append(A(T(label), _href=link)) export_menu = \ DIV(T('Export:'),_class="w2p_export_menu",*export_links) else: export_menu = None res = DIV(console, DIV(htmltable, _class="web2py_table"), _class='%s %s' % (_class, ui.get('widget'))) if paginator.components: res.append( DIV(paginator, _class="web2py_paginator %(header)s %(cornerbottom)s" % ui)) if export_menu: res.append(export_menu) res.create_form = create_form res.update_form = update_form res.view_form = view_form res.search_form = search_form return res
def test_SQLFORM(self): form = SQLFORM(self.db.auth_user) self.assertEqual(form.xml(), b'<form action="#" enctype="multipart/form-data" method="post"><table><tr id="auth_user_first_name__row"><td class="w2p_fl"><label class="" for="auth_user_first_name" id="auth_user_first_name__label">First name: </label></td><td class="w2p_fw"><input class="string" id="auth_user_first_name" name="first_name" type="text" value="" /></td><td class="w2p_fc"></td></tr><tr id="auth_user_last_name__row"><td class="w2p_fl"><label class="" for="auth_user_last_name" id="auth_user_last_name__label">Last name: </label></td><td class="w2p_fw"><input class="string" id="auth_user_last_name" name="last_name" type="text" value="" /></td><td class="w2p_fc"></td></tr><tr id="auth_user_email__row"><td class="w2p_fl"><label class="" for="auth_user_email" id="auth_user_email__label">E-mail: </label></td><td class="w2p_fw"><input class="string" id="auth_user_email" name="email" type="text" value="" /></td><td class="w2p_fc"></td></tr><tr id="auth_user_username__row"><td class="w2p_fl"><label class="" for="auth_user_username" id="auth_user_username__label">Username: </label></td><td class="w2p_fw"><input class="string" id="auth_user_username" name="username" type="text" value="" /></td><td class="w2p_fc"></td></tr><tr id="auth_user_password__row"><td class="w2p_fl"><label class="" for="auth_user_password" id="auth_user_password__label">Password: </label></td><td class="w2p_fw"><input class="password" id="auth_user_password" name="password" type="password" value="" /></td><td class="w2p_fc"></td></tr><tr id="submit_record__row"><td class="w2p_fl"></td><td class="w2p_fw"><input type="submit" value="Submit" /></td><td class="w2p_fc"></td></tr></table></form>')
def insert(): (db, table) = get_table(request) form = SQLFORM(db[table], ignore_rw=ignore_rw) if form.accepts(request.vars, session): response.flash = T('new record inserted') return dict(form=form, table=db[table])
def test_SQLFORM(self): form = SQLFORM(self.db.auth_user) self.assertEqual(form.xml()[:5], b'<form')
def create_fieldlist(table): fields_lst = [] # if table=="setting": # table="fieldvalue" fields = ns.db[table].fields for fname in fields: fieldcat=1 if fname in("id","deleted"): continue if ns.db[table][fname].type=="text": ns.db[table][fname].widget=lambda field,value: SQLFORM.widgets.string.widget(field,value) if type(ns.db[table][fname].requires).__name__=="check_boolean": fields_lst.append({"fieldname":fname,"label":ns.db[table][fname].label, "widget":SELECT([OPTION("", _value=""),OPTION(T("YES"), _value="1"),OPTION(T("NO"), _value="0",)], _id=table+"_"+fname, _name=fname), "fieldcat":1}) continue if table in("address","contact"): if fname=="nervatype": ns.db[table].nervatype.requires = IS_IN_SET(('customer', 'employee', 'event', 'place', 'product', 'project', 'tool', 'trans')) fieldcat=0 elif fname=="ref_id": fields_lst.append({"fieldname":"refnumber","label":T('Ref.No.'), "widget":INPUT(_type="text",_value="",_name="refnumber",_id=table+"_refnumber",_class="string"), "fieldcat":0}) fields_lst.append({"fieldname":"rownumber","label":T('Row No.'), "widget":INPUT(_type="text",_value="0",_name="rownumber",_id=table+"_rownumber",_class="integer"), "fieldcat":0}) continue elif table=="barcode": if fname=="code": fields_lst.append({"fieldname":"code","label":T('Barcode'), "widget":INPUT(_type="text",_value="",_name="code",_id=table+"_code",_class="string"), "fieldcat":0}) continue elif fname=="product_id": fields_lst.append({"fieldname":"partnumber","label":T('Product No.'), "widget":INPUT(_type="text",_value="",_name="partnumber",_id=table+"_partnumber",_class="string"), "fieldcat":1}) continue elif fname=="barcodetype": ns.db.barcode.barcodetype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('barcodetype')), ns.db.groups.groupvalue, '%(groupvalue)s') elif table=="currency": if fname=="curr": fieldcat=0 elif table=="customer": if fname=="custnumber": fieldcat=0 elif fname=="custtype": ns.db.customer.custtype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('custtype')&(ns.db.groups.groupvalue!="own")), ns.db.groups.groupvalue, '%(groupvalue)s') elif table=="deffield": if fname=="fieldname": fieldcat=0 elif fname=="nervatype": ns.db[table].nervatype.requires = IS_IN_SET(('address', 'barcode', 'contact', 'currency', 'customer', 'employee', 'event', 'item', 'link', 'log', 'movement', 'payment', 'price', 'place', 'product', 'project', 'rate', 'tax', 'tool', 'trans', 'setting')) elif fname=="subtype": ns.db[table][fname].widget=lambda field,value: SQLFORM.widgets.string.widget(field,value) elif fname=="fieldtype": ns.db.deffield.fieldtype.requires = IS_IN_DB(ns.db((ns.db.groups.groupname.like('fieldtype')) &(ns.db.groups.groupvalue!="checkbox")&(ns.db.groups.groupvalue!="trans")), ns.db.groups.groupvalue, '%(groupvalue)s') elif table=="employee": if fname=="empnumber": fieldcat=0 elif fname=="usergroup": ns.db.employee.usergroup.requires = IS_IN_DB(ns.db((ns.db.groups.groupname.like('usergroup'))&(ns.db.groups.deleted==0)), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname=="department": ns.db.employee.department.requires = IS_EMPTY_OR(IS_IN_DB(ns.db((ns.db.groups.groupname.like('department')) &(ns.db.groups.deleted==0)), ns.db.groups.groupvalue, '%(groupvalue)s')) elif fname in("password","registration_key","reset_password_key","registration_id"): continue elif table=="event": if fname=="calnumber": fieldcat=0 elif fname=="ref_id": fields_lst.append({"fieldname":"refnumber","label":T('Ref. No.'), "widget":INPUT(_type="text",_value="",_name="refnumber",_id=table+"_refnumber",_class="string"), "fieldcat":1}) continue elif fname=="nervatype": ns.db[table].nervatype.requires = IS_IN_SET(('customer', 'employee', 'place', 'product', 'project', 'tool', 'trans')) elif fname=="eventgroup": ns.db[table][fname].widget=lambda field,value: SQLFORM.widgets.string.widget(field,value) elif table=="groups": if fname in("groupname","groupvalue"): fieldcat=0 elif table=="item": if fname=="trans_id": fields_lst.append({"fieldname":"transnumber","label":T('Doc.No.'), "widget":INPUT(_type="text",_value="",_name="transnumber",_id=table+"_transnumber",_class="string"), "fieldcat":0}) fields_lst.append({"fieldname":"rownumber","label":T('Row No.'), "widget":INPUT(_type="text",_value="0",_name="rownumber",_id=table+"_rownumber",_class="integer"), "fieldcat":0}) fields_lst.append({"fieldname":"inputmode","label":T('Input mode'), "widget":SELECT([OPTION("", _value=""),OPTION(T("fxprice"), _value="fxprice"), OPTION(T("netamount"), _value="netamount"),OPTION(T("amount"), _value="amount") ], _id="item_inputmode", _name="inputmode"), "fieldcat":1}) fields_lst.append({"fieldname":"inputvalue","label":T('Input value'), "widget":INPUT(_type="text",_value="0",_name="inputvalue",_id=table+"_inputvalue",_class="double"), "fieldcat":1}) continue elif fname=="product_id": fields_lst.append({"fieldname":"partnumber","label":T('Product No.'), "widget":INPUT(_type="text",_value="",_name="partnumber",_id=table+"_partnumber",_class="string"), "fieldcat":1}) continue elif fname=="tax_id": taxcode = ns.db(ns.db.tax.inactive==0).select(ns.db.tax.taxcode) widget=SELECT(*[OPTION(field.taxcode) for field in taxcode], _id="item_taxcode", _name="taxcode") widget.insert(0, OPTION("")) fields_lst.append({"fieldname":"taxcode","label":T('Tax'), "widget":widget, "fieldcat":1}) continue elif fname in("fxprice","netamount","vatamount","amount"): continue elif table=="link": nervatype_lst=['address', 'barcode', 'contact', 'currency', 'customer', 'employee', 'event', 'groups', 'item', 'movement', 'payment', 'price', 'place', 'product', 'project', 'rate', 'tax', 'tool', 'trans'] if fname == "nervatype_1": widget=SELECT(*[OPTION(nervatype) for nervatype in nervatype_lst], _id="link_nervatype1", _name="nervatype1") widget.insert(0, OPTION("")) fields_lst.append({"fieldname":"nervatype1","label":T('Nervatype 1'), "widget":widget, "fieldcat":0}) continue elif fname == "nervatype_2": widget=SELECT(*[OPTION(nervatype) for nervatype in nervatype_lst], _id="link_nervatype2", _name="nervatype2") widget.insert(0, OPTION("")) fields_lst.append({"fieldname":"nervatype2","label":T('Nervatype 2'), "widget":widget, "fieldcat":0}) continue elif fname=="ref_id_1": fields_lst.append({"fieldname":"refnumber1","label":T('Ref. No. 1'), "widget":INPUT(_type="text",_value="",_name="refnumber1",_id=table+"_refnumber1",_class="string"), "fieldcat":0}) continue elif fname=="ref_id_2": fields_lst.append({"fieldname":"refnumber2","label":T('Ref. No. 2'), "widget":INPUT(_type="text",_value="",_name="refnumber2",_id=table+"_refnumber2",_class="string"), "fieldcat":0}) continue elif table=="log": nervatype_lst=['address', 'barcode', 'contact', 'currency', 'customer', 'employee', 'deffield', 'event', 'groups', 'item', 'link', 'movement', 'payment', 'price', 'place', 'product', 'project', 'rate', 'tax', 'tool', 'trans', 'setting'] if fname=="employee_id": fields_lst.append({"fieldname":"empnumber","label":T('Employee No.'), "widget":INPUT(_type="text",_value="",_name="empnumber",_id=table+"_empnumber",_class="string"), "fieldcat":0}) continue elif fname=="crdate": fieldcat=0 elif fname == "nervatype": widget=SELECT(*[OPTION(nervatype) for nervatype in nervatype_lst], _id="log_nervatype", _name="nervatype") widget.insert(0, OPTION("")) fields_lst.append({"fieldname":"nervatype","label":T('Nervatype'), "widget":widget, "fieldcat":1}) continue elif fname == "logstate": widget=SELECT(*[OPTION(logstate.groupvalue) for logstate in ns.db(ns.db.groups.groupname.like('logstate')).select(ns.db.groups.groupvalue)], _id="log_logstate", _name="logstate") widget.insert(0, OPTION("")) fields_lst.append({"fieldname":"logstate","label":T('State'), "widget":widget, "fieldcat":1}) continue elif fname=="ref_id": fields_lst.append({"fieldname":"refnumber","label":T('Ref.No.'), "widget":INPUT(_type="text",_value="",_name="refnumber",_id=table+"_refnumber",_class="string"), "fieldcat":1}) continue elif table=="movement": if fname=="trans_id": fields_lst.append({"fieldname":"transnumber","label":T('Doc.No.'), "widget":INPUT(_type="text",_value="",_name="transnumber",_id=table+"_transnumber",_class="string"), "fieldcat":0}) fields_lst.append({"fieldname":"rownumber","label":T('Row No.'), "widget":INPUT(_type="text",_value="0",_name="rownumber",_id=table+"_rownumber",_class="integer"), "fieldcat":0}) continue elif fname=="movetype": ns.db.movement.movetype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('movetype') & ns.db.groups.groupvalue.belongs(('inventory', 'store', 'tool')) ), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname=="product_id": fields_lst.append({"fieldname":"partnumber","label":T('Product No.'), "widget":INPUT(_type="text",_value="",_name="partnumber",_id=table+"_partnumber",_class="string"), "fieldcat":1}) continue elif fname=="tool_id": fields_lst.append({"fieldname":"serial","label":T('Serial'), "widget":INPUT(_type="text",_value="",_name="serial",_id=table+"_serial",_class="string"), "fieldcat":1}) continue elif fname=="place_id": fields_lst.append({"fieldname":"planumber","label":T('Place No.'), "widget":INPUT(_type="text",_value="",_name="planumber",_id=table+"_planumber",_class="string"), "fieldcat":1}) continue elif table=="numberdef": if fname=="numberkey": fieldcat=0 elif table=="pattern": if fname=="description": fieldcat=0 elif fname=="transtype": ns.db.pattern.transtype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('transtype')), ns.db.groups.groupvalue, '%(groupvalue)s') elif table=="payment": if fname=="trans_id": fields_lst.append({"fieldname":"transnumber","label":T('Doc.No.'), "widget":INPUT(_type="text",_value="",_name="transnumber",_id=table+"_transnumber",_class="string"), "fieldcat":0}) fields_lst.append({"fieldname":"rownumber","label":T('Row No.'), "widget":INPUT(_type="text",_value="0",_name="rownumber",_id=table+"_rownumber",_class="integer"), "fieldcat":0}) continue elif table=="place": if fname=="planumber": fieldcat=0 elif fname=="place_id": fields_lst.append({"fieldname":"ref_planumber","label":T('Ref. No.'), "widget":INPUT(_type="text",_value="",_name="ref_planumber",_id=table+"_ref_planumber",_class="string"), "fieldcat":1}) continue elif fname=="placetype": ns.db.place.placetype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('placetype')), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname=="storetype": continue elif table=="price": if fname=="product_id": fields_lst.append({"fieldname":"partnumber","label":T('Product No.'), "widget":INPUT(_type="text",_value="",_name="partnumber",_id=table+"_partnumber",_class="string"), "fieldcat":0}) fields_lst.append({"fieldname":"pricetype","label":T('Type'), "widget":SELECT([OPTION("", _value=""),OPTION(T("price"), _value="price"), OPTION(T("discount"), _value="discount") ], _id=table+"_pricetype", _name="pricetype"), "fieldcat":0}) continue elif fname=="validfrom": fieldcat=0 elif fname=="curr": fieldcat=0 elif fname=="qty": fieldcat=0 elif fname=="pricevalue": ns.db.price.pricevalue.label = T("Value/limit") elif fname=="calcmode": ns.db.price.calcmode.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('calcmode')), ns.db.groups.groupvalue, '%(description)s') elif table=="product": if fname=="partnumber": fieldcat=0 elif fname=="protype": ns.db.product.protype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('protype')), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname=="tax_id": taxcode = ns.db(ns.db.tax.inactive==0).select(ns.db.tax.taxcode) widget=SELECT(*[OPTION(field.taxcode) for field in taxcode], _id="product_taxcode", _name="taxcode") widget.insert(0, OPTION("")) fields_lst.append({"fieldname":"taxcode","label":T('Tax'), "widget":widget, "fieldcat":1}) continue elif table=="project": if fname=="pronumber": fieldcat=0 elif fname=="customer_id": fields_lst.append({"fieldname":"custnumber","label":T('Customer No.'), "widget":INPUT(_type="text",_value="",_name="custnumber",_id=table+"_custnumber",_class="string"), "fieldcat":1}) continue elif table=="rate": if fname == "ratetype": fieldcat=0 ns.db.rate.ratetype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('ratetype')), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname in("ratedate","curr"): fieldcat=0 elif fname=="place_id": fields_lst.append({"fieldname":"planumber","label":T('Place No.'), "widget":INPUT(_type="text",_value="",_name="planumber",_id=table+"_planumber",_class="string"), "fieldcat":0}) continue elif fname == "rategroup": ns.db.rate.rategroup.requires = IS_EMPTY_OR(IS_IN_DB(ns.db((ns.db.groups.deleted==0) &ns.db.groups.groupname.like('rategroup')), ns.db.groups.groupvalue, '%(groupvalue)s')) elif table=="tax": if fname=="taxcode": fieldcat=0 elif table=="tool": if fname=="serial": fieldcat=0 elif fname=="product_id": fields_lst.append({"fieldname":"partnumber","label":T('Product No.'), "widget":INPUT(_type="text",_value="",_name="partnumber",_id=table+"_partnumber",_class="string"), "fieldcat":1}) continue elif fname == "toolgroup": ns.db.tool.toolgroup.requires = IS_EMPTY_OR(IS_IN_DB(ns.db((ns.db.groups.deleted==0) &ns.db.groups.groupname.like('toolgroup')), ns.db.groups.groupvalue, '%(groupvalue)s')) elif table=="trans": if fname=="transnumber": fieldcat=0 elif fname == "transtype": ns.db.trans.transtype.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('transtype')), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname == "direction": ns.db.trans.direction.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('direction')), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname == "paidtype": ns.db.trans.paidtype.requires = IS_EMPTY_OR(IS_IN_DB(ns.db((ns.db.groups.deleted==0) &ns.db.groups.groupname.like('paidtype')), ns.db.groups.groupvalue, '%(groupvalue)s')) elif fname == "department": ns.db.trans.department.requires = IS_EMPTY_OR(IS_IN_DB(ns.db((ns.db.groups.deleted==0) &ns.db.groups.groupname.like('department')), ns.db.groups.groupvalue, '%(groupvalue)s')) elif fname == "transtate": ns.db.trans.transtate.requires = IS_IN_DB(ns.db(ns.db.groups.groupname.like('transtate')), ns.db.groups.groupvalue, '%(groupvalue)s') elif fname=="customer_id": fields_lst.append({"fieldname":"custnumber","label":T('Customer No.'), "widget":INPUT(_type="text",_value="",_name="custnumber",_id=table+"_custnumber",_class="string"), "fieldcat":1}) continue elif fname=="employee_id": fields_lst.append({"fieldname":"empnumber","label":T('Employee No.'), "widget":INPUT(_type="text",_value="",_name="empnumber",_id=table+"_empnumber",_class="string"), "fieldcat":1}) continue elif fname=="project_id": fields_lst.append({"fieldname":"pronumber","label":T('Project No.'), "widget":INPUT(_type="text",_value="",_name="pronumber",_id=table+"_pronumber",_class="string"), "fieldcat":1}) continue elif fname=="place_id": fields_lst.append({"fieldname":"planumber","label":T('Place No.'), "widget":INPUT(_type="text",_value="",_name="planumber",_id=table+"_planumber",_class="string"), "fieldcat":1}) continue elif fname=="cruser_id": continue elif table=="fieldvalue": if fname=="fieldname": fields_lst.append({"fieldname":"fieldname","label":T('Fieldname'), "widget":INPUT(_type="text",_value="",_name="fieldname",_id=table+"_fieldname",_class="string"), "fieldcat":0}) continue elif fname=="ref_id": fields_lst.append({"fieldname":"refnumber","label":T('Ref.No.'), "widget":INPUT(_type="text",_value="",_name="refnumber",_id=table+"_refnumber",_class="string"), "fieldcat":0}) fields_lst.append({"fieldname":"rownumber","label":T('Row No.'), "widget":INPUT(_type="text",_value="1",_name="rownumber",_id=table+"_rownumber",_class="integer"), "fieldcat":0}) continue elif fname=="fieldtype": ns.db.fieldvalue.fieldtype.requires = IS_IN_DB(ns.db((ns.db.groups.groupname.like('fieldtype')) &(ns.db.groups.groupvalue!="checkbox")&(ns.db.groups.groupvalue!="trans")), ns.db.groups.id, '%(groupvalue)s') form = SQLFORM(ns.db[table]) fields_lst.append({"fieldname":fname,"label":form.custom.label[fname], "widget":form.custom.widget[fname],"fieldcat":fieldcat}) if table in("address", "barcode", "contact", "currency", "customer", "employee", "event", "groups", "item", "link", "log", "movement", "price", "place", "product", "project", "rate", "tax", "tool", "trans"): nervatype = ns.db((ns.db.groups.groupname=="nervatype")&(ns.db.groups.groupvalue==table)).select().as_list()[0]["id"] deffields = ns.db((ns.db.deffield.deleted==0)&(ns.db.deffield.visible==1)&(ns.db.deffield.nervatype==nervatype) &(ns.db.deffield.readonly==0)&(ns.db.deffield.fieldtype==ns.db.groups.id)).select( ns.db.deffield.fieldname,ns.db.groups.groupvalue,ns.db.deffield.description,ns.db.deffield.valuelist) for deffield in deffields: if deffield.groups.groupvalue=="bool": fields_lst.append({"fieldname":deffield.deffield.fieldname,"label":deffield.deffield.description, "widget":INPUT(_type="checkbox",_value="on",_name=deffield.deffield.fieldname,_id=table+"_"+deffield.deffield.fieldname,_class="boolean"), "fieldcat":2}) elif deffield.groups.groupvalue=="integer": fields_lst.append({"fieldname":deffield.deffield.fieldname,"label":deffield.deffield.description, "widget":INPUT(_type="text",_value="0",_name=deffield.deffield.fieldname,_id=table+"_"+deffield.deffield.fieldname,_class="integer"), "fieldcat":2}) elif deffield.groups.groupvalue=="float": fields_lst.append({"fieldname":deffield.deffield.fieldname,"label":deffield.deffield.description, "widget":INPUT(_type="text",_value="0",_name=deffield.deffield.fieldname,_id=table+"_"+deffield.deffield.fieldname,_class="double"), "fieldcat":2}) elif deffield.groups.groupvalue=="date": fields_lst.append({"fieldname":deffield.deffield.fieldname,"label":deffield.deffield.description, "widget":INPUT(_type="text",_value="",_name=deffield.deffield.fieldname,_id=table+"_"+deffield.deffield.fieldname,_class="date"), "fieldcat":2}) elif deffield.groups.groupvalue=="valuelist": widget = SELECT(*[OPTION(field) for field in deffield.deffield.valuelist.split("|")], _name=deffield.deffield.fieldname,_id=table+"_"+deffield.deffield.fieldname) widget.insert(0, OPTION("", _value="")) fields_lst.append({"fieldname":deffield.deffield.fieldname,"label":deffield.deffield.description,"widget":widget,"fieldcat":2}) else: fields_lst.append({"fieldname":deffield.deffield.fieldname,"label":deffield.deffield.description, "widget":INPUT(_type="text",_value="",_name=deffield.deffield.fieldname,_id=table+"_"+deffield.deffield.fieldname,_class="string"), "fieldcat":2}) return fields_lst
Field('bio', 'text', comment="resume (CV)"), ) # set sample validator (do not allow empty nor duplicate names) db.person.name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'person.name')] db.person.sex.requires = IS_IN_SET({'M': 'Male', 'F': 'Female'}) # create the wxPython GUI application instance: app = wx.App(False) # create a testing frame (wx "window"): f = wx.Frame(None, title="web2py/gui2py sample app") # create the web2py FORM based on person table form = SQLFORM(db.person) # create the HTML "browser" window: html = wx.html.HtmlWindow(f, style=wx.html.HW_DEFAULT_STYLE | wx.TAB_TRAVERSAL) # convert the web2py FORM to XML and display it html.SetPage(form.xml()) def on_form_submit(evt): "Handle submit button user action" global form print "Submitting to %s via %s with args %s" % (evt.form.action, evt.form.method, evt.args) if form.accepts(evt.args, formname=None, keepvalues=False, dbio=False): print "accepted!" # insert the record in the table (if dbio=True this is done by web2py):