Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Added additional verification for GenerateChangelogTest #486

Merged
merged 15 commits into from
Feb 3, 2023
Merged

Added additional verification for GenerateChangelogTest #486

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
15 commits
Select commit Hold shift + click to select a range
368c983
Added additional verification for GenerateChangelogTest
yodzhubeiskyi Jan 30, 2023
174d20d
Changed sql validation logic for GenerateChangelogTest
yodzhubeiskyi Jan 31, 2023
d761241
Sql comparison fix for GenerateChangelogTest
yodzhubeiskyi Jan 31, 2023
417fd31
Sql comparison fix for GenerateChangelogTest
yodzhubeiskyi Jan 31, 2023
4db30fe
Sql comparison fix for GenerateChangelogTest
yodzhubeiskyi Jan 31, 2023
e99651b
Verification sql fix
yodzhubeiskyi Jan 31, 2023
8b2ee02
Verification sql fix
yodzhubeiskyi Jan 31, 2023
fdc8612
Verification sql fix
yodzhubeiskyi Jan 31, 2023
1ab99a5
Verification sql fix
yodzhubeiskyi Feb 1, 2023
2e4c199
Verification sql fix
yodzhubeiskyi Feb 1, 2023
5d83cb8
Fixed error message
yodzhubeiskyi Feb 1, 2023
36d87a6
Fixed azure-postgers test data
yodzhubeiskyi Feb 1, 2023
be2472b
Fixed azure-postgers test data
yodzhubeiskyi Feb 1, 2023
396a22a
Fixed azure-postgers test data
yodzhubeiskyi Feb 1, 2023
c3b47d4
Made requested changes
yodzhubeiskyi Feb 3, 2023
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
The table of contents is too big for display.
Diff view
Diff view
  •  
  •  
  •  
41 changes: 36 additions & 5 deletions src/main/groovy/liquibase/harness/generateChangelog/GenerateChangelogTest.groovy
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -23,7 +23,8 @@ class GenerateChangelogTest extends Specification {
List<DatabaseUnderTest> databases
@Shared
UIService uiService = Scope.getCurrentScope().getUI()
String testResourcesPath = System.getProperty("user.dir") + "/src/test/resources/"
String resourcesDirFullPath = System.getProperty("user.dir") + "/src/test/resources/"
String resourcesDirPath = "/src/test/resources/"
long timeMillisBeforeTest
long timeMillisAfterTest

Expand Down Expand Up @@ -65,11 +66,12 @@ class GenerateChangelogTest extends Specification {
when: "execute generateChangelog command using different changelog formats"
argsMap.put("changeLogFile", testInput.xmlChangelogPath)
executeCommandScope("update", argsMap)
argsMap.put("changeLogFile", testResourcesPath + entry.value)
argsMap.put("changeLogFile", resourcesDirFullPath + entry.value)
argsMap.put("excludeObjects", "(?i)posts, (?i)authors")//excluding static test-harness objects from generated changelog
if (entry.key.equalsIgnoreCase("expectedSqlChangelog")) {
def shortDbName = getShortDatabaseName(testInput.databaseName)
sqlSpecificChangelogFile = entry.value.replace(".sql", ".$shortDbName" + ".sql")
argsMap.put("changeLogFile", testResourcesPath + sqlSpecificChangelogFile)
argsMap.put("changeLogFile", resourcesDirFullPath + sqlSpecificChangelogFile)
}
executeCommandScope("generateChangelog", argsMap, testInput.databaseName)

Expand All @@ -81,6 +83,35 @@ class GenerateChangelogTest extends Specification {
assert generatedChangelog.contains("$testInput.change")
}

when: "get sql generated for the change set"
String generatedSql
argsMap.put("changeLogFile", resourcesDirPath + entry.value)
if (!entry.key.equalsIgnoreCase("expectedSqlChangelog")) {
generatedSql = parseQuery(executeCommandScope("updateSql", argsMap).toString())
generatedSql = removeSchemaNames(generatedSql, testInput.database)
}


then: "execute updateSql command on generated changelogs"
if (!entry.key.equalsIgnoreCase("expectedSqlChangelog")) {
def expectedSql
try {
expectedSql = parseQuery(getSqlFileContent(testInput.change, testInput.databaseName, testInput.version,
"liquibase/harness/generateChangelog/verificationSql")).toLowerCase()
} catch (NullPointerException exception) {
expectedSql = parseQuery(getSqlFileContent(testInput.change, testInput.databaseName, testInput.version,
"liquibase/harness/generateChangelog/expectedSql")).toLowerCase()
}
def generatedSqlIsCorrect = generatedSql == expectedSql
if (!generatedSqlIsCorrect) {
Scope.getCurrentScope().getUI().sendMessage("FAIL! Expected sql doesn't " +
"match generated sql! \nEXPECTED SQL: \n" + expectedSql + " \n" +
"GENERATED SQL: \n" + generatedSql)
assert generatedSql == expectedSql
}
}


and: "rollback changes"
argsMap.put("changeLogFile", testInput.xmlChangelogPath)
strategy.performRollback(argsMap)
Expand All @@ -97,9 +128,9 @@ class GenerateChangelogTest extends Specification {
}
for (Map.Entry<String, String> entry : map.entrySet()) {
if (entry.key.equalsIgnoreCase("expectedSqlChangelog")) {
deleteFile(testResourcesPath + sqlSpecificChangelogFile)
deleteFile(resourcesDirFullPath + sqlSpecificChangelogFile)
} else {
deleteFile(testResourcesPath + entry.value)
deleteFile(resourcesDirFullPath + entry.value)
}
}

Expand Down
23 changes: 21 additions & 2 deletions src/main/groovy/liquibase/harness/generateChangelog/GenerateChangelogTestHelper.groovy
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -28,7 +28,7 @@ class GenerateChangelogTestHelper {
for (DatabaseUnderTest databaseUnderTest : databaseConnectionUtil
.initializeDatabasesConnection(TestConfig.instance.getFilteredDatabasesUnderTest())) {
for (def changeLogEntry : FileUtils.resolveInputFilePaths(databaseUnderTest, baseChangelogPath +
"expectedChangeLog", "sql").entrySet()) {
"expectedChangeLog", "xml").entrySet()) {
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

can we use TestConfig.instance.inputFormat here? Or maybe we can change to build testInput in other way as we don't really pick up only files with this extension

if (!commandLineChangesList || commandLineChangesList.contains(changeLogEntry.key)) {
inputList.add(TestInput.builder()
.databaseName(databaseUnderTest.name)
Expand All @@ -46,8 +46,12 @@ class GenerateChangelogTestHelper {
"stress/select", "xml").get(changeLogEntry.key))
.xmlChangelogPath(FileUtils.resolveInputFilePaths(databaseUnderTest, baseChangelogPath +
"expectedChangeLog", "xml").get(changeLogEntry.key))
.jsonChangelogPath(FileUtils.resolveInputFilePaths(databaseUnderTest, baseChangelogPath +
"expectedChangeLog", "json").get(changeLogEntry.key))
.ymlChangelogPath(FileUtils.resolveInputFilePaths(databaseUnderTest, baseChangelogPath +
"expectedChangeLog", "yml").get(changeLogEntry.key))
.sqlChangelogPath(FileUtils.resolveInputFilePaths(databaseUnderTest, baseChangelogPath +
"expectedChangeLog", "sql").get(changeLogEntry.key))
"expectedSql", "sql").get(changeLogEntry.key))
.change(changeLogEntry.key)
.database(databaseUnderTest.database)
.build())
Expand Down Expand Up @@ -83,6 +87,19 @@ class GenerateChangelogTestHelper {
}
}

static String getSqlSpecificChangelogFile (String dbName, String changelogFileName) {
def replacementName = String.format(".%s.sql", getShortDatabaseName(dbName))
return changelogFileName.replace(".sql", replacementName)
}

static String removeSchemaNames(String generatedSql, Database database) {
if (database.getShortName().equals("sqlite")) {
return generatedSql.toLowerCase()
}
def schemaName = database.getDefaultSchemaName().toLowerCase()
return generatedSql.toLowerCase().replace(schemaName + ".", "").replace("\"" + schemaName + "\".", "")
}

@Builder
@ToString(includeNames = true, includeFields = true, includePackage = false, excludes = 'database,password')
static class TestInput {
Expand All @@ -96,6 +113,8 @@ class GenerateChangelogTestHelper {
String updateChangelogPath
String selectChangelogPath
String xmlChangelogPath
String jsonChangelogPath
String ymlChangelogPath
String sqlChangelogPath
String dbSchema
String change
Expand Down
5 changes: 3 additions & 2 deletions src/main/groovy/liquibase/harness/util/TestUtils.groovy
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -75,8 +75,6 @@ class TestUtils {
}
commandScope.setOutput(outputStream)
try {
Logger.getLogger(this.class.name).info(String.format("Executing liquibase command: %s ", commandName))
commandScope.execute()
//TODO investigate and fix mssql issue with autogenerated objects
if (commandName.equals("generateChangelog")) {
String testResourcesPath = String.format("%s/src/test/resources/liquibase/harness/generateChangelog/expectedChangeLog/%s/objects/", System.getProperty("user.dir"), dbName) + ""
Expand All @@ -85,6 +83,9 @@ class TestUtils {
FileUtils.forceDelete(new File(testResourcesPath))
}
}
Logger.getLogger(this.class.name).info(String.format("Executing liquibase command: %s ", commandName))
commandScope.execute()

} catch (Exception exception) {
if (exception instanceof CommandExecutionException && exception.toString().contains("is not available in SQL output mode")) {
//Here we check whether updateSql command throws specific exception and skip it (updateSql doesn't work for SQLite for some change types)
Expand Down
30 changes: 0 additions & 30 deletions src/main/resources/liquibase/harness/generateChangelog/expectedChangeLog/createTable.json
View file
Open in desktop

This file was deleted.

6 changes: 0 additions & 6 deletions src/main/resources/liquibase/harness/generateChangelog/expectedChangeLog/createTable.sql
View file
Open in desktop

This file was deleted.

14 changes: 0 additions & 14 deletions src/main/resources/liquibase/harness/generateChangelog/expectedChangeLog/createTable.yml
View file
Open in desktop

This file was deleted.

0 ...tedChangeLog/cockroachdb/20.2/primary.sql → .../expectedSql/cockroachdb/20.2/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/cockroachdb/22.1/column.sql → ...g/expectedSql/cockroachdb/22.1/column.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/cockroachdb/22.1/createIndex.sql → ...ectedSql/cockroachdb/22.1/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/cockroachdb/22.1/createTable.sql → ...ectedSql/cockroachdb/22.1/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/cockroachdb/22.1/unique.sql → ...g/expectedSql/cockroachdb/22.1/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...ngeLog/cockroachdb/addCheckConstraint.sql → ...tedSql/cockroachdb/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...g/cockroachdb/addForeignKeyConstraint.sql → ...l/cockroachdb/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/cockroachdb/column.sql → ...ngelog/expectedSql/cockroachdb/column.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/cockroachdb/createFunction.sql → ...xpectedSql/cockroachdb/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/cockroachdb/createIndex.sql → ...g/expectedSql/cockroachdb/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/cockroachdb/createPackage.sql → ...expectedSql/cockroachdb/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/cockroachdb/createPackageBody.sql → ...ctedSql/cockroachdb/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/cockroachdb/createProcedure.sql → ...pectedSql/cockroachdb/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/cockroachdb/createSequence.sql → ...xpectedSql/cockroachdb/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/cockroachdb/createSynonym.sql → ...expectedSql/cockroachdb/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/cockroachdb/createTable.sql → ...g/expectedSql/cockroachdb/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/cockroachdb/createTrigger.sql → ...expectedSql/cockroachdb/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/cockroachdb/createView.sql → ...og/expectedSql/cockroachdb/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/cockroachdb/primary.sql → ...gelog/expectedSql/cockroachdb/primary.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/cockroachdb/unique.sql → ...ngelog/expectedSql/cockroachdb/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/db2-luw/addCheckConstraint.sql → ...xpectedSql/db2-luw/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...geLog/db2-luw/addForeignKeyConstraint.sql → ...edSql/db2-luw/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/db2-luw/column.sql → ...eChangelog/expectedSql/db2-luw/column.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/db2-luw/createFunction.sql → ...og/expectedSql/db2-luw/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/db2-luw/createIndex.sql → ...gelog/expectedSql/db2-luw/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/db2-luw/createPackage.sql → ...log/expectedSql/db2-luw/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/db2-luw/createPackageBody.sql → ...expectedSql/db2-luw/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/db2-luw/createProcedure.sql → ...g/expectedSql/db2-luw/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/db2-luw/createSequence.sql → ...og/expectedSql/db2-luw/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/db2-luw/createSynonym.sql → ...log/expectedSql/db2-luw/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/db2-luw/createTable.sql → ...gelog/expectedSql/db2-luw/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/db2-luw/createTrigger.sql → ...log/expectedSql/db2-luw/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/db2-luw/createView.sql → ...ngelog/expectedSql/db2-luw/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...log/expectedChangeLog/db2-luw/primary.sql → ...Changelog/expectedSql/db2-luw/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/db2-luw/unique.sql → ...eChangelog/expectedSql/db2-luw/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/derby/addForeignKeyConstraint.sql → ...ctedSql/derby/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/derby/addUniqueConstraint.sql → ...expectedSql/derby/addUniqueConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ngelog/expectedChangeLog/derby/column.sql → ...ateChangelog/expectedSql/derby/column.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/derby/createIndex.sql → ...angelog/expectedSql/derby/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/derby/createProcedure.sql → ...log/expectedSql/derby/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/derby/createSequence.sql → ...elog/expectedSql/derby/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/derby/createTable.sql → ...angelog/expectedSql/derby/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...og/expectedChangeLog/derby/createView.sql → ...hangelog/expectedSql/derby/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...gelog/expectedChangeLog/derby/primary.sql → ...teChangelog/expectedSql/derby/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/edb-edb/10/createProcedure.sql → ...xpectedSql/edb-edb/10/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/edb-edb/10/createTrigger.sql → .../expectedSql/edb-edb/10/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/edb-edb/11/createTrigger.sql → .../expectedSql/edb-edb/11/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/edb-edb/9.5/createProcedure.sql → ...pectedSql/edb-edb/9.5/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/edb-edb/9.5/createSequence.sql → ...xpectedSql/edb-edb/9.5/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/edb-edb/9.5/createTrigger.sql → ...expectedSql/edb-edb/9.5/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/edb-edb/9.6/createProcedure.sql → ...pectedSql/edb-edb/9.6/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/edb-edb/9.6/createSequence.sql → ...xpectedSql/edb-edb/9.6/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/edb-edb/9.6/createTrigger.sql → ...expectedSql/edb-edb/9.6/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/edb-edb/addCheckConstraint.sql → ...xpectedSql/edb-edb/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...geLog/edb-edb/addForeignKeyConstraint.sql → ...edSql/edb-edb/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/edb-edb/column.sql → ...eChangelog/expectedSql/edb-edb/column.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/edb-edb/createFunction.sql → ...og/expectedSql/edb-edb/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/edb-edb/createIndex.sql → ...gelog/expectedSql/edb-edb/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/edb-edb/createPackage.sql → ...log/expectedSql/edb-edb/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/edb-edb/createPackageBody.sql → ...expectedSql/edb-edb/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/edb-edb/createProcedure.sql → ...g/expectedSql/edb-edb/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/edb-edb/createSequence.sql → ...og/expectedSql/edb-edb/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/edb-edb/createSynonym.sql → ...log/expectedSql/edb-edb/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/edb-edb/createTable.sql → ...gelog/expectedSql/edb-edb/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/edb-edb/createTrigger.sql → ...log/expectedSql/edb-edb/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/edb-edb/createView.sql → ...ngelog/expectedSql/edb-edb/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...log/expectedChangeLog/edb-edb/primary.sql → ...Changelog/expectedSql/edb-edb/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/edb-edb/unique.sql → ...eChangelog/expectedSql/edb-edb/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...eLog/firebird/addForeignKeyConstraint.sql → ...dSql/firebird/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/firebird/addUniqueConstraint.sql → ...ectedSql/firebird/addUniqueConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...log/expectedChangeLog/firebird/column.sql → ...Changelog/expectedSql/firebird/column.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/firebird/createIndex.sql → ...elog/expectedSql/firebird/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/firebird/createProcedure.sql → .../expectedSql/firebird/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/firebird/createSequence.sql → ...g/expectedSql/firebird/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/firebird/createTable.sql → ...elog/expectedSql/firebird/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/firebird/createView.sql → ...gelog/expectedSql/firebird/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...og/expectedChangeLog/firebird/primary.sql → ...hangelog/expectedSql/firebird/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/h2/addForeignKeyConstraint.sql → ...xpectedSql/h2/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/h2/addUniqueConstraint.sql → ...og/expectedSql/h2/addUniqueConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...Changelog/expectedChangeLog/h2/column.sql → ...nerateChangelog/expectedSql/h2/column.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/h2/createIndex.sql → ...eChangelog/expectedSql/h2/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/h2/createSequence.sql → ...angelog/expectedSql/h2/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/h2/createTable.sql → ...eChangelog/expectedSql/h2/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...gelog/expectedChangeLog/h2/createView.sql → ...teChangelog/expectedSql/h2/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...hangelog/expectedChangeLog/h2/primary.sql → ...erateChangelog/expectedSql/h2/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...ngeLog/hsqldb/addForeignKeyConstraint.sql → ...tedSql/hsqldb/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/hsqldb/addUniqueConstraint.sql → ...xpectedSql/hsqldb/addUniqueConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...gelog/expectedChangeLog/hsqldb/column.sql → ...teChangelog/expectedSql/hsqldb/column.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/hsqldb/createIndex.sql → ...ngelog/expectedSql/hsqldb/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/hsqldb/createProcedure.sql → ...og/expectedSql/hsqldb/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/hsqldb/createSequence.sql → ...log/expectedSql/hsqldb/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/hsqldb/createTable.sql → ...ngelog/expectedSql/hsqldb/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/hsqldb/createView.sql → ...angelog/expectedSql/hsqldb/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/hsqldb/primary.sql → ...eChangelog/expectedSql/hsqldb/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/mariadb/10.2/createFunction.sql → ...pectedSql/mariadb/10.2/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/mariadb/10.2/createSequence.sql → ...pectedSql/mariadb/10.2/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/mariadb/10.3/createFunction.sql → ...pectedSql/mariadb/10.3/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/mariadb/10.4/createFunction.sql → ...pectedSql/mariadb/10.4/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/mariadb/addCheckConstraint.sql → ...xpectedSql/mariadb/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...geLog/mariadb/addForeignKeyConstraint.sql → ...edSql/mariadb/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...geLog/mariadb/aws_10.6/createFunction.sql → ...edSql/mariadb/aws_10.6/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/mariadb/column.sql → ...eChangelog/expectedSql/mariadb/column.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/mariadb/createFunction.sql → ...og/expectedSql/mariadb/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mariadb/createIndex.sql → ...gelog/expectedSql/mariadb/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/mariadb/createPackage.sql → ...log/expectedSql/mariadb/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/mariadb/createPackageBody.sql → ...expectedSql/mariadb/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/mariadb/createProcedure.sql → ...g/expectedSql/mariadb/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/mariadb/createSequence.sql → ...og/expectedSql/mariadb/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/mariadb/createSynonym.sql → ...log/expectedSql/mariadb/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mariadb/createTable.sql → ...gelog/expectedSql/mariadb/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/mariadb/createTrigger.sql → ...log/expectedSql/mariadb/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/mariadb/createView.sql → ...ngelog/expectedSql/mariadb/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...log/expectedChangeLog/mariadb/primary.sql → ...Changelog/expectedSql/mariadb/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/mariadb/unique.sql → ...eChangelog/expectedSql/mariadb/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/mssql/addCheckConstraint.sql → .../expectedSql/mssql/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/mssql/addForeignKeyConstraint.sql → ...ctedSql/mssql/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ngelog/expectedChangeLog/mssql/column.sql → ...ateChangelog/expectedSql/mssql/column.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/mssql/createFunction.sql → ...elog/expectedSql/mssql/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/mssql/createIndex.sql → ...angelog/expectedSql/mssql/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mssql/createPackage.sql → ...gelog/expectedSql/mssql/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/mssql/createPackageBody.sql → ...g/expectedSql/mssql/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/mssql/createProcedure.sql → ...log/expectedSql/mssql/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/mssql/createSequence.sql → ...elog/expectedSql/mssql/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mssql/createSynonym.sql → ...gelog/expectedSql/mssql/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/mssql/createTable.sql → ...angelog/expectedSql/mssql/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mssql/createTrigger.sql → ...gelog/expectedSql/mssql/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...og/expectedChangeLog/mssql/createView.sql → ...hangelog/expectedSql/mssql/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...gelog/expectedChangeLog/mssql/primary.sql → ...teChangelog/expectedSql/mssql/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...ngelog/expectedChangeLog/mssql/unique.sql → ...ateChangelog/expectedSql/mssql/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/mysql/5.6/primary.sql → ...angelog/expectedSql/mysql/5.6/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/mysql/8/addCheckConstraint.sql → ...xpectedSql/mysql/8/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/mysql/8/createFunction.sql → ...og/expectedSql/mysql/8/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/mysql/addCheckConstraint.sql → .../expectedSql/mysql/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/mysql/addForeignKeyConstraint.sql → ...ctedSql/mysql/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...geLog/mysql/aurora/addCheckConstraint.sql → ...edSql/mysql/aurora/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/mysql/aurora/createFunction.sql → ...pectedSql/mysql/aurora/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/mysql/aws/addCheckConstraint.sql → ...ectedSql/mysql/aws/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/mysql/aws/createFunction.sql → .../expectedSql/mysql/aws/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...ngeLog/mysql/azure/addCheckConstraint.sql → ...tedSql/mysql/azure/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/mysql/azure/createFunction.sql → ...xpectedSql/mysql/azure/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/mysql/azure/createProcedure.sql → ...pectedSql/mysql/azure/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...ngelog/expectedChangeLog/mysql/column.sql → ...ateChangelog/expectedSql/mysql/column.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/mysql/createFunction.sql → ...elog/expectedSql/mysql/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/mysql/createIndex.sql → ...angelog/expectedSql/mysql/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mysql/createPackage.sql → ...gelog/expectedSql/mysql/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/mysql/createPackageBody.sql → ...g/expectedSql/mysql/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/mysql/createProcedure.sql → ...log/expectedSql/mysql/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/mysql/createSequence.sql → ...elog/expectedSql/mysql/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mysql/createSynonym.sql → ...gelog/expectedSql/mysql/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/mysql/createTable.sql → ...angelog/expectedSql/mysql/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...expectedChangeLog/mysql/createTrigger.sql → ...gelog/expectedSql/mysql/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...og/expectedChangeLog/mysql/createView.sql → ...hangelog/expectedSql/mysql/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/mysql/gcp/addCheckConstraint.sql → ...ectedSql/mysql/gcp/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/mysql/gcp/createFunction.sql → .../expectedSql/mysql/gcp/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...gelog/expectedChangeLog/mysql/primary.sql → ...teChangelog/expectedSql/mysql/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...ngelog/expectedChangeLog/mysql/unique.sql → ...ateChangelog/expectedSql/mysql/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/oracle/addCheckConstraint.sql → ...expectedSql/oracle/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ngeLog/oracle/addForeignKeyConstraint.sql → ...tedSql/oracle/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/oracle/addUniqueConstraint.sql → ...xpectedSql/oracle/addUniqueConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...gelog/expectedChangeLog/oracle/column.sql → ...teChangelog/expectedSql/oracle/column.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/oracle/createFunction.sql → ...log/expectedSql/oracle/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/oracle/createIndex.sql → ...ngelog/expectedSql/oracle/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/oracle/createPackage.sql → ...elog/expectedSql/oracle/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/oracle/createPackageBody.sql → .../expectedSql/oracle/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/oracle/createProcedure.sql → ...og/expectedSql/oracle/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/oracle/createSequence.sql → ...log/expectedSql/oracle/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/oracle/createSynonym.sql → ...elog/expectedSql/oracle/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/oracle/createTable.sql → ...ngelog/expectedSql/oracle/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...xpectedChangeLog/oracle/createTrigger.sql → ...elog/expectedSql/oracle/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/oracle/createView.sql → ...angelog/expectedSql/oracle/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...elog/expectedChangeLog/oracle/primary.sql → ...eChangelog/expectedSql/oracle/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...xtradb-cluster/5.7/addCheckConstraint.sql → ...xtradb-cluster/5.7/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ona-xtradb-cluster/5.7/createFunction.sql → ...ona-xtradb-cluster/5.7/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...ona-xtradb-cluster/addCheckConstraint.sql → ...ona-xtradb-cluster/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...tradb-cluster/addForeignKeyConstraint.sql → ...tradb-cluster/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/percona-xtradb-cluster/column.sql → ...ctedSql/percona-xtradb-cluster/column.sql
View file
Open in desktop
File renamed without changes.
0 ...percona-xtradb-cluster/createFunction.sql → ...percona-xtradb-cluster/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...og/percona-xtradb-cluster/createIndex.sql → ...ql/percona-xtradb-cluster/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 .../percona-xtradb-cluster/createPackage.sql → .../percona-xtradb-cluster/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...cona-xtradb-cluster/createPackageBody.sql → ...cona-xtradb-cluster/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...ercona-xtradb-cluster/createProcedure.sql → ...ercona-xtradb-cluster/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...percona-xtradb-cluster/createSequence.sql → ...percona-xtradb-cluster/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 .../percona-xtradb-cluster/createSynonym.sql → .../percona-xtradb-cluster/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...og/percona-xtradb-cluster/createTable.sql → ...ql/percona-xtradb-cluster/createTable.sql
View file
Open in desktop
File renamed without changes.
0 .../percona-xtradb-cluster/createTrigger.sql → .../percona-xtradb-cluster/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...Log/percona-xtradb-cluster/createView.sql → ...Sql/percona-xtradb-cluster/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...ngeLog/percona-xtradb-cluster/primary.sql → ...tedSql/percona-xtradb-cluster/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/percona-xtradb-cluster/unique.sql → ...ctedSql/percona-xtradb-cluster/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/postgresql/10/createProcedure.sql → ...ctedSql/postgresql/10/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/postgresql/10/createTrigger.sql → ...pectedSql/postgresql/10/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/postgresql/11/createTrigger.sql → ...pectedSql/postgresql/11/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...ngeLog/postgresql/9.5/createProcedure.sql → ...tedSql/postgresql/9.5/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/postgresql/9.5/createSequence.sql → ...ctedSql/postgresql/9.5/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/postgresql/9.5/createTrigger.sql → ...ectedSql/postgresql/9.5/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/postgresql/9/createProcedure.sql → ...ectedSql/postgresql/9/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/postgresql/9/createSequence.sql → ...pectedSql/postgresql/9/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/postgresql/9/createTrigger.sql → ...xpectedSql/postgresql/9/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...angeLog/postgresql/addCheckConstraint.sql → ...ctedSql/postgresql/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...og/postgresql/addForeignKeyConstraint.sql → ...ql/postgresql/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...g/postgresql/azure/addCheckConstraint.sql → ...l/postgresql/azure/addCheckConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...tgresql/azure/addForeignKeyConstraint.sql → ...tgresql/azure/addForeignKeyConstraint.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/postgresql/azure/column.sql → ...g/expectedSql/postgresql/azure/column.sql
View file
Open in desktop
File renamed without changes.
0 ...geLog/postgresql/azure/createFunction.sql → ...edSql/postgresql/azure/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/postgresql/azure/createIndex.sql → ...ectedSql/postgresql/azure/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...eLog/postgresql/azure/createProcedure.sql → ...dSql/postgresql/azure/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...geLog/postgresql/azure/createSequence.sql → ...edSql/postgresql/azure/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/postgresql/azure/createTable.sql → ...ectedSql/postgresql/azure/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...ngeLog/postgresql/azure/createTrigger.sql → ...tedSql/postgresql/azure/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...ChangeLog/postgresql/azure/createView.sql → ...pectedSql/postgresql/azure/createView.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/postgresql/azure/primary.sql → .../expectedSql/postgresql/azure/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...ctedChangeLog/postgresql/azure/unique.sql → ...g/expectedSql/postgresql/azure/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/postgresql/column.sql → ...angelog/expectedSql/postgresql/column.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/postgresql/createFunction.sql → ...expectedSql/postgresql/createFunction.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/postgresql/createIndex.sql → ...og/expectedSql/postgresql/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/postgresql/createPackage.sql → .../expectedSql/postgresql/createPackage.sql
View file
Open in desktop
File renamed without changes.
0 ...hangeLog/postgresql/createPackageBody.sql → ...ectedSql/postgresql/createPackageBody.sql
View file
Open in desktop
File renamed without changes.
0 ...dChangeLog/postgresql/createProcedure.sql → ...xpectedSql/postgresql/createProcedure.sql
View file
Open in desktop
File renamed without changes.
0 ...edChangeLog/postgresql/createSequence.sql → ...expectedSql/postgresql/createSequence.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/postgresql/createSynonym.sql → .../expectedSql/postgresql/createSynonym.sql
View file
Open in desktop
File renamed without changes.
0 ...ectedChangeLog/postgresql/createTable.sql → ...og/expectedSql/postgresql/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...tedChangeLog/postgresql/createTrigger.sql → .../expectedSql/postgresql/createTrigger.sql
View file
Open in desktop
File renamed without changes.
0 ...pectedChangeLog/postgresql/createView.sql → ...log/expectedSql/postgresql/createView.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/postgresql/primary.sql → ...ngelog/expectedSql/postgresql/primary.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/postgresql/unique.sql → ...angelog/expectedSql/postgresql/unique.sql
View file
Open in desktop
File renamed without changes.
0 ...gelog/expectedChangeLog/sqlite/column.sql → ...teChangelog/expectedSql/sqlite/column.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/sqlite/createIndex.sql → ...ngelog/expectedSql/sqlite/createIndex.sql
View file
Open in desktop
File renamed without changes.
0 .../expectedChangeLog/sqlite/createTable.sql → ...ngelog/expectedSql/sqlite/createTable.sql
View file
Open in desktop
File renamed without changes.
0 ...g/expectedChangeLog/sqlite/createView.sql → ...angelog/expectedSql/sqlite/createView.sql
View file
Open in desktop
File renamed without changes.
1 change: 1 addition & 0 deletions ...esources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/20.2/primary.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table (id BIGINT NOT NULL, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT "primary" PRIMARY KEY (id));
1 change: 1 addition & 0 deletions ...resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/22.1/column.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table (test_column BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, "varcharColumn" VARCHAR(25), "intColumn" BIGINT, "dateColumn" date, CONSTRAINT test_table_pkey PRIMARY KEY (rowid));
3 changes: 3 additions & 0 deletions ...rces/liquibase/harness/generateChangelog/verificationSql/cockroachdb/22.1/createIndex.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
CREATE TABLE test_table (id BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT test_table_pkey PRIMARY KEY (rowid));

CREATE INDEX idx_first_name ON test_table(id);
1 change: 1 addition & 0 deletions ...rces/liquibase/harness/generateChangelog/verificationSql/cockroachdb/22.1/createTable.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table_xml (test_column BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT test_table_xml_pkey PRIMARY KEY (rowid));
3 changes: 3 additions & 0 deletions ...resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/22.1/unique.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
CREATE TABLE test_table (id BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT test_table_pkey PRIMARY KEY (rowid));

ALTER TABLE test_table ADD CONSTRAINT test_unique_constraint UNIQUE (id);
1 change: 1 addition & 0 deletions ...es/liquibase/harness/generateChangelog/verificationSql/cockroachdb/addCheckConstraint.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
ALTER TABLE posts ADD CONSTRAINT test_check_constraint CHECK (((id > 0)));
7 changes: 7 additions & 0 deletions ...quibase/harness/generateChangelog/verificationSql/cockroachdb/addForeignKeyConstraint.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,7 @@
CREATE TABLE test_table_base (id BIGINT NOT NULL, CONSTRAINT test_table_base_pkey PRIMARY KEY (id));

CREATE TABLE test_table_reference (id BIGINT NOT NULL, test_column BIGINT NOT NULL, CONSTRAINT test_table_reference_pkey PRIMARY KEY (id));

ALTER TABLE test_table_reference ADD CONSTRAINT test_table_reference_test_column_key UNIQUE (test_column);

ALTER TABLE test_table_base ADD CONSTRAINT test_fk FOREIGN KEY (id) REFERENCES test_table_reference (test_column) ON UPDATE RESTRICT ON DELETE CASCADE;
1 change: 1 addition & 0 deletions ...main/resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/column.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table (test_column BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, "varcharColumn" VARCHAR(25), "intColumn" BIGINT, "dateColumn" date, CONSTRAINT "primary" PRIMARY KEY (rowid));
3 changes: 3 additions & 0 deletions ...resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/createIndex.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
CREATE TABLE test_table (id BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT "primary" PRIMARY KEY (rowid));

CREATE INDEX idx_first_name ON test_table(id);
1 change: 1 addition & 0 deletions ...ources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/createSequence.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE SEQUENCE IF NOT EXISTS test_sequence START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1;
1 change: 1 addition & 0 deletions ...resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/createTable.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table_xml (test_column BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT "primary" PRIMARY KEY (rowid));
1 change: 1 addition & 0 deletions .../resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/createView.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE VIEW test_view AS SELECT id, first_name, last_name, email FROM lbcat.authors;
1 change: 1 addition & 0 deletions ...ain/resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/primary.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table (id BIGINT NOT NULL, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT test_pk PRIMARY KEY (id));
3 changes: 3 additions & 0 deletions ...main/resources/liquibase/harness/generateChangelog/verificationSql/cockroachdb/unique.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
CREATE TABLE test_table (id BIGINT, rowid BIGINT DEFAULT unique_rowid() NOT NULL, CONSTRAINT "primary" PRIMARY KEY (rowid));

ALTER TABLE test_table ADD CONSTRAINT test_unique_constraint UNIQUE (id);
3 changes: 3 additions & 0 deletions ...main/resources/liquibase/harness/generateChangelog/verificationSql/db2-luw/createView.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
CREATE TABLE TEST_TABLE (ID INTEGER NOT NULL, CONSTRAINT PK_TEST_TABLE PRIMARY KEY (ID));

CREATE VIEW test_view AS select id from test_table;
11 changes: 11 additions & 0 deletions ...esources/liquibase/harness/generateChangelog/verificationSql/edb-edb/10/createTrigger.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,11 @@
CREATE OR REPLACE FUNCTION test_function()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE 'Test trigger function created';
RETURN NEW;
END;
$function$;

CREATE TRIGGER test_trigger BEFORE INSERT ON posts FOR EACH ROW EXECUTE PROCEDURE test_function();
11 changes: 11 additions & 0 deletions ...esources/liquibase/harness/generateChangelog/verificationSql/edb-edb/11/createTrigger.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,11 @@
CREATE OR REPLACE FUNCTION test_function()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE 'Test trigger function created';
RETURN NEW;
END;
$function$;

CREATE TRIGGER test_trigger BEFORE INSERT ON posts FOR EACH ROW EXECUTE PROCEDURE test_function();
1 change: 1 addition & 0 deletions ...ources/liquibase/harness/generateChangelog/verificationSql/edb-edb/9.5/createSequence.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE SEQUENCE IF NOT EXISTS test_sequence;
11 changes: 11 additions & 0 deletions ...sources/liquibase/harness/generateChangelog/verificationSql/edb-edb/9.5/createTrigger.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,11 @@
CREATE OR REPLACE FUNCTION test_function()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE 'Test trigger function created';
RETURN NEW;
END;
$function$;

CREATE TRIGGER test_trigger BEFORE INSERT ON posts FOR EACH ROW EXECUTE PROCEDURE test_function();
1 change: 1 addition & 0 deletions ...ources/liquibase/harness/generateChangelog/verificationSql/edb-edb/9.6/createSequence.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE SEQUENCE IF NOT EXISTS test_sequence;
11 changes: 11 additions & 0 deletions ...sources/liquibase/harness/generateChangelog/verificationSql/edb-edb/9.6/createTrigger.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,11 @@
CREATE OR REPLACE FUNCTION test_function()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE 'Test trigger function created';
RETURN NEW;
END;
$function$;

CREATE TRIGGER test_trigger BEFORE INSERT ON posts FOR EACH ROW EXECUTE PROCEDURE test_function();
1 change: 1 addition & 0 deletions ...ources/liquibase/harness/generateChangelog/verificationSql/edb-edb/addCheckConstraint.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
ALTER TABLE posts ADD CONSTRAINT test_check_constraint CHECK (((id > 0)));
7 changes: 7 additions & 0 deletions ...s/liquibase/harness/generateChangelog/verificationSql/edb-edb/addForeignKeyConstraint.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,7 @@
CREATE TABLE test_table_reference (id INTEGER NOT NULL, test_column INTEGER NOT NULL, CONSTRAINT test_table_reference_pkey PRIMARY KEY (id));

ALTER TABLE test_table_reference ADD CONSTRAINT test_table_reference_test_column_key UNIQUE (test_column);

CREATE TABLE test_table_base (id INTEGER NOT NULL, CONSTRAINT test_table_base_pkey PRIMARY KEY (id));

ALTER TABLE test_table_base ADD CONSTRAINT test_fk FOREIGN KEY (id) REFERENCES test_table_reference (test_column) ON UPDATE RESTRICT ON DELETE CASCADE;
1 change: 1 addition & 0 deletions src/main/resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/column.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table (test_column INTEGER, "varcharColumn" VARCHAR(25), "intColumn" INTEGER, "dateColumn" TIMESTAMP WITHOUT TIME ZONE);
9 changes: 9 additions & 0 deletions .../resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createFunction.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,9 @@
CREATE OR REPLACE FUNCTION test_function()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE 'Test function created';
RETURN NEW;
END;
$function$;
3 changes: 3 additions & 0 deletions ...ain/resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createIndex.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
CREATE TABLE test_table (id INTEGER);

CREATE INDEX idx_first_name ON test_table(id);
3 changes: 3 additions & 0 deletions ...n/resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createPackage.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
CREATE OR REPLACE PACKAGE test_package IS
PROCEDURE test_procedure();
END;
10 changes: 10 additions & 0 deletions ...sources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createPackageBody.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,10 @@
CREATE OR REPLACE PACKAGE test_package IS
PROCEDURE test_procedure();
END;

CREATE OR REPLACE PACKAGE BODY test_package IS
PROCEDURE test_procedure() IS
BEGIN
DELETE FROM posts WHERE author_id = '15';
END;
END
7 changes: 7 additions & 0 deletions ...resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createProcedure.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,7 @@
CREATE OR REPLACE PROCEDURE test_procedure()
SECURITY DEFINER
AS $procedure$
BEGIN
END;
$procedure$
LANGUAGE edbspl;
1 change: 1 addition & 0 deletions .../resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createSequence.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE SEQUENCE IF NOT EXISTS test_sequence AS integer START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;
1 change: 1 addition & 0 deletions ...n/resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createSynonym.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE PUBLIC SYNONYM TEST_SYNONYM FOR AUTHORS;
1 change: 1 addition & 0 deletions ...ain/resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createTable.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1 @@
CREATE TABLE test_table_xml (test_column INTEGER);
11 changes: 11 additions & 0 deletions ...n/resources/liquibase/harness/generateChangelog/verificationSql/edb-edb/createTrigger.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,11 @@
CREATE OR REPLACE FUNCTION test_function()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE 'Test trigger function created';
RETURN NEW;
END;
$function$;

CREATE TRIGGER test_trigger BEFORE INSERT ON posts FOR EACH ROW EXECUTE FUNCTION test_function();
Loading