import json
import psycopg2

# I wrote all of DB queries in 'query.py' file
import query as q

# And load json file like this, I renamed the file [data.json]
jsonfile = open('data.json', 'r')
data = json.load(jsonfile)

# establish connection to database
conn = psycopg2.connect(
    "host=localhost dbname='bluetechsoft' user=postgres password=password")
cur = conn.cursor()

# By review_object I mean a single review in json file
for review_object in data:
    cur.execute(q.review_data_insertion,
                (review_object['points'], review_object['title'],
                 review_object['description'], review_object['taster_name'],
                 review_object['taster_twitter_handle'],
                 review_object['price'], review_object['designation'],
                 review_object['variety'], review_object['region_1'],
                 review_object['region_2'], review_object['province'],
                 review_object['country'], review_object['winery']))

conn.commit()
conn.close()