Fri, 18 Dec 2020 16:09:20 +0100
Update issue "updated" date when a comment is added or changed - fixes #111
/* * 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) } }