import json
#import pymysql.cursors


cnx = pymysql.connect(user='root', password='1234', host='127.0.0.1', database='Eksamen_Normal')
cursor = cnx.cursor()
  #Hent data

j =json.loads( open("Rossmann.json").read())


for i in range (len(j)):
    strasse = (j[i]["strasse"])
    offensamstag = (j[i]["offen_samstag"])
    offenmofr = (j[i]["offen_mo-fr"])
    kette = (j[i]["kette"])
    postnummer = (j[i]["stadt"]) . split (" ") [0]
    by = (j[i]["stadt"]) . split (" ") [1]
    name = (j[i]["name"]) #VI har droppet name

print(strasse)
print (offenmofr)
print(offensamstag)
print(kette)


 cursor.execute("INSERT INTO åbningstider (tid) VALUES (%s)",str(offensamstag))
 cnx.commit()
#     cursor.execute("INSERT INTO åbningstider (tid) VALUES (%s)",str(offenmofr))
#     cnx.commit()
#     cursor.execute("INSERT INTO postnummer (postnummer) VALUES (%s)",str(postnummer))
#     cursor.execute("INSERT INTO by (by) VALUES (%s)",str(by))
#     cursor.execute("INSERT INTO kæde (kæde) (%s)",str(kette))