debug_test.rs

use mysql2postgres::MySQLToPostgreSQLConverter;
use std::fs;
use tempfile::TempDir;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let mysql_dump = "CREATE TABLE `test_table` (`id` INT AUTO_INCREMENT, `name` VARCHAR(255), PRIMARY KEY (`id`));";
    
    let temp_dir = TempDir::new()?;
    let input_file = temp_dir.path().join("test_input.sql");
    let output_file = temp_dir.path().join("test_output.sql");
    
    fs::write(&input_file, mysql_dump)?;
    
    let converter = MySQLToPostgreSQLConverter::new(&input_file, &output_file, 8192)?;
    let stats = converter.convert()?;
    
    let output = fs::read_to_string(&output_file)?;
    println!("=== INPUT ===");
    println!("{}", mysql_dump);
    println!("\n=== OUTPUT ===");
    println!("{}", output);
    println!("\n=== STATS ===");
    println!("{:?}", stats);
    
    println!("\nContains SERIAL: {}", output.contains("SERIAL"));
    println!("Contains INT: {}", output.contains("INT"));
    println!("Contains AUTO_INCREMENT: {}", output.contains("AUTO_INCREMENT"));
    
    Ok(())
}