r5484 - trunk/cumin/model/upgrades

tmckay at fedoraproject.org tmckay at fedoraproject.org
Thu Sep 27 19:20:40 UTC 2012


Author: tmckay
Date: 2012-09-27 19:20:39 +0000 (Thu, 27 Sep 2012)
New Revision: 5484

Added:
   trunk/cumin/model/upgrades/1.1a_to_1.2
Removed:
   trunk/cumin/model/upgrades/1.1_to_1.2
Modified:
   trunk/cumin/model/upgrades/1.2_to_1.3
Log:
Fix up schema upgrade scripts to use new auth mechanism


Deleted: trunk/cumin/model/upgrades/1.1_to_1.2
===================================================================
--- trunk/cumin/model/upgrades/1.1_to_1.2	2012-09-27 19:08:47 UTC (rev 5483)
+++ trunk/cumin/model/upgrades/1.1_to_1.2	2012-09-27 19:20:39 UTC (rev 5484)
@@ -1,5 +0,0 @@
-#!/bin/bash
-echo alter table \"com.redhat.grid\".\"Submission\" add column \"Suspended\" bigint | psql -d cumin -U cumin -h localhost
-echo alter table \"com.redhat.grid\".\"Submission_samples\" add column \"Suspended\" bigint | psql -d cumin -U cumin -h localhost
-echo alter table \"com.redhat.grid\".\"Submission\" add column \"TransferringOutput\" bigint | psql -d cumin -U cumin -h localhost
-echo alter table \"com.redhat.grid\".\"Submission_samples\" add column \"TransferringOutput\" bigint | psql -d cumin -U cumin -h localhost

Copied: trunk/cumin/model/upgrades/1.1a_to_1.2 (from rev 5482, trunk/cumin/model/upgrades/1.1_to_1.2)
===================================================================
--- trunk/cumin/model/upgrades/1.1a_to_1.2	                        (rev 0)
+++ trunk/cumin/model/upgrades/1.1a_to_1.2	2012-09-27 19:20:39 UTC (rev 5484)
@@ -0,0 +1,5 @@
+#!/bin/bash
+su - postgres -c 'echo alter table \"com.redhat.grid\".\"Submission\" add column \"Suspended\" bigint'
+su - postgres -c 'echo alter table \"com.redhat.grid\".\"Submission_samples\" add column \"Suspended\" bigint'
+su - postgres -c 'echo alter table \"com.redhat.grid\".\"Submission\" add column \"TransferringOutput\" bigint'
+su - postgres -c 'echo alter table \"com.redhat.grid\".\"Submission_samples\" add column \"TransferringOutput\" bigint'

Modified: trunk/cumin/model/upgrades/1.2_to_1.3
===================================================================
--- trunk/cumin/model/upgrades/1.2_to_1.3	2012-09-27 19:08:47 UTC (rev 5483)
+++ trunk/cumin/model/upgrades/1.2_to_1.3	2012-09-27 19:20:39 UTC (rev 5484)
@@ -1,69 +1,48 @@
 #!/bin/bash
-echo 'create schema "com.redhat.grid.plumage"' | psql -d cumin -U cumin -h localhost
-echo 'create sequence "com.redhat.grid.plumage"."OSUtil_id_seq"' | psql -d cumin -U cumin -h localhost
-echo 'create table "com.redhat.grid.plumage"."OSUtil" ("_id" int8 not null,"host" text not null,"ts" timestamp not null,"total" int8 not null,"used" int8 not null,"unused" int8 not null,"owner" int8 not null,"efficiency" float4 not null,constraint "OSUtil_pk" primary key ("_id"))'| psql -d cumin -U cumin -h localhost
-echo 'create table "com.redhat.grid.plumage"."OSUtil_samples" ("ts" timestamp not null,"total" int8 not null,"used" int8 not null,"unused" int8 not null,"owner" int8 not null,"efficiency" float4 not null)'| psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN freemem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN usedmem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN availmem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN totalmem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN freecpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN usedcpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN availcpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil" ADD COLUMN totalcpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN freemem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN usedmem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN availmem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN totalmem int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN freecpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN usedcpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN availcpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN totalcpu int8 NOT NULL DEFAULT 0' | psql -d cumin -U cumin -h localhost
-echo 'DROP TABLE "com.redhat.cumin"."BrokerGroup" cascade' | psql -d cumin -U cumin -h localhost
-echo 'DROP TABLE "com.redhat.cumin"."BrokerGroup_samples" cascade' | psql -d cumin -U cumin -h localhost
-echo 'DROP TABLE "com.redhat.cumin"."BrokerGroupMapping" cascade' | psql -d cumin -U cumin -h localhost
-echo 'DROP TABLE "com.redhat.cumin"."BrokerGroupMapping_samples" cascade' | psql -d cumin -U cumin -h localhost
-echo 'DROP SEQUENCE "com.redhat.cumin"."BrokerGroup_id_seq"' | psql -d cumin -U cumin -h localhost
-echo 'DROP SEQUENCE "com.redhat.cumin"."BrokerGroupMapping_id_seq"' | psql -d cumin -U cumin -h localhost
-echo 'create schema "com.redhat.cumin.messaging"' | psql -d cumin -U cumin -h localhost
-echo 'create sequence "com.redhat.cumin.messaging"."BrokerGroup_id_seq"'| psql -d cumin -U cumin -h localhost
-echo 'create sequence "com.redhat.cumin.messaging"."BrokerGroupMapping_id_seq"'| psql -d cumin -U cumin -h localhost
-echo 'create table "com.redhat.cumin.messaging"."BrokerGroup" (
-        "_id" int8 not null,
-        "_qmf_agent_id" text not null,
-        "_qmf_object_id" text not null,
-        "_qmf_create_time" timestamp not null,
-        "_qmf_update_time" timestamp not null,
-        "_qmf_delete_time" timestamp,
-        "name" text not null,
-        "description" text,
-        constraint "BrokerGroup_pk" primary key ("_id"),
-        constraint "BrokerGroup_qmf_id_uq" unique ("_qmf_agent_id", "_qmf_object_id")
-        )' | psql -d cumin -U cumin -h localhost
-echo 'create table "com.redhat.cumin.messaging"."BrokerGroup_samples" (
-        "_qmf_agent_id" text not null,
-        "_qmf_object_id" text not null,
-        "_qmf_update_time" timestamp not null
-        )' | psql -d cumin -U cumin -h localhost
-echo 'create table "com.redhat.cumin.messaging"."BrokerGroupMapping" (
-        "_id" int8 not null,
-        "_qmf_agent_id" text not null,
-        "_qmf_object_id" text not null,
-        "_qmf_create_time" timestamp not null,
-        "_qmf_update_time" timestamp not null,
-        "_qmf_delete_time" timestamp,
-        "_broker_id" int8,
-        "_group_id" int8,
-        constraint "BrokerGroupMapping_pk" primary key ("_id"),
-        constraint "BrokerGroupMapping_qmf_id_uq" unique ("_qmf_agent_id", "_qmf_object_id")
-        )' | psql -d cumin -U cumin -h localhost
-echo 'create table "com.redhat.cumin.messaging"."BrokerGroupMapping_samples" (
-        "_qmf_agent_id" text not null,
-        "_qmf_object_id" text not null,
-        "_qmf_update_time" timestamp not null
-        )' | psql -d cumin -U cumin -h localhost
-echo 'create index "BrokerGroup_samples_qmf_id_idx" on "com.redhat.cumin.messaging"."BrokerGroup_samples" ("_qmf_agent_id", "_qmf_object_id")' | psql -d cumin -U cumin -h localhost
-echo 'create index "BrokerGroupMapping_samples_qmf_id_idx" on "com.redhat.cumin.messaging"."BrokerGroupMapping_samples" ("_qmf_agent_id", "_qmf_object_id")' | psql -d cumin -U cumin -h localhost
-echo 'alter table "com.redhat.cumin.messaging"."BrokerGroupMapping"
-    add constraint "_broker_id_fk" foreign key ("_broker_id") references "org.apache.qpid.broker"."Broker" ("_id") on update cascade on delete set null,
-    add constraint "_group_id_fk" foreign key ("_group_id") references "com.redhat.cumin.messaging"."BrokerGroup" ("_id") on update cascade on delete set null' | psql -d cumin -U cumin -h localhost
+
+function run {
+    su - postgres -c "echo $1 | psql -d cumin"
+}
+
+run 'create schema \"com.redhat.grid.plumage\"'
+run 'create sequence \"com.redhat.grid.plumage\".\"OSUtil_id_seq\"'
+run 'create table \"com.redhat.grid.plumage\".\"OSUtil\" \(\"_id\" int8 not null,\"host\" text not null,\"ts\" timestamp not null,\"total\" int8 not null,\"used\" int8 not null,\"unused\" int8 not null,\"owner\" int8 not null,\"efficiency\" float4 not null,constraint \"OSUtil_pk\" primary key \(\"_id\"\)\)'
+run 'create table \"com.redhat.grid.plumage\".\"OSUtil_samples\" \(\"ts\" timestamp not null,\"total\" int8 not null,\"used\" int8 not null,\"unused\" int8 not null,\"owner\" int8 not null,\"efficiency\" float4 not null\)'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN freemem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN usedmem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN availmem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN totalmem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN freecpu int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN usedcpu int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN availcpu int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil\" ADD COLUMN totalcpu int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN freemem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN usedmem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN availmem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN totalmem int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN freecpu int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN usedcpu int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN availcpu int8 NOT NULL DEFAULT 0'
+run 'ALTER TABLE \"com.redhat.grid.plumage\".\"OSUtil_samples\" ADD COLUMN totalcpu int8 NOT NULL DEFAULT 0'
+run 'DROP TABLE \"com.redhat.cumin\".\"BrokerGroup\" cascade'
+run 'DROP TABLE \"com.redhat.cumin\".\"BrokerGroup_samples\" cascade'
+run 'DROP TABLE \"com.redhat.cumin\".\"BrokerGroupMapping\" cascade'
+run 'DROP TABLE \"com.redhat.cumin\".\"BrokerGroupMapping_samples\" cascade'
+run 'DROP SEQUENCE \"com.redhat.cumin\".\"BrokerGroup_id_seq\"'
+run 'DROP SEQUENCE \"com.redhat.cumin\".\"BrokerGroupMapping_id_seq\"'
+run 'create schema \"com.redhat.cumin.messaging\"'
+run 'create sequence \"com.redhat.cumin.messaging\".\"BrokerGroup_id_seq\"'
+run 'create sequence \"com.redhat.cumin.messaging\".\"BrokerGroupMapping_id_seq\"'
+
+run 'create table \"com.redhat.cumin.messaging\".\"BrokerGroup\" \(\"_id\" int8 not null,\"_qmf_agent_id\" text not null,\"_qmf_object_id\" text not null,\"_qmf_create_time\" timestamp not null,\"_qmf_update_time\" timestamp not null,\"_qmf_delete_time\" timestamp,\"name\" text not null,\"description\" text,constraint \"BrokerGroup_pk\" primary key \(\"_id\"\),constraint \"BrokerGroup_qmf_id_uq\" unique \(\"_qmf_agent_id\", \"_qmf_object_id\"\)\)'
+
+run 'create table \"com.redhat.cumin.messaging\".\"BrokerGroup_samples\" \(\"_qmf_agent_id\" text not null,\"_qmf_object_id\" text not null,\"_qmf_update_time\" timestamp not null\)'
+
+run 'create table \"com.redhat.cumin.messaging\".\"BrokerGroupMapping\" \(\"_id\" int8 not null,\"_qmf_agent_id\" text not null,\"_qmf_object_id\" text not null,\"_qmf_create_time\" timestamp not null,\"_qmf_update_time\" timestamp not null,\"_qmf_delete_time\" timestamp,\"_broker_id\" int8,\"_group_id\" int8,constraint \"BrokerGroupMapping_pk\" primary key \(\"_id\"\),constraint \"BrokerGroupMapping_qmf_id_uq\" unique \(\"_qmf_agent_id\", \"_qmf_object_id\"\)\)'
+
+run 'create table \"com.redhat.cumin.messaging\".\"BrokerGroupMapping_samples\" \(\"_qmf_agent_id\" text not null,\"_qmf_object_id\" text not null,\"_qmf_update_time\" timestamp not null\)'
+
+run 'create index \"BrokerGroup_samples_qmf_id_idx\" on \"com.redhat.cumin.messaging\".\"BrokerGroup_samples\" \(\"_qmf_agent_id\", \"_qmf_object_id\"\)'
+run 'create index \"BrokerGroupMapping_samples_qmf_id_idx\" on \"com.redhat.cumin.messaging\".\"BrokerGroupMapping_samples\" \(\"_qmf_agent_id\", \"_qmf_object_id\"\)'
+
+run 'alter table \"com.redhat.cumin.messaging\".\"BrokerGroupMapping\" add constraint \"_broker_id_fk\" foreign key \(\"_broker_id\"\) references \"org.apache.qpid.broker\".\"Broker\" \(\"_id\"\) on update cascade on delete set null, add constraint \"_group_id_fk\" foreign key \(\"_group_id\"\) references \"com.redhat.cumin.messaging\".\"BrokerGroup\" \(\"_id\"\) on update cascade on delete set null'



More information about the cumin-developers mailing list