Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

3.1 KB
Raw Blame
use dbx_core::xlsx_export::{
    build_xlsx_workbook_multi_with_auto_filter, build_xlsx_workbook_with_auto_filter, XlsxWorksheetData,
};
use serde::Deserialize;
use serde_json::Value;

#[derive(Debug, Clone, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct QueryResultXlsxExportRequest {
    pub file_path: String,
    pub sheet_name: Option<String>,
    pub columns: Vec<String>,
    #[serde(default)]
    pub column_types: Vec<String>,
    #[serde(default)]
    pub column_comments: Vec<Option<String>>,
    /// Render comments as a second header row (names row 1, comments row 2,
    /// data from row 3) instead of overriding the header text.
    #[serde(default)]
    pub header_comment_rows: bool,
    pub rows: Vec<Vec<Value>>,
    #[serde(default)]
    pub numeric_column_right_align: bool,
    #[serde(default)]
    pub auto_filter: Option<bool>,
    /// Global export date/time pattern (Day.js syntax). Drives the workbook's
    /// `numFmt`, so a pattern carrying `SSS` keeps milliseconds visible instead
    /// of falling back to the `yyyy-mm-dd hh:mm:ss` default.
    #[serde(default)]
    pub date_time_format: Option<String>,
}

#[derive(Debug, Clone, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct QueryResultsXlsxExportRequest {
    pub file_path: String,
    pub worksheets: Vec<XlsxWorksheetData>,
    #[serde(default)]
    pub auto_filter: Option<bool>,
    #[serde(default)]
    pub date_time_format: Option<String>,
}

#[tauri::command]
pub async fn export_query_result_xlsx(request: QueryResultXlsxExportRequest) -> Result<(), String> {
    tauri::async_runtime::spawn_blocking(move || {
        let mut data = XlsxWorksheetData {
            sheet_name: request.sheet_name,
            columns: request.columns,
            column_types: request.column_types,
            column_comments: request.column_comments,
            rows: request.rows,
            numeric_column_right_align: request.numeric_column_right_align,
            auto_filter: request.auto_filter,
            header_comment_rows: request.header_comment_rows,
        };
        // Ensure consistency: if the feature is disabled, clear the flag.
        if !data.numeric_column_right_align {
            data.numeric_column_right_align = false;
        }
        let workbook = build_xlsx_workbook_with_auto_filter(
            &data,
            request.auto_filter.unwrap_or(true),
            request.date_time_format.as_deref(),
        )?;
        std::fs::write(&request.file_path, workbook).map_err(|err| err.to_string())
    })
    .await
    .map_err(|err| err.to_string())?
}

#[tauri::command]
pub async fn export_query_results_xlsx(request: QueryResultsXlsxExportRequest) -> Result<(), String> {
    tauri::async_runtime::spawn_blocking(move || {
        let workbook = build_xlsx_workbook_multi_with_auto_filter(
            &request.worksheets,
            request.auto_filter.unwrap_or(true),
            request.date_time_format.as_deref(),
        )?;
        std::fs::write(&request.file_path, workbook).map_err(|err| err.to_string())
    })
    .await
    .map_err(|err| err.to_string())?
}