Anand Doshi | 9ca7e52 | 2011-12-22 15:05:14 +0530 | [diff] [blame] | 1 | import webnotes |
2 | def execute(): | ||||
3 | doc_type_list = webnotes.conn.sql("""SELECT DISTINCT parent FROM `tabDocField` where idx=0""") | ||||
4 | for doc_type in doc_type_list: | ||||
5 | if doc_type and doc_type[0]: | ||||
6 | webnotes.conn.sql("""\ | ||||
7 | UPDATE `tabDocField` SET idx=idx+1 | ||||
8 | WHERE parent=%s | ||||
9 | """, doc_type[0]) |