API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 10th, 2016
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.95 KB | None | 0 0
raw download clone embed print report
  1. MacBook-Pro:flyway_example salam$ ./bin/flyway_wrapper.sh
  2.  
  3. Updating DB schema...
  4.  
  5. Flyway 4.0.1 by Boxfuse
  6.  
  7. Database: jdbc:oracle:thin:@//localhost:1521/orcl.localdomain (Oracle 12.1)
  8.  
  9. 21:24:24.149 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  10.  
  11. Creating Metadata table: "SANDBOX"."FLYWAY_SCHEMA_VERSION"
  12.  
  13. 21:24:24.239 [main] INFO - 1. CREATE TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" ( "installed_rank" INT NOT NULL, "version" VARCHAR2(50), "description" VARCHAR2(200) NOT NULL, "type" VARCHAR2(20) NOT NULL, "script" VARCHAR2(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR2(100) NOT NULL, "installed_on" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, "execution_time" INT NOT NULL, "success" NUMBER(1) NOT NULL ) {executed in 23 ms}
  14.  
  15. 21:24:24.253 [main] INFO - 1. ALTER TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" ADD CONSTRAINT "FLYWAY_SCHEMA_VERSION_pk" PRIMARY KEY ("installed_rank") {executed in 13 ms}
  16.  
  17. 21:24:24.260 [main] INFO - 1. CREATE INDEX "SANDBOX"."FLYWAY_SCHEMA_VERSION_s_idx" ON "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("success") {executed in 7 ms}
  18.  
  19. 21:24:24.262 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  20.  
  21. Current version of schema "SANDBOX": << Empty Schema >>
  22.  
  23. Migrating schema "SANDBOX" to version 20160609.001 - DDL create dummy table
  24.  
  25. 21:24:24.288 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  26.  
  27. 21:24:24.306 [main] INFO - 2. CREATE TABLE dummy_table ( id NUMBER NOT NULL PRIMARY KEY, dummy_text VARCHAR2 ( 100 CHAR ) ) {executed in 17 ms}
  28.  
  29. 21:24:24.344 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (1, '20160609.001', 'DDL create dummy table', 'SQL', 'V20160609.001__DDL_create_dummy_table.sql', -1748400554, USER, 22, 1) {executed in 31 ms}
  30.  
  31. 21:24:24.348 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  32.  
  33. Migrating schema "SANDBOX" to version 20160609.002 - DDL create dummy sequence
  34.  
  35. 21:24:24.362 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  36.  
  37. 21:24:24.372 [main] INFO - 2. CREATE SEQUENCE dummy_sequence START WITH 100000 INCREMENT BY 1 NOCACHE {executed in 9 ms}
  38.  
  39. 21:24:24.380 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (2, '20160609.002', 'DDL create dummy sequence', 'SQL', 'V20160609.002__DDL_create_dummy_sequence.sql', -1920605542, USER, 13, 1) {executed in 2 ms}
  40.  
  41. 21:24:24.384 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  42.  
  43. Migrating schema "SANDBOX" to version 20160609.003 - DML add some data
  44.  
  45. 21:24:24.395 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 0 ms}
  46.  
  47. 21:24:24.409 [main] INFO - 2. INSERT INTO dummy_table ( id, dummy_text ) VALUES ( dummy_sequence.NEXTVAL, 'dummy_text_' || TO_CHAR ( dummy_sequence.CURRVAL ) ) {executed in 13 ms}
  48.  
  49. 21:24:24.411 [main] INFO - 2. INSERT INTO dummy_table ( id, dummy_text ) VALUES ( dummy_sequence.NEXTVAL, 'dummy_text_' || TO_CHAR ( dummy_sequence.CURRVAL ) ) {executed in 1 ms}
  50.  
  51. 21:24:24.417 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (3, '20160609.003', 'DML add some data', 'SQL', 'V20160609.003__DML_add_some_data.sql', -1449160155, USER, 20, 1) {executed in 1 ms}
  52.  
  53. 21:24:24.423 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  54.  
  55. Migrating schema "SANDBOX" to version 20160610.001 - DDL add audit columns
  56.  
  57. 21:24:24.435 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  58.  
  59. 21:24:24.453 [main] INFO - 2. ALTER TABLE dummy_table ADD ( modified_at TIMESTAMP DEFAULT SYSTIMESTAMP, modified_by VARCHAR2 ( 100 CHAR ) DEFAULT SYS_CONTEXT ( 'userenv','os_user' ) || '@'|| SYS_CONTEXT ( 'userenv','host' ) ) {executed in 17 ms}
  60.  
  61. 21:24:24.458 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (4, '20160610.001', 'DDL add audit columns', 'SQL', 'V20160610.001__DDL_add_audit_columns.sql', 628445732, USER, 21, 1) {executed in 1 ms}
  62.  
  63. 21:24:24.463 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  64.  
  65. Migrating schema "SANDBOX" to version 20160610.002 - DML fill audit columns
  66.  
  67. 21:24:24.476 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  68.  
  69. 21:24:24.482 [main] INFO - 2. UPDATE dummy_table SET modified_by = 'migration_default_value' {executed in 5 ms}
  70.  
  71. 21:24:24.487 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (5, '20160610.002', 'DML fill audit columns', 'SQL', 'V20160610.002__DML_fill_audit_columns.sql', 108603650, USER, 10, 1) {executed in 1 ms}
  72.  
  73. 21:24:24.491 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  74.  
  75. Migrating schema "SANDBOX" to version 20160610.003 - DML add some data
  76.  
  77. 21:24:24.502 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  78.  
  79. 21:24:24.534 [main] INFO - 2. BEGIN FOR i IN 1 .. 100 LOOP INSERT INTO dummy_table ( id, dummy_text ) VALUES ( dummy_sequence.NEXTVAL, 'dummy_text_' || TO_CHAR ( dummy_sequence.CURRVAL ) ); END LOOP; END; {executed in 30 ms}
  80.  
  81. 21:24:24.541 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (6, '20160610.003', 'DML add some data', 'SQL', 'V20160610.003__DML_add_some_data.sql', -1176254022, USER, 38, 1) {executed in 1 ms}
  82.  
  83. 21:24:24.547 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  84.  
  85. Migrating schema "SANDBOX" to version 20160611.001 - DDL create another table
  86.  
  87. 21:24:24.558 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  88.  
  89. 21:24:24.567 [main] INFO - 2. CREATE TABLE another_table ( row_count NUMBER, min_modified_at TIMESTAMP, max_modified_at TIMESTAMP ) {executed in 8 ms}
  90.  
  91. 21:24:24.572 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (7, '20160611.001', 'DDL create another table', 'SQL', 'V20160611.001__DDL_create_another_table.sql', -604805357, USER, 12, 1) {executed in 1 ms}
  92.  
  93. 21:24:24.576 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  94.  
  95. Migrating schema "SANDBOX" to version 20160611.002 - DML migrate to another table
  96.  
  97. 21:24:24.588 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  98.  
  99. 21:24:24.600 [main] INFO - 2. INSERT INTO another_table ( row_count, min_modified_at, max_modified_at ) SELECT COUNT ( * ), MIN ( modified_at ), MAX ( modified_at ) FROM dummy_table {executed in 10 ms}
  100.  
  101. 21:24:24.605 [main] INFO - 1. INSERT INTO "SANDBOX"."FLYWAY_SCHEMA_VERSION" ("installed_rank","version","description","type","script","checksum","installed_by","execution_time","success") VALUES (8, '20160611.002', 'DML migrate to another table', 'SQL', 'V20160611.002__DML_migrate_to_another_table.sql', 1147979938, USER, 16, 1) {executed in 1 ms}
  102.  
  103. 21:24:24.610 [main] INFO - 1. LOCK TABLE "SANDBOX"."FLYWAY_SCHEMA_VERSION" IN EXCLUSIVE MODE {executed in 1 ms}
  104.  
  105. Successfully applied 8 migrations to schema "SANDBOX" (execution time 00:00.464s).
  106.  
  107. 21:24:24.623 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA="SANDBOX" {executed in 1 ms}
  108.  
  109. 21:24:24.626 [main] INFO - 2. ALTER SESSION SET CURRENT_SCHEMA=SYS {executed in 1 ms}
  110.  
  111. MacBook-Pro:flyway_example salam$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!