From e75119228d65c8ca37c0ea0b9a51d3b97d1cb3eb Mon Sep 17 00:00:00 2001 From: Matthias Beyer Date: Tue, 9 Feb 2021 13:56:13 +0100 Subject: Add Artifact::get_release() to get a Release object for the artifact, if it exists Signed-off-by: Matthias Beyer --- src/db/models/artifact.rs | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'src/db') diff --git a/src/db/models/artifact.rs b/src/db/models/artifact.rs index 1050b30..11e2cec 100644 --- a/src/db/models/artifact.rs +++ b/src/db/models/artifact.rs @@ -20,6 +20,7 @@ use diesel::prelude::*; use diesel::PgConnection; use crate::db::models::Job; +use crate::db::models::Release; use crate::schema::artifacts; use crate::schema::artifacts::*; @@ -51,6 +52,18 @@ impl Artifact { crate::db::models::Release::create(database_connection, &self, release_date) } + pub fn get_release(&self, database_connection: &PgConnection) -> Result> { + use crate::schema; + + schema::artifacts::table + .inner_join(schema::releases::table) + .filter(schema::releases::artifact_id.eq(self.id)) + .select(schema::releases::all_columns) + .first::(database_connection) + .optional() + .map_err(Error::from) + } + pub fn create( database_connection: &PgConnection, art_path: &ArtifactPath, -- cgit v1.2.3