parsql-cli 0.5.0

Command-line interface for parsql database toolkit
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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92

//! Parsql CLI library
//! 
//! This crate provides the command-line interface for the parsql database toolkit.

use clap::Subcommand;

pub mod config;
pub mod utils;
pub mod commands;
pub mod ui;

#[derive(Subcommand)]
pub enum MigrateCommands {
    /// Create a new migration
    #[command(alias = "c")]
    Create {
        /// Migration name (e.g., "create_users_table")
        name: String,
        
        /// Migration type
        #[arg(short = 't', long, default_value = "sql", value_parser = ["sql", "rust"])]
        migration_type: String,
    },
    
    /// Run pending migrations
    #[command(alias = "r")]
    Run {
        /// Target database URL (overrides global --database-url)
        #[arg(long)]
        database_url: Option<String>,
        
        /// Dry run - show what would be executed without applying
        #[arg(long)]
        dry_run: bool,
        
        /// Target version (run up to this version)
        #[arg(long)]
        target: Option<i64>,
    },
    
    /// Rollback migrations
    #[command(alias = "b")]
    Rollback {
        /// Target version to rollback to
        #[arg(long, short = 't')]
        to: i64,
        
        /// Target database URL (overrides global --database-url)
        #[arg(long)]
        database_url: Option<String>,
        
        /// Dry run - show what would be rolled back without executing
        #[arg(long)]
        dry_run: bool,
    },
    
    /// Show migration status
    #[command(alias = "s")]
    Status {
        /// Target database URL (overrides global --database-url)
        #[arg(long)]
        database_url: Option<String>,
        
        /// Show detailed information including checksums
        #[arg(long)]
        detailed: bool,
    },
    
    /// Validate migration files
    #[command(alias = "v")]
    Validate {
        /// Check for version gaps
        #[arg(long)]
        check_gaps: bool,
        
        /// Verify migration checksums
        #[arg(long)]
        verify_checksums: bool,
    },
    
    /// List migration files
    #[command(alias = "l")]
    List {
        /// Show only pending migrations
        #[arg(long)]
        pending: bool,
        
        /// Show only applied migrations
        #[arg(long)]
        applied: bool,
    },
}