def get_station_vector(self,query,FCC_db,FCC_db_name):
SH = Sqlite_Helper(FCC_db,FCC_db_name)
conn,cursor = SH.set_db()
stations = {}
for callsign in query:
cursor.execute("SELECT * FROM {tn} WHERE callsign = '{callsign}'".\
format(tn = FCC_db_name,callsign = callsign))
results = cursor.fetchall()
if results:
results = results[0]
type = results['type'].encode('ASCII')
trans_lat = results['trans_lat']
trans_lon = results['trans_lon']
if type == 'FM':
reach_lats,reach_lons = Sqlite_Helper.get_reach_vector(self,results)
average_reach = Sqlite_Helper.get_average_reach(self,trans_lat,trans_lon,reach_lats,reach_lons)
else:
average_reach = 50
stations[results['callsign'].encode('ASCII')] = {'trans_lat':trans_lat,'trans_lon':trans_lon,'average reach':average_reach}
conn.close()
return stations
