// Copyright (c) 2026 Kirky.X
//
// Licensed under the MIT License
// See LICENSE file in the project root for full license information.

//! 自动迁移集成测试
//!
//! 测试自动迁移功能的各个组件：配置解析、迁移扫描、手动迁移、自动迁移触发等

#![cfg(feature = "auto-migrate")]

use dbnexus::DbConfig;
use dbnexus::DbPool;
use dbnexus::foundation::DatabaseType;
use std::fs;
use std::path::PathBuf;
use tempfile::TempDir;

#[path = "../../common/mod.rs"]
mod common;

fn id_column_definition(db_type: DatabaseType) -> &'static str {
    match db_type {
        DatabaseType::Sqlite => "INTEGER PRIMARY KEY",
        DatabaseType::Postgres => "INTEGER PRIMARY KEY",
        DatabaseType::MySql => "INT PRIMARY KEY",
        // DuckDB 支持 INTEGER PRIMARY KEY 语法
        DatabaseType::DuckDb => "INTEGER PRIMARY KEY",
    }
}

/// TEST-AM-001: 自动迁移配置创建测试
#[tokio::test]
async fn test_auto_migrate_config_creation() {
    let config = dbnexus::DbConfig {
        url: "sqlite::memory:".to_string(),
        migrations_dir: Some(PathBuf::from("./migrations")),
        auto_migrate: true,
        migration_timeout: 120,
        ..Default::default()
    };

    assert!(config.auto_migrate);
    assert_eq!(config.migration_timeout, 120);
    assert!(config.migrations_dir.is_some());
}

/// TEST-AM-002: 迁移文件扫描测试（使用内存数据库）
#[tokio::test]
#[cfg(any(feature = "sqlite", feature = "postgres", feature = "mysql"))]
async fn test_migration_file_scanning() {
    let temp_dir = TempDir::new().expect("Failed to create temp directory");

    let url = common::get_test_database_url();
    let db_type = DatabaseType::parse_database_type(&url).unwrap();
    let id_column = id_column_definition(db_type);

    // 创建测试迁移文件（使用唯一表名避免冲突）
    let table_suffix = std::time::SystemTime::now()
        .duration_since(std::time::UNIX_EPOCH)
        .unwrap()
        .as_nanos();

    let migration_content_1 = format!(
        r#"-- Migration: create_users_table
-- Version: 1

-- UP:
CREATE TABLE users_{table_suffix} (
    id {id_column},
    name TEXT NOT NULL,
    email TEXT
);

-- DOWN:
DROP TABLE users_{table_suffix};
"#
    );

    let migration_content_2 = format!(
        r#"-- Migration: create_orders_table
-- Version: 2

-- UP:
CREATE TABLE orders_{table_suffix} (
    id {id_column},
    user_id INTEGER NOT NULL,
    total DECIMAL(10, 2) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- DOWN:
DROP TABLE orders_{table_suffix};
"#
    );

    fs::write(temp_dir.path().join("1_create_users_table.sql"), migration_content_1)
        .expect("Failed to write migration file 1");
    fs::write(temp_dir.path().join("2_create_orders_table.sql"), migration_content_2)
        .expect("Failed to write migration file 2");

    // 使用内存数据库
    let config = dbnexus::DbConfig {
        url,
        max_connections: 5,
        min_connections: 1,
        idle_timeout: 300,
        acquire_timeout: 5000,
        admin_role: "admin".to_string(),
        migration_timeout: 60,
        ..Default::default()
    };

    let pool = DbPool::with_config(config).await.expect("Failed to create test pool");

    // 运行迁移（不手动删除表，让迁移系统处理）
    let migrations = pool
        .run_migrations(temp_dir.path())
        .await
        .expect("Failed to run migrations");

    // 验证迁移已应用
    assert_eq!(migrations, 2, "Should have applied 2 migrations");
}

/// TEST-AM-003: 迁移超时配置测试
#[tokio::test]
async fn test_migration_timeout_config() {
    let config = dbnexus::DbConfig {
        url: "sqlite::memory:".to_string(),
        migration_timeout: 300,
        ..Default::default()
    };

    assert_eq!(config.migration_timeout, 300);
    assert_eq!(config.migration_timeout_duration().as_secs(), 300);
}

/// TEST-AM-004: 空迁移目录测试
#[tokio::test]
#[cfg(any(feature = "sqlite", feature = "postgres", feature = "mysql"))]
async fn test_empty_migrations_directory() {
    let temp_dir = TempDir::new().expect("Failed to create temp directory");

    let url = common::get_test_database_url();
    let config = dbnexus::DbConfig {
        url,
        max_connections: 5,
        min_connections: 1,
        idle_timeout: 300,
        acquire_timeout: 5000,
        admin_role: "admin".to_string(),
        migration_timeout: 60,
        ..Default::default()
    };

    let pool = DbPool::with_config(config).await.expect("Failed to create test pool");

    let result = pool.run_migrations(temp_dir.path()).await;

    assert!(result.is_ok(), "Running migrations on empty directory should succeed");
    assert_eq!(result.unwrap(), 0, "Should apply 0 migrations");
}

/// TEST-AM-005: 不存在目录测试
#[tokio::test]
#[cfg(any(feature = "sqlite", feature = "postgres", feature = "mysql"))]
async fn test_nonexistent_migrations_directory() {
    let url = common::get_test_database_url();
    let config = dbnexus::DbConfig {
        url,
        max_connections: 5,
        min_connections: 1,
        idle_timeout: 300,
        acquire_timeout: 5000,
        admin_role: "admin".to_string(),
        migration_timeout: 60,
        ..Default::default()
    };

    let pool = DbPool::with_config(config).await.expect("Failed to create test pool");

    let non_existent_path = PathBuf::from("/tmp/non_existent_migrations_12345");

    let result = pool.run_migrations(&non_existent_path).await;

    assert!(
        result.is_ok(),
        "Running migrations on non-existent directory should succeed"
    );
    assert_eq!(result.unwrap(), 0, "Should apply 0 migrations");
}

/// TEST-AM-006: 环境变量迁移配置测试
#[tokio::test]
#[cfg(feature = "config-env")]
async fn test_migration_config_from_env() {
    // 保存原始环境变量值
    let original_database_url = std::env::var("DATABASE_URL").ok();
    let original_migrations_dir = std::env::var("DB_MIGRATIONS_DIR").ok();
    let original_auto_migrate = std::env::var("DB_AUTO_MIGRATE").ok();
    let original_migration_timeout = std::env::var("DB_MIGRATION_TIMEOUT").ok();

    // 设置测试环境变量
    unsafe {
        std::env::set_var("DATABASE_URL", "sqlite::memory:");
        std::env::set_var("DB_MIGRATIONS_DIR", "/custom/migrations");
        std::env::set_var("DB_AUTO_MIGRATE", "true");
        std::env::set_var("DB_MIGRATION_TIMEOUT", "120");
    }

    // 执行测试逻辑，确保在任何情况下都清理环境变量
    let result = std::panic::catch_unwind(std::panic::AssertUnwindSafe(|| {
        let config = DbConfig::from_env().expect("Failed to create config from env");

        assert!(config.auto_migrate);
        assert!(config.migrations_dir.is_some());
        assert_eq!(config.migrations_dir.unwrap(), PathBuf::from("/custom/migrations"));
        assert_eq!(config.migration_timeout, 120);
    }));

    // 恢复原始环境变量
    unsafe {
        match original_database_url {
            Some(val) => std::env::set_var("DATABASE_URL", val),
            None => std::env::remove_var("DATABASE_URL"),
        }
        match original_migrations_dir {
            Some(val) => std::env::set_var("DB_MIGRATIONS_DIR", val),
            None => std::env::remove_var("DB_MIGRATIONS_DIR"),
        }
        match original_auto_migrate {
            Some(val) => std::env::set_var("DB_AUTO_MIGRATE", val),
            None => std::env::remove_var("DB_AUTO_MIGRATE"),
        }
        match original_migration_timeout {
            Some(val) => std::env::set_var("DB_MIGRATION_TIMEOUT", val),
            None => std::env::remove_var("DB_MIGRATION_TIMEOUT"),
        }
    }

    // 如果测试失败，重新触发panic
    if let Err(e) = result {
        std::panic::resume_unwind(e);
    }
}

/// TEST-AM-007: 迁移版本排序测试（使用内存数据库）
#[tokio::test]
#[cfg(any(feature = "sqlite", feature = "postgres", feature = "mysql"))]
async fn test_migration_version_sorting() {
    let temp_dir = TempDir::new().expect("Failed to create temp directory");

    let url = common::get_test_database_url();
    let db_type = DatabaseType::parse_database_type(&url).unwrap();
    let id_column = id_column_definition(db_type);

    // 使用唯一表名避免冲突
    let table_suffix = std::time::SystemTime::now()
        .duration_since(std::time::UNIX_EPOCH)
        .unwrap()
        .as_nanos();

    // 创建乱序的迁移文件
    let migration_v3 = format!(
        r#"-- Migration: third
-- Version: 3
-- UP:
CREATE TABLE table_3_{table_suffix} (id {id_column});
-- DOWN:
DROP TABLE table_3_{table_suffix};
"#
    );

    let migration_v1 = format!(
        r#"-- Migration: first
-- Version: 1
-- UP:
CREATE TABLE table_1_{table_suffix} (id {id_column});
-- DOWN:
DROP TABLE table_1_{table_suffix};
"#
    );

    let migration_v2 = format!(
        r#"-- Migration: second
-- Version: 2
-- UP:
CREATE TABLE table_2_{table_suffix} (id {id_column});
-- DOWN:
DROP TABLE table_2_{table_suffix};
"#
    );

    // 乱序写入
    fs::write(temp_dir.path().join("3_third.sql"), migration_v3).expect("Failed to write v3");
    fs::write(temp_dir.path().join("1_first.sql"), migration_v1).expect("Failed to write v1");
    fs::write(temp_dir.path().join("2_second.sql"), migration_v2).expect("Failed to write v2");

    let config = dbnexus::DbConfig {
        url,
        max_connections: 5,
        min_connections: 1,
        idle_timeout: 300,
        acquire_timeout: 5000,
        admin_role: "admin".to_string(),
        migration_timeout: 60,
        ..Default::default()
    };

    let pool = DbPool::with_config(config).await.expect("Failed to create test pool");

    // 运行迁移（不手动删除表，让迁移系统处理）
    let applied = pool
        .run_migrations(temp_dir.path())
        .await
        .expect("Failed to run migrations");
    assert_eq!(applied, 3, "Should apply all 3 migrations");
}
