Popularity
0.9
Stable
Activity
0.0
Stable
10
1
4

Programming language: Scala
Tags: Database    
Latest version: v1.0.0

MapperDao alternatives and similar packages

Based on the "Database" category

Do you think we are missing an alternative of MapperDao or a related project?

Add another 'Database' Package

Popular Comparisons

SaaSHub - Software Alternatives and Reviews
View more from us

README

Summary

MapperDao is an ORM library for the scala language and the following databases:

  • oracle
  • postgresql
  • mysql
  • derby
  • sql server
  • h2

It allows [...(more)](wiki/Summary.md)

News

  • 28/12/2016 : 1.0.2 for scala 2.11 and 2.12 is released.
  • 05/04/2015 : moved the project to github.
  • 25/08/2014 : updated the [tutorial](documentation/tutorial.pdf)
  • 08/06/2014 : 1.0.1 for scala 2.10 & 2.11 is available, a maintenance release. The artifactId now complies with sbt rules reg. scala version. Also minor clean up of the exposed API and code.
  • 21/04/2014 : 1.0.0.2.11 is now released for scala 2.11 .
  • 20/04/2014 : 1.0.0.2.10 is now released for scala 2.10 .
  • 18/01/2014 : 1.0.0.2.10.3-SNAPSHOT with immutable query DSL, better [aliasing](wiki/QueryAlias.md) and [immutable builder](wiki/DynamicQueries.md)

[...(more)](wiki/News.md)

  • [mapperdao tutorial (pdf)](documentation/tutorial.pdf)

  • [Documentation](wiki/TableOfContents.md)

  • Examples

  • [Sbt/Maven Configuration](wiki/MavenConfiguration.md)

  • Discussions group

  • [F.A.Q.](wiki/FAQ.md)

Example

import java.util.Properties
import org.apache.commons.dbcp.BasicDataSourceFactory

// create a datasource using apache dbcp
val properties = new Properties
properties.load(getClass.getResourceAsStream("/jdbc.test.properties"))
val dataSource = BasicDataSourceFactory.createDataSource(properties)

// create the mapperdao instance, connect to an oracle database and register our 2 entities
import com.googlecode.mapperdao.utils.Setup
val (jdbc,mapperDao,queryDao,txManager) = Setup.oracle(dataSource,List(PersonEntity,CompanyEntity))

// domain model classes (immutable)
class Person(val name: String, val company: Company)
class Company(val name: String)

// mappings (using default table and column naming convention)
object PersonEntity extends Entity[Int,SurrogateIntId, Person] {
    val id = key("id") autogenerated (_.id)
    val name = column("name") to (_.name)
    val company = manytoone(CompanyEntity) to (_.company)

    def constructor(implicit m) = new Person(name, company) with Stored {
        val id: Int = PersonEntity.id
    }
}

object CompanyEntity extends Entity[Int,SurrogateIntId, Company] {
    val id = key("id") autogenerated (_.id)
    val name = column("name") to (_.name)

    def constructor(implicit m) = new Company(name) with Stored {
        val id: Int = CompanyEntity.id
    }
}

val tx = Transaction.get(txManager, Propagation.Nested, Isolation.ReadCommited, -1) 

// insert a person
import mapperDao._
val person = new Person("Kostas", new Company("Coders limited"))

val inserted = tx { () => insert(PersonEntity, person) } // inserts person, company, in 1 transaction

// print the autogenerated id and the person name
println(s"${inserted.id} ${inserted.name}"))

// now update the company for this person
val company2 = insert(CompanyEntity, Company("Scala Inc"))
val modified = new Person(inserted.name, company2)
val updated = update(PersonEntity, inserted, modified) // no transaction here, but we could do the operation transactionally

// and select it from the database
val selected = select(PersonEntity, updated.id).get

// finally, delete the row
mapperDao.delete(PersonEntity, selected)

// run some queries
val pe=PersonEntity //alias
val people=query(select from pe) // get all
// people is a list of Person with IntId

// fetch only page 2 of all people
val people=query(QueryConfig.pagination(2, 10),select from pe)
// people is a list of Person with IntId

Roadmap

  • sqlite driver
  • optimistic locking
  • sum, avg, min, max and for column mappings and groupby in mappings of statistical entities

MapperDao would like to thank

  • YourKit is kindly supporting this open source project with its full-featured Java Profiler. YourKit, LLC is the creator of innovative and intelligent tools for profiling Java and .NET applications. Take a look at YourKit's leading software products:

YourKit Java Profiler and YourKit .NET Profiler.