commit - 7e1e64f5db5593deaefdac146e4d91fb5d16d7d7
commit + 4a617a0f911d249aeeb72d96dae966edbb4dfc53
blob - b1eab722bc189f77be4945956ba7ef9f34c6188d
blob + 1651d895497d8728f2af5f1e417b8ffd73e3aa67
--- migrations/20221120130636_create_posts_table.down.sql
+++ migrations/20221120130636_create_posts_table.down.sql
@@ -1 +1 @@
-DROP TABLE posts
+DROP TABLE posts;
blob - fa5e70c2498450231d92b8f201cf6ae42a1c9c65
blob + a3950de1bc8d33c27da985c483ad814d14b42a26
--- migrations/20221120130636_create_posts_table.up.sql
+++ migrations/20221120130636_create_posts_table.up.sql
@@ -7,4 +7,4 @@ CREATE TABLE posts (
 	pub_date BIGINT,
 	content TEXT,
 	sent BOOLEAN NOT NULL DEFAULT 0
-)
+);
blob - /dev/null
blob + e544b4075bbf99103bf8785ee1764f589fef5295 (mode 644)
--- /dev/null
+++ sqlx-data.json
@@ -0,0 +1,83 @@
+{
+  "db": "SQLite",
+  "16366cbbd996bcafbc346fd577ad22dcf6087ba19c051333876905a3a84317f7": {
+    "describe": {
+      "columns": [],
+      "nullable": [],
+      "parameters": {
+        "Right": 1
+      }
+    },
+    "query": "update posts set sent = true where guid = ?"
+  },
+  "5340013611d6d969ae2e330a70c35ac280e821f1367b38d6cecaaa26dfe2a40c": {
+    "describe": {
+      "columns": [],
+      "nullable": [],
+      "parameters": {
+        "Right": 7
+      }
+    },
+    "query": "insert into posts (guid, title, author, url, feedurl, pub_date, content) values (?, ?, ?, ?, ?, ?, ?)"
+  },
+  "9955438bce6b0c7cd1c7896a6fdf0b7b58390a5d996ba7cef003bd4b3052353d": {
+    "describe": {
+      "columns": [
+        {
+          "name": "guid",
+          "ordinal": 0,
+          "type_info": "Text"
+        },
+        {
+          "name": "title",
+          "ordinal": 1,
+          "type_info": "Text"
+        },
+        {
+          "name": "author",
+          "ordinal": 2,
+          "type_info": "Text"
+        },
+        {
+          "name": "url",
+          "ordinal": 3,
+          "type_info": "Text"
+        },
+        {
+          "name": "feedurl",
+          "ordinal": 4,
+          "type_info": "Text"
+        },
+        {
+          "name": "pub_date",
+          "ordinal": 5,
+          "type_info": "Int64"
+        },
+        {
+          "name": "content",
+          "ordinal": 6,
+          "type_info": "Text"
+        },
+        {
+          "name": "sent",
+          "ordinal": 7,
+          "type_info": "Bool"
+        }
+      ],
+      "nullable": [
+        false,
+        true,
+        true,
+        true,
+        true,
+        true,
+        true,
+        false
+      ],
+      "parameters": {
+        "Right": 0
+      }
+    },
+    "query": "select * from posts where sent != true order by pub_date desc"
+  }
+}
\ No newline at end of file