Merge lp:~cjwatson/launchpad/db-git-activity into lp:launchpad/db-devel

[Colin Watson]

Add GitActivity table.

See https://docs.google.com/document/d/1JW_D_Tgo4X2-vPMZtShSbi3cm1iOsGcNIzeOpa5E_wA for the design and https://code.launchpad.net/~cjwatson/launchpad/git-activity-model/+merge/354399 for the initial code model.

[William Grant (wgrant)]

review: Approve (db)

=== added file 'database/schema/patch-2209-85-1.sql'
--- database/schema/patch-2209-85-1.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-85-1.sql	2018-10-03 09:15:36 +0000
@@ -0,0 +1,29 @@
+-- Copyright 2018 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+CREATE TABLE GitActivity (
+    id serial PRIMARY KEY,
+    repository integer NOT NULL REFERENCES gitrepository,
+    date_changed timestamp without time zone DEFAULT (CURRENT_TIMESTAMP AT TIME ZONE 'UTC') NOT NULL,
+    changer integer NOT NULL REFERENCES person,
+    changee integer REFERENCES person,
+    what_changed integer NOT NULL,
+    old_value text,
+    new_value text
+);
+
+CREATE INDEX gitactivity__repository__date_changed__id__idx
+    ON GitActivity(repository, date_changed DESC, id DESC);
+
+COMMENT ON TABLE GitActivity IS 'An activity log entry for a Git repository.';
+COMMENT ON COLUMN GitActivity.repository IS 'The repository that this log entry is for.';
+COMMENT ON COLUMN GitActivity.date_changed IS 'The time when this change happened.';
+COMMENT ON COLUMN GitActivity.changer IS 'The user who made this change.';
+COMMENT ON COLUMN GitActivity.changee IS 'The person or team that this change was applied to.';
+COMMENT ON COLUMN GitActivity.what_changed IS 'The property of the repository that changed.';
+COMMENT ON COLUMN GitActivity.old_value IS 'JSON object representing the value before the change.';
+COMMENT ON COLUMN GitActivity.new_value IS 'JSON object representing the value after the change.';
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 85, 1);

=== modified file 'database/schema/security.cfg'
--- database/schema/security.cfg	2018-10-02 20:40:59 +0000
+++ database/schema/security.cfg	2018-10-03 09:15:36 +0000
@@ -187,6 +187,7 @@
 public.featureflag                      = SELECT, INSERT, UPDATE, DELETE
 public.featureflagchangelogentry        = SELECT, INSERT, UPDATE
 public.flatpackagesetinclusion          = SELECT, INSERT, UPDATE, DELETE
+public.gitactivity                      = SELECT, INSERT, UPDATE, DELETE
 public.gitjob                           = SELECT, INSERT, UPDATE, DELETE
 public.gitref                           = SELECT, INSERT, UPDATE, DELETE
 public.gitrepository                    = SELECT, INSERT, UPDATE, DELETE
@@ -2211,6 +2212,7 @@
 public.emailaddress                     = SELECT, UPDATE, DELETE
 public.faq                              = SELECT, UPDATE
 public.featureflagchangelogentry        = SELECT, UPDATE
+public.gitactivity                      = SELECT, UPDATE
 public.gitrepository                    = SELECT, UPDATE
 public.gitrule                          = SELECT, UPDATE
 public.gitrulegrant                     = SELECT, UPDATE, DELETE

=== modified file 'lib/lp/registry/model/person.py'
--- lib/lp/registry/model/person.py	2018-10-02 19:31:32 +0000
+++ lib/lp/registry/model/person.py	2018-10-03 09:15:36 +0000
@@ -2370,6 +2370,8 @@
             ('bugtask', 'assignee'),
             ('codereviewvote', 'reviewer'),
             ('emailaddress', 'person'),
+            ('gitactivity', 'changee'),
+            ('gitactivity', 'changer'),
             ('gitrepository', 'owner'),
             ('gitrule', 'creator'),
             ('gitrulegrant', 'grantee'),