sq3-rs 0.2.2

SQLite reader with no dependencies
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

use crate::SqliteConnection;

// const TEST_QUERIES: [&str; 10] = [
const TEST_QUERIES: [&str; 5] = [
    "SELECT (1)",
    "SELECT (5+2)",
    "SELECT (5-2)",
    "SELECT (5*2)",
    "SELECT (5/2)",
    // "SELECT id,name FROM users WHERE age > 18",
    // "UPDATE users SET name = 'John' WHERE id = 1",
    // "INSERT INTO users (name, age) VALUES ('Alice', 30)",
    // "DELETE FROM users WHERE id = 5",
    // "TRUNCATE TABLE users",
];

#[test]
#[ignore = "Todo"]
fn run_queries() {
    let conn_str = "./data/small.sqlite3";
    let mut conn = SqliteConnection::connect(conn_str).unwrap();
    for query in TEST_QUERIES {
        println!("Query: {}", query);

        match conn.run_query(query) {
            Ok(parsed_query) => println!("Parsed query: {:#?}", parsed_query),
            Err(e) => println!("Error: {}", e),
        }
    }
}