dsn 1.2.1

DSN (Data Source Name) parser
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

//! Examples of building DSN strings for various databases

use dsn::DSNBuilder;

fn main() {
    println!("=== DSN Builder Examples ===\n");

    // MySQL / MariaDB
    println!("1. MySQL with TCP:");
    let mysql = DSNBuilder::mysql()
        .username("root")
        .password("my-secret-pw")
        .host("db.example.com")
        .database("myapp")
        .param("charset", "utf8mb4")
        .param("parseTime", "true")
        .build();
    println!("   {mysql}\n");

    // MySQL with Unix socket
    println!("2. MySQL with Unix socket:");
    let mysql_sock = DSNBuilder::mysql()
        .username("webapp")
        .password("secret")
        .socket("/var/run/mysqld/mysqld.sock")
        .database("webapp_db")
        .build();
    println!("   {mysql_sock}\n");

    // PostgreSQL
    println!("3. PostgreSQL with SSL:");
    let postgres = DSNBuilder::postgres()
        .username("postgres")
        .password("admin123")
        .host("postgres.example.com")
        .port(5432)
        .database("production")
        .param("sslmode", "require")
        .param("connect_timeout", "10")
        .build();
    println!("   {postgres}\n");

    // PostgreSQL with custom port
    println!("4. PostgreSQL with custom port:");
    let postgres_custom = DSNBuilder::postgres()
        .username("user")
        .password("pass")
        .host("localhost")
        .port(5433)
        .database("testdb")
        .build();
    println!("   {postgres_custom}\n");

    // PostgreSQL with SSL disabled (development)
    println!("5. PostgreSQL with SSL disabled:");
    let postgres_no_ssl = DSNBuilder::postgres()
        .username("dev")
        .password("dev123")
        .host("localhost")
        .database("dev_db")
        .param("sslmode", "disable")
        .build();
    println!("   {postgres_no_ssl}\n");

    // Redis
    println!("6. Redis:");
    let redis = DSNBuilder::redis()
        .host("cache.example.com")
        .password("redis-secret")
        .database("0")
        .build();
    println!("   {redis}\n");

    // Redis with authentication
    println!("7. Redis with custom port:");
    let redis_custom = DSNBuilder::redis()
        .host("localhost")
        .port(6380)
        .database("1")
        .build();
    println!("   {redis_custom}\n");

    // MariaDB
    println!("8. MariaDB:");
    let mariadb = DSNBuilder::mariadb()
        .username("admin")
        .password("secure-password")
        .host("mariadb.local")
        .database("app_data")
        .param("timeout", "30s")
        .build();
    println!("   {mariadb}\n");

    // Generic builder
    println!("9. Custom driver (MongoDB):");
    let mongo = DSNBuilder::default()
        .driver("mongodb")
        .username("admin")
        .password("admin")
        .host("mongo1.example.com")
        .port(27017)
        .database("admin")
        .param("replicaSet", "rs0")
        .param("authSource", "admin")
        .build();
    println!("   {mongo}\n");

    // Special characters in password
    println!("10. Password with special characters:");
    let special = DSNBuilder::mysql()
        .username("user@domain")
        .password("p@ss:w0rd!#$")
        .host("localhost")
        .database("mydb")
        .build();
    println!("   {special}\n");
    println!("    (Note: special characters are automatically percent-encoded)");
}