def view_datasets(): datasets_pending = fetch_pending_tables(MetaTable) shapes_pending = fetch_pending_tables(ShapeMetadata) datasets = MetaTable.get_all_with_etl_status() shapesets = ShapeMetadata.get_all_with_etl_status() return render_template('admin/view-datasets.html', datasets_pending=datasets_pending, shapes_pending=shapes_pending, datasets=datasets, shape_datasets=shapesets)
def view_datasets(): datasets_pending = session.query(MetaTable).\ filter(MetaTable.approved_status != True).\ all() shapes_pending = session.query(ShapeMetadata).\ filter(ShapeMetadata.approved_status != True).\ all() try: q = text(''' SELECT m.*, c.status, c.task_id FROM meta_master AS m LEFT JOIN celery_taskmeta AS c ON c.id = ( SELECT id FROM celery_taskmeta WHERE task_id = ANY(m.result_ids) ORDER BY date_done DESC LIMIT 1 ) WHERE m.approved_status = 'true' ''') with engine.begin() as c: datasets = list(c.execute(q)) except NoSuchTableError: datasets = session.query(MetaTable)\ .filter(MetaTable.approved_status == True)\ .all() try: shape_datasets = ShapeMetadata.get_all_with_etl_status() except NoSuchTableError: # If we can't find shape metadata, soldier on. shape_datasets = None return render_template('admin/view-datasets.html', datasets_pending=datasets_pending, shapes_pending=shapes_pending, datasets=datasets, shape_datasets=shape_datasets)