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.7 KB
Raw Blame
use dbx_core::db::sqlserver;
use std::time::Duration;

#[tokio::test]
#[ignore = "requires DBX_LIVE_SQLSERVER_HOST/PORT/USER/PASSWORD pointing at SQL Server"]
async fn live_sqlserver_long_varchar_results_are_complete_and_use_sql_type_names() {
    let host = std::env::var("DBX_LIVE_SQLSERVER_HOST").unwrap_or_else(|_| "127.0.0.1".to_string());
    let port = std::env::var("DBX_LIVE_SQLSERVER_PORT").ok().and_then(|value| value.parse().ok()).unwrap_or(1433);
    let user = std::env::var("DBX_LIVE_SQLSERVER_USER").unwrap_or_else(|_| "sa".to_string());
    let password = std::env::var("DBX_LIVE_SQLSERVER_PASSWORD").expect("DBX_LIVE_SQLSERVER_PASSWORD");
    let database = std::env::var("DBX_LIVE_SQLSERVER_DATABASE").unwrap_or_else(|_| "tempdb".to_string());
    let mut client = sqlserver::connect_with_port_explicit(
        &host,
        port,
        true,
        &user,
        &password,
        Some(&database),
        None,
        Duration::from_secs(15),
    )
    .await
    .expect("connect to SQL Server");

    let result = sqlserver::execute_query(
        &mut client,
        "SELECT CAST(REPLICATE('A', 250) + REPLICATE('B', 250) AS VARCHAR(500)) AS long_value \
         UNION ALL \
         SELECT CAST(REPLICATE('C', 500) AS VARCHAR(500))",
    )
    .await
    .expect("query VARCHAR(500) values");

    assert_eq!(result.columns, vec!["long_value"]);
    assert_eq!(result.column_types, vec!["varchar"]);
    assert_eq!(result.rows.len(), 2);
    assert_eq!(result.rows[0][0].as_str().map(str::len), Some(500));
    assert_eq!(result.rows[0][0], serde_json::json!(format!("{}{}", "A".repeat(250), "B".repeat(250))));
    assert_eq!(result.rows[1][0], serde_json::json!("C".repeat(500)));
}