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
  }
}