def get_table_column_stats(column_id):
"""Get all table stats column by id"""
with DBSession() as session:
column = logic.get_column_by_id(column_id, session=session)
verify_data_table_permission(column.table_id, session=session)
return DataTableColumnStatistics.get_all(column_id=column_id,
session=session)
def get_column(column_id, with_table=False):
with DBSession() as session:
column = logic.get_column_by_id(column_id, session=session)
verify_data_table_permission(column.table_id, session=session)
column_dict = column.to_dict(with_table)
return column_dict
def create_table_column_stats(data):
"""Batch add/update table column stats"""
# TODO: verify user is a service account
with DBSession() as session:
for d in data:
column = logic.get_column_by_id(d["column_id"], session=session)
if column:
verify_data_table_permission(column.table_id, session=session)
for s in d["stats"]:
logic.upsert_table_column_stat(
column_id=d["column_id"],
key=s["key"],
value=s["value"],
uid=current_user.id,
session=session,
)
return