async def qshield_aggregator(*, t, group_col, agg_col, func, tk, **kw): table = None if t is None: raise APIValueError('t', message='t is None') else: table = table_model(t) if group_col is None: raise APIValueError('group_col', message='group collum is None') if agg_col is None: raise APIValueError('agg_col', message='aggregation collum is None') if func is None: raise APIValueError('func', message='aggregation function is None') if tk is None: raise APIValueError('tk', message='tk is None') res = await table.aggregator(g_c=group_col, a_c=agg_col, func=func, tk=tk, **kw) return data_res_format(data=res)
async def qshield_selector(*, t, st, tk, **kw): table = None if t is None: raise APIValueError('t', message='t is None') else: table = table_model(t) if st is None: raise APIValueError('st', message='st is None') if tk is None: raise APIValueError('tk', message='tk is None') res = await table.selector(st=st, tk=tk, **kw) return data_res_format(data=res)
async def qshield_query(*, st, p, tk, **kw): if st is None: raise APIValueError('st', message='st is None') if p is None: raise APIValueError('p', message='p is None') if tk is None: raise APIValueError('tk', message='tk is None') table_identifiers = extract_tables(st) if table_identifiers is None: raise APIValueError('st', message=r"cannot extract tables from '%s'" % st) else: logging.info('found target tables: %s' % ', '.join(table_identifiers)) tables = [] for i in table_identifiers: tables.append(table_model(i)) res = await Tables.sql_exe(tables=tables, st=st, p=p, tk=tk, **kw) return data_res_format(data=res)
async def qshield_joiner(*, t1, t2, st, mode, tk, **kw): table1 = None if t1 is None: raise APIValueError('t1', message='t1 is None') else: table1 = table_model(t1) table2 = None if t2 is None: raise APIValueError('t2', message='t2 is None') else: table2 = table_model(t2) if st is None: raise APIValueError('st', message='st is None') if mode is None: raise APIValueError('mode', message='mode is None') if tk is None: raise APIValueError('tk', message='tk is None') res = await table1.joiner(table2=table2, st=st, mode=mode, tk=tk, **kw) return data_res_format(data=res)