Typesafe Activator

Hello ScalikeJDBC!

Hello ScalikeJDBC!

scalikejdbc
Source
November 8, 2014
scala database backbonejs coffeescript

Just write SQL and get things done! 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. This template is built with ScalikeJDBC, Play2, Backbone.js and CoffeeScript.

How to get "Hello ScalikeJDBC!" on your computer

There are several ways to get this template.

Option 1: Choose scalikejdbc-activator-template in the Typesafe Activator UI.

Already have Typesafe Activator (get it here)? Launch the UI then search for scalikejdbc-activator-template in the list of templates.

Option 2: Download the scalikejdbc-activator-template project as a zip archive

If you haven't installed Activator, you can get the code by downloading the template bundle for scalikejdbc-activator-template.

  1. Download the Template Bundle for "Hello ScalikeJDBC!"
  2. Extract the downloaded zip file to your system
  3. The bundle includes a small bootstrap script that can start Activator. To start Typesafe Activator's UI:

    In your File Explorer, navigate into the directory that the template was extracted to, right-click on the file named "activator.bat", then select "Open", and if prompted with a warning, click to continue:

    Or from a command line:

     C:\Users\typesafe\scalikejdbc-activator-template> activator ui 
    This will start Typesafe Activator and open this template in your browser.

Option 3: Create a scalikejdbc-activator-template project from the command line

If you have Typesafe Activator, use its command line mode to create a new project from this template. Type activator new PROJECTNAME scalikejdbc-activator-template on the command line.

Option 4: View the template source

The creator of this template maintains it at https://github.com/scalikejdbc/hello-scalikejdbc#master.

Option 5: Preview the tutorial below

We've included the text of this template's tutorial below, but it may work better if you view it inside Activator on your computer. Activator tutorials are often designed to be interactive.

Preview the tutorial

Run snippets on sbt console

You can try snippets on sbt console as follows.


// basic import
import scalikejdbc._

// load conf/application.conf
import scalikejdbc.config._
DBs.setupAll

// prepare data
import models._, utils._
DBInitializer.run()
GlobalSettings.sqlFormatter = SQLFormatterSettings("utils.HibernateSQLFormatter")

implicit val autoSession = AutoSession

// run snippets
val c = Company.syntax("c")
val companies: List[Company] = withSQL {
  select.from(Company as c).where.isNull(c.deletedAt).orderBy(c.id)
}.map(Company(c)).list.apply()

More Examples

Let's move on to app/models/Company.scala which contains some examples.

Next Steps

For more information, check out the manual on the website.

comments powered by Disqus