spec/dummy/log/development.log in mks_edm-1.0.1 vs spec/dummy/log/development.log in mks_edm-1.0.2

- old
+ new

@@ -33280,5 +33280,221 @@  (1.3ms) COMMIT ActiveRecord::InternalMetadata Load (0.6ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "environment"], ["LIMIT", 1]]  (2.3ms) BEGIN ActiveRecord::InternalMetadata Update (1.1ms) UPDATE "ar_internal_metadata" SET "value" = $1, "updated_at" = $2 WHERE "ar_internal_metadata"."key" = $3 [["value", "test"], ["updated_at", "2018-09-05 05:07:09.725663"], ["key", "environment"]]  (1.3ms) COMMIT +  (1.7ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC +  (0.9ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "environment"]] +  (1.0ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC +  (0.7ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "environment"]] +  (1.3ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC +  (0.8ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "environment"]] +  (123.4ms) DROP DATABASE IF EXISTS "construction_test" +  (340.3ms) CREATE DATABASE "construction_test" ENCODING = 'utf8' + SQL (0.9ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.7ms) DROP TABLE IF EXISTS "mks_auth_application_modules" CASCADE +  (14.5ms) CREATE TABLE "mks_auth_application_modules" ("id" serial NOT NULL PRIMARY KEY, "code" character varying NOT NULL, "name" character varying NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (0.8ms) DROP TABLE IF EXISTS "mks_auth_menus" CASCADE +  (6.7ms) CREATE TABLE "mks_auth_menus" ("id" serial NOT NULL PRIMARY KEY, "text" character varying NOT NULL, "icon_cls" character varying, "class_name" character varying, "location" character varying, "parent_id" integer, "application_module_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.5ms) CREATE INDEX "index_mks_auth_menus_on_application_module_id" ON "mks_auth_menus" ("application_module_id") +  (3.5ms) CREATE INDEX "index_mks_auth_menus_on_parent_id" ON "mks_auth_menus" ("parent_id") +  (1.1ms) DROP TABLE IF EXISTS "mks_auth_menus_user_roles" CASCADE +  (4.9ms) CREATE TABLE "mks_auth_menus_user_roles" ("id" serial NOT NULL PRIMARY KEY, "menu_id" integer, "user_role_id" integer) +  (4.6ms) CREATE INDEX "index_mks_auth_menus_user_roles_on_menu_id_and_user_role_id" ON "mks_auth_menus_user_roles" ("menu_id", "user_role_id") +  (0.8ms) DROP TABLE IF EXISTS "mks_auth_user_roles" CASCADE +  (6.7ms) CREATE TABLE "mks_auth_user_roles" ("id" serial NOT NULL PRIMARY KEY, "name" character varying NOT NULL, "application_module_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.3ms) CREATE INDEX "index_mks_auth_user_roles_on_application_module_id" ON "mks_auth_user_roles" ("application_module_id") +  (0.8ms) DROP TABLE IF EXISTS "mks_auth_users" CASCADE +  (7.0ms) CREATE TABLE "mks_auth_users" ("id" serial NOT NULL PRIMARY KEY, "first_name" character varying NOT NULL, "last_name" character varying NOT NULL, "email" character varying NOT NULL, "active" boolean DEFAULT TRUE NOT NULL, "password_digest" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (0.9ms) DROP TABLE IF EXISTS "mks_auth_users_application_modules" CASCADE +  (1.9ms) CREATE TABLE "mks_auth_users_application_modules" ("user_id" bigint, "application_module_id" bigint) +  (3.7ms) CREATE INDEX "am_on_users_indx" ON "mks_auth_users_application_modules" ("user_id", "application_module_id") +  (0.7ms) DROP TABLE IF EXISTS "mks_auth_users_user_roles" CASCADE +  (2.1ms) CREATE TABLE "mks_auth_users_user_roles" ("user_id" integer, "user_role_id" integer) +  (3.2ms) CREATE INDEX "index_mks_auth_users_user_roles_on_user_id_and_user_role_id" ON "mks_auth_users_user_roles" ("user_id", "user_role_id") +  (0.7ms) DROP TABLE IF EXISTS "mks_edm_equipment_categories" CASCADE +  (6.5ms) CREATE TABLE "mks_edm_equipment_categories" ("id" bigserial primary key, "code" character varying, "name" character varying NOT NULL, "description" character varying, "equipment_type_id" bigint, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.2ms) CREATE INDEX "ec_on_et_indx" ON "mks_edm_equipment_categories" ("equipment_type_id") +  (0.8ms) DROP TABLE IF EXISTS "mks_edm_equipment_components" CASCADE +  (6.2ms) CREATE TABLE "mks_edm_equipment_components" ("id" bigserial primary key, "serial_no" character varying, "name" character varying NOT NULL, "equipment_item_id" bigint, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.5ms) CREATE INDEX "ei_on_ec_indx" ON "mks_edm_equipment_components" ("equipment_item_id") +  (0.8ms) DROP TABLE IF EXISTS "mks_edm_equipment_items" CASCADE +  (6.9ms) CREATE TABLE "mks_edm_equipment_items" ("id" bigserial primary key, "code" character varying, "name" character varying NOT NULL, "description" character varying, "status" character varying DEFAULT 'READY', "serial_number" character varying, "brand" character varying, "item_model" character varying, "purchase_price" float NOT NULL, "purchase_date" date NOT NULL, "license_fee" float, "tax" float, "equipment_id" bigint, "current_location_id" bigint, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (4.3ms) CREATE INDEX "equipment_on_el_indx" ON "mks_edm_equipment_items" ("current_location_id") +  (3.5ms) CREATE INDEX "equipment_on_ei_indx" ON "mks_edm_equipment_items" ("equipment_id") +  (1.0ms) DROP TABLE IF EXISTS "mks_edm_equipment_locations" CASCADE +  (6.7ms) CREATE TABLE "mks_edm_equipment_locations" ("id" bigserial primary key, "code" character varying, "name" character varying NOT NULL, "location_type_id" bigint, "description" character varying, "address" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (4.3ms) CREATE INDEX "lt_on_el_indx" ON "mks_edm_equipment_locations" ("location_type_id") +  (0.8ms) DROP TABLE IF EXISTS "mks_edm_equipment_types" CASCADE +  (7.5ms) CREATE TABLE "mks_edm_equipment_types" ("id" bigserial primary key, "code" character varying, "name" character varying NOT NULL, "description" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (0.9ms) DROP TABLE IF EXISTS "mks_edm_equipment_valuations" CASCADE +  (6.6ms) CREATE TABLE "mks_edm_equipment_valuations" ("id" bigserial primary key, "equipment_item_id" bigint, "initial_cost" float NOT NULL, "residual_value" float NOT NULL, "work_hrs_per_yr" float NOT NULL, "life_year" float NOT NULL, "insurance_premium" float NOT NULL, "fuel_cost_per_hr" float, "oil_rate" float, "repair_rate" float, "rate_of_return" float, "dep_method" character varying, "is_current" boolean DEFAULT TRUE, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.2ms) CREATE INDEX "ev_on_ei_indx" ON "mks_edm_equipment_valuations" ("equipment_item_id") +  (0.7ms) DROP TABLE IF EXISTS "mks_edm_equipments" CASCADE +  (7.0ms) CREATE TABLE "mks_edm_equipments" ("id" bigserial primary key, "code" character varying, "name" character varying NOT NULL, "description" character varying, "minimum_acquisition_time" float DEFAULT 0.0 NOT NULL, "equipment_category_id" bigint, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.6ms) CREATE INDEX "equipment_on_ec_indx" ON "mks_edm_equipments" ("equipment_category_id") +  (0.9ms) DROP TABLE IF EXISTS "mks_edm_location_types" CASCADE +  (6.6ms) CREATE TABLE "mks_edm_location_types" ("id" bigserial primary key, "code" character varying, "name" character varying, "description" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (0.8ms) DROP TABLE IF EXISTS "mks_rate_bundle_discounts" CASCADE +  (5.8ms) CREATE TABLE "mks_rate_bundle_discounts" ("id" bigserial primary key, "chargeable_service_id" bigint, "service_bundle_id" bigint, "percent_discount" float NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.5ms) CREATE INDEX "cs_on_bd_indx" ON "mks_rate_bundle_discounts" ("chargeable_service_id") +  (3.3ms) CREATE INDEX "sb_on_bd_indx" ON "mks_rate_bundle_discounts" ("service_bundle_id") +  (0.6ms) DROP TABLE IF EXISTS "mks_rate_chargeable_service_discounts" CASCADE +  (7.0ms) CREATE TABLE "mks_rate_chargeable_service_discounts" ("id" bigserial primary key, "unit_variable" character varying NOT NULL, "from" float NOT NULL, "to" float NOT NULL, "value" float NOT NULL, "chargeable_service_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (0.7ms) DROP TABLE IF EXISTS "mks_rate_chargeable_services" CASCADE +  (7.0ms) CREATE TABLE "mks_rate_chargeable_services" ("id" bigserial primary key, "code" character varying NOT NULL, "name" character varying NOT NULL, "service_type_id" integer, "base_unit_id" integer, "utilization_unit_id" integer, "service_delivery_unit_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.9ms) CREATE INDEX "bu_on_cs_indx" ON "mks_rate_chargeable_services" ("base_unit_id") +  (3.6ms) CREATE INDEX "sdu_on_cs_indx" ON "mks_rate_chargeable_services" ("service_delivery_unit_id") +  (3.3ms) CREATE INDEX "st_on_cs_indx" ON "mks_rate_chargeable_services" ("service_type_id") +  (3.5ms) CREATE INDEX "uu_on_cs_indx" ON "mks_rate_chargeable_services" ("utilization_unit_id") +  (0.6ms) DROP TABLE IF EXISTS "mks_rate_rate_change_requests" CASCADE +  (7.6ms) CREATE TABLE "mks_rate_rate_change_requests" ("id" bigserial primary key, "reference_number" character varying, "authorized_by" character varying NOT NULL, "effective_on" date NOT NULL, "authorized_on" date NOT NULL, "rates" json NOT NULL, "status" character varying DEFAULT 'SUBMITTED' NOT NULL, "created_by_id" bigint, "approved_by_id" bigint, "remark" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.5ms) CREATE INDEX "ab_on_rcr_indx" ON "mks_rate_rate_change_requests" ("approved_by_id") +  (3.3ms) CREATE INDEX "cb_on_rcr_indx" ON "mks_rate_rate_change_requests" ("created_by_id") +  (4.7ms) CREATE UNIQUE INDEX "index_mks_rate_rate_change_requests_on_reference_number" ON "mks_rate_rate_change_requests" ("reference_number") +  (0.7ms) DROP TABLE IF EXISTS "mks_rate_service_bundles" CASCADE +  (7.0ms) CREATE TABLE "mks_rate_service_bundles" ("id" bigserial primary key, "code" character varying, "name" character varying NOT NULL, "description" character varying, "service_delivery_unit_id" bigint, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (4.4ms) CREATE INDEX "sdu_on_sb_indx" ON "mks_rate_service_bundles" ("service_delivery_unit_id") +  (0.8ms) DROP TABLE IF EXISTS "mks_rate_service_delivery_units" CASCADE +  (8.5ms) CREATE TABLE "mks_rate_service_delivery_units" ("id" bigserial primary key, "code" character varying NOT NULL, "name" character varying NOT NULL, "address" character varying NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (0.8ms) DROP TABLE IF EXISTS "mks_rate_service_rates" CASCADE +  (4.9ms) CREATE TABLE "mks_rate_service_rates" ("id" bigserial primary key, "chargeable_service_id" bigint, "equipment_item_id" bigint, "base_rate" float DEFAULT 0.0, "utilization_rate" float DEFAULT 0.0, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.4ms) CREATE INDEX "cs_on_sr_indx" ON "mks_rate_service_rates" ("chargeable_service_id") +  (4.1ms) CREATE INDEX "cs_on_ei_indx" ON "mks_rate_service_rates" ("equipment_item_id") +  (1.3ms) DROP TABLE IF EXISTS "mks_rate_service_types" CASCADE +  (6.2ms) CREATE TABLE "mks_rate_service_types" ("id" bigserial primary key, "code" character varying, "name" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (0.7ms) DROP TABLE IF EXISTS "mks_rate_unit_of_charges" CASCADE +  (6.6ms) CREATE TABLE "mks_rate_unit_of_charges" ("id" bigserial primary key, "name" character varying NOT NULL, "unit_variables" json NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) +  (3.3ms) ALTER TABLE "mks_auth_menus" ADD CONSTRAINT "fk_rails_e5dd25fcb5" +FOREIGN KEY ("application_module_id") + REFERENCES "mks_auth_application_modules" ("id") + +  (2.8ms) ALTER TABLE "mks_auth_menus" ADD CONSTRAINT "fk_rails_826b2757bc" +FOREIGN KEY ("parent_id") + REFERENCES "mks_auth_menus" ("id") + +  (2.4ms) ALTER TABLE "mks_auth_menus_user_roles" ADD CONSTRAINT "fk_rails_1807c05e36" +FOREIGN KEY ("menu_id") + REFERENCES "mks_auth_menus" ("id") + +  (2.6ms) ALTER TABLE "mks_auth_menus_user_roles" ADD CONSTRAINT "fk_rails_c24fca59c0" +FOREIGN KEY ("user_role_id") + REFERENCES "mks_auth_user_roles" ("id") + +  (2.6ms) ALTER TABLE "mks_auth_user_roles" ADD CONSTRAINT "fk_rails_b0b293e4e2" +FOREIGN KEY ("application_module_id") + REFERENCES "mks_auth_application_modules" ("id") + +  (3.3ms) ALTER TABLE "mks_auth_users_application_modules" ADD CONSTRAINT "fk_rails_b100f8542c" +FOREIGN KEY ("application_module_id") + REFERENCES "mks_auth_application_modules" ("id") + +  (2.8ms) ALTER TABLE "mks_auth_users_application_modules" ADD CONSTRAINT "fk_rails_1010e0182a" +FOREIGN KEY ("user_id") + REFERENCES "mks_auth_users" ("id") + +  (2.4ms) ALTER TABLE "mks_auth_users_user_roles" ADD CONSTRAINT "fk_rails_3dae904cd8" +FOREIGN KEY ("user_role_id") + REFERENCES "mks_auth_user_roles" ("id") + +  (2.4ms) ALTER TABLE "mks_auth_users_user_roles" ADD CONSTRAINT "fk_rails_7cc19890aa" +FOREIGN KEY ("user_id") + REFERENCES "mks_auth_users" ("id") + +  (3.3ms) ALTER TABLE "mks_edm_equipment_categories" ADD CONSTRAINT "fk_rails_37d48f9db9" +FOREIGN KEY ("equipment_type_id") + REFERENCES "mks_edm_equipment_types" ("id") + +  (3.4ms) ALTER TABLE "mks_edm_equipment_components" ADD CONSTRAINT "fk_rails_df30d7c6f8" +FOREIGN KEY ("equipment_item_id") + REFERENCES "mks_edm_equipment_items" ("id") + +  (2.5ms) ALTER TABLE "mks_edm_equipment_items" ADD CONSTRAINT "fk_rails_c0b56e395b" +FOREIGN KEY ("current_location_id") + REFERENCES "mks_edm_equipment_locations" ("id") + +  (3.2ms) ALTER TABLE "mks_edm_equipment_items" ADD CONSTRAINT "fk_rails_9c44a32cfe" +FOREIGN KEY ("equipment_id") + REFERENCES "mks_edm_equipments" ("id") + +  (3.0ms) ALTER TABLE "mks_edm_equipment_locations" ADD CONSTRAINT "fk_rails_4117320862" +FOREIGN KEY ("location_type_id") + REFERENCES "mks_edm_location_types" ("id") + +  (4.3ms) ALTER TABLE "mks_edm_equipment_valuations" ADD CONSTRAINT "fk_rails_b09a0ab3c3" +FOREIGN KEY ("equipment_item_id") + REFERENCES "mks_edm_equipment_items" ("id") + +  (4.3ms) ALTER TABLE "mks_edm_equipments" ADD CONSTRAINT "fk_rails_59110db010" +FOREIGN KEY ("equipment_category_id") + REFERENCES "mks_edm_equipment_categories" ("id") + +  (3.4ms) ALTER TABLE "mks_rate_bundle_discounts" ADD CONSTRAINT "fk_rails_e6bce7b79c" +FOREIGN KEY ("chargeable_service_id") + REFERENCES "mks_rate_chargeable_services" ("id") + +  (2.6ms) ALTER TABLE "mks_rate_bundle_discounts" ADD CONSTRAINT "fk_rails_72a3777128" +FOREIGN KEY ("service_bundle_id") + REFERENCES "mks_rate_service_bundles" ("id") + +  (2.7ms) ALTER TABLE "mks_rate_chargeable_service_discounts" ADD CONSTRAINT "fk_rails_688682e0b5" +FOREIGN KEY ("chargeable_service_id") + REFERENCES "mks_rate_chargeable_services" ("id") + +  (3.0ms) ALTER TABLE "mks_rate_chargeable_services" ADD CONSTRAINT "fk_rails_4e0ff36276" +FOREIGN KEY ("service_delivery_unit_id") + REFERENCES "mks_rate_service_delivery_units" ("id") + +  (3.7ms) ALTER TABLE "mks_rate_chargeable_services" ADD CONSTRAINT "fk_rails_c9195a9eb4" +FOREIGN KEY ("service_type_id") + REFERENCES "mks_rate_service_types" ("id") + +  (3.1ms) ALTER TABLE "mks_rate_chargeable_services" ADD CONSTRAINT "fk_rails_323d899c02" +FOREIGN KEY ("base_unit_id") + REFERENCES "mks_rate_unit_of_charges" ("id") + +  (3.6ms) ALTER TABLE "mks_rate_chargeable_services" ADD CONSTRAINT "fk_rails_a4bbde1129" +FOREIGN KEY ("utilization_unit_id") + REFERENCES "mks_rate_unit_of_charges" ("id") + +  (3.1ms) ALTER TABLE "mks_rate_rate_change_requests" ADD CONSTRAINT "fk_rails_1ec309ecbf" +FOREIGN KEY ("approved_by_id") + REFERENCES "mks_auth_users" ("id") + +  (3.1ms) ALTER TABLE "mks_rate_rate_change_requests" ADD CONSTRAINT "fk_rails_c0525c8963" +FOREIGN KEY ("created_by_id") + REFERENCES "mks_auth_users" ("id") + +  (2.8ms) ALTER TABLE "mks_rate_service_bundles" ADD CONSTRAINT "fk_rails_d6c823a60f" +FOREIGN KEY ("service_delivery_unit_id") + REFERENCES "mks_rate_service_delivery_units" ("id") + +  (2.7ms) ALTER TABLE "mks_rate_service_rates" ADD CONSTRAINT "fk_rails_8f0c330d29" +FOREIGN KEY ("equipment_item_id") + REFERENCES "mks_edm_equipment_items" ("id") + +  (2.5ms) ALTER TABLE "mks_rate_service_rates" ADD CONSTRAINT "fk_rails_a39cc6503a" +FOREIGN KEY ("chargeable_service_id") + REFERENCES "mks_rate_chargeable_services" ("id") + +  (7.1ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL PRIMARY KEY) +  (1.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC +  (1.6ms) INSERT INTO "schema_migrations" (version) VALUES (20180317043420) +  (2.4ms) INSERT INTO "schema_migrations" (version) VALUES +(20171215080758), +(20171215081601), +(20171216024320), +(20171216041414), +(20171216070855), +(20171217081426), +(20171220133548); + + +  (6.3ms) CREATE TABLE "ar_internal_metadata" ("key" character varying NOT NULL PRIMARY KEY, "value" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) + ActiveRecord::InternalMetadata Load (1.0ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "environment"], ["LIMIT", 1]] +  (0.7ms) BEGIN + ActiveRecord::InternalMetadata Create (1.0ms) INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "key" [["key", "environment"], ["value", "development"], ["created_at", "2018-09-05 07:55:54.141935"], ["updated_at", "2018-09-05 07:55:54.141935"]] +  (2.1ms) COMMIT + ActiveRecord::InternalMetadata Load (1.0ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "environment"], ["LIMIT", 1]] +  (0.9ms) BEGIN + ActiveRecord::InternalMetadata Update (1.1ms) UPDATE "ar_internal_metadata" SET "value" = $1, "updated_at" = $2 WHERE "ar_internal_metadata"."key" = $3 [["value", "test"], ["updated_at", "2018-09-05 07:55:54.152035"], ["key", "environment"]] +  (1.8ms) COMMIT