>>> from storm.locals import *

>>> class Book(object):

...     __storm_table__="book"

...     id=Int(primary=True)

...     name=Unicode()

...     npages=Int()

>>> db=create_database("sqlite:")

>>> store=Store(db)

>>> store.execute("CREATE TABLE book (id INTEGER PRIMARY KEY, name VARCHAR, npages INTEGER)")

>>> rbook.name=u"Introduction to Ruby"

>>> rbook.npages=210

>>> print rbook.id, rbook.name, rbook.npages

None Introduction to Ruby 210

>>> store.add(rbook)

<__main__.Book object at 0xb78aecac>

>>> print rbook.id, rbook.name, rbook.npages

None Introduction to Ruby 210

>>> 

>>> pybook.name=u"PyGuide"

>>> pybook.npages=230

>>> print pybook

<__main__.Book object at 0xb78ae80c>

>>> store.add(pybook)

<__main__.Book object at 0xb78ae80c>

>>> pythonbook=store.find(Book, Book.name==u"PyGuide").one()

>>> pythonbook.name

u'PyGuide'

>>> store.get(Book, 1).name

u'Introduction to Ruby'

>>> store.flush()

>>> store.get(Book, 1).id

1

>>> pythonbook=store.find(Book, Book.name==u"PyGuide").one()

>>> pythonbook.id

2

>>> from sqlobject import *

>>> 

>>> sqlhub.processConnection=connectionForURI('sqlite:/:memory:')

>>> 

>>> class Book(SQLObject):

...     title=StringCol()

...     npages=IntCol()

>>> Book.createTable()

[]

>>> rbbook=Book(title="Introduction to Ruby", npages=230)

>>> rbbook.title

'Introduction to Ruby'

>>> rbbook.npages

230

>>> rbbook

<Book 1 title="'Introduction to ...'" npages=230>


>>> pybook="PyGuide"

>>> pybook=Book(title="PyGuide, npages=330")

>>> pybook=Book(title="PyGuide", npages=330)

>>> pybook

<Book 2 title='PyGuide' npages=330>

>>> Book.get(1)

<Book 1 title="'Introduction to ...'" npages=230>

>>> book=Book.get(2)

>>> book

<Book 2 title='PyGuide' npages=330>

>>> books=Book.select()

>>> list(books)

[<Book 1 title="'Introduction to ...'" npages=230>, <Book 2 title='PyGuide' npages=330>]

>>> rbbooks=Book.select(Book.q.title=="Introduction to Ruby")

>>> list(rbbooks)

[<Book 1 title="'Introduction to ...'" npages=230>]

<Book 2 title='PyGuide' npages=330>

>>> pybook.npages=230

>>> pages230=Book.selectBy(npages=230)

>>> list(pages230)

[<Book 1 title="'Introduction to ...'" npages=230>, <Book 2 title='PyGuide' npages=230>]