Subversion Repositories SmartDukaan

Rev

Rev 15804 | Rev 15806 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15804 Rev 15805
Line 124... Line 124...
124
124
125 
    cursor.execute(userGroupSegmentationQuery)
 125 
    cursor.execute(userGroupSegmentationQuery)
126 
    allUserGroups = cursor.fetchall()
 126 
    allUserGroups = cursor.fetchall()
127 
    for userGroup in allUserGroups:
 127 
    for userGroup in allUserGroups:
128 
        sql = "insert into pushnotificationusergroups (brand, userids, min_price, max_price, pricerange, category_id) values('%s', '%s', %f, %f, '%s', %d)"%(userGroup[0], userGroup[1], userGroup[2], userGroup[3], userGroup[4], userGroup[5])
 128 
        sql = "insert into pushnotificationusergroups (brand, userids, min_price, max_price, pricerange, category_id) values('%s', '%s', %f, %f, '%s', %d)"%(userGroup[0], userGroup[1], userGroup[2], userGroup[3], userGroup[4], userGroup[5])
- 
 
 129 
        print sql
129 
        try:
 130 
        try:
130 
            dtrdb = MySQLdb.connect('localhost',"root","shop2020","dtr" )
 131 
            dtrdb = MySQLdb.connect('localhost',"root","shop2020","dtr" )
131 
            cursor = dtrdb.cursor()
 132 
            cursor = dtrdb.cursor()
132 
            cursor.execute(sql)
 133 
            cursor.execute(sql)
133 
            dtrdb.commit()
 134 
            dtrdb.commit()