Hi all,
Ik ben nieuw op dit forum, en ik heb een probleempje bij het scripten.
Hopelijk kunnen jullie mij hierbij helpen!
Het wilt bij mij gewoon niet werken..
code:
#Paramters
import pymysql
import json
import requests
import datetime
#Parameters:
api_url = "https://my.api.mockaroo.com/"
host = "localhost"
username = "x"
password = "x"
database = "bimbdk89"
# get 50 rows of data from API
response = requests.get(api_url)
print("API response status: " + str(response.status_code))
# return_code 200 is ok, codes die beginnen met 30, 40 of 50 zijn errors
processed_response = response.json()
# connecting to database
db = pymysql.connect(host, username, password, database)
# prepare a cursor object for temporary results
cursor = db.cursor()
def convert_to_mysql_date (input_date):
if not input_date:
return "NULL"
else:
return (
datetime.datetime.strptime(input_date,
"%m/%d/%Y").date().strftime("%Y/%m/%d")
)
for purchase in processed_response:
purchase_date = datetime.date (2019, 1, 1)
date = datetime
#check if values are None, then continue
if purchase_date == None:
continue
#select all from dimension date
cursor.execute("""
SELECT * from dim_datum
WHERE purchase_date = '"""+purchase_date+"""'
""")
resultcount = cursor.rowcount
if resultcount == 0:
#insert into SQL
sql = """
INSERT INTO dim_datum (purchase_date)
VALUES ('"""+purchase_date+"""')
"""
#execute
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
Mvg,
Kirsten