import org.squeryl.SessionFactory;
import org.squeryl.Session;
import org.squeryl.adapters.H2Adapter;
import org.squeryl.PrimitiveTypeMode._;
public class SquerylExample {
public static void main(String[] args) {
SessionFactory sessionFactory = SessionFactory
.forURL("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;", new H2Adapter());
Session session = sessionFactory.createSession();
class Person extends KeyedEntity[Long] {
val id: Long = 0L;
var name: String = ""
}
transaction {
val result = from(persons)(p => where(p.name === "Alice") select p)
result.foreach(p => println(s"ID: ${p.id}, Name: ${p.name}"))
}
session.close()
}
}
