Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. spring:
  2. application:
  3. name: liquibase-spring-jpa-postgres-example
  4. liquibase:
  5. change-log: db.changelog/db.changelog-master.xml
  6.  
  7. spring:
  8. profiles: dev
  9. datasource:
  10. url: jdbc:postgresql://localhost:5432/dev
  11. username: postgres
  12. password: password
  13. driver-class-name: org.postgresql.Driver
  14.  
  15. spring:
  16. profiles: ci
  17. datasource:
  18. url: jdbc:postgresql://localhost:5432/ci
  19. username: postgres
  20. password: password
  21. driver-class-name: org.postgresql.Driver
  22.  
  23. spring:
  24. profiles: qa
  25. datasource:
  26. url: jdbc:postgresql://localhost:5432/qa
  27. username: postgres
  28. password: password
  29. driver-class-name: org.postgresql.Driver
  30.  
  31. spring:
  32. profiles: production
  33. datasource:
  34. url: jdbc:postgresql://localhost:5432/prod
  35. username: postgres
  36. password: password
  37. driver-class-name: org.postgresql.Driver
  38.  
  39. <changeSet id="20161016_my_first_change" author="fike" context="dev, qa, ci, production">
  40. <sql>
  41. CREATE TABLE customer
  42. (
  43. id BIGSERIAL PRIMARY KEY,
  44. firstname character varying NOT NULL,
  45. lastname character varying NOT NULL
  46. );
  47. </sql>
  48. <rollback>
  49. drop table customer;
  50. </rollback>
  51. </changeSet>
  52.  
  53. <changeSet id="20161016_my_first_change2" author="krudland" context="dev">
  54. <sql>
  55. insert into customer (firstname, lastname) values ('Franklin','Ike');
  56. </sql>
  57. <rollback>
  58. delete from customer where firstname = 'Franklin' and lastname = 'Ike';
  59. </rollback>
  60. </changeSet>
  61.  
  62. spring:
  63. profiles: dev
  64. datasource:
  65. url: jdbc:postgresql://localhost:5432/dev
  66. username: postgres
  67. password: password
  68. driver-class-name: org.postgresql.Driver
  69. liquibase:
  70. contexts: dev
  71.  
  72. <changeSet id="20161016_my_first_change2" author="krudland" context="dev">
  73. <sql>
  74. insert into customer (firstname, lastname) values ('Franklin','Ike');
  75. </sql>
  76. <rollback>
  77. delete from customer where firstname = 'Franklin' and lastname = 'Ike';
  78. </rollback>
  79. </changeSet>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement