geni 1.3.1

A standalone database CLI migration tool
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

use anyhow::{bail, Result};
use std::path::PathBuf;

/// Helper function to validate migration files for testing
pub fn validate_migration_files(
    files: &[(i64, PathBuf)],
    migration_folder: &str,
    direction: &str,
) -> Result<()> {
    if files.is_empty() {
        bail!(
            "Didn't find any files ending with .{}.sql at {}. Does the path exist?",
            direction,
            migration_folder,
        );
    }
    Ok(())
}

/// Helper function to filter pending migrations for testing
pub fn filter_pending_migrations(
    files: Vec<(i64, PathBuf)>,
    applied_migrations: &[String],
) -> Vec<(i64, PathBuf)> {
    files
        .into_iter()
        .filter(|(timestamp, _)| {
            let id = timestamp.to_string();
            !applied_migrations.contains(&id)
        })
        .collect()
}

/// Helper function to get migrations to rollback for testing
pub fn get_migrations_to_rollback(
    applied_migrations: Vec<String>,
    rollback_amount: i64,
) -> Result<Vec<i64>> {
    let mut migrations: Vec<i64> = applied_migrations
        .into_iter()
        .filter_map(|s| s.parse::<i64>().ok())
        .collect();

    // Sort in descending order (newest first) for rollback
    migrations.sort_by(|a, b| b.cmp(a));

    let rollback_count = rollback_amount as usize;
    if rollback_count > migrations.len() {
        Ok(migrations) // Return all if asking for more than available
    } else {
        Ok(migrations.into_iter().take(rollback_count).collect())
    }
}

/// Helper function to find rollback file for testing
pub fn find_rollback_file<'a>(
    files: &'a [(i64, PathBuf)],
    migration_id: i64,
) -> Option<&'a (i64, PathBuf)> {
    files
        .iter()
        .find(|(timestamp, _)| *timestamp == migration_id)
}