Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement