diff options
| author | Akshay Nair <phenax5@gmail.com> | 2026-06-02 21:28:39 +0530 |
|---|---|---|
| committer | Akshay Nair <phenax5@gmail.com> | 2026-06-02 21:28:39 +0530 |
| commit | 49bc31720ab6206980cda95a0a30a44e7f882fcc (patch) | |
| tree | 9dc6540563d04dd4daceb8b716d83b15a0de89d3 /src | |
| parent | 4ccc095ed2efeda97805bdfb9473f62ed46220b7 (diff) | |
| download | sqlite-creative-coding-49bc31720ab6206980cda95a0a30a44e7f882fcc.tar.gz sqlite-creative-coding-49bc31720ab6206980cda95a0a30a44e7f882fcc.zip | |
Clean up the c stuff and switch to simple bash + add example
Diffstat (limited to 'src')
| -rw-r--r-- | src/main.c | 70 |
1 files changed, 0 insertions, 70 deletions
diff --git a/src/main.c b/src/main.c deleted file mode 100644 index 2da78b0..0000000 --- a/src/main.c +++ /dev/null @@ -1,70 +0,0 @@ -#include <sqlite3.h> -#include <stdio.h> -#include <string.h> - -typedef struct { - int x; - int y; - int r; - int g; - int b; -} Pixel; - -void show_pixels(Pixel *pixels, int len) { - for (int i = 0; i < len; i++) { - Pixel p = pixels[i]; - printf("%d %d %d\n", p.r, p.g, p.b); - } -} - -void show_image(Pixel *pixels, int len) { - printf("P3\n"); - printf("%d %d\n", 6, 6); - printf("%d\n", 255); - show_pixels(pixels, len); -} - -int main(void) { - sqlite3 *db; - - sqlite3_open("fun.db", &db); - if (db == NULL) { - printf("Unable to open db\n"); - return 1; - } - - sqlite3_stmt *stmt; - sqlite3_prepare_v2(db, - "select x, y, r, g, b from pixels ORDER BY y ASC, x ASC", - -1, &stmt, NULL); - - Pixel pixels[200 * 200]; - int index = 0; - - while (sqlite3_step(stmt) != SQLITE_DONE) { - int num_cols = sqlite3_column_count(stmt); - Pixel pixel; - for (int col = 0; col < num_cols; col++) { - const char *name = sqlite3_column_name(stmt, col); - if (strcmp(name, "x") == 0) - pixel.x = sqlite3_column_int(stmt, col); - else if (strcmp(name, "y") == 0) - pixel.y = sqlite3_column_int(stmt, col); - else if (strcmp(name, "r") == 0) - pixel.r = sqlite3_column_int(stmt, col); - else if (strcmp(name, "g") == 0) - pixel.g = sqlite3_column_int(stmt, col); - else if (strcmp(name, "b") == 0) - pixel.b = sqlite3_column_int(stmt, col); - } - pixels[index++] = pixel; - } - int frames = 1; - for (int i = 0; i < frames; i++) - show_image(pixels, index); - - sqlite3_finalize(stmt); - sqlite3_close(db); - - return 0; -} |
