Changeset 37508

Timestamp:

Oct 20, 2014, 2:45:29 PM (12 years ago)

Author:

Serge CHASTEL

Message:

limited mysql transactions

File:

• trunk/mops/mops_ringsv3/populate_ringsv3_database.py (modified) (2 diffs)

trunk/mops/mops_ringsv3/populate_ringsv3_database.py

@@ -53 +53 @@
              table.field('CRPIX1'), table.field('CRPIX2'),
              ]
-    cursor = database.cursor()
     query = """INSERT INTO %s (skycell, 
 raProjectionCenter, craProjectionCenter, sraProjectionCenter, 
@@ -67 +66 @@
     step = 10000
     while begin < len(remapped):
+        cursor = database.cursor()
         cursor.executemany(query, remapped[begin:begin+step])
+        cursor.close()
+        database.commit()
         begin += step
     cursor.executemany(query, remapped[begin:-1])