[Webware-discuss] webware and sqlobject example

[<py...@ce...>]

hi,

just wondering whether there is any documentation which shows simple example
how to use sqlobject in webware ..

I am playing with it, and I am not sure where I should make a connection
(awake?), and when /how to close it (sleep?)....

Is this a proper way to work with sqlobject in webware:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
from WebKit.Page import Page
from SQLObject import *

__connection__ = MySQLConnection(host='localhost', db='test', user='root',
passwd='', debug=1)

class Person(SQLObject):
    firstName       = StringCol(length=100)
    middleInitial   = StringCol(length=1, default=None)
    lastName        = StringCol(length=100)

class Test(Page):
    def title(self):
        return 'Test'

    def awake(self, trans):
        Page.awake(self, trans)
        # should I do connection here???

    def sleep(self, trans):
        Page.sleep(self, trans)
        # should I close connection here???

    def writeContent(self):
        self.writeln('<h1>Test of webware with sqlobject</h1>')
        people=Person.select(Person.q.firstName=='Adam')
        for person in people:
            self.writeln('<li>',person.firstName,' ', person.lastName)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

thanks,
mike