use yang_base::database::DatabaseInitializer;
use yang_base::plugin::{Plugin, PluginManager};
use yang_db::Database;
struct TestPlugin1;
#[async_trait::async_trait]
impl Plugin for TestPlugin1 {
fn name(&self) -> &str {
"test_plugin_1"
}
fn version(&self) -> &str {
"1.0.0"
}
fn init_sql(&self) -> Vec<String> {
vec![r#"
CREATE TABLE IF NOT EXISTS test_users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
"#
.to_string()]
}
fn migration_sql(&self) -> Vec<(String, String)> {
vec![(
"20240101000001".to_string(),
"ALTER TABLE test_users ADD COLUMN status INT DEFAULT 1".to_string(),
)]
}
}
struct TestPlugin2;
#[async_trait::async_trait]
impl Plugin for TestPlugin2 {
fn name(&self) -> &str {
"test_plugin_2"
}
fn version(&self) -> &str {
"1.0.0"
}
fn dependencies(&self) -> &[&str] {
&["test_plugin_1"]
}
fn init_sql(&self) -> Vec<String> {
vec![r#"
CREATE TABLE IF NOT EXISTS test_orders (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
amount DECIMAL(10, 2) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
"#
.to_string()]
}
}
#[tokio::test]
#[ignore] async fn test_database_initializer_without_transaction() {
let db_url = "mysql://root:password@localhost:3306/test_db";
let db = match Database::connect(db_url).await {
Ok(db) => db,
Err(_) => {
println!("跳过测试:无法连接到数据库");
return;
}
};
let manager = PluginManager::new();
manager.register(TestPlugin1).await.unwrap();
manager.register(TestPlugin2).await.unwrap();
let initializer = DatabaseInitializer::new(db, false);
let result = initializer.initialize_all(&manager).await;
assert!(result.is_ok(), "数据库初始化失败: {:?}", result);
let db = Database::connect(db_url).await.unwrap();
let table_exists = db
.table_exists(yang_db::table!("test_users"))
.await
.unwrap();
assert!(table_exists, "test_users 表未创建");
let table_exists = db
.table_exists(yang_db::table!("test_orders"))
.await
.unwrap();
assert!(table_exists, "test_orders 表未创建");
let table_exists = db
.table_exists(yang_db::table!("_migrations"))
.await
.unwrap();
assert!(table_exists, "_migrations 表未创建");
let _ = db.drop_table(yang_db::table!("test_users")).await;
let _ = db.drop_table(yang_db::table!("test_orders")).await;
let _ = db.drop_table(yang_db::table!("_migrations")).await;
}
#[tokio::test]
#[ignore] async fn test_database_initializer_with_transaction() {
let db_url = "mysql://root:password@localhost:3306/test_db";
let db = match Database::connect(db_url).await {
Ok(db) => db,
Err(_) => {
println!("跳过测试:无法连接到数据库");
return;
}
};
let manager = PluginManager::new();
manager.register(TestPlugin1).await.unwrap();
manager.register(TestPlugin2).await.unwrap();
let initializer = DatabaseInitializer::new(db, true);
let result = initializer.initialize_all(&manager).await;
assert!(result.is_ok(), "数据库初始化失败: {:?}", result);
let db = Database::connect(db_url).await.unwrap();
let table_exists = db
.table_exists(yang_db::table!("test_users"))
.await
.unwrap();
assert!(table_exists, "test_users 表未创建");
let table_exists = db
.table_exists(yang_db::table!("test_orders"))
.await
.unwrap();
assert!(table_exists, "test_orders 表未创建");
let table_exists = db
.table_exists(yang_db::table!("_migrations"))
.await
.unwrap();
assert!(table_exists, "_migrations 表未创建");
let _ = db.drop_table(yang_db::table!("test_users")).await;
let _ = db.drop_table(yang_db::table!("test_orders")).await;
let _ = db.drop_table(yang_db::table!("_migrations")).await;
}
#[tokio::test]
#[ignore] async fn test_migration_idempotency() {
let db_url = "mysql://root:password@localhost:3306/test_db";
let db = match Database::connect(db_url).await {
Ok(db) => db,
Err(_) => {
println!("跳过测试:无法连接到数据库");
return;
}
};
let manager = PluginManager::new();
manager.register(TestPlugin1).await.unwrap();
let initializer = DatabaseInitializer::new(db, false);
let result = initializer.initialize_all(&manager).await;
assert!(result.is_ok(), "第一次初始化失败: {:?}", result);
let result = initializer.initialize_all(&manager).await;
assert!(result.is_ok(), "第二次初始化失败: {:?}", result);
let is_executed = initializer
.is_migration_executed("test_plugin_1", "20240101000001")
.await
.unwrap();
assert!(is_executed, "迁移记录未找到");
let db = Database::connect(db_url).await.unwrap();
let _ = db.drop_table(yang_db::table!("test_users")).await;
let _ = db.drop_table(yang_db::table!("_migrations")).await;
}
#[tokio::test]
#[ignore] async fn test_create_migration_table() {
let db_url = "mysql://root:password@localhost:3306/test_db";
let db = match Database::connect(db_url).await {
Ok(db) => db,
Err(_) => {
println!("跳过测试:无法连接到数据库");
return;
}
};
let initializer = DatabaseInitializer::new(db, false);
let result = initializer.create_migration_table().await;
assert!(result.is_ok(), "创建迁移记录表失败: {:?}", result);
let db = Database::connect(db_url).await.unwrap();
let table_exists = db
.table_exists(yang_db::table!("_migrations"))
.await
.unwrap();
assert!(table_exists, "_migrations 表未创建");
let _ = db.drop_table(yang_db::table!("_migrations")).await;
}