[Modeling-cvs] ProjectModeling/Modeling/DatabaseAdaptors/MySQLAdaptorLayer MySQLAdaptorChannel.py,1.1,1.2

[<sbi...@us...>]

Update of /cvsroot/modeling/ProjectModeling/Modeling/DatabaseAdaptors/MySQLAdaptorLayer
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23227/Modeling/DatabaseAdaptors/MySQLAdaptorLayer

Modified Files:
	MySQLAdaptorChannel.py 
Log Message:
Fixed generation of PK: two threads could get the same id

Index: MySQLAdaptorChannel.py
===================================================================
RCS file: /cvsroot/modeling/ProjectModeling/Modeling/DatabaseAdaptors/MySQLAdaptorLayer/MySQLAdaptorChannel.py,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** MySQLAdaptorChannel.py	10 Jan 2003 10:45:45 -0000	1.1
--- MySQLAdaptorChannel.py	17 Feb 2004 18:53:40 -0000	1.2
***************
*** 80,84 ****
        pkRootName=anEntity.primaryKeyRootName()
        statements=["UPDATE PK_SEQ_%s SET id=LAST_INSERT_ID(id+1)"%pkRootName,
!                   "select id FROM PK_SEQ_%s"%pkRootName]
        result=[]
        for idx in range(count):
--- 80,84 ----
        pkRootName=anEntity.primaryKeyRootName()
        statements=["UPDATE PK_SEQ_%s SET id=LAST_INSERT_ID(id+1)"%pkRootName,
!                   "select LAST_INSERT_ID()"]
        result=[]
        for idx in range(count):