real-time-sqlx 0.1.1

Real-time SQLx backend for Tauri
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

//! Dummy data for testing

use std::fs;

use serde::{Deserialize, Serialize};
use sqlx::{prelude::FromRow, Pool, Sqlite};

/// A dummy struct for testing purposes
#[derive(Debug, Clone, Serialize, Deserialize, FromRow, Eq, PartialEq)]
pub struct Todo {
    pub id: i32,
    pub title: String,
    pub content: String,
}

#[cfg(feature = "sqlite")]
/// Create an in-memory Sqlite database and return a pool connection
pub async fn dummy_sqlite_database() -> Pool<Sqlite> {
    sqlx::sqlite::SqlitePoolOptions::new()
        .connect("sqlite::memory:")
        .await
        .expect("Failed to create an in-memory sqlite database")
}

#[cfg(feature = "sqlite")]
/// Create and seed a Sqlite database from a pool connection
pub async fn prepare_dummy_sqlite_database(pool: &Pool<Sqlite>) {
    let mut tx = pool.begin().await.unwrap();

    let create_stmt = fs::read_to_string("src/tests/sql/01_create.sql").unwrap();
    let query = sqlx::query(&create_stmt);

    query
        .execute(&mut *tx)
        .await
        .expect("Failed to create a dummy database");

    let insert_stmt = fs::read_to_string("src/tests/sql/02_insert.sql").unwrap();
    let query = sqlx::query(&insert_stmt);

    query
        .execute(&mut *tx)
        .await
        .expect("Failed to insert dummy data");

    tx.commit()
        .await
        .expect("Failed to prepare a dummy database");
}