def topic_data_page_(where, sort, pageable, model, name) -> DataPage:
if name == "topic_raw_pipeline_monitor":
return raw_pipeline_monitor_page_(where, sort, pageable, model, name)
else:
count = count_topic_data_table(name)
table = get_topic_table_by_name(name)
stmt = select(table).where(build_oracle_where_expression(table, where))
orders = build_oracle_order(table, sort)
for order in orders:
stmt = stmt.order_by(order)
offset = pageable.pageSize * (pageable.pageNumber - 1)
# stmt = stmt.offset(offset).limit(pageable.pageSize)
stmt = text(
str(stmt.compile(compile_kwargs={"literal_binds": True})) +
" OFFSET :offset ROWS FETCH NEXT :maxnumrows ROWS ONLY")
result = []
with engine.connect() as conn:
cursor = conn.execute(stmt, {
"offset": offset,
"maxnumrows": pageable.pageSize
}).cursor
columns = [col[0] for col in cursor.description]
cursor.rowfactory = lambda *args: dict(zip(columns, args))
res = cursor.fetchall()
for row in res:
if model is not None:
result.append(parse_obj(model, row, table))
else:
result.append(row)
return build_data_pages(pageable, result, count)
def list_(where, model, name) -> list:
table = get_table_by_name(name)
stmt = select(table).where(build_oracle_where_expression(table, where))
with engine.connect() as conn:
cursor = conn.execute(stmt).cursor
columns = [col[0] for col in cursor.description]
cursor.rowfactory = lambda *args: dict(zip(columns, args))
res = cursor.fetchall()
result = []
for row in res:
result.append(parse_obj(model, row, table))
return result
def find_by_id(id_, model, name):
table = get_table_by_name(name)
primary_key = get_primary_key(name)
stmt = select(table).where(eq(table.c[primary_key.lower()], id_))
with engine.connect() as conn:
cursor = conn.execute(stmt).cursor
columns = [col[0] for col in cursor.description]
cursor.rowfactory = lambda *args: dict(zip(columns, args))
result = cursor.fetchone()
if result is None:
return
else:
return parse_obj(model, result, table)
def find_one(where, model, name):
table = get_table_by_name(name)
check_result = check_where_column_type(name, where)
if check_result is not None:
stmt = text(build_raw_sql_with_json_table(check_result, where, name))
else:
stmt = select(table)
stmt = stmt.where(build_oracle_where_expression(table, where))
with engine.connect() as conn:
cursor = conn.execute(stmt).cursor
columns = [col[0] for col in cursor.description]
cursor.rowfactory = lambda *args: dict(zip(columns, args))
result = cursor.fetchone()
if result is None:
return
else:
return parse_obj(model, result, table)