import scalikejdbc._

import scalikejdbc.config._

object CommonOperation {

  def main(args: Array[String]): Unit = {

    DBsWithEnv("dev").setupAll()

    case class Emp(id: Int, name: String)

    DB autoCommit { implicit session =>

      sql"create table emp ( id int(20) not null AUTO_INCREMENT, name varchar(30),   primary key (id))".execute.apply()

    }

    val id = 1

    val name = "sky"

    val newName = "bill"

    DB localTx { implicit session =>

      sql"""insert into emp (name) values (${name})"""

        .update.apply()

      val idd = sql"insert into emp (name) values (${name})"

        .updateAndReturnGeneratedKey.apply()

      println("new insert: " + idd)

      sql"update emp set name = ${newName} where id = ${id}".update.apply()

      sql"delete emp where id = ${id}".update.apply()

      val emps: List[Emp] = sql"select id, name from emp".map(

        (rs: WrappedResultSet) => Emp(

          id = rs.int("id"),

          name = rs.string("name"))).list.apply()

      for (emp <- emps) {

        println(emp.id + "," + emp.name)

      }

    }

    DBsWithEnv("dev").closeAll()

  }

}