Changeset 37506

Timestamp:

Oct 20, 2014, 2:43:38 PM (12 years ago)

Author:

Serge CHASTEL

Message:

limited mysql transactions

File:

• trunk/mops/mops_ringsv3/populate_ringsv3_database.py (modified) (1 diff)

trunk/mops/mops_ringsv3/populate_ringsv3_database.py

@@ -58 +58 @@
 decProjectionCenter, cdecProjectionCenter, sdecProjectionCenter,
 xSkycellCenter, ySkycellCenter) VALUES (%%s, %%s, %%s, %%s, %%s, %%s, %%s, %%s, %%s)""" % tableName
-    print query
+    # print query
     remapped = zip(*data)
-    print
-    print query % remapped[0]
-    print
-    print remapped[0:5]
-    cursor.executemany(query, remapped)
+    # print
+    # print query % remapped[0]
+    # print
+    # print remapped[0:5]
+    begin = 0
+    step = 40000
+    while begin < len(remapped):
+        cursor.executemany(query, remapped[begin:begin+step])
+        begin += step
+    cursor.executemany(query, remapped[begin:-1])
     fits.close()
     cursor.close()