From: Michael Tremer <michael.tremer@ipfire.org>
Date: Sun, 22 Oct 2017 17:30:55 +0000 (+0100)
Subject: Allow repositories to be owner by a user
X-Git-Url: http://git.ipfire.org/?p=people%2Fjschlag%2Fpbs.git;a=commitdiff_plain;h=a7a18be14817377faab6fa79657e5f7e56d03bd2

Allow repositories to be owner by a user

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
---

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
 --