From 3e41859789c644a59334da6a07157aa0f1e0138f Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Mon, 10 Dec 2012 16:35:33 +0100 Subject: wip --- src/main/scala/developerstream/Db.scala | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 src/main/scala/developerstream/Db.scala (limited to 'src/main/scala/developerstream/Db.scala') diff --git a/src/main/scala/developerstream/Db.scala b/src/main/scala/developerstream/Db.scala new file mode 100644 index 0000000..4ddd129 --- /dev/null +++ b/src/main/scala/developerstream/Db.scala @@ -0,0 +1,30 @@ +package developerstream + +// Import the session management, including the implicit threadLocalSession +import org.scalaquery.session._ +import org.scalaquery.session.Database.threadLocalSession +import org.joda.time.DateTime +import java.util.UUID +import java.net.URL +import java.sql.Timestamp + +// Import the query language +import org.scalaquery.ql._ + +// Import the standard SQL types +import org.scalaquery.ql.TypeMapper._ + +// Use H2Driver which implements ExtendedProfile and thus requires ExtendedTables +import org.scalaquery.ql.extended.PostgresDriver.Implicit._ +import org.scalaquery.ql.extended.{ExtendedTable => Table} + +object Db { + val JenkinsServer = new Table[(UUID, Timestamp, String, Boolean)]("jenkins_server") { + def uuid = column[UUID]("uuid", O.PrimaryKey) + def created_date = column[Timestamp]("created_date") + def url = column[String]("url") + def enabled = column[Boolean]("enabled") + // Every table needs a * projection with the same type as the table's type parameter + def * = uuid ~ created_date ~ url ~ enabled + } +} -- cgit v1.2.3