def get_object_counts(): status = {} status["queries_count"] = Query.query.count() if settings.FEATURE_SHOW_QUERY_RESULTS_COUNT: status["query_results_count"] = QueryResult.query.count() status["unused_query_results_count"] = QueryResult.unused().count() status["dashboards_count"] = Dashboard.query.count() status["widgets_count"] = Widget.query.count() return status
def get_object_counts(): status = {} status['queries_count'] = Query.query.count() if settings.FEATURE_SHOW_QUERY_RESULTS_COUNT: status['query_results_count'] = QueryResult.query.count() status['unused_query_results_count'] = QueryResult.unused().count() status['dashboards_count'] = Dashboard.query.count() status['widgets_count'] = Widget.query.count() return status
def get_object_counts(): status = {} status['指标数'] = Query.query.count() if settings.FEATURE_SHOW_QUERY_RESULTS_COUNT: status['指标结果集数'] = QueryResult.query.count() status['未使用指标结果集数'] = QueryResult.unused().count() status['看板数'] = Dashboard.query.count() status['小部件数'] = Widget.query.count() return status
def test_doesnt_update_queries_with_different_hash(self): query1 = self.factory.create_query(query_text=self.query) query2 = self.factory.create_query(query_text=self.query) query3 = self.factory.create_query(query_text=self.query + "123") query_result = QueryResult.store_result(self.data_source.org_id, self.data_source, self.query_hash, self.query, self.data, self.runtime, self.utcnow) Query.update_latest_result(query_result) self.assertEqual(query1.latest_query_data, query_result) self.assertEqual(query2.latest_query_data, query_result) self.assertNotEqual(query3.latest_query_data, query_result)
def test_updates_existing_queries(self): query1 = self.factory.create_query(query_text=self.query) query2 = self.factory.create_query(query_text=self.query) query3 = self.factory.create_query(query_text=self.query) query_result = QueryResult.store_result(self.data_source.org_id, self.data_source, self.query_hash, self.query, self.data, self.runtime, self.utcnow) Query.update_latest_result(query_result) self.assertEqual(query1.latest_query_data, query_result) self.assertEqual(query2.latest_query_data, query_result) self.assertEqual(query3.latest_query_data, query_result)