Add model for submit storing

This also needs the "uuid" and "chrono" diesel features.

Signed-off-by: Matthias Beyer <mail@beyermatthias.de>

2 files changed, 19 insertions, 0 deletions

diff --git a/src/db/models/mod.rs b/src/db/models/mod.rs
index 958a0aa..c724c5c 100644
--- a/src/db/models/mod.rs
+++ b/src/db/models/mod.rs
@@ -13,3 +13,6 @@ pub use githash::*;
 mod package;
 pub use package::*;
 
+mod submit;
+pub use submit::*;
+
diff --git a/src/db/models/submit.rs b/src/db/models/submit.rs
new file mode 100644
index 0000000..ecdc57e
--- /dev/null
+++ b/src/db/models/submit.rs
@@ -0,0 +1,16 @@
+use chrono::NaiveDateTime;
+use diesel::types::Uuid;
+use diesel::types::Jsonb;
+
+#[derive(Queryable)]
+pub struct Submit {
+    pub id: i32,
+    pub uuid: Uuid,
+    pub submit_time: NaiveDateTime,
+    pub requested_image_id: i32,
+    pub requested_package_id: i32,
+    pub repo_hash_id: i32,
+    pub tree: Jsonb,
+    pub buildplan: Jsonb,
+}
+