[icinga-checkins] icinga.org: icingaweb2-module-director/master: schema/pgsql: add state columns for import sources

git at icinga.org git at icinga.org
Sat May 21 00:28:54 CEST 2016


Module: icingaweb2-module-director
Branch: master
Commit: 8fe1bda36e017df1ba4c25bd71a14e2093d52e48
URL:    https://git.icinga.org/?p=icingaweb2-module-director.git;a=commit;h=8fe1bda36e017df1ba4c25bd71a14e2093d52e48

Author: Thomas Gelf <thomas at gelf.net>
Date:   Sat May 21 00:11:01 2016 +0200

schema/pgsql: add state columns for import sources

---

 schema/pgsql-migrations/upgrade_95.sql |   20 ++++++++++++++++++++
 schema/pgsql.sql                       |    5 ++++-
 2 files changed, 24 insertions(+), 1 deletion(-)

diff --git a/schema/pgsql-migrations/upgrade_95.sql b/schema/pgsql-migrations/upgrade_95.sql
new file mode 100644
index 0000000..21a212b
--- /dev/null
+++ b/schema/pgsql-migrations/upgrade_95.sql
@@ -0,0 +1,20 @@
+ALTER TABLE import_source
+  ADD COLUMN import_state enum_sync_state NOT NULL DEFAULT 'unknown',
+  ADD COLUMN last_error_message character varying(255) NULL DEFAULT NULL,
+  ADD COLUMN last_attempt timestamp with time zone NULL DEFAULT NULL
+;
+
+
+UPDATE import_source
+  SET last_attempt = ir.start_time
+  FROM (
+    SELECT source_id, MAX(start_time) AS start_time
+      FROM import_run
+      GROUP BY source_id
+  ) ir WHERE import_source.id = ir.source_id;
+
+
+
+INSERT INTO director_schema_migration
+  (schema_version, migration_time)
+  VALUES (95, NOW());
diff --git a/schema/pgsql.sql b/schema/pgsql.sql
index b5f0d9d..2d4704f 100644
--- a/schema/pgsql.sql
+++ b/schema/pgsql.sql
@@ -1244,6 +1244,9 @@ CREATE TABLE import_source (
   source_name character varying(64) NOT NULL,
   key_column character varying(64) NOT NULL,
   provider_class character varying(72) NOT NULL,
+  import_state enum_sync_state NOT NULL DEFAULT 'unknown',
+  last_error_message character varying(255) NULL DEFAULT NULL,
+  last_attempt timestamp with time zone NULL DEFAULT NULL,
   PRIMARY KEY (id)
 );
 
@@ -1513,4 +1516,4 @@ CREATE UNIQUE INDEX notification_inheritance ON icinga_notification_inheritance
 
 INSERT INTO director_schema_migration
   (schema_version, migration_time)
-  VALUES (94, NOW());
+  VALUES (95, NOW());



More information about the icinga-checkins mailing list