Function test_db_handler_basic

tests/connection_pool_test.rs:6–27

()

#[tokio::test]
async fn test_db_handler_basic() -> Result<(), Box<dyn std::error::Error>> {
    let temp_dir = tempfile::tempdir()?;
    let db_path = temp_dir.path().join("test_basic.db");
    let db_handler = Arc::new(DbHandler::new(db_path.to_str().unwrap())?);
    
    // Create a session
    let session_id = Uuid::new_v4();
    db_handler.create_session_connection(session_id).await?;
    
    // Test basic operations
    db_handler.execute_with_session("CREATE TABLE test_basic (id INTEGER PRIMARY KEY, name TEXT)", &session_id).await?;
    db_handler.execute_with_session("INSERT INTO test_basic (name) VALUES ('test1')", &session_id).await?;
    
    let result = db_handler.query_with_session("SELECT * FROM test_basic", &session_id).await?;
    assert_eq!(result.rows.len(), 1);
    assert_eq!(result.columns, vec!["id", "name"]);
    
    // Clean up
    db_handler.remove_session_connection(&session_id);
    
    Ok(())
}

#[tokio::test]
async fn test_db_handler_transactions() -> Result<(), Box<dyn std::error::Error>> {