On Sat, Feb 16, 2008 at 09:37:58PM -0500, Nathan Edwards wrote:
> sqlhub.processConnection = connectionForURI(connuri)
> 
> class AAA(SQLObject):
>      class sqlmeta:
>          createSQL = {'mysql': 'ALTER TABLE aa_a ENGINE InnoDB'}
>          cacheValues = False
>      value = IntCol(alternateID=True)
> 
> def thr1():
>      localData = threading.local()
>      localData.conn = connectionForURI(connuri)

   Shouldn't that be
sqlhub.threadConnection = connectionForURI(connuri)
   ?

>      for i in range(1000):
>          try:
>              a = AAA(value=1,connection=localData.conn)
>          except dberrors.DuplicateEntryError:
>              a = AAA.byValue(1,connection=localData.conn)

     for i in range(1000):
         try:
             a = AAA(value=1)
         except dberrors.DuplicateEntryError:
             a = AAA.byValue(1)

> AAA.dropTable(ifExists=True)
> AAA.createTable()
> 
> for i in range(20):
>      t = threading.Thread(target=thr1,args=())
>      t.start()

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            [EMAIL PROTECTED]
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to