def show_result(sql, table=None, data=None): offset = int(request.args.get('offset', 0)) # We need to have a result to get the field types if data is None: data = {} result = run_sql(sql + ' LIMIT 1', data) fields = sa_common.get_result_fields(db.engine, result, table) # Now run query result = run_sql(sql + (' LIMIT 1000 OFFSET %s' % offset), data) output = { 'fields': fields, 'data': result, 'offset': offset, } if 'raw' not in request.args: output['links'] = auto_links(fields) output['functions'] = auto_functions(fields) return output
def get_result_fields(*args, **kw): return sa_common.get_result_fields(engine, *args, **kw)