libsql-ffi 0.2.1

Native bindings to libSQL
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72

#include <sqlite3mc/sqlite3mc.h>
#include <stdio.h>

int main(int argc, char *argv[])
{
    sqlite3 *db;
    const char *key = "password";
    const char *wrongKey = "wrongPassword";

    // Create database
    int rc = sqlite3_open("test.db", &db);
    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "Failed to open database: %s\n", sqlite3_errmsg(db));
        sqlite3_close(db);
        return 1;
    }

    // Encrypt
    sqlite3_key(db, key, strlen(key));

    // Fill db with some data and close it
    rc = sqlite3_exec(db, "CREATE TABLE users (name TEXT NOT NULL, ID INTEGER PRIMARY KEY UNIQUE)", NULL, NULL, NULL);
    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
        sqlite3_close(db);
        return 1;
    }
    rc = sqlite3_exec(db, "INSERT INTO users (name, ID) VALUES ('testUser', '12345')", NULL, NULL, NULL);
    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
        sqlite3_close(db);
        return 1;
    }
    rc = sqlite3_close(db);
    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "Failed to close database: %s\n", sqlite3_errmsg(db));
        return 1;
    }

    // Reopen and provide wrong key
    rc = sqlite3_open("test.db", &db);
    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "Failed to open database: %s\n", sqlite3_errmsg(db));
        sqlite3_close(db);
        return 1;
    }
    sqlite3_key(db, wrongKey, strlen(wrongKey));

    // Try to access the database, should fail
    rc = sqlite3_exec(db, "SELECT name FROM users WHERE ID = '12345'", NULL, NULL, NULL);
    if (rc == SQLITE_OK)
    {
        fprintf(stderr, "Access was provided without the proper key\n");
        sqlite3_close(db);
        return 1;
    }
    rc = sqlite3_close(db);
    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "Failed to close database: %s\n", sqlite3_errmsg(db));
        return 1;
    }


    fprintf(stdout, "Test successful\n");
    return 0;
}