#!/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'%( '

Entry Added

' + form.frozen(), os.environ['SCRIPT_NAME'] ) else: print """

Error

There were some invalid fields. Please correct them.

%s"""%(form.html()) else: entries = '' entries += '' for row in database['Person'].values(): entries += ''%( row['firstName'], row['surname'], row['profession'], row['sex'] ) entries += '
FirstnameSurnameProfessionSex
%s%s%s%s
' print "%s

Entries

%s

"%( '

Enter Data

'+form.html(), entries ) connection.commit() # Save the changes connection.close() # Close the connection