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

pub use sqlx::*;

pub type SqlxError = sqlx::Error;

#[cfg(not(feature = "sqlx-mysql"))]
pub struct MySqlPool;

#[cfg(not(feature = "sqlx-postgres"))]
pub struct PgPool;

#[cfg(not(feature = "sqlx-sqlite"))]
pub struct SqlitePool;

pub enum SqlxRow {
    #[cfg(feature = "sqlx-mysql")]
    MySql(sqlx::mysql::MySqlRow),
    #[cfg(feature = "sqlx-postgres")]
    Postgres(sqlx::postgres::PgRow),
    #[cfg(feature = "sqlx-sqlite")]
    Sqlite(sqlx::sqlite::SqliteRow),
}

#[allow(unreachable_patterns)]
impl SqlxRow {
    #[cfg(feature = "sqlx-mysql")]
    pub fn mysql(self) -> mysql::MySqlRow {
        match self {
            Self::MySql(row) => row,
            _ => panic!("Not MySql"),
        }
    }

    #[cfg(feature = "sqlx-postgres")]
    pub fn postgres(self) -> postgres::PgRow {
        match self {
            Self::Postgres(row) => row,
            _ => panic!("Not Postgres"),
        }
    }

    #[cfg(feature = "sqlx-sqlite")]
    pub fn sqlite(self) -> sqlite::SqliteRow {
        match self {
            Self::Sqlite(row) => row,
            _ => panic!("Not Sqlite"),
        }
    }
}

#[cfg(feature = "sqlx-sqlite")]
pub async fn connect_sqlite(s: &str) -> Result<SqlitePool, SqlxError> {
    SqlitePool::connect(s).await
}

#[cfg(feature = "sqlx-sqlite")]
pub async fn execute_sqlite(pool: &SqlitePool, sql: &str) -> Result<(), SqlxError> {
    sqlx::query(sqlx::AssertSqlSafe(sql)).execute(pool).await?;
    Ok(())
}