From 4ccc095ed2efeda97805bdfb9473f62ed46220b7 Mon Sep 17 00:00:00 2001 From: Akshay Nair Date: Tue, 2 Jun 2026 11:51:17 +0530 Subject: Show pixels from db --- src/main.c | 55 ++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 54 insertions(+), 1 deletion(-) (limited to 'src/main.c') diff --git a/src/main.c b/src/main.c index 23d6e58..2da78b0 100644 --- a/src/main.c +++ b/src/main.c @@ -1,5 +1,28 @@ #include #include +#include + +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; @@ -10,8 +33,38 @@ int main(void) { return 1; } - printf("Foobar\n"); + 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; } -- cgit v1.3.1