Re: Temporary databases / Closing the :memory: database connection

On 17 October 2013 17:26, Oleg Broytman <[email protected]> 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()

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk

_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss