import urllib.request, json
import pymysql.cursors

cnx = pymysql.connect(user="bookzi_dk",
                      password="thispasswordisbad",
                      host='mysql73.unoeuro.com',
                      database='bookzi_dk_db')
cursor = cnx.cursor()

for i in range(14059, 99998):
    if i < 10000:
        print(i)
        try:
            with urllib.request.urlopen("http://api.zippopotam.us/DE/0" + str(i)) as url:
                data = json.loads(url.read().decode())
                query = ('INSERT INTO zipcode (zipcode, City) VALUES (%s, %s);')
                zipcode = data['post code']
                city = data['places'][0]['place name']
                cursor.execute(query, (zipcode, city))
                cnx.commit()
        except:
            print("no postnumber found!")

    elif i <= 99998:
        print(i)
        try:
            with urllib.request.urlopen("http://api.zippopotam.us/DE/" + str(i)) as url:
                data = json.loads(url.read().decode())
                query = ('INSERT INTO zipcode (zipcode, City) VALUES (%s, %s);')
                zipcode = data['post code']
                city = data['places'][0]['place name']
                cursor.execute(query, (zipcode, city))
                cnx.commit()
        except:
            print("no postnumber found!")