search

croc-code / sql-boot

Advanced REST-wrapper for your SQL-queries (actually not only SQL)
BSD 3-Clause "New" or "Revised" License
59 stars 4 forks source link

PSTGRSCROC-135 #427

Closed mgramin closed 4 years ago

mgramin commented 4 years ago

@rultor merge

rultor commented 4 years ago

@rultor merge

@mgramin OK, I'll try to merge now. You can check the progress of the merge here

rultor commented 4 years ago

@rultor merge

@mgramin Oops, I failed. You can see the full log here (spent 5min)

18:58:16.405 [SpringContextShutdownHook] DEBUG org.springframework.jdbc.datasource.SimpleDriverDataSource - Creating new JDBC Driver Connection to [jdbc:h2:mem:dataSource;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false]
18:58:16.406 [SpringContextShutdownHook] INFO org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseFactory - Shutting down embedded database: url='jdbc:h2:mem:dataSource;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false'
18:58:16.406 [SpringContextShutdownHook] DEBUG org.springframework.jdbc.datasource.SimpleDriverDataSource - Creating new JDBC Driver Connection to [jdbc:h2:mem:dataSource;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false]
18:58:16.410 [SpringContextShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Shutdown initiated...
18:58:16.411 [SpringContextShutdownHook] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Before shutdown stats (total=10, active=0, idle=10, waiting=0)
18:58:16.411 [SpringContextShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown initiated...
18:58:16.412 [SpringContextShutdownHook] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Before shutdown stats (total=10, active=0, idle=10, waiting=0)
18:58:16.414 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn10: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.414 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn0: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.414 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn11: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.414 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn1: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.415 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn2: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.415 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn12: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.415 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn13: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.415 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn3: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.416 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn4: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.416 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn14: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.416 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn5: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.416 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn6: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.417 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn15: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.417 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn7: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.418 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn16: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.424 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn8: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.424 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn17: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.424 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection conn9: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.424 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn18: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.424 [HikariPool-2 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-2 - Closing connection conn19: url=jdbc:h2:mem:testdb user=SA: (connection evicted)
18:58:16.425 [SpringContextShutdownHook] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After shutdown stats (total=0, active=0, idle=0, waiting=0)
18:58:16.428 [SpringContextShutdownHook] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - After shutdown stats (total=0, active=0, idle=0, waiting=0)
18:58:16.428 [SpringContextShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed.
18:58:16.428 [SpringContextShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Shutdown completed.
[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Failures: 
[ERROR]   MetadataTest.properties:47 expected: <{description=foo, key_1=value_1, key=name, visible=true}> but was: <{description=foo, key_1=value_1, visible=true}>
[ERROR]   MetadataTest.toJson:61 expected: <{"description":"foo","key_1":"value_1","visible":true,"key":"name","name":"name","type":"String","value":"name","text":"name"}> but was: <{"description":"foo","key_1":"value_1","visible":true,"name":"name","type":"String","value":"name","text":"name"}>
[INFO] 
[ERROR] Tests run: 181, Failures: 2, Errors: 0, Skipped: 0
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 01:04 min
[INFO] Finished at: 2019-11-25T18:58:18+00:00
[INFO] Final Memory: 78M/534M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test (default-test) on project sql-boot: 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 ce0fb727c27572eaf70059e36deed36f07ebad0c22c41a1987e9ff87b860b205 is dead
Mon Nov 25 19:58:25 CET 2019
codecov-io commented 4 years ago

Codecov Report

Merging #427 into master will decrease coverage by 2.01%. The diff coverage is 70.83%.

Impacted file tree graph

@@             Coverage Diff              @@
##             master     #427      +/-   ##
============================================
- Coverage     74.95%   72.94%   -2.02%     
+ Complexity      214      212       -2     
============================================
  Files            42       45       +3     
  Lines           623      632       +9     
  Branches         62       61       -1     
============================================
- Hits            467      461       -6     
- Misses          111      126      +15     
  Partials         45       45
Impacted Files Coverage Δ Complexity Δ
...ub/mgramin/sqlboot/model/connection/RestWrapper.kt 10% <100%> (ø) 1 <1> (?)
...min/sqlboot/model/resource/wrappers/RestWrapper.kt 71.42% <100%> (ø) 5 <1> (?)
...amin/sqlboot/model/resourcetypelist/RestWrapper.kt 7.14% <16.66%> (ø) 1 <1> (?)
...hub/mgramin/sqlboot/model/resourcetype/Metadata.kt 84.61% <50%> (+0.24%) 9 <0> (-1) :arrow_down:
...t/model/resourcetype/ResourceTypeJsonSerializer.kt 50% <50%> (ø) 1 <1> (?)
...odel/resourcetype/wrappers/ParallelResourceType.kt 60% <60%> (ø) 5 <5> (?)
.../model/resourcetypelist/impl/FsResourceTypeList.kt 88% <88%> (ø) 3 <3> (?)
... and 1 more

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update c71797a...0c0a9b2. Read the comment docs.

mgramin commented 4 years ago

@rultor merge

rultor commented 4 years ago

@rultor merge

@mgramin OK, I'll try to merge now. You can check the progress of the merge here

rultor commented 4 years ago

@rultor merge

@mgramin Oops, I failed. You can see the full log here (spent 6min)

     , registration_date /* Registration date */
  from (select name  as n
             , email as mail
             , registration_date
          from main_schema.users)) q
 order by n desc, mail asc
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.025 s - in com.github.mgramin.sqlboot.sql.select.wrappers.OrderedSelectQueryTest
[INFO] Running com.github.mgramin.sqlboot.sql.select.wrappers.GrafanaSelectQueryTest
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 s - in com.github.mgramin.sqlboot.sql.select.wrappers.GrafanaSelectQueryTest
[INFO] Running com.github.mgramin.sqlboot.sql.select.wrappers.ExecutableSelectQueryTest
2019-12-03 21:00:38.442  INFO 169 --- [           main] o.s.t.c.s.DefaultTestContextBootstrapper : Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener, org.springframework.test.context.event.EventPublishingTestExecutionListener]
2019-12-03 21:00:38.442  INFO 169 --- [           main] o.s.t.c.s.DefaultTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@171c0e89, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@2e253ac6, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@7ae8f346, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@7972606c, org.springframework.test.context.support.DirtiesContextTestExecutionListener@eed418d, org.springframework.test.context.transaction.TransactionalTestExecutionListener@999a99c, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@3456192a, org.springframework.test.context.event.EventPublishingTestExecutionListener@5ecd7ecc, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@3ac8bdb1, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@7ed9363d, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@7a42ef85, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@4f4cc51f, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@3096dc72]
2019-12-03 21:00:38.453  INFO 169 --- [           main] c.g.m.s.s.s.w.ExecutableSelectQuery      : 
select n                 /* First name */
     , mail              /* Personal email */
     , registration_date /* Registration date */
  from (select name  as n
             , email as mail
             , registration_date
          from main_schema.users)
2019-12-03 21:00:38.454  INFO 169 --- [     parallel-3] c.g.m.s.s.s.w.ExecutableSelectQuery      : Thread[parallel-3,5,main]
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.029 s - in com.github.mgramin.sqlboot.sql.select.wrappers.ExecutableSelectQueryTest
[INFO] Running com.github.mgramin.sqlboot.sql.select.wrappers.TemplatedSelectQueryTest
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 s - in com.github.mgramin.sqlboot.sql.select.wrappers.TemplatedSelectQueryTest
2019-12-03 21:00:38.508  INFO 169 --- [extShutdownHook] o.s.j.d.e.EmbeddedDatabaseFactory        : Shutting down embedded database: url='jdbc:h2:mem:dataSource;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false'
2019-12-03 21:00:38.616  INFO 169 --- [extShutdownHook] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
2019-12-03 21:00:38.617  INFO 169 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-3 - Shutdown initiated...
2019-12-03 21:00:38.620  INFO 169 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown initiated...
2019-12-03 21:00:38.620  INFO 169 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2019-12-03 21:00:38.643  INFO 169 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
2019-12-03 21:00:38.643  INFO 169 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-3 - Shutdown completed.
2019-12-03 21:00:38.644  INFO 169 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown completed.
[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Errors: 
[ERROR]   ResourceTypeJsonSerializerTest.serialize:23 ? JsonGeneration No native support...
[INFO] 
[ERROR] Tests run: 169, Failures: 0, Errors: 1, Skipped: 0
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 01:05 min
[INFO] Finished at: 2019-12-03T21:00:39+00:00
[INFO] Final Memory: 111M/653M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test (default-test) on project sql-boot: 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 cce711ca2ca5b4d0258cf2ae9ceeb4d289d0a56cbf49ef27278f43cb89f258bf is dead
Tue Dec  3 22:01:16 CET 2019
mgramin commented 4 years ago

@rultor merge

rultor commented 4 years ago

@rultor merge

@mgramin OK, I'll try to merge now. You can check the progress of the merge here

rultor commented 4 years ago

@rultor merge

@mgramin Done! FYI, the full log is here (took me 6min)