Re: [SQLObject] Temporary databases / Closing the :memory: database connection

[Petr J. <pet...@tp...>]

On 17 October 2013 17:26, Oleg Broytman <ph...@ph...> wrote:

> Do you close and reopen the memory database in you program(s)?



Nope. I am only creating table once at the start of the program:

connectionInMemory = connectionForURI('sqlite:/:memory:')

class TextyServisnihoDispleje(SQLObject):
    _connection = connectionInMemory
    level=StringCol(length=1, default=None)
    text=UnicodeCol(length=20, default=None)
    cislovatRadek=EnumCol(enumValues=('Y','N'), default='Y')
    akce=StringCol(length=100, default=None)
    predek=ForeignKey("TextyServisnihoDispleje", default=None)
    potomci=MultipleJoin("TextyServisnihoDispleje", joinColumn="predek_id")

TextyServisnihoDispleje.createTable()