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

#[cfg(test)]
use crate::config::{Config, Protocol};
use crate::server::Server;
use std::io::Write;
use tempfile::NamedTempFile;

#[tokio::test]
async fn test_server_uses_yaml_auth() {
    let yaml_content = r#"
database:
  name: "test_db"
  auth:
    username: "yaml_user"
    password: "yaml_pass"

tables:
  test:
    columns:
      id: "INTEGER PRIMARY KEY"
"#;

    let mut temp_file = NamedTempFile::new().unwrap();
    temp_file.write_all(yaml_content.as_bytes()).unwrap();
    temp_file.flush().unwrap();

    let config = Config {
        file: temp_file.path().to_path_buf(),
        port: None,
        bind_address: "127.0.0.1".to_string(),
        protocol: Protocol::Postgres,
        username: "cli_user".to_string(), // These should be overridden
        password: "cli_pass".to_string(), // by YAML auth
        hot_reload: false,
        verbose: false,
        log_level: "error".to_string(),
        database: None,
        allow_anonymous: false,
        max_connections: None,
        connection_timeout: None,
        idle_timeout: None,
        enable_keepalive: false,
    };

    let server = Server::new(config).await.unwrap();

    // Verify that the server's config has been updated with YAML auth
    assert_eq!(server.config.username, "yaml_user");
    assert_eq!(server.config.password, "yaml_pass");
}

#[tokio::test]
async fn test_server_without_yaml_auth() {
    let yaml_content = r#"
database:
  name: "test_db"

tables:
  test:
    columns:
      id: "INTEGER PRIMARY KEY"
"#;

    let mut temp_file = NamedTempFile::new().unwrap();
    temp_file.write_all(yaml_content.as_bytes()).unwrap();
    temp_file.flush().unwrap();

    let config = Config {
        file: temp_file.path().to_path_buf(),
        port: None,
        bind_address: "127.0.0.1".to_string(),
        protocol: Protocol::Postgres,
        username: "cli_user".to_string(),
        password: "cli_pass".to_string(),
        hot_reload: false,
        verbose: false,
        log_level: "error".to_string(),
        database: None,
        allow_anonymous: false,
        max_connections: None,
        connection_timeout: None,
        idle_timeout: None,
        enable_keepalive: false,
    };

    let server = Server::new(config).await.unwrap();

    // Verify that the server's config keeps CLI auth when YAML has none
    assert_eq!(server.config.username, "cli_user");
    assert_eq!(server.config.password, "cli_pass");
}