daily pastebin goal
14%
SHARE
TWEET

Untitled

a guest Apr 21st, 2017 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. parsed_string = json.loads(json_string)
  2. cursor.execute("update Table set Status = ? where Name like ? ",(json.dumps(parsed_string), "Blabla"))
  3. cnxn.commit()
  4.    
  5. cursor.execute("""select Status from Table where Name like ?""", "Blabla")
  6. cursor.fetchall()
  7.    
  8. "{"orderID": 42, "orderContents": [{"productName": "keyboard", "quantity": 1, "productID": 23}, {"productName": "mouse", "quantity": 1, "productID": 13}],
RAW Paste Data
Top