sea-schema 0.18.0

🌿 SQL schema definition and discovery
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

use sea_query::{MysqlQueryBuilder, SelectStatement};
use sea_query_sqlx::SqlxBinder;
use sqlx::MySqlPool;

use crate::{
    Connection, debug_print,
    sqlx_types::{Row, SqlxError, SqlxRow, mysql::MySqlRow},
};

pub struct Executor {
    pool: MySqlPool,
}

pub trait IntoExecutor {
    fn into_executor(self) -> Executor;
}

impl IntoExecutor for MySqlPool {
    fn into_executor(self) -> Executor {
        Executor { pool: self }
    }
}

pub trait GetMySqlValue {
    fn get_string(&self, idx: usize) -> String;

    fn get_string_opt(&self, idx: usize) -> Option<String>;
}

impl GetMySqlValue for MySqlRow {
    fn get_string(&self, idx: usize) -> String {
        String::from_utf8(self.get::<Vec<u8>, _>(idx)).unwrap()
    }

    fn get_string_opt(&self, idx: usize) -> Option<String> {
        self.get::<Option<Vec<u8>>, _>(idx)
            .map(|v| String::from_utf8(v).unwrap())
    }
}

#[async_trait::async_trait(?Send)]
impl Connection for Executor {
    async fn query_all(&self, select: SelectStatement) -> Result<Vec<SqlxRow>, SqlxError> {
        let (sql, values) = select.build_sqlx(MysqlQueryBuilder);
        debug_print!("{}, {:?}", sql, values);

        Ok(sqlx::query_with(sqlx::AssertSqlSafe(sql), values)
            .fetch_all(&mut *self.pool.acquire().await?)
            .await?
            .into_iter()
            .map(SqlxRow::MySql)
            .collect())
    }

    async fn query_all_raw(&self, sql: String) -> Result<Vec<SqlxRow>, SqlxError> {
        debug_print!("{}", sql);

        Ok(sqlx::query(sqlx::AssertSqlSafe(sql))
            .fetch_all(&mut *self.pool.acquire().await?)
            .await?
            .into_iter()
            .map(SqlxRow::MySql)
            .collect())
    }
}