Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. postconn = mysql.connector.connect(user='root', password='Infinity8', host='127.0.0.1', database='geodb')
  2. postcursor = postconn.cursor() # creating cursor
  3. ....
  4. print ("currently selected ID: ", mydata[0])
  5. sql_update_flag = """ UPDATE REQUESTS SET fl_ready = {0} WHERE request_id={1} """.format(set_flag, current_id)
  6. print (sql_update_flag)
  7. print ("Before commit")
  8. currSrc.execute(sql_update_flag)
  9. print "after commit"
  10. connSrc.commit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement