C[omp]ute

From: andrew cooke <andrew@...>

Date: Mon, 28 Sep 2009 21:39:07 -0400

My first ever Scala code.  All it does is not crash, but that's
something...  Andrew


package org.acooke.uykfd.db

import java.sql.DriverManager

import org.apache.empire.commons.ErrorObject
import org.apache.empire.data.DataType
import org.apache.empire.db.DBDatabase
import org.apache.empire.db.DBTable
import org.apache.empire.db.DBTableColumn
import org.apache.empire.db.hsql.DBDatabaseDriverHSql

import org.hsqldb.jdbcDriver


object Database extends DBDatabase {

  class Artists(db: DBDatabase) extends DBTable("artists", db) {
    val ID = addColumn("id", DataType.AUTOINC,
                       0, true, "artist_id_seq")
  }
  val ARTISTS = new Artists(this)

  class Tracks(db: DBDatabase) extends DBTable("tracks", db) {
    val ID = addColumn("id", DataType.AUTOINC,
                       0, true, "track_id_seq")
    val ARTIST = addColumn("artist", DataType.INTEGER, 0, true)
  }
  val TRACKS = new Tracks(this) {
    setPrimaryKey(ID)
  }

  addRelation(TRACKS.ARTIST.referenceOn(TRACKS.ID))

  def create() {
    ErrorObject.setExceptionsEnabled(true)
    new jdbcDriver()
    val conxn = DriverManager.getConnection(
      "jdbc:hsqldb:file:hsqldb/sample;shutdown=true", "sa", "")
    val driver = new DBDatabaseDriverHSql()
    open(driver, conxn)
  }

  def main(args: Array[String]) {
    create()
  }

}