def status_get(): """Displays the latest mapping statistics""" status = service_status.get_status() if status is None: # We ensure we can connect to the database during the status check with db.DBConn() as conn: try: number_of_mappings = db.query_db(conn, ''' SELECT COUNT(*) FROM projects ''', one=True)['count'] except psycopg2.errors.UndefinedTable: safe_fail_request(500, "DB uninitialized") current_rate = db.get_latest_rate(conn) status = { 'status': 'ok', 'project_count': number_of_mappings, 'rate': current_rate } service_status.set_status(status) return status
def status_get(): """Displays the latest mapping statistics""" status = cache.get_status() if status is None: # We ensure we can connect to the database during the status check db1 = db.get_db() number_of_mappings = db.query_db(db1, ''' SELECT COUNT(*) FROM projects ''', one=True)['count'] current_rate = db.get_latest_rate(db1) status = { 'status': 'ok', 'project_count': number_of_mappings, 'rate': current_rate } cache.set_status(status) return status
def projects_get(): logger.info("Getting list of all projects") projects = db.query_db(get_db(), 'select project_id, time_added from projects') return ProjectList().dump(projects)
def projects_get(): logger.info("Getting list of all projects") with DBConn() as conn: projects = db.query_db(conn, 'select project_id, time_added from projects') return ProjectList().dump(projects)