From 9d14d9ca39b46042c4196382613dd9c4bf711fcb Mon Sep 17 00:00:00 2001
From: Joel Klinghed <the_jk@spawned.biz>
Date: Mon, 27 Jan 2025 22:57:15 +0100
Subject: Add user keys to database

Next step is to generate authorized_keys files for git server
based on keys.
---
 ...180e5ebb59fc78c9a71a34ec3f4309c2b495b1eeee.json | 58 ++++++++++++++++++++++
 ...6cc575b5888bfd6b7e3aa60fb50d58fb2e46231e79.json | 25 ++++++++++
 ...5cd4423b22f84fd28b8a07f21fbcee0d907873c591.json | 12 +++++
 ...843507c69b3d34a4ef3f30ce5fefc0d3bc2e284faa.json | 58 ++++++++++++++++++++++
 ...31e4732e97e6119d519263f8b188550fc2bfe707f3.json | 12 +++++
 5 files changed, 165 insertions(+)
 create mode 100644 server/.sqlx/query-322c1c671af1dc5daf2303180e5ebb59fc78c9a71a34ec3f4309c2b495b1eeee.json
 create mode 100644 server/.sqlx/query-7dff27857ca04ff487c71c6cc575b5888bfd6b7e3aa60fb50d58fb2e46231e79.json
 create mode 100644 server/.sqlx/query-947c8d9f63c791b1e56eb85cd4423b22f84fd28b8a07f21fbcee0d907873c591.json
 create mode 100644 server/.sqlx/query-a384335c775a26f6780e8b843507c69b3d34a4ef3f30ce5fefc0d3bc2e284faa.json
 create mode 100644 server/.sqlx/query-ec7cb8523695d2bf73721631e4732e97e6119d519263f8b188550fc2bfe707f3.json

(limited to 'server/.sqlx')

diff --git a/server/.sqlx/query-322c1c671af1dc5daf2303180e5ebb59fc78c9a71a34ec3f4309c2b495b1eeee.json b/server/.sqlx/query-322c1c671af1dc5daf2303180e5ebb59fc78c9a71a34ec3f4309c2b495b1eeee.json
new file mode 100644
index 0000000..9ec46e5
--- /dev/null
+++ b/server/.sqlx/query-322c1c671af1dc5daf2303180e5ebb59fc78c9a71a34ec3f4309c2b495b1eeee.json
@@ -0,0 +1,58 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT id,kind,data,comment FROM user_keys WHERE id=? AND user=?",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "id",
+        "type_info": {
+          "type": "LongLong",
+          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
+          "char_set": 63,
+          "max_size": 20
+        }
+      },
+      {
+        "ordinal": 1,
+        "name": "kind",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
+        }
+      },
+      {
+        "ordinal": 2,
+        "name": "data",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 32768
+        }
+      },
+      {
+        "ordinal": 3,
+        "name": "comment",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      }
+    ],
+    "parameters": {
+      "Right": 2
+    },
+    "nullable": [
+      false,
+      false,
+      false,
+      false
+    ]
+  },
+  "hash": "322c1c671af1dc5daf2303180e5ebb59fc78c9a71a34ec3f4309c2b495b1eeee"
+}
diff --git a/server/.sqlx/query-7dff27857ca04ff487c71c6cc575b5888bfd6b7e3aa60fb50d58fb2e46231e79.json b/server/.sqlx/query-7dff27857ca04ff487c71c6cc575b5888bfd6b7e3aa60fb50d58fb2e46231e79.json
new file mode 100644
index 0000000..5b52cc0
--- /dev/null
+++ b/server/.sqlx/query-7dff27857ca04ff487c71c6cc575b5888bfd6b7e3aa60fb50d58fb2e46231e79.json
@@ -0,0 +1,25 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT COUNT(id) AS count FROM user_keys WHERE user=?",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "count",
+        "type_info": {
+          "type": "LongLong",
+          "flags": "NOT_NULL | BINARY",
+          "char_set": 63,
+          "max_size": 21
+        }
+      }
+    ],
+    "parameters": {
+      "Right": 1
+    },
+    "nullable": [
+      false
+    ]
+  },
+  "hash": "7dff27857ca04ff487c71c6cc575b5888bfd6b7e3aa60fb50d58fb2e46231e79"
+}
diff --git a/server/.sqlx/query-947c8d9f63c791b1e56eb85cd4423b22f84fd28b8a07f21fbcee0d907873c591.json b/server/.sqlx/query-947c8d9f63c791b1e56eb85cd4423b22f84fd28b8a07f21fbcee0d907873c591.json
new file mode 100644
index 0000000..4ce7b53
--- /dev/null
+++ b/server/.sqlx/query-947c8d9f63c791b1e56eb85cd4423b22f84fd28b8a07f21fbcee0d907873c591.json
@@ -0,0 +1,12 @@
+{
+  "db_name": "MySQL",
+  "query": "DELETE FROM user_keys WHERE id=? AND user=?",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Right": 2
+    },
+    "nullable": []
+  },
+  "hash": "947c8d9f63c791b1e56eb85cd4423b22f84fd28b8a07f21fbcee0d907873c591"
+}
diff --git a/server/.sqlx/query-a384335c775a26f6780e8b843507c69b3d34a4ef3f30ce5fefc0d3bc2e284faa.json b/server/.sqlx/query-a384335c775a26f6780e8b843507c69b3d34a4ef3f30ce5fefc0d3bc2e284faa.json
new file mode 100644
index 0000000..9d50b8a
--- /dev/null
+++ b/server/.sqlx/query-a384335c775a26f6780e8b843507c69b3d34a4ef3f30ce5fefc0d3bc2e284faa.json
@@ -0,0 +1,58 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT id,kind,data,comment FROM user_keys WHERE user=? ORDER BY id LIMIT ? OFFSET ?",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "id",
+        "type_info": {
+          "type": "LongLong",
+          "flags": "NOT_NULL | PRIMARY_KEY | UNSIGNED | AUTO_INCREMENT",
+          "char_set": 63,
+          "max_size": 20
+        }
+      },
+      {
+        "ordinal": 1,
+        "name": "kind",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
+        }
+      },
+      {
+        "ordinal": 2,
+        "name": "data",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 32768
+        }
+      },
+      {
+        "ordinal": 3,
+        "name": "comment",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      }
+    ],
+    "parameters": {
+      "Right": 3
+    },
+    "nullable": [
+      false,
+      false,
+      false,
+      false
+    ]
+  },
+  "hash": "a384335c775a26f6780e8b843507c69b3d34a4ef3f30ce5fefc0d3bc2e284faa"
+}
diff --git a/server/.sqlx/query-ec7cb8523695d2bf73721631e4732e97e6119d519263f8b188550fc2bfe707f3.json b/server/.sqlx/query-ec7cb8523695d2bf73721631e4732e97e6119d519263f8b188550fc2bfe707f3.json
new file mode 100644
index 0000000..b1aa378
--- /dev/null
+++ b/server/.sqlx/query-ec7cb8523695d2bf73721631e4732e97e6119d519263f8b188550fc2bfe707f3.json
@@ -0,0 +1,12 @@
+{
+  "db_name": "MySQL",
+  "query": "INSERT INTO user_keys (user, kind, data, comment) VALUES (?, ?, ?, ?)",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Right": 4
+    },
+    "nullable": []
+  },
+  "hash": "ec7cb8523695d2bf73721631e4732e97e6119d519263f8b188550fc2bfe707f3"
+}
-- 
cgit v1.2.3-70-g09d2