liquid_feedback_core

changeset 547:3cde0bb68adf

Use unit/area/policy_updated event instead of unit/area/policy_removed
author jbe
date Tue Jul 18 12:28:45 2017 +0200 (2017-07-18)
parents f46ebb677898
children 1adb0ad5900c
files core.sql update/core-update.v3.2.2-v4.0.0.sql
line diff
     1.1 --- a/core.sql	Tue Jul 18 01:14:45 2017 +0200
     1.2 +++ b/core.sql	Tue Jul 18 12:28:45 2017 +0200
     1.3 @@ -1315,13 +1315,10 @@
     1.4  CREATE TYPE "event_type" AS ENUM (
     1.5          'unit_created',
     1.6          'unit_updated',
     1.7 -        'unit_removed',
     1.8          'area_created',
     1.9          'area_updated',
    1.10 -        'area_removed',
    1.11          'policy_created',
    1.12          'policy_updated',
    1.13 -        'policy_removed',
    1.14          'issue_state_changed',
    1.15          'initiative_created_in_new_issue',
    1.16          'initiative_created_in_existing_issue',
    1.17 @@ -1722,10 +1719,10 @@
    1.18        IF TG_OP = 'UPDATE' THEN
    1.19          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.20            RETURN NULL;
    1.21 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.22 -          "event_v" := 'unit_created';
    1.23 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.24 -          "event_v" := 'unit_removed';
    1.25 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.26 +        --  "event_v" := 'unit_created';
    1.27 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.28 +        --  "event_v" := 'unit_removed';
    1.29          ELSIF OLD != NEW THEN
    1.30            "event_v" := 'unit_updated';
    1.31          ELSE
    1.32 @@ -1755,10 +1752,10 @@
    1.33        IF TG_OP = 'UPDATE' THEN
    1.34          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.35            RETURN NULL;
    1.36 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.37 -          "event_v" := 'area_created';
    1.38 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.39 -          "event_v" := 'area_removed';
    1.40 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.41 +        --  "event_v" := 'area_created';
    1.42 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.43 +        --  "event_v" := 'area_removed';
    1.44          ELSIF OLD != NEW THEN
    1.45            "event_v" := 'area_updated';
    1.46          ELSE
    1.47 @@ -1788,10 +1785,10 @@
    1.48        IF TG_OP = 'UPDATE' THEN
    1.49          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.50            RETURN NULL;
    1.51 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.52 -          "event_v" := 'policy_created';
    1.53 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.54 -          "event_v" := 'policy_removed';
    1.55 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.56 +        --  "event_v" := 'policy_created';
    1.57 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.58 +        --  "event_v" := 'policy_removed';
    1.59          ELSIF OLD != NEW THEN
    1.60            "event_v" := 'policy_updated';
    1.61          ELSE
     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 01:14:45 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 12:28:45 2017 +0200
     2.3 @@ -1,12 +1,9 @@
     2.4  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_created';
     2.5  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_updated';
     2.6 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_removed';
     2.7  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_created';
     2.8  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_updated';
     2.9 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_removed';
    2.10  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_created';
    2.11  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_updated';
    2.12 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_removed';
    2.13  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'suggestion_removed';
    2.14  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_activated';
    2.15  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_removed';
    2.16 @@ -985,10 +982,10 @@
    2.17        IF TG_OP = 'UPDATE' THEN
    2.18          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    2.19            RETURN NULL;
    2.20 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.21 -          "event_v" := 'unit_created';
    2.22 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.23 -          "event_v" := 'unit_removed';
    2.24 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.25 +        --  "event_v" := 'unit_created';
    2.26 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.27 +        --  "event_v" := 'unit_removed';
    2.28          ELSIF OLD != NEW THEN
    2.29            "event_v" := 'unit_updated';
    2.30          ELSE
    2.31 @@ -1018,10 +1015,10 @@
    2.32        IF TG_OP = 'UPDATE' THEN
    2.33          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    2.34            RETURN NULL;
    2.35 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.36 -          "event_v" := 'area_created';
    2.37 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.38 -          "event_v" := 'area_removed';
    2.39 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.40 +        --  "event_v" := 'area_created';
    2.41 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.42 +        --  "event_v" := 'area_removed';
    2.43          ELSIF OLD != NEW THEN
    2.44            "event_v" := 'area_updated';
    2.45          ELSE
    2.46 @@ -1051,10 +1048,10 @@
    2.47        IF TG_OP = 'UPDATE' THEN
    2.48          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    2.49            RETURN NULL;
    2.50 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.51 -          "event_v" := 'policy_created';
    2.52 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.53 -          "event_v" := 'policy_removed';
    2.54 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.55 +        --  "event_v" := 'policy_created';
    2.56 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.57 +        --  "event_v" := 'policy_removed';
    2.58          ELSIF OLD != NEW THEN
    2.59            "event_v" := 'policy_updated';
    2.60          ELSE

Impressum / About Us