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()]