Skip to content

Instantly share code, notes, and snippets.

@tpolecat
Created January 7, 2014 02:26
Show Gist options
  • Save tpolecat/8293765 to your computer and use it in GitHub Desktop.
Save tpolecat/8293765 to your computer and use it in GitHub Desktop.
> runMain doobie.hi.Test
[info] Compiling 37 Scala sources to /Users/rnorris/Scala/doobie/target/scala-2.10/classes...
[info] Running doobie.hi.Test
The answer was: java.lang.RuntimeException: Bogus country: NCL
nyQL log for hi.examples
+- [ok] getConnection(jdbc:h2:mem:test;DB_CLOSE_DELAY=-1, sa, ***) | conn1: url=jdbc:h2:mem:test us 304.109 ms
`- [ex] database session | Bogus country: NCL 1496.911 ms
+- [ok] populate database from /Users/rnorris/Scala/doobie/world.sql | false 1378.663 ms
| +- [ok] prepareStatement(RUNSCRIPT FROM ? CHARSET 'UTF-8') | prep1: RUNSCRIPT FROM ? CHARSE 3.950 ms
| `- [ok] process preparedstatement | false 1363.693 ms
| +- [ok] structured set at index 1: world.sql | () 0.649 ms
| | `- [ok] setString(1, world.sql) | () 0.210 ms
| +- [ok] execute | false 1358.934 ms
| `- [ok] ps.close | () 1.313 ms
+- [ex] find countries where more than 30.0% of population speak Fre | Bogus country: NCL 76.905 ms
| +- [ok] prepareStatement(/ SELECT C.CODE, C.NAME, C.POPULATI | prep2: / SELECT C.CODE, C 4.138 ms
| `- [ex] process preparedstatement | Bogus country: NCL 71.526 ms
| +- [ok] structured set at index 1: (French,30.0) | () 11.213 ms
| | +- [ok] setString(1, French) | () 0.305 ms
| | `- [ok] setDouble(2, 30.0) | () 0.732 ms
| +- [ok] executeQuery | rs11: org.h2.result.LocalResul 11.508 ms
| +- [ex] process resultset | Bogus country: NCL 40.234 ms
| | +- [ok] next | true 0.353 ms
| | +- [ok] structured get at index 1 | Country(BEL,Belgium,10239000) 7.863 ms
| | | +- [ok] getString(1) | BEL 0.461 ms
| | | +- [ok] getString(2) | Belgium 0.234 ms
| | | `- [ok] getInt(3) | 10239000 0.256 ms
| | +- [ok] next | true 0.168 ms
| | +- [ok] structured get at index 1 | Country(FRA,France,59225700) 1.734 ms
| | | +- [ok] getString(1) | FRA 0.153 ms
| | | +- [ok] getString(2) | France 0.160 ms
| | | `- [ok] getInt(3) | 59225700 0.163 ms
| | +- [ok] next | true 0.285 ms
| | +- [ok] structured get at index 1 | Country(MCO,Monaco,34000) 2.669 ms
| | | +- [ok] getString(1) | MCO 0.254 ms
| | | +- [ok] getString(2) | Monaco 0.256 ms
| | | `- [ok] getInt(3) | 34000 0.223 ms
| | +- [ok] next | true 0.240 ms
| | +- [ex] structured get at index 1 | Bogus country: NCL 3.816 ms
| | | +- [ok] getString(1) | NCL 0.219 ms
| | | +- [ok] getString(2) | New Caledonia 0.194 ms
| | | `- [ok] getInt(3) | 214000 0.200 ms
| | `- [ok] rs.close | () 0.338 ms
| `- [ok] ps.close | () 0.164 ms
`- [ok] conn.close | () 0.231 ms
[success] Total time: 56 s, completed Jan 6, 2014 5:05:38 PM
>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment