yamlbase 0.7.2

A lightweight SQL server that serves YAML-defined tables over standard SQL protocols
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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125

use clap::Parser;
use serde::{Deserialize, Serialize};
use std::path::PathBuf;
use std::time::Duration;

#[derive(Debug, Clone, Parser, Serialize, Deserialize)]
#[command(name = "yamlbase")]
#[command(author, version, about, long_about = None)]
pub struct Config {
    #[arg(short, long, value_name = "FILE", help = "Path to YAML database file")]
    pub file: PathBuf,

    #[arg(
        short,
        long,
        help = "Port to listen on (default: 5432 for postgres, 3306 for mysql)"
    )]
    pub port: Option<u16>,

    #[arg(long, default_value = "0.0.0.0", help = "Address to bind to")]
    pub bind_address: String,

    #[arg(
        long,
        value_enum,
        default_value = "postgres",
        help = "SQL protocol to use"
    )]
    pub protocol: Protocol,

    #[arg(
        short = 'u',
        long,
        default_value = "admin",
        help = "Authentication username"
    )]
    pub username: String,

    #[arg(
        short = 'P',
        long,
        default_value = "password",
        help = "Authentication password"
    )]
    pub password: String,

    #[arg(long, help = "Enable hot-reloading of YAML file changes")]
    pub hot_reload: bool,

    #[arg(short, long, help = "Enable verbose logging")]
    pub verbose: bool,

    #[arg(
        long,
        default_value = "info",
        help = "Set log level: debug, info, warn, error"
    )]
    pub log_level: String,

    #[arg(long, help = "Database name")]
    pub database: Option<String>,

    #[arg(
        long,
        help = "Allow anonymous connections (no authentication required)"
    )]
    pub allow_anonymous: bool,

    // Connection management settings (not exposed via CLI - configured via YAML)
    #[serde(skip_serializing_if = "Option::is_none")]
    #[clap(skip)]
    pub max_connections: Option<usize>,

    #[serde(skip_serializing_if = "Option::is_none")]
    #[serde(with = "humantime_serde")]
    #[clap(skip)]
    pub connection_timeout: Option<Duration>,

    #[serde(skip_serializing_if = "Option::is_none")]
    #[serde(with = "humantime_serde")]
    #[clap(skip)]
    pub idle_timeout: Option<Duration>,

    #[serde(default)]
    #[clap(skip)]
    pub enable_keepalive: bool,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, clap::ValueEnum)]
pub enum Protocol {
    Postgres,
    Mysql,
    Sqlserver,
}

impl Config {
    pub fn effective_port(&self) -> u16 {
        self.port.unwrap_or(match self.protocol {
            Protocol::Postgres => 5432,
            Protocol::Mysql => 3306,
            Protocol::Sqlserver => 1433,
        })
    }

    pub fn init_logging(&self) -> anyhow::Result<()> {
        let log_level = if self.verbose {
            "debug"
        } else {
            &self.log_level
        };

        let filter = tracing_subscriber::EnvFilter::try_from_default_env()
            .unwrap_or_else(|_| tracing_subscriber::EnvFilter::new(log_level));

        tracing_subscriber::fmt()
            .with_env_filter(filter)
            .with_target(false)
            .with_thread_ids(false)
            .with_file(self.verbose)
            .with_line_number(self.verbose)
            .init();

        Ok(())
    }
}