import sqlite3
from datetime import datetime


def main():
    #import sqlite3
    #from datetime import datetime
    con = sqlite3.connect('FireDataHistory.db')
    cur = con.cursor()

#Create table
    #cur.execute('''CREATE TABLE firedata(station text, date text, time int)''')
    cur.execute('''CREATE TABLE firedata(station text, date text, time int, model text, hr1 int, hr10 int, hr100 int, hr1000 int, hrb int, wdy int, ic int, sc int, ec int, bi int, type text, temp int, rh int, wdir int, wspd int, tmax int, tmin int, rhmax int, rhmin int, pdur int, pamt real)''')

#Insert a row of data
    #cur.execute("""INSERT INTO firedata VALUES ('Tacoma','07-18-2021',13)""")

# Save (commit) the changes
    #con.commit()
    #for row in cur.execute('SELECT * FROM firedata WHERE station = "Tacoma" ORDER BY date DESC'):
        #print(row)
    con.commit()
    con.close()

    input()

 
main()