clickhouse-postgres-client 0.2.0

ClickHouse Postgres Client
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

use sqlx_clickhouse_ext::{
    sqlx_core::{
        column::Column as _, column::ColumnIndex, error::Error, postgres::PgRow, row::Row as _,
        type_info::TypeInfo as _, value::ValueRef as _,
    },
    value::ValueRefTryGet as _,
};

use crate::type_info::{ClickhousePgType, ClickhousePgValue};

pub struct ClickhousePgRow {
    inner: PgRow,
}
impl From<PgRow> for ClickhousePgRow {
    fn from(row: PgRow) -> Self {
        Self { inner: row }
    }
}
impl ClickhousePgRow {
    pub fn try_get_data(&self) -> Result<Vec<(&str, ClickhousePgValue)>, Error> {
        let mut array = vec![];
        for (i, column) in self.inner.columns().iter().enumerate() {
            array.push((column.name(), self.try_get_value(i)?));
        }
        Ok(array)
    }

    pub fn try_get_value<I>(&self, index: I) -> Result<ClickhousePgValue, Error>
    where
        I: ColumnIndex<PgRow>,
    {
        let index = index.index(&self.inner)?;

        let value = self.inner.try_get_raw(index)?;

        let cpt = ClickhousePgType::try_from((value.type_info().name(), index))?;

        match cpt {
            ClickhousePgType::Char => (value, index).try_get().map(ClickhousePgValue::Char),
            ClickhousePgType::Int2 => {
                // Fix v23
                if let Ok(bytes) = value.as_bytes() {
                    match bytes {
                        b"true" => {
                            return Ok(ClickhousePgValue::Bool(true));
                        }
                        b"false" => {
                            return Ok(ClickhousePgValue::Bool(false));
                        }
                        _ => {}
                    }
                }
                (value, index).try_get().map(ClickhousePgValue::I16)
            }
            ClickhousePgType::Int4 => (value, index).try_get().map(ClickhousePgValue::I32),
            ClickhousePgType::Int8 => (value, index).try_get().map(ClickhousePgValue::I64),
            ClickhousePgType::Float4 => (value, index).try_get().map(ClickhousePgValue::F32),
            ClickhousePgType::Float8 => (value, index).try_get().map(ClickhousePgValue::F64),
            ClickhousePgType::Varchar => (value, index).try_get().map(ClickhousePgValue::String),
            #[cfg(feature = "chrono")]
            ClickhousePgType::Date => (value, index).try_get().map(ClickhousePgValue::NaiveDate),
            #[cfg(feature = "bigdecimal")]
            ClickhousePgType::Numeric => {
                (value, index).try_get().map(ClickhousePgValue::BigDecimal)
            }
            #[cfg(feature = "uuid")]
            ClickhousePgType::Uuid => (value, index).try_get().map(ClickhousePgValue::Uuid),
        }
    }
}