Initial support for translation reviews

4 files changed, 219 insertions, 0 deletions

diff --git a/server/.sqlx/query-1017223642074d4567738e03c40357a4a6c5dfadb77c21b99e26db113bb97339.json b/server/.sqlx/query-1017223642074d4567738e03c40357a4a6c5dfadb77c21b99e26db113bb97339.json
new file mode 100644
index 0000000..0c10e57
--- /dev/null
+++ b/server/.sqlx/query-1017223642074d4567738e03c40357a4a6c5dfadb77c21b99e26db113bb97339.json
@@ -0,0 +1,58 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT id,name,dn,translation_review_users.role AS role FROM users JOIN translation_review_users ON translation_review_users.user=id WHERE translation_review_users.translation_review=? ORDER BY role,id",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "id",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
+        }
+      },
+      {
+        "ordinal": 1,
+        "name": "name",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      },
+      {
+        "ordinal": 2,
+        "name": "dn",
+        "type_info": {
+          "type": "VarString",
+          "flags": "",
+          "char_set": 224,
+          "max_size": 1024
+        }
+      },
+      {
+        "ordinal": 3,
+        "name": "role",
+        "type_info": {
+          "type": "Tiny",
+          "flags": "NOT_NULL | UNSIGNED",
+          "char_set": 63,
+          "max_size": 3
+        }
+      }
+    ],
+    "parameters": {
+      "Right": 1
+    },
+    "nullable": [
+      false,
+      false,
+      true,
+      false
+    ]
+  },
+  "hash": "1017223642074d4567738e03c40357a4a6c5dfadb77c21b99e26db113bb97339"
+}
diff --git a/server/.sqlx/query-3d22e3c8189b094ff2c241d46e8b93bcdf2bdcc59feeec3e750e81fdb2aa122b.json b/server/.sqlx/query-3d22e3c8189b094ff2c241d46e8b93bcdf2bdcc59feeec3e750e81fdb2aa122b.json
new file mode 100644
index 0000000..87dea51
--- /dev/null
+++ b/server/.sqlx/query-3d22e3c8189b094ff2c241d46e8b93bcdf2bdcc59feeec3e750e81fdb2aa122b.json
@@ -0,0 +1,25 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT main_branch FROM projects WHERE id=?",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "main_branch",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      }
+    ],
+    "parameters": {
+      "Right": 1
+    },
+    "nullable": [
+      false
+    ]
+  },
+  "hash": "3d22e3c8189b094ff2c241d46e8b93bcdf2bdcc59feeec3e750e81fdb2aa122b"
+}
diff --git a/server/.sqlx/query-9ba4679a5c8d66008a1ad6f79870365aa75d1832440f7d0e7a1b79f0f8827b9a.json b/server/.sqlx/query-9ba4679a5c8d66008a1ad6f79870365aa75d1832440f7d0e7a1b79f0f8827b9a.json
new file mode 100644
index 0000000..6f02f6b
--- /dev/null
+++ b/server/.sqlx/query-9ba4679a5c8d66008a1ad6f79870365aa75d1832440f7d0e7a1b79f0f8827b9a.json
@@ -0,0 +1,124 @@
+{
+  "db_name": "MySQL",
+  "query": "SELECT title,description,state,progress,archived,base,head,users.id AS user_id,users.name AS name,users.dn AS user_dn FROM translation_reviews JOIN users ON users.id=owner WHERE project=? AND translation_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": "archived",
+        "type_info": {
+          "type": "Tiny",
+          "flags": "NOT_NULL",
+          "char_set": 63,
+          "max_size": 1
+        }
+      },
+      {
+        "ordinal": 5,
+        "name": "base",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 160
+        }
+      },
+      {
+        "ordinal": 6,
+        "name": "head",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 160
+        }
+      },
+      {
+        "ordinal": 7,
+        "name": "user_id",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL | PRIMARY_KEY | NO_DEFAULT_VALUE",
+          "char_set": 224,
+          "max_size": 512
+        }
+      },
+      {
+        "ordinal": 8,
+        "name": "name",
+        "type_info": {
+          "type": "VarString",
+          "flags": "NOT_NULL",
+          "char_set": 224,
+          "max_size": 4096
+        }
+      },
+      {
+        "ordinal": 9,
+        "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,
+      false,
+      true
+    ]
+  },
+  "hash": "9ba4679a5c8d66008a1ad6f79870365aa75d1832440f7d0e7a1b79f0f8827b9a"
+}
diff --git a/server/.sqlx/query-c71522cbb790b5ba59d1a88c129b7b8c4fed68313bb8855702a38299d35d2bf9.json b/server/.sqlx/query-c71522cbb790b5ba59d1a88c129b7b8c4fed68313bb8855702a38299d35d2bf9.json
new file mode 100644
index 0000000..f5932db
--- /dev/null
+++ b/server/.sqlx/query-c71522cbb790b5ba59d1a88c129b7b8c4fed68313bb8855702a38299d35d2bf9.json
@@ -0,0 +1,12 @@
+{
+  "db_name": "MySQL",
+  "query": "INSERT INTO translation_reviews (project, owner, title, description, base, head) VALUES (?, ?, ?, ?, ?, ?)",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Right": 6
+    },
+    "nullable": []
+  },
+  "hash": "c71522cbb790b5ba59d1a88c129b7b8c4fed68313bb8855702a38299d35d2bf9"
+}