You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@syncope.apache.org by il...@apache.org on 2018/10/12 07:27:49 UTC

[1/2] syncope git commit: [SYNCOPE-1369] Missing support to drop the workflowId column from SyncopeGroup and AnyObject

Repository: syncope
Updated Branches:
  refs/heads/2_1_X a17460de0 -> 9612d30ff
  refs/heads/master 28e8cd3fe -> 0162f98eb


[SYNCOPE-1369] Missing support to drop the workflowId column from SyncopeGroup and AnyObject


Project: http://git-wip-us.apache.org/repos/asf/syncope/repo
Commit: http://git-wip-us.apache.org/repos/asf/syncope/commit/9612d30f
Tree: http://git-wip-us.apache.org/repos/asf/syncope/tree/9612d30f
Diff: http://git-wip-us.apache.org/repos/asf/syncope/diff/9612d30f

Branch: refs/heads/2_1_X
Commit: 9612d30ff96778d1027e098ba6db23afb19e8b2c
Parents: a17460d
Author: Francesco Chicchiriccò <il...@apache.org>
Authored: Fri Oct 12 09:27:35 2018 +0200
Committer: Francesco Chicchiriccò <il...@apache.org>
Committed: Fri Oct 12 09:27:35 2018 +0200

----------------------------------------------------------------------
 .../org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java  | 8 ++++++++
 1 file changed, 8 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/syncope/blob/9612d30f/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
----------------------------------------------------------------------
diff --git a/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java b/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
index 37d7062..15756f7 100644
--- a/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
+++ b/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
@@ -417,6 +417,14 @@ public final class GenerateUpgradeSQL {
         OUT.write("DROP VIEW user_search;\n");
         OUT.write("ALTER TABLE SyncopeUser DROP COLUMN workflowId;\n");
         OUT.write("CREATE VIEW user_search AS SELECT u.id as any_id, u.* FROM SyncopeUser u;\n");
+
+        OUT.write("DROP VIEW group_search;\n");
+        OUT.write("ALTER TABLE SyncopeGroup DROP COLUMN workflowId;\n");
+        OUT.write("CREATE VIEW group_search AS SELECT r.id as any_id, r.* FROM SyncopeGroup r;\n");
+
+        OUT.write("DROP VIEW anyObject_search;\n");
+        OUT.write("ALTER TABLE AnyObject DROP COLUMN workflowId;\n");
+        OUT.write("CREATE VIEW anyObject_search AS SELECT a.id as any_id, a.* FROM AnyObject a;\n");
     }
 
     public static void main(final String[] args) throws Exception {


[2/2] syncope git commit: [SYNCOPE-1369] Missing support to drop the workflowId column from SyncopeGroup and AnyObject

Posted by il...@apache.org.
[SYNCOPE-1369] Missing support to drop the workflowId column from SyncopeGroup and AnyObject


Project: http://git-wip-us.apache.org/repos/asf/syncope/repo
Commit: http://git-wip-us.apache.org/repos/asf/syncope/commit/0162f98e
Tree: http://git-wip-us.apache.org/repos/asf/syncope/tree/0162f98e
Diff: http://git-wip-us.apache.org/repos/asf/syncope/diff/0162f98e

Branch: refs/heads/master
Commit: 0162f98ebac0fcc88511602495ddef011bd22f2b
Parents: 28e8cd3
Author: Francesco Chicchiriccò <il...@apache.org>
Authored: Fri Oct 12 09:27:35 2018 +0200
Committer: Francesco Chicchiriccò <il...@apache.org>
Committed: Fri Oct 12 09:27:41 2018 +0200

----------------------------------------------------------------------
 .../org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java  | 8 ++++++++
 1 file changed, 8 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/syncope/blob/0162f98e/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
----------------------------------------------------------------------
diff --git a/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java b/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
index 37d7062..15756f7 100644
--- a/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
+++ b/core/upgrade/src/main/java/org/apache/syncope/core/upgrade/GenerateUpgradeSQL.java
@@ -417,6 +417,14 @@ public final class GenerateUpgradeSQL {
         OUT.write("DROP VIEW user_search;\n");
         OUT.write("ALTER TABLE SyncopeUser DROP COLUMN workflowId;\n");
         OUT.write("CREATE VIEW user_search AS SELECT u.id as any_id, u.* FROM SyncopeUser u;\n");
+
+        OUT.write("DROP VIEW group_search;\n");
+        OUT.write("ALTER TABLE SyncopeGroup DROP COLUMN workflowId;\n");
+        OUT.write("CREATE VIEW group_search AS SELECT r.id as any_id, r.* FROM SyncopeGroup r;\n");
+
+        OUT.write("DROP VIEW anyObject_search;\n");
+        OUT.write("ALTER TABLE AnyObject DROP COLUMN workflowId;\n");
+        OUT.write("CREATE VIEW anyObject_search AS SELECT a.id as any_id, a.* FROM AnyObject a;\n");
     }
 
     public static void main(final String[] args) throws Exception {