From a7a18be14817377faab6fa79657e5f7e56d03bd2 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Sun, 22 Oct 2017 18:30:55 +0100 Subject: [PATCH] Allow repositories to be owner by a user Signed-off-by: Michael Tremer --- src/buildservice/repository.py | 9 +++++++++ src/database.sql | 11 ++++++++++- 2 files changed, 19 insertions(+), 1 deletion(-) diff --git a/src/buildservice/repository.py b/src/buildservice/repository.py index 8018cd1..155de2f 100644 --- a/src/buildservice/repository.py +++ b/src/buildservice/repository.py @@ -118,6 +118,15 @@ class Repository(base.DataObject): priority = property(lambda s: s.data.priority, set_priority) + def get_user(self): + if self.data.user_id: + return self.backend.users.get_by_id(self.data.user_id) + + def set_user(self, user): + self._set_attribute("user_id", user.id) + + user = property(get_user, set_user) + @property def info(self): return { diff --git a/src/database.sql b/src/database.sql index 68ca33a..53be666 100644 --- a/src/database.sql +++ b/src/database.sql @@ -1564,7 +1564,8 @@ CREATE TABLE repositories ( update_started timestamp without time zone, update_ended timestamp without time zone, deleted boolean DEFAULT false NOT NULL, - priority integer + priority integer, + user_id integer ); @@ -3272,6 +3273,14 @@ ALTER TABLE ONLY repositories ADD CONSTRAINT repositories_parent_id FOREIGN KEY (parent_id) REFERENCES repositories(id); +-- +-- Name: repositories_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire +-- + +ALTER TABLE ONLY repositories + ADD CONSTRAINT repositories_user_id FOREIGN KEY (user_id) REFERENCES users(id); + + -- -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire -- -- 2.47.3