import scalikejdbc._

object Main{
	def main(args: Array[String]): Unit = {
		val user = "user"
		val pass = "pass"
		val url = """url"""

		Class.forName("com.mysql.jdbc.Driver")
		ConnectionPool.singleton(url, user, pass)

		case class User(id: Int, name: String, liked: String)
		object User extends SQLSyntaxSupport[User]{
			override val tableName = "user"
			def apply(rs: WrappedResultSet): User = new User(rs.int("id"), rs.string("name"),
				rs.string("liked"))
		}


		val result = DB readOnly {implicit session =>
			sql"select * from user".map(rs => rs.string("name")).first.apply()
		}
		println(result)
	}
}