connect sample

package sample

import scalikejdbc._
import SQLInterpolation._

/**
 * http://scalikejdbc.org/
 * 
 */
object Main {

  def main(args: Array[String]) {
    Class.forName("com.mysql.jdbc.Driver")

    ConnectionPool.singleton("jdbc:mysql://localhost/host", "user", "pass")

    implicit val session = AutoSession

    println(session)

    sql"""
create table members (
  id serial not null primary key,
  name varchar(64),
  created_at timestamp not null
)
""".execute.apply()

    // insert initial data
    Seq("Alice", "Bob", "Chris") foreach { name =>
      sql"insert into members (name, created_at) values (${name}, current_timestamp)".update.apply()
    }

    val entities: List[Map[String, Any]] = sql"select * from members".map(_.toMap).list.apply()

    entities.foreach(println)

  }
}

scalike jdbc settings

name := "useScalikeJDBC"

version := "1.0"

scalaVersion := "2.10.2"

resolvers += "scct-github-repository" at "http://mtkopone.github.com/scct/maven-repo"

resolvers += "Typesafe Repository" at "http://repo.typesafe.com/typesafe/releases/"

libraryDependencies ++= Seq(
  "org.scalikejdbc" %% "scalikejdbc"               % "1.7.5",
  "org.scalikejdbc" %% "scalikejdbc-interpolation" % "1.7.5",
  "mysql" % "mysql-connector-java" % "5.1.30",
  "ch.qos.logback"  %  "logback-classic"           % "[1.1,)"
)

check scaffold