easy-sqlx-core 0.1.7

The Rust Toolkit to easy use sqlx
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

pub const TABLE_NAME: &str = "__easy_upgrade";
pub const TABLE_DDL: &str = r#"
 CREATE TABLE public.__easy_upgrade
    (
        id BIGSERIAL,
        table_name character varying(255),
        up_tag character varying(20),
        up_value character varying(255),
        create_time character varying(20),
        PRIMARY KEY (id)
    );
"#;

pub const TABLE_INSERT: &str = r#"
 insert into public.__easy_upgrade
    (
        table_name,
        up_tag,
        up_value,
        create_time
    )
    values 
    (
        $1, $2, $3, $4
    )
"#;

pub const TABLE_QUERY: &str = r#"
    select id,
        table_name,
        up_tag,
        up_value,
        create_time 
    from public.__easy_upgrade
    where table_name = $1 and up_tag = $2
    order by id desc
"#;

#[derive(Default, sqlx::FromRow, Debug)]
pub struct Upgrade {
    pub id: i64,
    pub table_name: String,
    pub up_tag: String,
    pub up_value: String,
    pub create_time: String,
}

// impl<'r, DB: sqlx::Database> sqlx::FromRow<'r, <DB as sqlx::Database>::Row> for Upgrade {
//     fn from_row(row: &'r <DB as sqlx::Database>::Row) -> Result<Self, sqlx::Error> {
//         todo!()
//     }
// }