import readdb
import sqlite3


def insert(pval):
    con = sqlite3.connect('FireDataHistory.db')
    cur = con.cursor()
    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[1],pval[2],int(pval[3]),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]),int(pval[14]),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]),int(pval[24]),float(pval[25])))
    con.commit()
    con.close()

pval = [0]
pval = pval + ['TACOMA CREEK']
pval = pval + [input('Date: ')]
pval = pval + ['13']
pval = pval + ['16Y2P']
pval = pval + [int(input('hr1: '))]
pval = pval + [int(input('hr10: '))]
pval = pval + [int(input('hr100: '))]
pval = pval + [int(input('hr1000: '))]
pval = pval + [int(input('hrb: '))]
pval = pval + [int(input('wdy: '))]
pval = pval + [int(input('ic: '))]
pval = pval + [int(input('sc: '))]
pval = pval + [int(input('ec: '))]
pval = pval + [int(input('bi: '))]
pval = pval + ['O']
pval = pval + [int(input('temp: '))]
pval = pval + [int(input('rh: '))]
pval = pval + [int(input('wdir: '))]
pval = pval + [int(input('wspd: '))]
pval = pval + [int(input('tmax: '))]
pval = pval + [int(input('tmin: '))]
pval = pval + [int(input('rhmax: '))]
pval = pval + [int(input('rhmin: '))]
pval = pval + [int(input('pdur: '))]
pval = pval + [int(input('pamt: '))]

insert(pval)
readdb.main()
input()