qail 0.27.10

Schema-first database toolkit - migrations, diff, lint, and query generation
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

//! Centralized resolution for database URL and SSH tunnel config.
//!
//! Priority chain: CLI flag → `qail.toml` → error.
//!
//! # Example
//!
//! ```ignore
//! let url = resolve_db_url(cli_url.as_deref())?;
//! let ssh = resolve_ssh(cli_ssh.as_deref());
//! ```

use anyhow::Result;
use qail_core::config::QailConfig;

/// Resolve database URL from CLI `--url` flag or `qail.toml`.
///
/// Priority: `--url` > `DATABASE_URL` env > `qail.toml [postgres].url` > error
pub fn resolve_db_url(cli_url: Option<&str>) -> Result<String> {
    // 1. Explicit CLI flag wins
    if let Some(url) = cli_url {
        return Ok(url.to_string());
    }

    // 2. Try DATABASE_URL env var directly
    if let Ok(url) = std::env::var("DATABASE_URL") {
        return Ok(url);
    }

    // 3. Try qail.toml
    match QailConfig::load() {
        Ok(config) => {
            let url = config.postgres.url.clone();
            // Don't return the default placeholder URL
            if url == "postgres://postgres@localhost:5432/postgres" {
                anyhow::bail!(
                    "No database URL configured.\n\n\
                     Set one of:\n  \
                     • --url postgres://user:pass@host/db\n  \
                     • DATABASE_URL env var\n  \
                     • [postgres].url in qail.toml"
                );
            }
            Ok(url)
        }
        Err(_) => {
            anyhow::bail!(
                "No database URL found.\n\n\
                 Set one of:\n  \
                 • --url postgres://user:pass@host/db\n  \
                 • DATABASE_URL env var\n  \
                 • [postgres].url in qail.toml"
            );
        }
    }
}

/// Resolve SSH tunnel host from CLI `--ssh` flag or `qail.toml`.
///
/// Priority: `--ssh` > `qail.toml [postgres].ssh` > None
pub fn resolve_ssh(cli_ssh: Option<&str>) -> Option<String> {
    // 1. Explicit CLI flag wins
    if let Some(ssh) = cli_ssh {
        return Some(ssh.to_string());
    }

    // 2. Try qail.toml
    QailConfig::load().ok().and_then(|c| c.postgres.ssh)
}