Advertisement
gantriis97

json_decode

Jun 4th, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. import pymysql.cursors
  2. import json
  3.  
  4. cnx = pymysql.connect(user ='root',
  5. password= '1234',
  6. host='127.0.0.1',
  7. database='Rossmann')
  8. cursor = cnx.cursor()
  9.  
  10. select = ("SELECT * FROM Filialen")
  11. cursor.execute(select)
  12. result = cursor.fetchall()
  13. cnx.close()
  14.  
  15. cnx = pymysql.connect(user ='root',
  16. password= '1234',
  17. host='127.0.0.1',
  18. database='Rossmann2')
  19. cursor = cnx.cursor()
  20.  
  21. for i in result:
  22. name = i[0]
  23. zipcode = i[2].split(",")[1].lstrip().split(" ")[0]
  24. city = i[2].split(",")[1].lstrip().split(" ")[1]
  25. adresse = i[2].split(",")[0]
  26. open1 = (i[3].split(",")[0].lstrip().replace("Mo-Fr ", "").split("-")[0]) + ".00"
  27. close1 = (i[3].split(",")[0].lstrip().replace("Mo-Fr ", "").split("-")[1]) + ".00"
  28. open2 = (i[3].split(",")[1].lstrip().replace("Sa ", "").split("-")[0]) + ".00"
  29. close2 = (i[3].split(",")[1].lstrip().replace("Sa ", "").split("-")[1]) + ".00"
  30.  
  31. cursor.execute('INSERT INTO json_file (Navn_Butik, Postnr, By_Navn, Adresse, Åben_manfre, Luk_manfre, Åben_lør, Luk_lør) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)',
  32. (name, zipcode, city, adresse, open1, close1, open2, close2))
  33.  
  34. with open ('/Users/Gantriis/Documents/Python/PythonMACOS/PyWS/Opgaver/src/Eksamen2/Rossmann.json') as data:
  35. database = json.load(data)
  36.  
  37. for i in database:
  38. name = i['name']
  39. zipcode = i['stadt'].split(' ')[0]
  40. city = i['stadt'].split(' ')[1]
  41. adresse = i['strasse']
  42. open1 = i['offen_mo-fr'].split('-')[0]
  43. close1 = i['offen_mo-fr'].split('-')[1].lstrip()
  44. open2 = i['offen_samstag'].split('-')[0]
  45. close2 = i['offen_samstag'].split('-')[1].lstrip()
  46.  
  47. cursor.execute('INSERT INTO json_file (Navn_Butik, Postnr, By_Navn, Adresse, Åben_manfre, Luk_manfre, Åben_lør, Luk_lør) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)',
  48. (name, zipcode, city, adresse, open1, close1, open2, close2))
  49. cnx.commit()
  50. cnx.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement