Subversion Repositories SmartDukaan

Rev

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

Rev 16357 Rev 16358
Line 136... Line 136...
136
            category_id=r[3] 
136
            category_id=r[3] 
137
        source=r[5]
137
        source=r[5]
138
        count=r[4]
138
        count=r[4]
139
        weight=r[6]
139
        weight=r[6]
140
        
140
        
141
        sql = "insert into userlinkssegmentation (user_id, product_name, brand, category_id, source, count,weight) values(%s, '%s', '%s', %s, '%s', %s,%s)"
141
        sql = "insert into userlinkssegmentation (user_id, product_name, brand, category_id, source, count,weight) values(%s, %s, %s, %s, %s, %s,%s)"
142
        print sql + ' ' +str(product_name)
142
        print sql + ' ' +str(product_name)
143
        cursor.execute(sql,(user_id,product_name,brand, category_id, source, count,weight))
143
        cursor.execute(sql,(user_id,product_name,brand, category_id, source, count,weight))
144
        conn.commit()
144
        conn.commit()
145
 
145
 
146
    conn.close()
146
    conn.close()