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



    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:

Rev 15120	Rev 15121
Line 211...	Line 211...
211	`result_data = cursor.fetchall()`	211	`result_data = cursor.fetchall()`
212	`if result_data:`	212	`if result_data:`
213	`for record_data in result_data:`	213	`for record_data in result_data:`
214	`updateUserGroup = False`	214	`updateUserGroup = False`
215	`print record_data[0]`	215	`print record_data[0]`
216	`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])`	216	`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])`
217	`print checkForCurrentRecord`	217	`print checkForCurrentRecord`
218	`'''`	218	`'''`
219	`cursor.execute(checkForCurrentRecord)`	219	`cursor.execute(checkForCurrentRecord)`
220	`currentRecord = cursor.fetchone()`	220	`currentRecord = cursor.fetchone()`
221	`if currentRecord is not None:`	221	`if currentRecord is not None:`

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/scripts/UserGroupSegmentation.py – Rev 15120 → 15121