summaryrefslogtreecommitdiff
path: root/src/main/scala/developerstream/Db.scala
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/scala/developerstream/Db.scala')
-rw-r--r--src/main/scala/developerstream/Db.scala30
1 files changed, 30 insertions, 0 deletions
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
+ }
+}