def data_cohort_gene_num_filtered():
# dataUseGeneNumFilter?cohortId=1&table=copynumber&attribute=relativecopynumber&ensg=ENSG00000141510&ranges=gt_2%lte_5;gte_10
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- table: the score table, which contains the attribute
- attribute: the score attribute to filter
- ensg: name of the gene
- ranges: filter ranges for the attribute, e.g >2 and <=5, or >=10 -> gt_2%lte_5;gte_10""".format(
route='dataUseGeneNumFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
dict_args = request.values.to_dict(
) # convert ImmutableMultiDict to dict
dict_args[
'name'] = 'clone' # add name element for the create_cohort_gene_num_filtered() function
clone_cohort = query.create_cohort_gene_num_filtered(
dict_args, cohort,
error_msg) # get filtered cohort from dict_args and cohort
del dict_args['attribute'] # remove attribute element to show all data
sql_text = query.get_cohort_data_sql(
dict_args, clone_cohort) # create sql statement from the cohort
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def size_cohort_depletion_score_filtered():
# sizeUseDepletionScoreFilter?cohortId=3&table=depletionscore&attribute=rsa&ensg=ENSG00000141510&depletionscreen=Drive&ranges=gte_-0.1%lt_-0.01
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- table: the score table, which contains the attribute
- attribute: the score attribute to filter
- ensg: name of the gene
- depletionscreen: name of the screen
- ranges: filter ranges for the attribute, e.g >2 and <=5, or >=10 -> gt_2%lte_5;gte_10""".format(
route='sizeUseDepletionScoreFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
dict_args = request.values.to_dict(
) # convert ImmutableMultiDict to dict
dict_args[
'name'] = 'clone' # add name element for the create_cohort_depletion_score_filtered() function
clone_cohort = query.create_cohort_depletion_score_filtered(
dict_args, cohort,
error_msg) # get filtered cohort from dict_args and cohort
sql_text = query.get_cohort_size_sql(
clone_cohort) # create sql statement from the cohort
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def size_cohort_num_filtered():
# sizeUseNumFilter?cohortId=1&attribute=age&ranges=gt_2%lte_5;gte_10
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- attribute: column used to filter
- ranges: filter ranges for the attribute, e.g >2 and <=5, or >=10 -> gt_2%lte_5;gte_10""".format(
route='sizeUseNumFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
dict_args = request.values.to_dict(
) # convert ImmutableMultiDict to dict
dict_args[
'name'] = 'clone' # add name element for the create_cohort_num_filtered() function
clone_cohort = query.create_cohort_num_filtered(
dict_args, cohort,
error_msg) # get filtered cohort from dict_args and cohort
sql_text = query.get_cohort_size_sql(
clone_cohort) # create sql statement from the cohort
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def size_cohort_panel_annotation_filtered():
# sizeUsePanelAnnotationFilter?cohortId=1&panel=TCGA normals&values=true
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- panel: name of the panel
- values: filter value(s) for the attribtue, separator '⸱', e.g. 'value1%26%23x2e31%3Bvalue2'""".format(
route='sizeUsePanelAnnotationFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
dict_args = request.values.to_dict(
) # convert ImmutableMultiDict to dict
dict_args[
'name'] = 'clone' # add name element for the create_cohort_panel_annotation_filtered() function
clone_cohort = query.create_cohort_panel_annotation_filtered(
dict_args, cohort,
error_msg) # get filtered cohort from args and cohort
sql_text = query.get_cohort_size_sql(
clone_cohort) # create sql statement from the cohort
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def size_cohort_gene_equals_filtered():
# sizeUseGeneEqualsFilter?cohortId=1&name=TestGeneEquals&table=mutation&attribute=dna_mutated&ensg=ENSG00000141510&numeric=false&values=false%26%23x2e31%3Btrue
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- table: the score table, which contains the attribute
- attribute: the score attribute to filter
- numeric: boolean if the attribute is number or not
- values: filter value(s) for the attribtue, separator '⸱', e.g. 'value1%26%23x2e31%3Bvalue2'""".format(
route='sizeUseGeneEqualsFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
dict_args = request.values.to_dict(
) # convert ImmutableMultiDict to dict
dict_args[
'name'] = 'clone' # add name element for the create_cohort_gene_equals_filtered() function
clone_cohort = query.create_cohort_gene_equals_filtered(
dict_args, cohort,
error_msg) # get filtered cohort from dict_args and cohort
sql_text = query.get_cohort_size_sql(
clone_cohort) # create sql statement from the cohort
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def data_cohort_equals_filtered():
# dataUseEqulasFilter?cohortId=1&attribute=gender&numeric=false&values=female%26%23x2e31%3Bmale
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- attribute: column used to filter
- numeric: boolean if the attribute is number or not
- values: filter value(s) for the attribtue, separator '⸱', e.g. 'value1%26%23x2e31%3Bvalue2'""".format(
route='dataUseEqulasFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
dict_args = request.values.to_dict(
) # convert ImmutableMultiDict to dict
dict_args[
'name'] = 'clone' # add name element for the create_cohort_equals_filtered() function
clone_cohort = query.create_cohort_equals_filtered(
dict_args, cohort,
error_msg) # get filtered cohort from args and cohort
del dict_args['attribute'] # remove attribute element to show all data
sql_text = query.get_cohort_data_sql(
dict_args, clone_cohort) # create sql statement from the cohort
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def get_cols_impl(dataset, rows):
if '/' + dataset not in h5:
abort(404)
if len(rows) > 0:
rowids = np.nonzero(np.in1d(h5.get_node('/' + dataset + '/cols'), rows))[0]
else:
rowids = Ellipsis
data = h5.get_node('/' + dataset + '/cols')
return to_json(data[rowids])
def _handle(path):
_log.info('proxy request url: %s', path)
url = _to_full_url(path)
if url:
_log.info('proxy request url: %s', url)
r = requests.get(url)
_log.info('proxy response status code: %s', r.status_code)
return Response(r.text,
status=r.status_code,
content_type=r.headers['content-type'])
abort(404)
def get_info_impl(dataset):
if '/' + dataset not in h5:
abort(404)
group = h5.get_node('/' + dataset)
if group._v_attrs.type == 'matrix':
return to_json(name=group._v_name, title=group._v_title.strip(), coltype=group._v_attrs.coltype.strip(),
rowtype=group._v_attrs.rowtype.strip(), dim=map(int, group.data.shape))
if group._v_attrs.type == 'stratification':
return to_json(name=group._v_name, title=group._v_title.strip(), idtype=group._v_attrs.idtype.strip(),
groups={name: dict(title=gf._v_title, size=len(gf)) for name, gf in group._v_children.iteritems()})
def size_cohort():
# size?cohortId=2
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort""".format(route='size')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
sql_text = query.get_cohort_size_sql(
cohort) # get sql statement to get size of cohort
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def insert_cohort():
# create?name=dummy&previous=-1&isInitial=1&database=tdp_publicdb&schema=tissue&table=tdp_tissue&statement=SELECT * FROM tissue.tdp_tissue
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameters are needed:
- name: name of the cohort
- isInitial: 0 if it has a parent cohort, 1 if it is the initial table
- previous: id of the previous cohort, -1 for the initial cohort
- database: database of the entitiy tale
- schema: schema of the entity table
- table: table of the entitiy""".format(route='create')
try:
query = QueryElements()
new_cohort = query.create_cohort(request.values,
error_msg) # crate cohort from args
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def panel_annotation():
# panelAnnotation?cohortId=3&panel=TCGA normals
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameters are needed:
- cohortId: id of the cohort, has to have a panel annotation
- panel: name of the panel""".format(route='panelAnnotation')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
sql_text = query.get_panel_annotation_sql(
request.values, cohort,
error_msg) # get sql statement for panel annotation
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def data_cohort():
# cohortData?cohortId=2&attribute=gender
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort
There is also one optional parameter:
- attribute: one column of the entity table""".format(route='cohortData')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
sql_text = query.get_cohort_data_sql(
request.values, cohort) # get sql statement to retrieve data
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def insert_cohort_num_filtered():
# createUseNumFilter?cohortId=1&name=TeSt&attribute=age&ranges=gt_2%lte_5;gte_10
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- name: name of the new cohort
- attribute: column used to filter
- ranges: filter ranges for the attribute, e.g >2 and <=5, or >=10 -> gt_2%lte_5;gte_10""".format(
route='createWithNumFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
new_cohort = query.create_cohort_num_filtered(
request.values, cohort,
error_msg) # get filtered cohort from args and cohort
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def insert_cohort_panel_annotation_filtered():
# createUsePanelAnnotationFilter?cohortId=1&name=testPanelAnno&panel=TCGA normals&values=true
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- name: name of the new cohort
- panel: name of the panel
- values: filter value(s) for the attribtue, separator '⸱', e.g. 'value1%26%23x2e31%3Bvalue2'""".format(
route='createUsePanelAnnotationFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
new_cohort = query.create_cohort_panel_annotation_filtered(
request.values, cohort,
error_msg) # get filtered cohort from args and cohort
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def gene_score_tissue():
# geneScore?cohortId=2&table=copynumber&attribute=relativecopynumber&ensg=ENSG00000141510
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameters are needed:
- cohortId: id of the cohort
- table: the score table, which contains the attribute
- attribute: the score attribute
- ensg: name of the gene""".format(route='geneScore')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
sql_text = query.get_gene_score_sql(
request.values, cohort,
error_msg) # get sql statement to get gene score for tissue
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def insert_cohort_equals_filtered():
# createUseEqulasFilter?cohortId=1&name=TeSt&attribute=gender&numeric=false&values=female%26%23x2e31%3Bmale
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- name: name of the new cohort
- attribute: column used to filter
- numeric: boolean if the attribute is number or not
- values: filter value(s) for the attribtue, separator '⸱', e.g. 'value1%26%23x2e31%3Bvalue2'""".format(
route='createWithEqualsFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
new_cohort = query.create_cohort_equals_filtered(
request.values, cohort,
error_msg) # get filtered cohort from args and cohort
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def insert_cohort_treatment_filtered():
# createUseTreatmentFilter?cohortId=29892&name=testTreatment&agent=Crizotinib%26%23x2e31%3BCisplatin®imen=2&baseAgent=true
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- name: name of the new cohort
- agent: filter value(s) for the agent, separator '⸱', e.g. 'value1%26%23x2e31%3Bvalue2'
- regimen: filter value for the regimen_number, e.g. '1'
- baseAgent: boolean if the agents are base agents (single agents), e.g. 'false'
At least one of the two attributes (agent, regimen) has to be defined !'""".format(
route='createUseTreatmentFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
new_cohort = query.create_cohort_treatment_filtered(
request.values, cohort,
error_msg) # get filtered cohort from args and cohort
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def depletion_score_cellline():
# celllineDepletionScore?cohortId=3&table=depletionscore&attribute=rsa&ensg=ENSG00000141510&depletionscreen=Drive
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameters are needed:
- cohortId: id of the cohort
- table: the score table, which contains the attribute
- attribute: the score attribute
- ensg: name of the gene
- depletionscreen: name of the screen""".format(
route='celllineDepletionScore')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
sql_text = query.get_gene_score_depletion_sql(
request.values, cohort,
error_msg) # get sql statement to get depletion score
return query.execute_sql_query(
sql_text, cohort.entity_database) # execute sql statement
except RuntimeError as error:
abort(400, error)
def insert_cohort_gene_num_filtered():
# createUseGeneNumFilter?cohortId=1&name=TeSt&table=copynumber&attribute=relativecopynumber&ensg=ENSG00000141510&ranges=gt_2%lte_5;gte_10
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- name: name of the new cohort
- table: the score table, which contains the attribute
- attribute: the score attribute to filter
- ensg: name of the gene
- ranges: filter ranges for the attribute, e.g >2 and <=5, or >=10 -> gt_2%lte_5;gte_10""".format(
route='createUseGeneNumFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
new_cohort = query.create_cohort_gene_num_filtered(
request.values, cohort,
error_msg) # get filtered cohort from args and cohort
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def insert_cohort_gene_equals_filtered():
# createUseGeneEqualsFilter?cohortId=1&name=TestGeneEquals&table=mutation&attribute=dna_mutated&ensg=ENSG00000141510&numeric=false&values=false%26%23x2e31%3Btrue
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- name: name of the new cohort
- table: the score table, which contains the attribute
- attribute: the score attribute to filter
- ensg: name of the gene
- numeric: boolean if the attribute is number or not
- values: filter value(s) for the attribtue, separator '⸱', e.g. 'value1%26%23x2e31%3Bvalue2'""".format(
route='createUseGeneEqualsFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
new_cohort = query.create_cohort_gene_equals_filtered(
request.values, cohort,
error_msg) # get filtered cohort from args and cohort
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def insert_cohort_depletion_score_filtered():
# createUseDepletionScoreFilter?cohortId=3&name=TeStDepletion&table=depletionscore&attribute=rsa&ensg=ENSG00000141510&depletionscreen=Drive&ranges=gte_-0.1%lt_-0.01
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- name: name of the new cohort
- table: the score table, which contains the attribute
- attribute: the score attribute to filter
- ensg: name of the gene
- depletionscreen: name of the screen
- ranges: filter ranges for the attribute, e.g >2 and <=5, or >=10 -> gt_2%lte_5;gte_10""".format(
route='createUseDepletionScoreFilter')
try:
query = QueryElements()
cohort = query.get_cohort_from_db(request.values,
error_msg) # get parent cohort
new_cohort = query.create_cohort_depletion_score_filtered(
request.values, cohort,
error_msg) # get filtered cohort from args and cohort
return query.add_cohort_to_db(new_cohort) # save new cohort into DB
except RuntimeError as error:
abort(400, error)
def login():
if ns.request.method == 'POST':
user = ns.request.values['username']
user_obj = self.login(user, ns.request.values)
if not user_obj:
return ns.abort(401) # 401 Unauthorized
_log.debug('user login: ' + user)
return ns.jsonify(name=user_obj.name, roles=user_obj.roles)
# return a login mask
login_mask = """
<!DOCTYPE html>
<html>
<body>
<form name="login" action="/login" method="post" accept-charset="utf-8">
<div><label for="username">User name: </label><input type="text" name="username" placeholder="name" required="required"></div>
<div><label for="password">Password</label><input type="password" name="password" placeholder="password" required="required"></div>
<div><label for="remember"><input type="checkbox" name="remember" value="True" required="required"></label></div>
<div><input type="reset" value="Reset"><input type="submit" value="Login"></div>
</form>
</body>
</html>
"""
return ns.render_template_string(login_mask)
def hist():
# hist?cohortId=2&type=dataCat&attribute=race
# hist?cohortId=2&type=dataNum&attribute=age
# hist?cohortId=2&type=geneScoreCat&attribute=aa_mutated&table=mutation&ensg=ENSG00000141510
# hist?cohortId=2&type=geneScoreNum&attribute=relativecopynumber&table=copynumber&ensg=ENSG00000141510
# hist?cohortId=3&type=depletionScore&attribute=rsa&table=depletionscore&ensg=ENSG00000141510&depletionscreen=Drive
# hist?cohortId=2&type=panelAnnotation&panel=TCGA normals
error_msg = """Paramerter missing or wrong!
For the {route} query the following parameter is needed:
- cohortId: id of the cohort parent cohort
- type: dataCat | dataNum | geneScoreCat | geneScoreNum | depletionScore | panelAnnotation
Depending on the 'type' different additional parameters have to exist
--> Type: dataCat | dataNum
- attribute: the entity attribute
--> Type: geneScoreCat | geneScoreNum
- table: the score table, which contains the attribute
- attribute: the score attribute
- ensg: name of the gene
--> Type: depletionScore
- table: the score table, which contains the attribute
- attribute: the score attribute
- ensg: name of the gene
- depletionscreen: name of the screen
--> Type: panelAnnotation
- panel: name of the panel""".format(route='hist')
try:
query = QueryElements()
type = request.values.get('type') # get type of hist
if type is None:
raise RuntimeError(error_msg)
hist = jsonify([])
cohort = query.get_cohort_from_db(request.values,
error_msg) # get cohort
database = cohort.entity_database
num_bins = 10
if type == 'dataCat':
# - cohortId: id of the cohort
# - attribute: the entity attribute
sql_text = query.get_hist_cat_sql(request.values, cohort,
error_msg)
hist = query.execute_sql_query(
sql_text, database,
config.supp_statement_timeout) # execute sql statement
elif type == 'dataNum':
# - cohortId: id of the cohort
# - attribute: the entity attribute
sql_text = query.get_hist_num_sql(request.values, cohort, num_bins,
error_msg)
hist_dict = query.execute_sql_query_as_dict(
sql_text, database,
config.supp_statement_timeout) # execute sql statement
hist = query.format_num_hist(hist_dict, num_bins)
elif type == 'geneScoreCat':
# - cohortId: id of the cohort
# - table: the score table, which contains the attribute
# - attribute: the score attribute
# - ensg: name of the gene
sql_text = query.get_hist_gene_cat_sql(request.values, cohort,
error_msg)
hist = query.execute_sql_query(
sql_text, database,
config.supp_statement_timeout) # execute sql statement
elif type == 'geneScoreNum':
# - cohortId: id of the cohort
# - table: the score table, which contains the attribute
# - attribute: the score attribute
# - ensg: name of the gene
sql_text = query.get_hist_gene_num_sql(request.values, cohort,
num_bins, error_msg)
hist_dict = query.execute_sql_query_as_dict(
sql_text, database,
config.supp_statement_timeout) # execute sql statement
hist = query.format_num_hist(hist_dict, num_bins)
elif type == 'depletionScore':
# - cohortId: id of the cohort
# - table: the score table, which contains the attribute
# - attribute: the score attribute
# - ensg: name of the gene
# - depletionscreen: name of the screen
sql_text = query.get_hist_depletion_sql(request.values, cohort,
num_bins, error_msg)
hist_dict = query.execute_sql_query_as_dict(
sql_text, database,
config.supp_statement_timeout) # execute sql statement
hist = query.format_num_hist(hist_dict, num_bins)
elif type == 'panelAnnotation':
# - cohortId: id of the cohort
# - panel: name of the panel
sql_text = query.get_hist_panel_sql(request.values, cohort,
error_msg)
hist = query.execute_sql_query(
sql_text, database,
config.supp_statement_timeout) # execute sql statement
return hist
except RuntimeError as error:
abort(400, error)
def get_groups_impl(dataset):
if '/' + dataset not in h5:
abort(404)
g = h5.get_node('/' + dataset)
r = {name: dict(title=gf._v_title, ids=gf) for name, gf in g._v_children.iteritems()}
return to_json(r)
def get_group(dataset, group):
if '/' + dataset + '/' + group not in h5:
abort(404)
g = h5.get_node('/' + dataset + '/' + group)
return jsonify(g)
def get_data_impl(dataset):
if '/' + dataset not in h5:
abort(404)
mini, rows, cols = resolve(dataset)
return to_json(dict(data=mini, cols=cols, rows=rows))
