def get_all_eclipses(engine): lats = [] lons = [] data = run_query(engine, 'lat, long', 'eclipselc').fetchall() for d in data: lats.append(d[0]) lons.append(d[1]) return lats, lons
def get_all_conflicts(engine): lats = [] lons = [] data = run_query(engine, 'lat, long', 'conflictlc').fetchall() for d in data: lats.append(d[0]) lons.append(d[1]) return lats, lons
def get_eclipse_coords(engine, year): coords = run_query(engine, 'distinct lat, long', 'eclipse', 'where calendardate_year = {}'.format(year)).fetchall() lats = [] lons = [] for coord in coords: lats.append(coord[0]) lons.append(coord[1]) lats, lons = to_num(lats, lons) return lats, lons
def get_eclipse_data(engine, lat, lon, year): lat, lon = to_str([ lat, ], [ lon, ]) return run_query( engine, 'calendardate, central_dur, ecl_type, sun_alt, path_width', 'eclipse', "where lat = '{}' and long = '{}' and calendardate_year = {}".format( lat[0], lon[0], year)).fetchall()
def get_confinfo_data(engine, lat, lon, year): loc = get_loc_from_coords_db(engine, [ lat, ], [ lon, ], 'conflictlc')[0][0][0] return run_query( engine, 'location, sidea, sideb, territoryname, startdate, ependdate', 'conflict', "where year = {} and location like '%%{}%%'".format(year, loc), '', 'order by location, startdate, sidea, sideb, territoryname').fetchall( )
def get_minyear(engine): return run_query(engine, 'min(year)', 'conflict').fetchall()[0][0]
def get_eclipse_data(engine, lat, lon, year): lat, lon = to_str([lat,], [lon,]) return run_query(engine, 'calendardate, central_dur, ecl_type, sun_alt, path_width', 'eclipse', "where lat = '{}' and long = '{}' and calendardate_year = {}".format(lat[0], lon[0], year)).fetchall()
def get_confinfo_data(engine, lat, lon, year): loc = get_loc_from_coords_db(engine, [lat,], [lon,], 'conflictlc')[0][0][0] return run_query(engine, 'location, sidea, sideb, territoryname, startdate, ependdate', 'conflict', "where year = {} and location like '%%{}%%'".format(year, loc), '', 'order by location, startdate, sidea, sideb, territoryname').fetchall()
def get_export_typeprice(engine, year): typeprice = run_query(engine, 'type, price', 'export', 'where year = {}'.format(year)).fetchall() return typeprice
def get_coords_db(engine, tablename, wh_cond, orderby = ''): coords = run_query(engine, 'distinct lat, long', tablename, wh_cond, '', orderby).fetchall() return coords[0][0], coords[0][1]
def get_locs_db(engine, tablename, wh_cond, orderby = ''): return run_query(engine, 'distinct location', tablename, wh_cond, '', orderby).fetchall()
def get_coords_db(engine, tablename, wh_cond, orderby=''): coords = run_query(engine, 'distinct lat, long', tablename, wh_cond, '', orderby).fetchall() return coords[0][0], coords[0][1]
def get_locs_db(engine, tablename, wh_cond, orderby=''): return run_query(engine, 'distinct location', tablename, wh_cond, '', orderby).fetchall()