Initial code example2.0.0-RC1

1 files changed, 22 insertions, 0 deletions

diff --git a/src/main/scala/Example.scala b/src/main/scala/Example.scala
new file mode 100644
index 0000000..85a6ed3
--- /dev/null
+++ b/src/main/scala/Example.scala
@@ -0,0 +1,22 @@
+object Tables extends demo.Tables{ // or just use object demo.Tables, which is hard-wired to the driver stated during generation

+  val profile = scala.slick.driver.H2Driver  

+}

+import Tables._

+import Tables.profile.simple._

+

+object Example extends App {

+  // connection info for a pre-populated throw-away, in-memory db for this demo, which is freshly initialized on every run

+  val url = "jdbc:h2:mem:test;INIT=runscript from 'src/main/sql/create.sql'"

+  val db = Database.forURL(url, driver = "org.h2.Driver")

+

+  // Using generated code. Our Build.sbt makes sure they are generated before compilation.

+  val q = Companies.join(Computers).on(_.id === _.manufacturerId)

+                   .map{ case (co,cp) => (co.name, cp.name) }

+

+  db.withTransaction { implicit session =>

+    println( q.run.groupBy{ case (co,cp) => co }

+                  .mapValues(_.map{ case (co,cp) => cp })

+                  .mkString("\n")

+    )

+  }

+}