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 8018cd161540a6b755816dd697fc08089f3b7aac..155de2f5d5d7c21eb143611fa4e3359d5a046471 100644 (file)
--- 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 68ca33a9235f36261f35d70d8ae742f0604e3c4e..53be666292f008c3b51d92d15bce33da13e4e227 100644 (file)
--- 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
 --