Comments by Megan van Bommel (Top 14 by date)

The code is working now in Python, but there were no values loaded. So id is not loading in an another table. This is the code:

# Fact_purchase
for fact_sales in processed_response:
cursor.execute("""
SELECT cinema_id, movie_id, booking_id, date_id
FROM dim_cinema, dim_movie, dim_booking, dim_date
WHERE cinema_name = '"""+cinema_name+"""'
AND cinema_location = '"""+cinema_location+""""'
OR Movie_Distributor = '"""+movie_distributor+"""'
OR Movie_Title = '"""+movie_title+""""'
OR booking_size = '"""+booking_size+"""'
OR booking_age = '"""+booking_age+""""'
OR date_purchase = '"""+date_purchase+"""'
OR date_vacation = '"""+date_vacation+""""'
OR date_week = '"""+date_week+""""'
OR date_month = '"""+date_month+""""'
""")

try:
cursor.execute(sql)
for result in cursor:
bioscoop_id = result['bioscoop_id']
cinema_id= dim_cinema['cinema_id']
movie_id= dim_movie['movie_id']
booking_id= dim_booking['booking_id']
movie_id= dim_movie['movie_id']
db.commit()

except Exception as e:
print(e)
db.rollback()

# Then, we insert the new record in the fact table, together with the values
# Revenue & Costs come from the API call
# Bioscoop_id was retrieved from the dimension table
try:
cursor.execute("INSERT INTO fact_sales (cinema_id, movie_id, booking_id, date_id) VALUES ('"+str(cinema_id)+"', '"+str(movie_id)+"', '"+str(booking_id)+"', '"+str(date_id)+"'")
db.commit()

except Exception as e:
print(e)
db.rollback()