From 2c4adce9fe8cef616ded756bb10b50e5ec782ecc Mon Sep 17 00:00:00 2001
From: Matthias Beyer <matthias.beyer@atos.net>
Date: Tue, 9 Feb 2021 12:26:53 +0100
Subject: Add Job:env() helper to get the ENV of a job

Signed-off-by: Matthias Beyer <matthias.beyer@atos.net>
---
 src/db/models/job.rs | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'src/db')

diff --git a/src/db/models/job.rs b/src/db/models/job.rs
index aa7b7f9..12af2a9 100644
--- a/src/db/models/job.rs
+++ b/src/db/models/job.rs
@@ -86,4 +86,15 @@ impl Job {
             .first::<Job>(database_connection)
             .map_err(Error::from)
     }
+
+    pub fn env(&self, database_connection: &PgConnection) -> Result<Vec<crate::db::models::EnvVar>> {
+        use crate::schema;
+
+        schema::job_envs::table
+            .inner_join(schema::envvars::table)
+            .filter(schema::job_envs::job_id.eq(self.id))
+            .select(schema::envvars::all_columns)
+            .load::<crate::db::models::EnvVar>(database_connection)
+            .map_err(Error::from)
+    }
 }
-- 
cgit v1.2.3