✘ adamj@Harvester-LINUX  ~/Development/Personal/Scala/span-digital-exercise   master  sbt "run --db-uri jdbc:mysql://localhost:3306/spandigitalexercise?user=adamj&password=password"
[info] Loading settings from idea.sbt ...
[info] Loading global plugins from /home/adamj/.sbt/1.0/plugins
[info] Loading settings from plugins.sbt,assembly.sbt ...
[info] Loading project definition from /rhome/adamj/Development/Personal/Scala/span-digital-exercise/project
[info] Loading settings from build.sbt ...
[info] Set current project to span-digital-exercise (in build file:/rhome/adamj/Development/Personal/Scala/span-digital-exercise/)
[info] Compiling 1 Scala source to /rhome/adamj/Development/Personal/Scala/span-digital-exercise/target/scala-2.12/classes ...
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:35:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.
[info]     context.run(query[Teams].filter(_.name == lift(name))) match {
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:35:16: Dynamic query
[info]     context.run(query[Teams].filter(_.name == lift(name))) match {
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:49:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.
[info]     context.run(query[Teams].sortBy(_.id)(Ord.ascNullsLast))
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:49:16: Dynamic query
[info]     context.run(query[Teams].sortBy(_.id)(Ord.ascNullsLast))
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:59:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.
[info]     context.run(query[Teams].insert(_.name -> lift(name)).returning(_.id))
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:59:16: Dynamic query
[info]     context.run(query[Teams].insert(_.name -> lift(name)).returning(_.id))
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:68:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.
[info]     context.run(query[Results].sortBy(_.id)(Ord.ascNullsLast))
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:68:16: Dynamic query
[info]     context.run(query[Results].sortBy(_.id)(Ord.ascNullsLast))
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:80:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.
[info]     context.run(
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:80:16: Dynamic query
[info]     context.run(
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:221:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.
[info]     context.run(teamNameTotalPointsQuery.sortBy(_._2)(Ord.descNullsLast))
[info]                ^
[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:221:16: Dynamic query
[info]     context.run(teamNameTotalPointsQuery.sortBy(_._2)(Ord.descNullsLast))
[info]                ^
[info] Done compiling.
[info] Packaging /rhome/adamj/Development/Personal/Scala/span-digital-exercise/target/scala-2.12/span-digital-exercise_2.12-1.0.jar ...
[info] Done packaging.
[info] Running com.github.oopman.spandigitalexercise.Main --db-uri jdbc:mysql://localhost:3306/spandigitalexercise?user=adamj&password=password
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[error] (run-main-0) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE  IF NOT EXISTS results
[error] (
[error]   id INTEGER NOT NULL PRIMARY KEY AUTO_INC' at line 7
[error] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE  IF NOT EXISTS results
[error] (
[error]   id INTEGER NOT NULL PRIMARY KEY AUTO_INC' at line 7
[error]         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[error]         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[error]         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[error]         at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[error]         at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
[error]         at com.mysql.jdbc.Util.getInstance(Util.java:387)
[error]         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
[error]         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
[error]         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
[error]         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
[error]         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
[error]         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
[error]         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
[error]         at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
[error]         at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
[error]         at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
[error]         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
[error]         at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
[error]         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
[error]         at io.getquill.context.jdbc.JdbcContext.$anonfun$executeAction$1(JdbcContext.scala:98)
[error]         at io.getquill.context.jdbc.JdbcContext.$anonfun$executeAction$1$adapted(JdbcContext.scala:95)
[error]         at io.getquill.context.jdbc.JdbcContext.$anonfun$withConnection$1(JdbcContext.scala:44)
[error]         at scala.Option.getOrElse(Option.scala:121)
[error]         at io.getquill.context.jdbc.JdbcContext.withConnection(JdbcContext.scala:42)
[error]         at io.getquill.context.jdbc.JdbcContext.executeAction(JdbcContext.scala:95)
[error]         at com.github.oopman.spandigitalexercise.DAO.<init>(DAO.scala:26)
[error]         at com.github.oopman.spandigitalexercise.CLI$.apply(CLI.scala:94)
[error]         at com.github.oopman.spandigitalexercise.Main$.delayedEndpoint$com$github$oopman$spandigitalexercise$Main$1(Main.scala:7)
[error]         at com.github.oopman.spandigitalexercise.Main$delayedInit$body.apply(Main.scala:6)
[error]         at scala.Function0.apply$mcV$sp(Function0.scala:34)
[error]         at scala.Function0.apply$mcV$sp$(Function0.scala:34)
[error]         at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
[error]         at scala.App.$anonfun$main$1$adapted(App.scala:76)
[error]         at scala.collection.immutable.List.foreach(List.scala:389)
[error]         at scala.App.main(App.scala:76)
[error]         at scala.App.main$(App.scala:74)
[error]         at com.github.oopman.spandigitalexercise.Main$.main(Main.scala:6)
[error]         at com.github.oopman.spandigitalexercise.Main.main(Main.scala)
[error]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[error]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[error]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[error]         at java.lang.reflect.Method.invoke(Method.java:498)
[error]         at sbt.Run.invokeMain(Run.scala:93)
[error]         at sbt.Run.run0(Run.scala:87)
[error]         at sbt.Run.execute$1(Run.scala:65)
[error]         at sbt.Run.$anonfun$run$4(Run.scala:77)
[error]         at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:12)
[error]         at sbt.util.InterfaceUtil$$anon$1.get(InterfaceUtil.scala:10)
[error]         at sbt.TrapExit$App.run(TrapExit.scala:252)
[error]         at java.lang.Thread.run(Thread.java:748)
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[error] java.lang.RuntimeException: Nonzero exit code: 1
[error]         at sbt.Run$.executeTrapExit(Run.scala:124)
[error]         at sbt.Run.run(Run.scala:77)
[error]         at sbt.Defaults$.$anonfun$bgRunTask$5(Defaults.scala:1185)
[error]         at sbt.Defaults$.$anonfun$bgRunTask$5$adapted(Defaults.scala:1180)
[error]         at sbt.internal.BackgroundThreadPool.$anonfun$run$1(DefaultBackgroundJobService.scala:366)
[error]         at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:12)
[error]         at scala.util.Try$.apply(Try.scala:209)
[error]         at sbt.internal.BackgroundThreadPool$BackgroundRunnable.run(DefaultBackgroundJobService.scala:289)
[error]         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[error]         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[error]         at java.lang.Thread.run(Thread.java:748)
[error] (Compile / run) Nonzero exit code: 1
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[error] Total time: 17 s, completed 05 Jun 2018 7:54:19 PM
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.