WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/scripts/UserGroupSegmentation.py

     cursor.execute(sql)
     result_data = cursor.fetchall()
     if result_data:
         for record_data in result_data:
+            updateUserGroup = False
             print record_data[0]
+            checkForCurrentRecord = "select * from usergroup where user_ids like '%%s%' or mobileNos like '%%s%' or imeis like '%%s%' or referrers like '%%s%'"%(record_data[0], record_data[1], record_data[2], record_data[3])
+            print checkForCurrentRecord
+            '''
+            cursor.execute(checkForCurrentRecord)
+            currentRecord = cursor.fetchone()
+            if currentRecord is not None:
+                if currentRecord[0] != record_data[0]:
+                    updateUserGroup = True
+            '''
             sql = "insert into usergroup (user_ids, mobileNos, imeis, referrers) values('%s', '%s', '%s', '%s')"%(record_data[0], record_data[1], record_data[2], record_data[3])
             print sql
+            '''
+            try:
+                cursor.execute(sql)
+                db.commit()
+            except:
+                # Rollback in case there is any error
+                db.rollback()
+            '''
 '''
     # initialize rownum variable
     rownum = 0
     message="""<html>

Subversion Repositories SmartDukaan