# -*- coding: utf-8 -*-
"""
Created on Mon Jan  2 13:11:57 2023

@author: corey
"""

import MySQLdb
import tdameritradedata as marketData
import datetime

values = []

db = MySQLdb.connect(host="a2nlmysql13plsk.secureserver.net",  # your host 
                     user="coreypace",       # username
                     passwd="Aud12rey",     # password
                     db="FarmBusiness")   # name of the database

cur = db.cursor()

# tradeDate = datetime.date.today()
tradeDate = datetime.date(1971,3,7)

data = marketData.GetData(tradeDate)
for record in data:
    x = data[record]
    values = []
    try:
        values = [x['cropCode'], x['monthCode'], x['contractYear'], x['shortSymbol'], x['tradeDate'], x['open'], x['high'],x['low'],x['last'], x['volume'],0]
        # cur.execute('insert into MarketHistory (Crop, Contract, Year, Symbol, Date, Open, High, Low, Close, Vol, OI) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', values)
        # db.commit()
    except:
        continue
    
db.close()