def __call__(self):
dbsession = DBSession()
bases = dbsession.query(Base.loc_gal, func.count('*').\
label('base_count'), select(["FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(base.timestamp)))"]).label("average_age")).\
group_by(Base.loc_gal)
astros = dbsession.query(Location.loc_gal,func.count(Location.location).label('astro_count'))
astros = astros.group_by(Location.loc_gal)
galaxies = {}
for row in range(0,80):
galaxies["A%s"%twodigitNumbers(row)] = {}
for astro_location,astro_count in astros:
row = astro_location
galaxy_info = galaxies[row]
galaxy_info['astro_count'] = astro_count
galaxy_info['base_count'] = 0
galaxy_info['base_age'] = -1
for base_location, base_count, base_age in bases:
row = base_location
if row:
galaxy_info = galaxies[row]
galaxy_info['base_count'] = base_count
galaxy_info['base_age'] = getAgeColorTimedelta(datetime.now() - base_age)
galaxies[row] = galaxy_info
legenda = getAgeLegenda()
return {'galaxies':galaxies,
'legenda':legenda,
'datetime':datetime}
def makeLocationDict(dbsession, location, group1, group2, row_index, col_index, do_base=True):
if do_base:
bases = dbsession.query(func.substring(Base.location,group1,group2).label('location'), func.count('*').\
label('base_count'), select(["FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(base.timestamp)))"]).label("average_age")).\
group_by(func.substring(Base.location,group1,group2)).filter(Base.location.like("%s%%"%location))
astros = dbsession.query(Location.location,func.count(Location.location).label('astro_count'))
astros = astros.filter(Location.location.like("%s%%"%location))
astros = astros.group_by(func.substring(Location.location,group1,group2))
locations = {}
for row in range(0,10):
locations[row] = {}
for col in range(0,10):
locations[row][col]={'astro_count':0, 'base_count':0, 'base_age':{}}
for astro,astro_count in astros:
row = int(astro[row_index])
col = int(astro[col_index])
location_info = locations[row][col]
location_info['astro_count'] = astro_count
if do_base:
location_info['base_count'] = 0
location_info['base_age'] = {}
locations[row][col] = location_info
if do_base:
for base_location,base_count,base_age in bases:
row = int(base_location[-2])
col = int(base_location[-1])
location_info = locations[row][col]
location_info['base_count'] = base_count
location_info['base_age'] = getAgeColorTimedelta(datetime.now() - base_age)
locations[row][col] = location_info
return locations
