Created
February 20, 2012 17:00
-
-
Save ostronom/1870114 to your computer and use it in GitHub Desktop.
Play 2.0 & squeryl simple integration
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package controllers | |
import org.squeryl.PrimitiveTypeMode._ | |
import org.squeryl.{Session} | |
import play.api._ | |
import play.api.mvc._ | |
import models._ | |
object CountryController extends Controller { | |
def index(offset: Int) = Action { | |
inTransaction { | |
val countriesPage = from(CoreSchema.countries)(country => | |
where(country.enabled === true) | |
select(country) | |
orderBy(country.id asc) | |
).page(25*offset, 25).toSeq | |
Ok(views.html.countries(countriesPage)) | |
} | |
} | |
def show(slug: String) = Action { | |
inTransaction { | |
//Session.currentSession.setLogger(println) | |
from(CoreSchema.countries)(country => | |
where(country.enabled === true and country.slug === slug) | |
select(country) | |
).headOption match { | |
case Some(item) => Ok(views.html.country(item)) | |
case None => NotFound(views.html.notfound()) | |
} | |
} | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import play.api._ | |
import play.api.db._ | |
import org.squeryl.{Session, SessionFactory} | |
import org.squeryl.adapters.PostgreSqlAdapter | |
object Global extends GlobalSettings { | |
override def onStart(app: Application) { | |
SessionFactory.concreteFactory = Some( () => connection ) | |
def connection() = { | |
Session.create(DB.getConnection()(app), new PostgreSqlAdapter) | |
} | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package models | |
//import scala.util.DynamicVariable | |
import play.api.db._ | |
import play.api.Play.current | |
import org.squeryl.KeyedEntity | |
import org.squeryl.PrimitiveTypeMode._ | |
import org.squeryl.dsl.{OneToMany} | |
import org.squeryl.Schema | |
import org.squeryl.annotations.Column | |
import org.squeryl.{Session, SessionFactory} | |
import java.sql.Timestamp | |
import System._ | |
import java.lang.{Integer} | |
class BaseEntity extends KeyedEntity[Long] { | |
val id: Long = 0 | |
} | |
trait SlugField { | |
val slug: String = "" | |
} | |
trait CreationTimeMonitoring { | |
val created_at: Timestamp = new Timestamp(System.currentTimeMillis) | |
} | |
class User(var username: String, | |
var password: String, | |
var email: String, | |
var verification_code: String, | |
var is_verified: Boolean) extends BaseEntity { | |
def this() = this("", "", "", "", false) | |
} | |
class Country(var enabled: Boolean, | |
var area: Integer, | |
var engname: String, | |
var rusname: String, | |
var iso: String) extends BaseEntity with SlugField { | |
def this() = this(false, 0, "", "", "") | |
lazy val cities: OneToMany[City] = CoreSchema.countryToCities.left(this) | |
def citiesByPopulation = { | |
from(CoreSchema.cities)(city => | |
where(city.country_id === id) | |
select(city) | |
orderBy(city.pop desc) | |
) | |
} | |
def wikifiedName = { | |
((engname toLowerCase) split " " map (_ capitalize)).mkString("_") | |
} | |
} | |
class City(var engname: String, | |
var rusname: String, | |
var lat: Double, | |
var lon: Double, | |
var pop: Long, | |
var country_id: Long) extends BaseEntity with SlugField{ | |
def this() = this("", "", 0, 0, 0, 0) | |
} | |
class Post(var title: String, | |
var content: String, | |
var author_id: Long, | |
var country_id: Long) extends BaseEntity with SlugField with CreationTimeMonitoring { | |
def this() = this("", "", 0, 0) | |
} | |
object CoreSchema extends Schema { | |
val users = table[User]("user") | |
val countries = table[Country]("country") | |
val cities = table[City]("city") | |
val posts = table[Post]("post") | |
val countryToPosts = | |
oneToManyRelation(countries, posts). | |
via((country,post) => country.id === post.country_id) | |
val countryToCities = | |
oneToManyRelation(countries, cities). | |
via((country,city) => country.id === city.country_id) | |
val userToPosts = | |
oneToManyRelation(users, posts). | |
via((user,post) => user.id === post.author_id) | |
on(users)(ent => declare( | |
ent.id is(autoIncremented), | |
ent.email is(unique, dbType("varchar(255)")) | |
)) | |
on(countries)(ent => declare( | |
ent.id is(autoIncremented), | |
ent.iso is(unique, dbType("varchar(2)")), | |
ent.slug is(unique) | |
)) | |
on(cities)(ent => declare( | |
ent.id is(autoIncremented), | |
ent.slug is(unique) | |
)) | |
on(posts)(ent => declare( | |
ent.id is(autoIncremented), | |
ent.slug is(unique) | |
)) | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Thank for this! Pretty much appreciated.
Is there any advantage of having your entity classes be "normal" classes over being "case classes"?