def wban2CallSign(wban_code):
sql = "SELECT call_sign FROM weather_stations where wban_code='%s'" % wban_code
result = engine.execute(sql)
#print "result=", result
x = result.first()
cs = None
if x:
cs = x[0]
#print "wban=", wban
else:
print "could not find wban:", wban_code
return cs
def callSign2Wban(call_sign):
sql = "SELECT wban_code FROM weather_stations where call_sign='%s'" % call_sign
result = engine.execute(sql)
#print "result=", result
x = result.first()
wban = None
if x:
wban = x[0]
#print "wban=", wban
#print "found call sign:", call_sign, "wban=", wban
return wban
else:
#print "could not find call sign:", call_sign
return None
def all_callSigns():
sql = "SELECT call_sign FROM weather_stations ORDER by call_sign"
result=engine.execute(sql)
return [x[0] for x in result.fetchall()]
