IMPORTANT NOTICE

This sample project is no longer maintained. Please see hello-scalikejdbc instead.

devteam app

This is a simple ScalikeJDBC demo application.

ScalikeJDBC

ScalikeJDBC is A tidy SQL-based DB access library for Scala developers. This library naturally wraps JDBC APIs and provides you easy-to-use APIs.

https://github.com/scalikejdbc/scalikejdbc

http://scalikejdbc.org

ScalikeJDBC Users Group

Join us if you're insterested!

https://groups.google.com/group/scalikejdbc-users-group

SQLInterpolation Basic

SQLInterpolation simplifies DB access. sbt console and try this:

val name = "Typesafe"
val company = sql"select id, name from company where name = ${name}".map(_.toMap).single.apply()

• More info

http://scalikejdbc.org/documentation/sql-interpolation.html

Query DSL Examples

Query DSL is a DRY and typesafe way to write SQL. There are some examples that effectively use Query DSL under src/main/scala/devteam/model. These are simple model example that use Query DSL.

https://github.com/scalikejdbc/devteam-app/tree/master/src/main/scala/devteam/model

You can use Query DSL directly on sbt console:

val typesafe = withSQL {
  select.from(Company as c).where.eq(c.name, "Typesafe")
}.map(Company(c)).single.apply()

or try prepared model examples:

val pg = Programmer.create("@seratch")
pg.addSkill(Skill.findAll.head)
pg.copy(companyId = Company.findAll.headOption.map(_.id)).save()

val seratch = Programmer.findAllBy(sqls.eq(p.name, "@seratch")).head
seratch.company
seratch.skills

• More info

http://scalikejdbc.org/documentation/query-dsl.html

Testing Support

ScalikeJDBC has powerful testing support. You can use auto-rollback and fixtures with ScalaTest or specs2. Check the following example:

https://github.com/scalikejdbc/devteam-app/blob/master/src/test/scala/devteam/model/ProgrammerSpec.scala

• More info

http://scalikejdbc.org/documentation/testing.html

Source Code Generator

scalikejdbc-gen is a useful sbt plugin to generate Scala code from existing tables. Usage is pretty simple. Just specify table name like this:

sbt "scalikejdbcGen company"

• More info

http://scalikejdbc.org/documentation/reverse-engineering.html

Typesafe Config Reader

This is an easy-to-use configuration loader for ScalikeJDBC which reads typesafe config. DBs.setupAll loads src/main/resources/application.conf.

• More info

http://scalikejdbc.org/documentation/configuration.html

Simple JSON API app (Play2)

The above models don't depend on any specific web framework. You can re-use them in wether Play2 app, Scalatra app or others.

playapp project is a pretty simple JSON API server demo app. Try it now:

sbt
project playapp
run

// access http://localhost:9000/companies

• Code

https://github.com/scalikejdbc/devteam-app/blob/master/playapp/app/controllers

• Routing

https://github.com/scalikejdbc/devteam-app/blob/master/playapp/conf/routes

• More info

http://scalikejdbc.org/documentation/playframework-support.html

Files

.
├── README.md
├── build.sbt
├── db
│   ├── playapp.h2.db
│   ├── sandbox.h2.db
├── playapp
│   ├── app
│   │   └── controllers
│   │       ├── Companies.scala
│   │       ├── Programmers.scala
│   │       ├── Root.scala
│   │       └── Skills.scala
│   ├── build.sbt
│   ├── conf
│   │   ├── application.conf
│   │   ├── db
│   │   │   └── migration
│   │   │       └── default
│   │   │           └── V1__create_tables.sql
│   │   ├── play.plugins
│   │   └── routes
│   ├── dependency-graph.txt
│   ├── project
│   │   └── build.properties
│   └── test
│       └── RootSpec.scala
├── project
│   ├── Build.scala
│   ├── build.properties
│   ├── plugins.sbt
│   └── scalikejdbc.properties
└── src
    ├── main
    │   ├── resources
    │   │   └── application.conf
    │   └── scala
    │       └── devteam
    │           ├── misc
    │           │   ├── DBInitializer.scala
    │           │   └── HibernateSQLFormatter.scala
    │           └── model
    │               ├── Company.scala
    │               ├── Programmer.scala
    │               ├── ProgrammerSkill.scala
    │               └── Skill.scala
    └── test
        ├── resources
        │   └── application.conf
        └── scala
            ├── devteam
            │   └── model
            │       ├── CompanySpec.scala
            │       ├── ProgrammerSpec.scala
            │       └── SkillSpec.scala
            └── settings
                └── DBSettings.scala

License

Copyright 2013-2014 ScalikeJDBC committers

Apache License, Version 2.0

http://www.apache.org/licenses/LICENSE-2.0.html