Function test_drift_report_formatting

tests/schema_drift_test.rs:247–285

()

#[test]
fn test_drift_report_formatting() -> rusqlite::Result<()> {
    let mut conn = Connection::open_in_memory()?;
    
    // Initialize metadata table
    TypeMetadata::init(&conn)?;
    
    // Create a table with drift
    conn.execute(
        "CREATE TABLE users (
            id INTEGER PRIMARY KEY,
            name TEXT
        )",
        []
    )?;
    
    // Store metadata with drift
    let tx = conn.transaction()?;
    tx.execute(
        "INSERT INTO __pgsqlite_schema (table_name, column_name, pg_type, sqlite_type)
         VALUES 
         ('users', 'id', 'int4', 'INTEGER'),
         ('users', 'name', 'int4', 'INTEGER'),
         ('users', 'email', 'text', 'TEXT')",
        []
    )?;
    tx.commit()?;
    
    // Check report format
    let drift = SchemaDriftDetector::detect_drift(&conn).unwrap();
    let report = drift.format_report();
    
    assert!(report.contains("Table 'users' has schema drift"));
    assert!(report.contains("Columns in metadata but missing from SQLite"));
    assert!(report.contains("email (text)"));
    assert!(report.contains("Type mismatches"));
    assert!(report.contains("name expected SQLite type 'INTEGER' but found 'TEXT'"));
    
    Ok(())
}

#[test]
fn test_type_normalization() -> rusqlite::Result<()> {