def _get_queries(self):
filters = util.get_filters()
table_queries_info = []
if not 'all' in filters: # all overrides table_query, shows all fields
route = util.get_path(2)
table_queries_info = self.rac.table_queries(route, self.table_name)
queries = []
if table_queries_info: # if table_query defined, use id
for query in table_queries_info: # page can have multiple
query = TableQuery(
query.TableQuery.id,
query.TableQuery.order,
query.TableQuery.display_name,
None,
self.criteria
)
queries.append(query)
elif self.table_name: # use table_name, show all fields, one table_query
table_object_row = self.rac.get_role_row('table_object', {'name': self.table_name})
if table_object_row.TableObjectRole.display_name:
display_name = table_object_row.TableObjectRole.display_name
else:
display_name = table_object_row.TableObject.display_name
query = TableQuery(
None,
1,
display_name,
self.table_name,
self.criteria)
queries.append(query)
return queries
def build_summary_ajax(table_name, criteria = {}):
start = time.time()
route = util.get_path(util.ROUTE)
# TODO: we don't want oac instantiated multiple times
oac = g_helper.get_org_access_control()
ret = None
filters = util.get_filters()
key = current_app.cache.make_key(
route,
g.rac.role.id,
oac.current_org_id,
table_name
)
if (not criteria and 'no_cache' not in filters):
print('checking cache')
ret = current_app.cache.get(key)
ret = None
if not ret:
print('cache miss')
tqc = TableQueryCollection(table_name, criteria)
current = time.time()
print(str(current - start))
tqc.get_results()
current = time.time()
print(str(current - start))
tqc.format_results()
current = time.time()
print(str(current - start))
table_query = tqc.get_first()
current = time.time()
print(str(current - start))
json_rows = table_query.get_row_list()
current = time.time()
print(str(current - start))
ret = jsonify({'data': json_rows})
if not criteria:
print('caching')
current_app.cache.set(key, ret, (24 * 60 * 60), [table_name])
else:
print('cache hit')
return ret