Show pixels from db

1 files changed, 54 insertions, 1 deletions

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 <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;
@@ -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;
 }