Test DBGit with procedures, views and UDT's

[rocket-3]

dvdrental and pagilla databases contains procedures, views and UDT's that can be created in schema by teams during development.
Adding such types in test cases is really important for DBGit to become a production-ready tool.

[rocket-3]

Now need to finish issue #7 to proceed

[rocket-3]

OK, custom types are implemented, we can proceed now

[rocket-3]

@rultor deploy, tests=*IntegrationTest*#*CustomTypes*

[rultor]

@rultor deploy, tests=*IntegrationTest*#*CustomTypes*

@rocket-3 OK, I'll try to deploy now. You can check the progress here

[rultor]

@rultor deploy, tests=*IntegrationTest*#*CustomTypes*

@rocket-3 Oops, I failed. You can see the full log here (spent 4min)

|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
|   	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
|   	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
|   	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)
|   	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
|   	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
|   	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
|   	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
|   	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
|   	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
|   	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
|   	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:220)
|   	at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$6(DefaultLauncher.java:188)
|   	at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:202)
|   	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:181)
|   	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:128)
|   	at org.apache.maven.surefire.junitplatform.JUnitPlatformProvider.invokeAllTests(JUnitPlatformProvider.java:150)
|   	at org.apache.maven.surefire.junitplatform.JUnitPlatformProvider.invoke(JUnitPlatformProvider.java:124)
|   	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
|   	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
|   	at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
|   	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 142.01 s <<< FAILURE! - in ru.fusionsoft.dbgit.integration.DbGitIntegrationTestBasic
[ERROR] dbToDbRestoreWorksWithCustomTypes  Time elapsed: 142.001 s  <<< FAILURE!
org.opentest4j.AssertionFailedError: expected: <true> but was: <false>
	at ru.fusionsoft.dbgit.integration.DbGitIntegrationTestBasic.dbToDbRestoreWorksWithCustomTypes(DbGitIntegrationTestBasic.java:358)

[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Failures: 
[ERROR]   DbGitIntegrationTestBasic.dbToDbRestoreWorksWithCustomTypes:358 expected: <true> but was: <false>
[INFO] 
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  02:25 min
[INFO] Finished at: 2021-06-11T03:13:40Z
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test (default-test) on project dbgit: There are test failures.
[ERROR] 
[ERROR] Please refer to /home/r/repo/target/surefire-reports for the individual test results.
[ERROR] Please refer to dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
container 2776c3faa33e596bacc331f631a160fc56948b699962e42d3ef9b667c4473291 is dead
Fri Jun 11 05:14:36 CEST 2021

[rocket-3]

Seems like types are OK and a some restore order problem here
Restore of Sakilla schema (dvdrental and 'pagilla' databases) is the current step on Production-ready milestone.

[rocket-3]

See issue #15 and corresponding PR #16 next