Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import json
- import pymysql
- conn = pymysql.connect(host=DB_HOST, user=DB_USER, password=DB_PASSWD,
- db=DB_NAME, charset='utf8')
- with open("input.json", encoding="utf-8") as open_file:
- data = json.load(open_file)
- for k in data["inputList"]:
- print (k)
- print(",".join(k), k.values())
- with conn.cursor() as cursor:
- for k in data["inputList"]:
- cs = ",".join(k)
- cc = 'uid', 'board_id', 'parent_uid', 'member_uid', 'member_display', 'title', 'content', 'date', 'update', 'view', 'comment', 'like', 'unlike', 'vote', 'thumbnail_name', 'thumbnail_file', 'category1', 'search'
- d1a= "'"+k['uid']+"'","'"+k['board_id']+"'","'"+k['parent_uid']+"'","'"+k['member_uid']+"'","'"+k['member_display']+"'","'"+k['title']+"'","'"+k['content']+"'","'"+k['date']+"'","'"+k['update']+"'","'"+k['view']+"'","'"+k['comment']+"'","'"+k['like']+"'","'"+k['unlike']+"'","'"+k['vote']+"'","'"+k['thumbnail_name']+"'","'"+k['thumbnail_file']+"'","'"+k['category1']+"'","'"+k['search']+"'"
- sql = "INSERT INTO wp_kboard_board_content (%s) VALUES (%s)"
- print(cc)
- cursor.execute(sql,(cc,d1a))
- conn.commit()
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement