pydal reference examples

gistfile1.txt

from pydal import DAL, Field
db=DAL()
db.define_table('person', Field('name'))
id = db.person.insert(name="Max")
print("%(name)s" % id)

db.define_table('dog', Field('name'), Field('owner', db.person))
db.dog.insert(name="Snoopy", owner=id)
dog = db(db.dog).select().first()
print("%(name)s" % dog.owner)
print(dog.owner.name)

cache =	py4web.Cache()
def format_person(id):
    key	= "person-%s" %	id
    return cache(key, lambda id: (db.person._format % db.person[id])