• Home
• org.liquibase
• liquibase-test-harness
• 1.0.2
• source code
• diffDatabases.yml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.diff.diffDatabases.yml Maven / Gradle / Ivy

# notes:
# - database names and versions should match with ones provided in harness-config.yml
# - targetDatabaseVersion and referenceDatabaseVersion parameters could be missed if harness-config.yml has only one DB ->
# -> with such name or DB doesn't have version as such
---
references:
  - targetDatabaseName: postgresql
    targetDatabaseVersion: 9
    referenceDatabaseName: postgresql
    referenceDatabaseVersion: 12
    expectedDiffs:
      missingObjects:
      unexpectedObjects:
      changedObjects:
        - diffName: "public.authors.added"
          diffs:
            defaultValue: "defaultValue changed from 'CURRENT_TIMESTAMP' to 'now()'"
        - diffName: "public.posts.id"
          diffs:
            defaultValue: "defaultValue changed from 'nextval('posts_id_seq'::regclass)' to 'null'"
            type: "type changed from 'serial' to 'int4'"
        - diffName: "public.authors.id"
          diffs:
            defaultValue: "defaultValue changed from 'nextval('authors_id_seq'::regclass)' to 'null'"
            type: "type changed from 'serial' to 'int4'"


  - targetDatabaseName: mysql
    targetDatabaseVersion: 5.7
    referenceDatabaseName: mysql
    referenceDatabaseVersion: 8
    expectedDiffs:
      missingObjects:
      unexpectedObjects:
      changedObjects:


  - targetDatabaseName: postgresql
    targetDatabaseVersion: 9
    referenceDatabaseName: mysql
    referenceDatabaseVersion: 8
    expectedDiffs:
      missingObjects:
      unexpectedObjects:
      changedObjects:
        - diffName: "lbcat.posts.id"
          diffs:
            type: "type changed from 'INT(10)' to 'int4'"
        - diffName: "lbcat.authors.id"
          diffs:
            type: "type changed from 'INT(10)' to 'int4'"
        - diffName: "lbcat.posts.content"
          diffs:
            type: "type changed from 'TEXT(65535)' to 'text'"
        - diffName: "lbcat.posts.author_id"
          diffs:
            type: "type changed from 'INT(10)' to 'int4'"
        - diffName: "lbcat.posts.inserted_date"
          diffs:
            type: "type changed from 'DATE(10)' to 'date'"
        - diffName: "lbcat.authors.added"
          diffs:
            defaultValue: "defaultValue changed from 'CURRENT_TIMESTAMP' to 'now()'"
        - diffName: "lbcat.authors.birthdate"
          diffs:
            type: "type changed from 'DATE(10)' to 'date'"