wtchr.de Gotweb

Commit Diff

Commit:: 5dae9c67009d122d97818ee8b9fd24dec7a37e7b
From:: Thomas Böhler <witcher@wiredspace.de>
Date:: Sun Aug 10 07:55:59 2025 UTC
Message:: chore: add sqlx query metadata Generate the sqlx query metadata for offline compile-time verification (like used in contrib/githooks/pre-commit). Signed-off-by: Thomas Böhler <witcher@wiredspace.de>
Actions:: Patch | Tree

commit - 5f2f73a1570567ccccb1787aad953e84a905b3a2
commit + 5dae9c67009d122d97818ee8b9fd24dec7a37e7b
blob - /dev/null
blob + b3265f25dcabe8ad8892e936f94ad9efa29b7bbd (mode 644)
--- /dev/null
+++ .sqlx/query-16366cbbd996bcafbc346fd577ad22dcf6087ba19c051333876905a3a84317f7.json
@@ -0,0 +1,12 @@
+{
+  "db_name": "SQLite",
+  "query": "update posts set sent = true where guid = ?",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Right": 1
+    },
+    "nullable": []
+  },
+  "hash": "16366cbbd996bcafbc346fd577ad22dcf6087ba19c051333876905a3a84317f7"
+}
blob - /dev/null
blob + ccc87c84f9775c81c35e578488764b0200eb8df8 (mode 644)
--- /dev/null
+++ .sqlx/query-9955438bce6b0c7cd1c7896a6fdf0b7b58390a5d996ba7cef003bd4b3052353d.json
@@ -0,0 +1,50 @@
+{
+  "db_name": "SQLite",
+  "query": "select * from posts where sent != true order by pub_date desc",
+  "describe": {
+    "columns": [
+      {
+        "name": "guid",
+        "ordinal": 0,
+        "type_info": "Text"
+      },
+      {
+        "name": "title",
+        "ordinal": 1,
+        "type_info": "Text"
+      },
+      {
+        "name": "url",
+        "ordinal": 2,
+        "type_info": "Text"
+      },
+      {
+        "name": "pub_date",
+        "ordinal": 3,
+        "type_info": "Integer"
+      },
+      {
+        "name": "content",
+        "ordinal": 4,
+        "type_info": "Text"
+      },
+      {
+        "name": "sent",
+        "ordinal": 5,
+        "type_info": "Bool"
+      }
+    ],
+    "parameters": {
+      "Right": 0
+    },
+    "nullable": [
+      false,
+      true,
+      true,
+      true,
+      true,
+      false
+    ]
+  },
+  "hash": "9955438bce6b0c7cd1c7896a6fdf0b7b58390a5d996ba7cef003bd4b3052353d"
+}
blob - /dev/null
blob + 379887189b3b283f7e85e64dd47f9130c4f95223 (mode 644)
--- /dev/null
+++ .sqlx/query-a0e1000c1a200a436e2f33b36adf4ca6b7a8edcc950c9b22a161ba2d47d8315b.json
@@ -0,0 +1,50 @@
+{
+  "db_name": "SQLite",
+  "query": "select *\n                     from posts\n                     where guid = ?",
+  "describe": {
+    "columns": [
+      {
+        "name": "guid",
+        "ordinal": 0,
+        "type_info": "Text"
+      },
+      {
+        "name": "title",
+        "ordinal": 1,
+        "type_info": "Text"
+      },
+      {
+        "name": "url",
+        "ordinal": 2,
+        "type_info": "Text"
+      },
+      {
+        "name": "pub_date",
+        "ordinal": 3,
+        "type_info": "Integer"
+      },
+      {
+        "name": "content",
+        "ordinal": 4,
+        "type_info": "Text"
+      },
+      {
+        "name": "sent",
+        "ordinal": 5,
+        "type_info": "Bool"
+      }
+    ],
+    "parameters": {
+      "Right": 1
+    },
+    "nullable": [
+      false,
+      true,
+      true,
+      true,
+      true,
+      false
+    ]
+  },
+  "hash": "a0e1000c1a200a436e2f33b36adf4ca6b7a8edcc950c9b22a161ba2d47d8315b"
+}
blob - /dev/null
blob + e19aa462e2a412fe81df762117425a7cf53b2086 (mode 644)
--- /dev/null
+++ .sqlx/query-e8c193917469a0ee24db731dd5ccef549b01e97eb3d05deb46706bd702b587fc.json
@@ -0,0 +1,12 @@
+{
+  "db_name": "SQLite",
+  "query": "insert or ignore into posts (guid, title, url, pub_date, content) values (?, ?, ?, ?, ?)",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Right": 5
+    },
+    "nullable": []
+  },
+  "hash": "e8c193917469a0ee24db731dd5ccef549b01e97eb3d05deb46706bd702b587fc"
+}