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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141

use std::{
    env::{set_var, var, VarError},
    ops::{Deref, DerefMut},
    str::FromStr,
};

use sqlx_clickhouse_ext::sqlx_core::{error::Error, postgres::PgConnectOptions};
use url::Url;

#[derive(Debug, Clone)]
pub struct ClickhousePgConnectOptions {
    pub(crate) inner: PgConnectOptions,
}
impl ClickhousePgConnectOptions {
    pub fn new() -> Self {
        update_env();

        Self {
            inner: PgConnectOptions::new(),
        }
    }

    pub fn into_inner(self) -> PgConnectOptions {
        self.inner
    }
}

impl Default for ClickhousePgConnectOptions {
    fn default() -> Self {
        Self::new()
    }
}

impl Deref for ClickhousePgConnectOptions {
    type Target = PgConnectOptions;

    fn deref(&self) -> &Self::Target {
        &self.inner
    }
}
impl DerefMut for ClickhousePgConnectOptions {
    fn deref_mut(&mut self) -> &mut Self::Target {
        &mut self.inner
    }
}

impl FromStr for ClickhousePgConnectOptions {
    type Err = Error;

    fn from_str(s: &str) -> Result<Self, Self::Err> {
        update_env();

        let s = update_url(s)?;

        PgConnectOptions::from_str(&s).map(|inner| Self { inner })
    }
}

//
const PORT_DEFAULT_STR: &str = "9005";
const SSL_MODE_PREFER: &str = "prefer";
const SSL_MODE_DISABLE: &str = "disable";

fn update_env() {
    if let Err(VarError::NotPresent) = var("PGPORT") {
        set_var("PGPORT", PORT_DEFAULT_STR)
    }

    match var("PGSSLMODE") {
        Ok(str) if str == SSL_MODE_PREFER => set_var("PGSSLMODE", SSL_MODE_DISABLE),
        Err(VarError::NotPresent) => set_var("PGSSLMODE", SSL_MODE_DISABLE),
        _ => (),
    }
}

fn update_url(s: &str) -> Result<String, Error> {
    let mut url: Url = s
        .parse()
        .map_err(|err: url::ParseError| Error::Configuration(err.into()))?;

    url.query_pairs()
        .map(|(k, v)| (k.to_string(), v.to_string()))
        .collect::<Vec<_>>()
        .into_iter()
        .fold(url.query_pairs_mut().clear(), |ser, (key, value)| {
            match key.as_ref() {
                "sslmode" => {
                    if value == SSL_MODE_PREFER {
                        ser.append_pair(&key, SSL_MODE_DISABLE);
                    } else {
                        ser.append_pair(&key, &value);
                    }
                }
                "ssl-mode" => {
                    if value == SSL_MODE_PREFER {
                        ser.append_pair(&key, SSL_MODE_DISABLE);
                    } else {
                        ser.append_pair(&key, &value);
                    }
                }
                _ => {
                    ser.append_pair(&key, &value);
                }
            };
            ser
        });

    Ok(url.to_string())
}

#[cfg(test)]
mod tests {
    use super::*;

    use std::env::remove_var;

    #[test]
    fn test_update_env() {
        remove_var("PGPORT");
        remove_var("PGSSLMODE");
        update_env();
        assert_eq!(var("PGPORT").unwrap(), "9005");
        assert_eq!(var("PGSSLMODE").unwrap(), "disable");

        remove_var("PGPORT");
        remove_var("PGSSLMODE");
        set_var("PGSSLMODE", "prefer");
        update_env();
        assert_eq!(var("PGPORT").unwrap(), "9005");
        assert_eq!(var("PGSSLMODE").unwrap(), "disable");
    }

    #[test]
    fn test_update_url() {
        let uri = "postgres:///?sslmode=prefer";
        assert_eq!(update_url(uri).unwrap(), "postgres:///?sslmode=disable");

        let uri = "postgres:///?ssl-mode=prefer";
        assert_eq!(update_url(uri).unwrap(), "postgres:///?ssl-mode=disable");
    }
}