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.AbstractProjectDao import de.uapcore.lightpit.dao.Functions import de.uapcore.lightpit.entities.IssueSummary import de.uapcore.lightpit.entities.Project import de.uapcore.lightpit.entities.User import java.sql.Connection import java.sql.PreparedStatement import java.sql.ResultSet class PGProjectDao(connection: Connection) : AbstractProjectDao() { private val query = "select projectid, name, node, description, repourl, " + "userid, username, lastname, givenname, mail " + "from lpit_project " + "left join lpit_user owner on lpit_project.owner = owner.userid " private val listStmt = connection.prepareStatement("$query order by name") private val findStmt = connection.prepareStatement("$query where projectid = ?") private val findByNodeStmt = connection.prepareStatement("$query where node = ?") private val issueSummaryStmt = connection.prepareStatement( "select phase, count(*) as total " + "from lpit_issue " + "join lpit_issue_phases using(status) " + "where project = ? " + "group by phase " ) private val insertStmt = connection.prepareStatement( "insert into lpit_project (name, node, description, repourl, owner) values (?, ?, ?, ?, ?)" ) private val updateStmt = connection.prepareStatement( "update lpit_project set name = ?, node = ?, description = ?, repourl = ?, owner = ? where projectid = ?" ) override fun mapResult(rs: ResultSet): Project { val proj = Project(rs.getInt("projectid")) proj.name = rs.getString("name") proj.node = rs.getString("node") proj.description = rs.getString("description") proj.repoUrl = rs.getString("repourl") proj.owner = PGUserDao.mapResult(rs).takeUnless { rs.wasNull() } return proj } override fun getIssueSummary(project: Project): IssueSummary { issueSummaryStmt.setInt(1, project.id) val result = issueSummaryStmt.executeQuery() val summary = IssueSummary() while (result.next()) { val phase = result.getInt("phase") val total = result.getInt("total") when (phase) { 0 -> summary.open = total 1 -> summary.active = total 2 -> summary.done = total } } return summary } private fun setColumns(stmt: PreparedStatement, instance: Project): Int { var column = 0 stmt.setString(++column, instance.name) stmt.setString(++column, instance.node) Functions.setStringOrNull(stmt, ++column, instance.description) Functions.setStringOrNull(stmt, ++column, instance.repoUrl) setForeignKeyOrNull(stmt, ++column, instance.owner, User::id) return column } override fun save(instance: Project) { setColumns(insertStmt, instance) insertStmt.executeUpdate() } override fun update(instance: Project): Boolean { var column = setColumns(updateStmt, instance) updateStmt.setInt(++column, instance.id) return updateStmt.executeUpdate() > 0 } override fun list(): List<Project> { return super.list(listStmt) } override fun find(id: Int): Project? { findStmt.setInt(1, id) return super.find(findStmt) } override fun findByNode(node: String): Project? { findByNodeStmt.setString(1, node) return super.find(findByNodeStmt) } }