Skip to content

Instantly share code, notes, and snippets.

@abdheshkumar abdheshkumar/build.sbt forked from seratch/build.sbt
Created Aug 14, 2014

Embed
What would you like to do?
scalaVersion := "2.9.1"
resolvers += "typesafe" at "http://repo.typesafe.com/typesafe/releases"
libraryDependencies ++= Seq(
"play" %% "anorm" % "2.0-RC4",
"com.github.seratch" %% "scalikejdbc" % "[0.5,)",
"org.hsqldb" % "hsqldb" % "[2,)"
)
import java.sql.Connection
import scalikejdbc._
import anorm._
/**
* @see "https://github.com/playframework/Play20/wiki/ScalaAnorm"
* @see "https://github.com/seratch/scalikejdbc"
*/
object WithScalikeJDBC extends App {
Class.forName("org.hsqldb.jdbc.JDBCDriver")
ConnectionPool.singleton("jdbc:hsqldb:mem:hsqldb:WithAnorm", "", "")
implicit val conn: Connection = ConnectionPool.borrow()
SQL("create table emp (id integer primary key, name varchar(30))").execute()
SQL("insert into emp (id, name) values ({id}, {name})").on("id" -> 1, "name" -> "name1").executeUpdate()
SQL("insert into emp (id, name) values ({id}, {name})").on("id" -> 2, "name" -> "name2").executeUpdate()
val selectAll: SqlQuery = SQL("select id, name from emp")
val all: Stream[SqlRow] = selectAll.apply
all.foreach {
row => println(row)
}
val selectAll2: SqlQuery = SQL("select * from emp")
selectAll2() foreach println
case class Emp(id: Int, name: String)
val res: Stream[Emp] = SQL("select id,name from emp")().collect {
case Row(id: Int, Some(name: String)) => Emp(id, name)
}
res foreach println
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.