# Database for database/Rossman

import pymysql
import json
import pymysql.cursors

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

    #hent data
    cursor.execute("SELECT* FROM filialen")
    results=cursor.fetchall()
    exist= cursor.fetchone()

    cnx.close()

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

    # Formater data

    print(results)
    for i in results:
        name = i[0]
        adresse_ = i[2].split(",")[0]
        zipcode =i[2].split(",")[1].lstrip().split(' ')[0]
        zipcode_area=i[2].split(",")[1].lstrip().split(' ')[1]

        query = ('INSERT INTO TyskKonkurenter (Navne_Butik, Postnr, By_Navn, Adresse) VALUES (%s, %s, %s, %s);')
        cursor.execute(query, (name, zipcode, zipcode_area, adresse_))
        #luk forbindelse til db



    cnx.commit()
    cnx.close()

butikker()