Guest User

Untitled

a guest
May 26th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. def process(form, path):
  2. po = pandas.read_json(path)
  3. #
  4. sql = "INSERT INTO jd_form_data (" \
  5. "`create_time`, " \
  6. "`update_time`, " \
  7. "`deliver_id`, " \
  8. "`form`, " \
  9. "`data_id`, " \
  10. "`form_data` " \
  11. ") VALUES "
  12. for row in po.iterrows():
  13. data_id = row[1]["_id"]
  14. form_data = row[1].to_json()
  15. form_data = json.loads(form_data)
  16. form_data = {"data": form_data}
  17. form_data = json.dumps(form_data)
  18. sql += " (now(),now(),'{}','{}','{}','{}'),".format(form + data_id, form, data_id, form_data)
  19. #
  20. sql = sql[0:len(sql) - 1]
  21. sql += " on duplicate key update " \
  22. "form_data=values(form_data)"
  23. cur.execute(sql)
  24. con.commit()
Add Comment
Please, Sign In to add comment