fsqlite 0.2.0

Public API facade
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

use fsqlite::Connection;
use fsqlite_types::SqliteValue;

#[test]
fn test_insert_test() {
    asupersync::test_utils::run_test(|| async {
        let conn = Connection::open(":memory:").await.unwrap();
        conn.execute("CREATE TABLE src (a INTEGER, b TEXT);")
            .await
            .unwrap();
        conn.execute("CREATE TABLE dst (x TEXT, y INTEGER);")
            .await
            .unwrap();
        conn.execute("INSERT INTO src VALUES (10, 'ten');")
            .await
            .unwrap();

        let rows = conn.query("SELECT a, b FROM src;").await.unwrap();
        println!("src row 0: {:?}", rows[0].values());

        conn.execute("INSERT INTO dst (y, x) SELECT a, b FROM src;")
            .await
            .unwrap();

        let rows2 = conn.query("SELECT x, y FROM dst;").await.unwrap();
        println!("dst row 0: {:?}", rows2[0].values());
        assert_eq!(
            rows2[0].values(),
            &[SqliteValue::Text("ten".into()), SqliteValue::Integer(10)]
        );
    });
}