import org.squeryl.PrimitiveTypeMode.*;
import org.squeryl.SessionFactory;
import org.squeryl.Session;
case class User(id: Long, name: String, age: Int)
object UserSchema extends Schema {
val users = table[User]("users")
}
Class.forName("com.mysql.jdbc.Driver")
val session = Session.create(DriverManager.getConnection("jdbc:mysql://localhost/mydb", "username", "password"), new MySQLAdapter)
transaction {
UserSchema.users.insert(new User(1, "John Doe", 25))
UserSchema.users.update(user => where(user.id === 1) set (user.name := "Jane Doe"))
val users = from(UserSchema.users)(user => where(user.age > 18) select user)
users.toList.foreach(println)
}
session.close()
