json_decode

''' Gantriis '''

import pymysql.cursors
import json

cnx = pymysql.connect(user ='root',
                      password= '1234',
                      host='127.0.0.1',
                      database='Rossmann')
cursor = cnx.cursor()

select = ("SELECT * FROM Filialen")
cursor.execute(select)
result = cursor.fetchall()
cnx.close()

cnx = pymysql.connect(user ='root',
                      password= '1234',
                      host='127.0.0.1',
                      database='Rossmann2')
cursor = cnx.cursor()

for i in result:
    name = i[0]
    zipcode = i[2].split(",")[1].lstrip().split(" ")[0]
    city = i[2].split(",")[1].lstrip().split(" ")[1]
    adresse = i[2].split(",")[0]
    open1 = (i[3].split(",")[0].lstrip().replace("Mo-Fr ", "").split("-")[0]) + ".00"
    close1 = (i[3].split(",")[0].lstrip().replace("Mo-Fr ", "").split("-")[1]) + ".00"
    open2 = (i[3].split(",")[1].lstrip().replace("Sa ", "").split("-")[0]) + ".00"
    close2 = (i[3].split(",")[1].lstrip().replace("Sa ", "").split("-")[1]) + ".00"

    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)',
                (name, zipcode, city, adresse, open1, close1, open2, close2))

with open ('/Users/Gantriis/Documents/Python/PythonMACOS/PyWS/Opgaver/src/Eksamen2/Rossmann.json') as data:
    database = json.load(data)

for i in database:
    name = i['name']
    zipcode = i['stadt'].split(' ')[0]
    city = i['stadt'].split(' ')[1]
    adresse = i['strasse']
    open1 = i['offen_mo-fr'].split('-')[0]
    close1 = i['offen_mo-fr'].split('-')[1].lstrip()
    open2 = i['offen_samstag'].split('-')[0]
    close2 = i['offen_samstag'].split('-')[1].lstrip()

    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)',
                    (name, zipcode, city, adresse, open1, close1, open2, close2))
cnx.commit()
cnx.close()