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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
use dbx_sql_schema::table_structure_sql::{build_create_table_sql, TableStructureSqlOptions};
#[test]
fn oceanbase_clone_create_preserves_decoded_quoted_target_names() {
for name in [" New ", "MixedCase", "A\"B", "普通表"] {
let options: TableStructureSqlOptions = serde_json::from_value(serde_json::json!({
"databaseType": "oceanbase-oracle", "schema": "APP", "tableName": name,
"columns": [{"id": "new:id", "name": "ID", "dataType": "NUMBER", "isNullable": true}]
}))
.unwrap();
let result = build_create_table_sql(options);
assert!(result.warnings.is_empty(), "{:?}", result.warnings);
let expected = format!("CREATE TABLE \"APP\".\"{}\" (", name.replace('"', "\"\""));
assert!(result.statements[0].starts_with(&expected), "{:?}", result.statements);
}
}
#[test]
fn other_databases_keep_create_name_input_trimming() {
for database_type in ["oracle", "postgres", "mysql"] {
let options: TableStructureSqlOptions = serde_json::from_value(serde_json::json!({
"databaseType": database_type, "schema": "APP", "tableName": " New ",
"columns": [{"id": "new:id", "name": "ID", "dataType": "INT", "isNullable": true}]
}))
.unwrap();
let result = build_create_table_sql(options);
assert!(result.warnings.is_empty(), "{:?}", result.warnings);
assert!(!result.statements[0].contains(" New "), "{:?}", result.statements);
}
}