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
|
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "sqlite3.h"
#include "data.h"
int main(void) {
sqlite3 *db;
int rc;
rc = sqlite3_open(":memory:", &db);
if (rc != SQLITE_OK) {
fprintf(stderr, "Cannot open database: %s\n", sqlite3_errmsg(db));
return 1;
}
rc = sqlite3_deserialize(db, "main", data, data_len, data_len, SQLITE_DESERIALIZE_READONLY);
if (rc != SQLITE_OK) {
fprintf(stderr, "Failed to load database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
return 1;
}
printf("Database loaded successfully!\n");
sqlite3_stmt *stmt;
const char *sql = "SELECT name FROM sqlite_master WHERE type='table';";
rc = sqlite3_prepare_v2(db, sql, -1, &stmt, NULL);
if (rc == SQLITE_OK) {
printf("Tables in database:\n");
while (sqlite3_step(stmt) == SQLITE_ROW) {
printf("- %s\n", sqlite3_column_text(stmt, 0));
}
sqlite3_finalize(stmt);
}
sqlite3_close(db);
return 0;
}
|
