luna-orm 0.3.6

ORM based on 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

use luna_orm::prelude::*;
use luna_orm::LunaOrmResult;

pub async fn setup_database() -> LunaOrmResult<DB<SqliteDatabase>> {
    let config = SqliteLocalConfig::new("./workspace", "test.db");
    let db: SqliteDatabase = SqliteDatabase::build(config).await.unwrap();
    let mut db: DB<SqliteDatabase> = DB(db);
    db.execute_plain("DROP TABLE IF EXISTS `article`")
        .await
        .unwrap();
    db.execute_plain(
        "CREATE TABLE IF NOT EXISTS `article`(`id` INT PRIMARY KEY, `age` INT, `content` VARCHAR(64))",
    ).await?;
    Ok(db)
}

pub async fn create_table<T>(
    db: &mut DB<T>,
    table_name: &str,
    create_table_stmt: &str,
) -> LunaOrmResult<bool>
where
    T: Database,
{
    let drop_stmt = format!("DROP TABLE IF EXISTS `{}`", table_name);
    db.execute_plain(&drop_stmt).await?;
    db.execute_plain(create_table_stmt).await?;
    //let delete_stmt = format!("DELETE FROM `{}`", table_name);
    //db.execute_plain(&delete_stmt).await?;
    Ok(true)
}