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