import sqlite3
import codecs
f = open('../airplanesbydate.html', 'w')
con = sqlite3.connect((r'../virtualRadar.sqb')
cur = con.cursor()
#cur.execute('SELECT COUNT(*) from Aircraft')
#cur_result = cur.fetchone()
#print(cur_result)
#cur.execute('SELECT COUNT(*) from Flights')
#cur_result = cur.fetchone()
#rows = cur_result[0]
#print(rows)
sql = 'select Flights.StartTime, Flights.Callsign, Aircraft.Registration, Aircraft.ICAOTypeCode from Flights INNER JOIN Aircraft on Flights.AircraftID = Aircraft.AircraftID group by Registration order by Flights.StartTime DESC'
#sql = 'select Flights.StartTime, Flights.Callsign, Aircraft.Registration, Aircraft.ICAOTypeCode from Flights INNER JOIN Aircraft on Flights.AircraftID = Aircraft.AircraftID group by Registration'
cur.execute(sql)
cur_result = cur.fetchall()
#cur_result = cur.fetchone()
#row = cur_result[0]
#print(row)
#row = cur.fetchall()
# the html code which will go in the file airplanes.html
html_head = """
Airplane Links
| Reg | CS | AType | Date |
|---|
"""
html_foot = """
"""
f.write(html_head)
for row in cur_result:
#print("ID ", row[0], "Reg ", row[1] )
mylink = '| ' + str(row[2]) + ' | ' + str(row[1]) + ' | ' + str(row[3]) + ' | ' + str(row[0]) + ' |
'
f.write(str(mylink))
#assert row[0] == row["Reg"]
#assert row["name"] == row["nAmE"]
#assert row[1] == row["age"]
#assert row[1] == row["AgE"]
f.write(html_foot)
f.close()
con.close()