#![cfg(any(feature = "mysql", feature = "postgres"))]
use crate::action::sql_bridge::count_query;
use crate::action::{ActionContext, TypedHandler};
use crate::error::BaseError;
use crate::table::{Record, SortOrder, WhereCondition};
use async_trait::async_trait;
use serde::{Deserialize, Serialize};
use yang_base_derive::Action;
fn default_page() -> u32 {
1
}
fn default_page_size() -> u32 {
10
}
fn default_sort_order() -> SortOrder {
SortOrder::Asc
}
#[derive(Deserialize, schemars::JsonSchema)]
#[serde(deny_unknown_fields)]
pub struct OrderByItem {
pub field: String,
#[serde(default = "default_sort_order")]
pub direction: SortOrder,
}
#[derive(Deserialize, schemars::JsonSchema)]
#[serde(deny_unknown_fields)]
pub struct SelectQuery {
#[serde(default = "default_page")]
pub page: u32,
#[serde(default = "default_page_size")]
pub page_size: u32,
#[serde(default)]
pub search: Option<String>,
#[serde(rename = "where", default)]
pub where_clause: Option<WhereCondition>,
#[serde(default)]
pub order_by: Vec<OrderByItem>,
#[serde(default)]
pub count_total: bool,
}
#[derive(Serialize, schemars::JsonSchema)]
pub struct SelectResult {
pub items: Vec<Record>,
pub page: u32,
pub page_size: u32,
#[serde(skip_serializing_if = "Option::is_none")]
pub total: Option<u64>,
}
#[derive(Action)]
#[action(
name = "select",
display_name = "查询列表",
description = "分页 + 多条件 AND 查询"
)]
pub struct SelectAction;
impl SelectAction {
pub fn new() -> Self {
Self
}
}
impl Default for SelectAction {
fn default() -> Self {
Self::new()
}
}
#[async_trait]
impl TypedHandler for SelectAction {
type Input = SelectQuery;
type Output = SelectResult;
async fn handle(
&self,
ctx: ActionContext,
input: SelectQuery,
) -> Result<SelectResult, BaseError> {
let SelectQuery {
page,
page_size,
search,
where_clause,
order_by,
count_total,
} = input;
if page == 0 || page_size == 0 || page_size > 100 {
return Err(BaseError::ParamInvalid(
"page/page_size".into(),
"page>=1, 1<=page_size<=100".into(),
));
}
if ctx.user.is_none() {
return Err(BaseError::Unauthorized("需要登录".to_string()));
}
let mut q = ctx.table_query()?;
q.ensure_readable_projection()?;
q = q.search(search.as_deref())?;
if let Some(tree) = where_clause {
q = q.where_tree(tree)?;
}
let total = if count_total {
Some(count_query(q.clone()).await?)
} else {
None
};
for OrderByItem { field, direction } in order_by {
q = q.order_by(&field, direction)?;
}
q = q.page(page as usize, page_size as usize)?;
let items = q.all().await?;
Ok(SelectResult {
items,
page,
page_size,
total,
})
}
}
#[cfg(test)]
mod tests {
use super::SelectQuery;
#[test]
fn select_query_accepts_generic_table_search() {
let query: SelectQuery = serde_json::from_value(serde_json::json!({
"search": "alice"
}))
.expect("通用 TableView 搜索词应属于标准 select 输入");
assert_eq!(query.search.as_deref(), Some("alice"));
}
}