import sqlite3
import codecs
f = open('./airplaneslist.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 |
|---|
"""
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]) + " |
"
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()