import sqlite3
#from datetime import datetime

# Open and read health data file one line at a time
file = open("FireDataHistoryTable.csv", "r")
con = sqlite3.connect('FireDataHistory.db')
cur = con.cursor()
for aline in file:
    pval = aline.split(',')

    # Skip known header
    if pval[0] == 'STATION':
        pass
    else:
        val = pval[24]
        tf = val.find('\n')
        upval = [val[:tf]]
        pval[24] = upval[0]



        cur.execute("INSERT INTO firedata (station, date, time, model, hr1, hr10, hr100, hr1000, hrb, wdy, ic, sc, ec, bi, type, temp, rh, wdir, wspd, tmax, tmin, rhmax, rhmin, pdur, pamt) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
                    (pval[0],pval[1],int(pval[2]),pval[3],int(pval[4]),int(pval[5]),int(pval[6]),int(pval[7]),int(pval[8]),int(pval[9]),int(pval[10]),int(pval[11]),int(pval[12]),int(pval[13]),pval[14],int(pval[15]),int(pval[16]),int(pval[17]),int(pval[18]),int(pval[19]),int(pval[20]),int(pval[21]),int(pval[22]),int(pval[23]),float(pval[24])))

        con.commit()

for row in cur.execute('SELECT * FROM firedata WHERE station = "TACOMA CREEK" ORDER BY date DESC'):
    print(row)

# Close file
file.close()
cur.close()
con.close()

input()