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。

1.6 KB
Raw Blame
use dbx_sql_schema::table_structure_sql::{
    build_mysql_table_charset_change_sql, MysqlTableCharsetChange, TableStructureSqlOptions,
};

fn mysql_options() -> TableStructureSqlOptions {
    serde_json::from_value(serde_json::json!({
        "databaseType": "mysql",
        "schema": "app",
        "tableName": "users",
        "columns": []
    }))
    .expect("valid MySQL table options")
}

#[test]
fn mysql_table_charset_change_alters_defaults_without_rebuilding_the_table() {
    let result = build_mysql_table_charset_change_sql(
        &mysql_options(),
        MysqlTableCharsetChange { charset: "utf8mb4".to_string(), collation: Some("utf8mb4_0900_ai_ci".to_string()) },
    );

    assert!(result.warnings.is_empty());
    assert_eq!(
        result.statements,
        vec!["ALTER TABLE `users` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;"]
    );
    assert!(!result.statements.iter().any(|sql| sql.contains("CREATE TABLE")));
    assert!(!result.statements.iter().any(|sql| sql.contains("CONVERT TO")));
}

#[test]
fn mysql_table_charset_change_requires_native_mysql() {
    let mut options = mysql_options();
    options.database_type = Some(dbx_sql_schema::models::connection::DatabaseType::Postgres);

    let result = build_mysql_table_charset_change_sql(
        &options,
        MysqlTableCharsetChange { charset: "utf8mb4".to_string(), collation: None },
    );

    assert!(result.statements.is_empty());
    assert_eq!(
        result.warnings,
        vec!["Changing the table character set is supported only for native MySQL connections."]
    );
}