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:50 UTC

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

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