#!/usr/bin/env python # show python where the modules are import sys; sys.path.append('../'); sys.path.append('../../../') import web.error; web.error.enable() import web, web.database, web.database.object, os connection = web.database.connect( adapter="snakesql", database="database-object-form", autoCreate = 1, ) cursor = connection.cursor() person = web.database.object.Table("Person") person.add(column="String", name='firstName', required=True) person.addColumn(web.database.object.String(name="surname")) person.addColumn( web.database.object.StringSelect( name="profession", options=[None, 'Developer', 'Web Developer'], displayNoneAs='Not Specified' ) ) person.add(column="Bool", name='sex', displayTrueAs='Male', displayFalseAs='Female') database = web.database.object.Database() database.addTable(person) database.init(cursor) if not database.tablesExist(): database.createTables() form = database['Person'].form() print web.header() # Print the content-type information if len(web.cgi) > 1: # Assume form submitted form.populate(web.cgi) if form.valid(): entry = database['Person'].insert(all=form.dict()) print '%s
Go Back'%( '
There were some invalid fields. Please correct them.
%s"""%(form.html()) else: entries = 'Firstname | ' entries += 'Surname | Profession | Sex |
%s | %s | %s | %s |
%s
"%( '