From 56e2243f3be7e859666ce0e4e1a8b8b94444f8d4 Mon Sep 17 00:00:00 2001
From: Jeremy Kerr <jk@ozlabs.org>
Date: Thu, 12 Aug 2010 12:15:48 +0800
Subject: Use generic email confirmation object

Rather than having a UserPerson-specific confirmation, add an
EmailConfirmation object to allow multiple types of confirmations (eg,
opt-out requests in future).

To do this, we use a view (patchwork.views.confirm) that will call the
type-specific view with the confirmation object.

Also, add tests to check that the User/Person linkage system works.

Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
---
 lib/sql/grant-all.postgres.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'lib/sql/grant-all.postgres.sql')

diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql
index 6a1a47d..47c4ad3 100644
--- a/lib/sql/grant-all.postgres.sql
+++ b/lib/sql/grant-all.postgres.sql
@@ -13,7 +13,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON
 	auth_group,
 	auth_user_user_permissions,
 	auth_permission,
-	patchwork_userpersonconfirmation,
+	patchwork_emailconfirmation,
 	patchwork_state,
 	patchwork_comment,
 	patchwork_person,
@@ -43,7 +43,7 @@ GRANT SELECT, UPDATE ON
 	patchwork_person_id_seq,
 	patchwork_project_id_seq,
 	patchwork_state_id_seq,
-	patchwork_userpersonconfirmation_id_seq,
+	patchwork_emailconfirmation_id_seq,
 	patchwork_userprofile_id_seq,
 	patchwork_userprofile_maintainer_projects_id_seq,
 	registration_registrationprofile_id_seq
-- 
cgit v1.2.3


From c2c6a408c7764fa29389ce160f52776c9308d50a Mon Sep 17 00:00:00 2001
From: Jeremy Kerr <jk@ozlabs.org>
Date: Sun, 31 Oct 2010 19:29:29 -0400
Subject: registration: use EmailConfimation rather than separate registration
 app

Since we have infrastructure for email confirmations, we no longer need
the separate registration app.

Requires a migration script, which will delete all inactive users,
including those newly added and pending confirmation. Use carefully.

Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
---
 lib/sql/grant-all.postgres.sql | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

(limited to 'lib/sql/grant-all.postgres.sql')

diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql
index 47c4ad3..591ffd0 100644
--- a/lib/sql/grant-all.postgres.sql
+++ b/lib/sql/grant-all.postgres.sql
@@ -22,8 +22,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON
 	patchwork_project,
 	patchwork_bundle,
 	patchwork_bundlepatch,
-	patchwork_patch,
-	registration_registrationprofile
+	patchwork_patch
 TO "www-data";
 GRANT SELECT, UPDATE ON
 	auth_group_id_seq,
@@ -45,8 +44,7 @@ GRANT SELECT, UPDATE ON
 	patchwork_state_id_seq,
 	patchwork_emailconfirmation_id_seq,
 	patchwork_userprofile_id_seq,
-	patchwork_userprofile_maintainer_projects_id_seq,
-	registration_registrationprofile_id_seq
+	patchwork_userprofile_maintainer_projects_id_seq
 TO "www-data";
 
 -- allow the mail user (in this case, 'nobody') to add patches
-- 
cgit v1.2.3


From 41f19b6643b44768dc06561c992c04ed6148477d Mon Sep 17 00:00:00 2001
From: Jeremy Kerr <jk@ozlabs.org>
Date: Wed, 11 Aug 2010 14:16:28 +0800
Subject: Add email opt-out system

We're going to start generating emails on patchwork updates, so firstly
allow people to opt-out of all patchwork communications.

We do this with a 'mail settings' interface, allowing non-registered
users to set preferences on their email address. Logged-in users can do
this through the user profile view.

Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
---
 lib/sql/grant-all.postgres.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'lib/sql/grant-all.postgres.sql')

diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql
index 591ffd0..9b6c862 100644
--- a/lib/sql/grant-all.postgres.sql
+++ b/lib/sql/grant-all.postgres.sql
@@ -22,7 +22,8 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON
 	patchwork_project,
 	patchwork_bundle,
 	patchwork_bundlepatch,
-	patchwork_patch
+	patchwork_patch,
+	patchwork_emailoptout
 TO "www-data";
 GRANT SELECT, UPDATE ON
 	auth_group_id_seq,
-- 
cgit v1.2.3


From 798a73b8bfb41f742e78e481ab9c961556e117b3 Mon Sep 17 00:00:00 2001
From: Jeremy Kerr <jk@ozlabs.org>
Date: Tue, 29 Mar 2011 11:58:39 +0800
Subject: models: Add PatchChangeNotification and record patch state changes

Add a PatchChangeNotification model to keep track of changes to a
patch's state. Hook this up to Patch's pre_save signal.

Requires a DB schema upgrade.

Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
---
 lib/sql/grant-all.postgres.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'lib/sql/grant-all.postgres.sql')

diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql
index 9b6c862..72abb57 100644
--- a/lib/sql/grant-all.postgres.sql
+++ b/lib/sql/grant-all.postgres.sql
@@ -23,7 +23,8 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON
 	patchwork_bundle,
 	patchwork_bundlepatch,
 	patchwork_patch,
-	patchwork_emailoptout
+	patchwork_emailoptout,
+	patchwork_patchchangenotification
 TO "www-data";
 GRANT SELECT, UPDATE ON
 	auth_group_id_seq,
@@ -45,7 +46,8 @@ GRANT SELECT, UPDATE ON
 	patchwork_state_id_seq,
 	patchwork_emailconfirmation_id_seq,
 	patchwork_userprofile_id_seq,
-	patchwork_userprofile_maintainer_projects_id_seq
+	patchwork_userprofile_maintainer_projects_id_seq,
+	patchwork_patchchangenotification_id_seq
 TO "www-data";
 
 -- allow the mail user (in this case, 'nobody') to add patches
-- 
cgit v1.2.3

