[update file data 2 patch] [fix] auto commit on many writes for the duration of the patch
diff --git a/patches/april_2013/p07_update_file_data_2.py b/patches/april_2013/p07_update_file_data_2.py
index 0cb44d0..548ba6c 100644
--- a/patches/april_2013/p07_update_file_data_2.py
+++ b/patches/april_2013/p07_update_file_data_2.py
@@ -2,6 +2,8 @@
def execute():
from patches.april_2013.p05_update_file_data import update_file_list, get_single_doctypes
+ webnotes.conn.auto_commit_on_many_writes = 1
+
singles = get_single_doctypes()
for doctype in webnotes.conn.sql_list("""select table_name from `information_schema`.`columns`
where table_schema=%s and column_name='file_list'""", webnotes.conn.cur_db_name):
@@ -13,4 +15,5 @@
webnotes.conn.sql("""delete from `tabCustom Field` where fieldname='file_list'
and parent=%s""", doctype)
-
\ No newline at end of file
+
+ webnotes.conn.auto_commit_on_many_writes = 0
\ No newline at end of file