Skip to content

Instantly share code, notes, and snippets.

@apex-omontgomery
Created April 22, 2018 03:29
Show Gist options
  • Save apex-omontgomery/cd8fe53fc520621cf713da3ebb23a91a to your computer and use it in GitHub Desktop.
Save apex-omontgomery/cd8fe53fc520621cf713da3ebb23a91a to your computer and use it in GitHub Desktop.
slack user migration
PS C:\Users\wimo7\Desktop\back> make db_migrate
docker-compose run web rake db:migrate
Starting operationcodebackend_operationcode-psql_1 ... done
Starting operationcodebackend_bundle_1 ... done
Starting operationcodebackend_redis_1 ... done
W, [2018-04-22T03:19:15.749687 #1] WARN -- : [SKYLIGHT] [1.5.0] Running Skylight in development mode. No data will be reported until you deploy your app.
(To disable this message for all local apps, run `skylight disable_dev_warning`.)
I, [2018-04-22T03:19:16.070514 #1] INFO -- : Raven 2.5.3 configured not to capture errors: DSN not set
W, [2018-04-22T03:19:16.594481 #1] WARN -- : Creating scope :open. Overwriting existing method GitHubStatistic.open.
D, [2018-04-22T03:19:17.058166 #1] DEBUG -- : (0.2ms) SELECT pg_try_advisory_lock(3885840460873229985);
D, [2018-04-22T03:19:17.074917 #1] DEBUG -- : ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations"
I, [2018-04-22T03:19:17.087733 #1] INFO -- : Migrating to CreateSlackUser (20180422030623)
D, [2018-04-22T03:19:17.092342 #1] DEBUG -- : (0.3ms) BEGIN
== 20180422030623 CreateSlackUser: migrating ==================================
-- create_table(:slack_users)
D, [2018-04-22T03:19:17.115209 #1] DEBUG -- : (19.2ms) CREATE TABLE "slack_users" ("id" serial primary key, "slack_id" character varying, "slack_name" character varying, "slack_real_name" character varying, "slack_display_name" character varying, "slack_email" character varying)
D, [2018-04-22T03:19:17.121411 #1] DEBUG -- : (3.1ms) CREATE INDEX "index_slack_users_on_slack_id" ON "slack_users" ("slack_id")
D, [2018-04-22T03:19:17.126163 #1] DEBUG -- : (2.8ms) CREATE INDEX "index_slack_users_on_slack_email" ON "slack_users" ("slack_email")
-> 0.0336s
== 20180422030623 CreateSlackUser: migrated (0.0338s) =========================
D, [2018-04-22T03:19:17.130311 #1] DEBUG -- : SQL (0.5ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version" [["version", "20180422030623"]]
D, [2018-04-22T03:19:17.134374 #1] DEBUG -- : (3.6ms) COMMIT
I, [2018-04-22T03:19:17.150882 #1] INFO -- : Migrating to DropUserSlackId (20180422031009)
D, [2018-04-22T03:19:17.155236 #1] DEBUG -- : (0.2ms) BEGIN
== 20180422031009 DropUserSlackId: migrating ==================================
-- remove_column(:users, :slack_name)
D, [2018-04-22T03:19:17.158308 #1] DEBUG -- : (2.2ms) ALTER TABLE "users" DROP "slack_name"
-> 0.0029s
== 20180422031009 DropUserSlackId: migrated (0.0030s) =========================
D, [2018-04-22T03:19:17.161098 #1] DEBUG -- : SQL (0.7ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version" [["version", "20180422031009"]]
D, [2018-04-22T03:19:17.165879 #1] DEBUG -- : (2.8ms) COMMIT
D, [2018-04-22T03:19:17.170596 #1] DEBUG -- : ActiveRecord::InternalMetadata Load (0.3ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", :environment], ["LIMIT", 1]]
D, [2018-04-22T03:19:17.176594 #1] DEBUG -- : (0.4ms) BEGIN
D, [2018-04-22T03:19:17.179339 #1] DEBUG -- : (0.5ms) COMMIT
D, [2018-04-22T03:19:17.180326 #1] DEBUG -- : (0.5ms) SELECT pg_advisory_unlock(3885840460873229985)
D, [2018-04-22T03:19:17.191723 #1] DEBUG -- : ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment