import sqlite3
import codecs
from ftplib import FTP
f = open('./airplanes_G.html', 'w')
con = sqlite3.connect(r'../virtualRadar.sqb',
detect_types=sqlite3.PARSE_DECLTYPES |
sqlite3.PARSE_COLNAMES)
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)
#this_year = datetime.date(datetime.date.today().isocalendar()[0], 1, 1)
#this_year = datetime.date(datetime.date.today().isocalendar()[0], 1, 1)
#this_year = (DT.date(DT.date.today().isocalendar()[0], 1, 1))
#print(this_year)
#currentDateTime = datetime.datetime.now()
#print(currentDateTime)
sql = "select Flights.StartTime, Flights.Callsign, Aircraft.Registration, Aircraft.ICAOTypeCode , Aircraft.Type, Aircraft.RegisteredOwners, Aircraft.YearBuilt from Flights INNER JOIN Aircraft on Flights.AircraftID = Aircraft.AircraftID where Flights.Callsign like 'DCM%' group by Registration order by Flights.StartTime DESC"
#sql = 'select Flights.StartTime, Flights.Callsign, Aircraft.Registration, Aircraft.ICAOTypeCode, Aircraft.Type, Aircraft.RegisteredOwners, Aircraft.YearBuilt from Flights INNER JOIN Aircraft on Flights.AircraftID = Aircraft.AircraftID group by Registration'
# WHERE StartTime BETWEEN JulianDay(\'now\') AND JulianDay(\'now\',\'+1 day\',\'-0.001 second\')
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 Info 1.0
| REG | CS | A Type | DATE | INFO | OWNER | M YEAR |
|---|
"""
html_foot = """
"""
f.write(html_head)
for row in cur_result:
#print("ID ", row[0], "Reg ", row[1] )
callsign=str(row[2])
callsign=callsign.strip("-")
mylink = '| ' + str(row[2]) + ' | ' + str(row[1]) + ' | ' + str(row[3]) + ' | ' + str(row[0]) + ' | ' + str(row[4]) + ' | ' + str(row[5]) + ' | ' + str(row[6]) + ' |
'
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()