Include branch in project/reviews response

But also add /review endpoint that takes an id. So you can get
review data with either the reviewid or the branchname.

3 files changed, 133 insertions, 20 deletions

diff --git a/server/.sqlx/query-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json b/server/.sqlx/query-0d7020607f7137538a3526e9e4cee127079adc31aa21ab57ff8038b20fac5785.json
index 22a6d40..8f0fda3 100644
--- a/server/.sqlx/query-956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831.json
+++ b/server/.sqlx/query-0d7020607f7137538a3526e9e4cee127079adc31aa21ab57ff8038b20fac5785.json
@@ -1,6 +1,6 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT reviews.id AS id,title,state,progress,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? ORDER BY id DESC LIMIT ? OFFSET ?",
+  "query": "SELECT reviews.id AS id,title,state,progress,branch,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? ORDER BY id DESC LIMIT ? OFFSET ?",
   "describe": {
     "columns": [
       {
@@ -45,6 +45,16 @@
       },
       {
         "ordinal": 4,
+        "name": "branch",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      },
+      {
+        "ordinal": 5,
         "name": "user_id",
         "type_info": {
           "type": "VarString",
@@ -54,7 +64,7 @@
         }
       },
       {
-        "ordinal": 5,
+        "ordinal": 6,
         "name": "name",
         "type_info": {
           "type": "VarString",
@@ -64,7 +74,7 @@
         }
       },
       {
-        "ordinal": 6,
+        "ordinal": 7,
         "name": "user_dn",
         "type_info": {
           "type": "VarString",
@@ -84,8 +94,9 @@
       false,
       false,
       false,
+      false,
       true
     ]
   },
-  "hash": "956140cf5bb8421762ee55e7ab7ce179eac7fb43ee9fb4a0c35ef3792a2df831"
+  "hash": "0d7020607f7137538a3526e9e4cee127079adc31aa21ab57ff8038b20fac5785"
 }
diff --git a/server/.sqlx/query-5566324138b5b05c369f70857d3d92603401f76dd5962159892a720537c96136.json b/server/.sqlx/query-5566324138b5b05c369f70857d3d92603401f76dd5962159892a720537c96136.json
new file mode 100644
index 0000000..df62083
--- /dev/null
+++ b/server/.sqlx/query-5566324138b5b05c369f70857d3d92603401f76dd5962159892a720537c96136.json
@@ -0,0 +1,113 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT title,description,state,progress,branch,archived,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? AND reviews.id=?",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "title",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      },
+      {
+        "ordinal": 1,
+        "name": "description",
+        "type_info": {
+          "type": "Blob",
+          "flags": "NOT_NULL | BLOB",
+          "char_set": 224,
+          "max_size": 67108860
+        }
+      },
+      {
+        "ordinal": 2,
+        "name": "state",
+        "type_info": {
+          "type": "Tiny",
+          "flags": "NOT_NULL | UNSIGNED",
+          "char_set": 63,
+          "max_size": 3
+        }
+      },
+      {
+        "ordinal": 3,
+        "name": "progress",
+        "type_info": {
+          "type": "Float",
+          "flags": "NOT_NULL",
+          "char_set": 63,
+          "max_size": 12
+        }
+      },
+      {
+        "ordinal": 4,
+        "name": "branch",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      },
+      {
+        "ordinal": 5,
+        "name": "archived",
+        "type_info": {
+          "type": "Tiny",
+          "flags": "NOT_NULL",
+          "char_set": 63,
+          "max_size": 1
+        }
+      },
+      {
+        "ordinal": 6,
+        "name": "user_id",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
+        }
+      },
+      {
+        "ordinal": 7,
+        "name": "name",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      },
+      {
+        "ordinal": 8,
+        "name": "user_dn",
+        "type_info": {
+          "type": "VarString",
+          "flags": "",
+          "char_set": 224,
+          "max_size": 1024
+        }
+      }
+    ],
+    "parameters": {
+      "Right": 2
+    },
+    "nullable": [
+      false,
+      false,
+      false,
+      false,
+      false,
+      false,
+      false,
+      false,
+      true
+    ]
+  },
+  "hash": "5566324138b5b05c369f70857d3d92603401f76dd5962159892a720537c96136"
+}
diff --git a/server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json b/server/.sqlx/query-666dec12f7177008c84cc15417e21be7ca6f63741e45928fba9f58915e6975e8.json
index e277262..2ebdede 100644
--- a/server/.sqlx/query-3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67.json
+++ b/server/.sqlx/query-666dec12f7177008c84cc15417e21be7ca6f63741e45928fba9f58915e6975e8.json
@@ -1,6 +1,6 @@
 {
   "db_name": "MySQL",
-  "query": "SELECT reviews.id AS id,title,description,state,progress,branch,archived,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? AND branch=?",
+  "query": "SELECT reviews.id AS id,title,description,state,progress,archived,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM reviews JOIN users ON users.id=owner WHERE project=? AND branch=?",
   "describe": {
     "columns": [
       {
@@ -55,16 +55,6 @@
       },
       {
         "ordinal": 5,
-        "name": "branch",
-        "type_info": {
-          "type": "VarString",
-          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
-          "char_set": 224,
-          "max_size": 4096
-        }
-      },
-      {
-        "ordinal": 6,
         "name": "archived",
         "type_info": {
           "type": "Tiny",
@@ -74,7 +64,7 @@
         }
       },
       {
-        "ordinal": 7,
+        "ordinal": 6,
         "name": "user_id",
         "type_info": {
           "type": "VarString",
@@ -84,7 +74,7 @@
         }
       },
       {
-        "ordinal": 8,
+        "ordinal": 7,
         "name": "name",
         "type_info": {
           "type": "VarString",
@@ -94,7 +84,7 @@
         }
       },
       {
-        "ordinal": 9,
+        "ordinal": 8,
         "name": "user_dn",
         "type_info": {
           "type": "VarString",
@@ -116,9 +106,8 @@
       false,
       false,
       false,
-      false,
       true
     ]
   },
-  "hash": "3864a730b1bcee1f511748360f92af157f36f3d92a667c0adc06c100cc495c67"
+  "hash": "666dec12f7177008c84cc15417e21be7ca6f63741e45928fba9f58915e6975e8"
 }