fn checksum(file_path: &str) -> io::Result<String> {

    let mut file = fs::File::open(file_path)?;

    let mut hasher = Sha256::new();

    let mut buffer = [0; 1024];

        let bytes_read = file.read(&mut buffer)?;

        if bytes_read == 0 {

            break;

        }

        hasher.update(&buffer[..bytes_read]);

    let hash = hasher.finalize();

    Ok(hash.iter().fold(String::new(), |mut acc, b| {

        write!(acc, "{b:02x}").unwrap();

        acc

    }))

}

fn main() {

    println!("cargo:rerun-if-changed=../doc/disdoc.org");

    let status = Command::new("emacs")

        .args([

            "-q",

            "--batch",

            "--eval",

            "(progn (require 'ob-emacs-lisp) (require 'ob-shell) (setq org-confirm-babel-evaluate nil))",

            "../doc/disdoc.org",

            "-l",

            "ox-md",

            "--eval",

            "(org-md-export-to-markdown)",

            "-f",

            "save-buffer",

            "-f",

            "kill-emacs",

        ])

        .status()

        .expect("Failed to export doc");

    assert!(status.success(), "Building finance doc failed");

    fs::copy("../doc/disdoc.md", "../target/nomisync.md").expect("Can't update finance doc file");

    println!(

        env::var("CARGO_MANIFEST_DIR").unwrap()

    println!("cargo:rerun-if-changed=../doc/nomisync.org");

    let status = Command::new("emacs")

        .args([

            "-q",

            "--batch",

            "../doc/nomisync.org",

            "--eval",

            "(org-babel-do-load-languages 'org-babel-load-languages '((sql . t)))",

            "--eval",

            "(setq org-confirm-babel-evaluate nil)",

            "--eval",

            "(org-babel-tangle)",

            "-f",

            "kill-emacs",

        ])

        .status()

        .expect("Failed to export SQL");

    assert!(status.success(), "Building SQL from org failed");

    sync_migration("../doc/nomisync.sql", "../migrations/0002_nomisync.sql");

    sync_migration(

        "../doc/0004_tags_canonical.sql",

        "../migrations/0004_tags_canonical.sql",

    println!("cargo:rerun-if-changed=../migrations");

}

fn sync_migration(tangled: &str, migration: &str) {

    if fs::metadata(tangled).is_err() {

    }

    let status = Command::new("sqlfluff")

        .args(["fix", "--dialect", "postgres", tangled, "--force"])

        .status()

        .expect("Failed to format SQL");

    assert!(status.success(), "Formatting tangled migration failed");

    let needs_copy = match fs::metadata(migration) {

        Ok(_) => checksum(tangled).unwrap() != checksum(migration).unwrap(),

    if needs_copy {

    } else {

        fs::remove_file(tangled).unwrap();

    }

}