Mercurial > hg > LightPIT / file revision

 /*

  * Copyright 2020 Mike Becker. All rights reserved.

  *

  * Redistribution and use in source and binary forms, with or without

  * modification, are permitted provided that the following conditions are met:

  *

  * 1. Redistributions of source code must retain the above copyright

  * notice, this list of conditions and the following disclaimer.

  *

  * 2. Redistributions in binary form must reproduce the above copyright

  * notice, this list of conditions and the following disclaimer in the

  * documentation and/or other materials provided with the distribution.

  *

  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"

  * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE

  * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE

  * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE

  * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL

  * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR

  * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

  * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,

  * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE

  * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

  *

  */

 package de.uapcore.lightpit.dao.postgres

 import de.uapcore.lightpit.dao.AbstractVersionDao

 import de.uapcore.lightpit.entities.Project

 import de.uapcore.lightpit.entities.Version

 import de.uapcore.lightpit.entities.VersionStatus

 import java.sql.Connection

 import java.sql.PreparedStatement

 import java.sql.ResultSet

 class PGVersionDao(connection: Connection) : AbstractVersionDao() {

     companion object {

         fun mapResult(rs: ResultSet): Version {

             val id = rs.getInt("versionid")

             return if (rs.wasNull()) {

                 Version(-1)

             } else {

                 val version = Version(id)

                 version.name = rs.getString("name")

                 version.node = rs.getString("node")

                 version.ordinal = rs.getInt("ordinal")

                 version.status = VersionStatus.valueOf(rs.getString("status"))

                 version

             }

         }

     }

     private val query = "select versionid, project, name, node, ordinal, status from lpit_version"

     private val listStmt = connection.prepareStatement(query + " where project = ? " +

             "order by ordinal desc, lower(name) desc")

     private val findStmt = connection.prepareStatement("$query where versionid = ?")

     private val findByNodeStmt = connection.prepareStatement("$query where project = ? and node = ?")

     private val insertStmt = connection.prepareStatement(

             "insert into lpit_version (name, node, ordinal, status, project) values (?, ?, ?, ?::version_status, ?)"

     )

     private val updateStmt = connection.prepareStatement(

             "update lpit_version set name = ?, node = ?, ordinal = ?, status = ?::version_status where versionid = ?"

     )

     override fun mapResult(rs: ResultSet): Version = Companion.mapResult(rs)

     private fun setFields(stmt: PreparedStatement, instance: Version): Int {

         var column = 0

         stmt.setString(++column, instance.name)

         stmt.setString(++column, instance.node)

         stmt.setInt(++column, instance.ordinal)

         stmt.setString(++column, instance.status.name)

         return column

     }

     override fun save(instance: Version, parent: Project) {

         var column = setFields(insertStmt, instance)

         insertStmt.setInt(++column, parent.id)

         insertStmt.executeUpdate()

     }

     override fun update(instance: Version): Boolean {

         var column = setFields(updateStmt, instance)

         updateStmt.setInt(++column, instance.id)

         return updateStmt.executeUpdate() > 0

     }

     override fun list(parent: Project): List<Version> {

         listStmt.setInt(1, parent.id)

         return super.list(listStmt)

     }

     override fun find(id: Int): Version? {

         findStmt.setInt(1, id)

         return super.find(findStmt)

     }

     override fun findByNode(parent: Project, node: String): Version? {

         findByNodeStmt.setInt(1, parent.id)

         findByNodeStmt.setString(2, node)

         return super.find(findByNodeStmt)

     }

 }