README.md

scala-ebean

Helpers for using Ebean ORM in Scala

Download

build.sbt:

resolvers += "Maven Central" at "https://repo1.maven.org/maven2"

libraryDependencies += "com.github.tarasbilinsky" % "scala-ebean-macros" % "0.0.1"

Maven Central

Jar

Usage

@Entity

public class Item extends Model {
    public Long id;
    public String title;
    public int qty;

}

    import models.Item
    import net.oltiv.scalaebean.Shortcuts._

    //Dummy placeholder model for query and expr
    val m = new Item()
    //Instead of
    com.avaje.ebean.Ebean.createQuery(classOf[Item])
        .select("title")
            .where()
                .gt("qty",0)
                .like("title","%orange%")
    .findList
    // Use query macro that type checks property names
    // auto complete works when you write the code
    val itemsOrange: Seq[Item] = 
    query(m,m.qty>0 && like(m.title,"%orange%"),m.title).seq

    val item5: Option[Item] = query(m,m.id==5).one

    val items456: Seq[Item] = query(m,in(m.id,4,5,6)).seq

    val itemsRaw: Seq[Item] = query(m,raw("exists (select id from item_type where item_id = t0.id)")).seq

    val anExpr: com.avaje.ebean.Expression = expr(m, m.id>0)
    val itemsSepExpr: Seq[Item] = query(m,m.qty>0 && wrap(anExpr)).seq

    //Transaction control
    transaction { implicit db =>
      val newRecord = new Item
        //...
      newRecord.save()
      executeSql(s" ... ")
      //...
      val item5= query(m,m.id==5).one
      //...
      val id = executeStoredProcedureReadOut[Long]("execSqlReturnId", Out(java.sql.Types.BIGINT), " ... ")

    }