1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/src/main/kotlin/de/uapcore/lightpit/dao/postgres/PGComponentDao.kt Thu Nov 19 13:58:54 2020 +0100
1.3 @@ -0,0 +1,110 @@
1.4 +/*
1.5 + * Copyright 2020 Mike Becker. All rights reserved.
1.6 + *
1.7 + * Redistribution and use in source and binary forms, with or without
1.8 + * modification, are permitted provided that the following conditions are met:
1.9 + *
1.10 + * 1. Redistributions of source code must retain the above copyright
1.11 + * notice, this list of conditions and the following disclaimer.
1.12 + *
1.13 + * 2. Redistributions in binary form must reproduce the above copyright
1.14 + * notice, this list of conditions and the following disclaimer in the
1.15 + * documentation and/or other materials provided with the distribution.
1.16 + *
1.17 + * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
1.18 + * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
1.19 + * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
1.20 + * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
1.21 + * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
1.22 + * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
1.23 + * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
1.24 + * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
1.25 + * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
1.26 + * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
1.27 + *
1.28 + */
1.29 +
1.30 +package de.uapcore.lightpit.dao.postgres
1.31 +
1.32 +import de.uapcore.lightpit.dao.AbstractComponentDao
1.33 +import de.uapcore.lightpit.dao.Functions
1.34 +import de.uapcore.lightpit.entities.Component
1.35 +import de.uapcore.lightpit.entities.Project
1.36 +import de.uapcore.lightpit.entities.User
1.37 +import de.uapcore.lightpit.types.WebColor
1.38 +import java.sql.Connection
1.39 +import java.sql.PreparedStatement
1.40 +import java.sql.ResultSet
1.41 +
1.42 +class PGComponentDao(connection: Connection) : AbstractComponentDao() {
1.43 +
1.44 + private val query = "select id, name, node, color, ordinal, description, " +
1.45 + "userid, username, givenname, lastname, mail " +
1.46 + "from lpit_component " +
1.47 + "left join lpit_user on lead = userid"
1.48 +
1.49 + private val listStmt = connection.prepareStatement("$query where project = ? order by ordinal, lower(name)")
1.50 + private val findStmt = connection.prepareStatement("$query where id = ? ")
1.51 + private val findByNodeStmt = connection.prepareStatement("$query where project = ? and node = ?")
1.52 + private val insertStmt = connection.prepareStatement(
1.53 + "insert into lpit_component (name, node, color, ordinal, description, lead, project) values (?, ?, ?, ?, ?, ?, ?)"
1.54 + )
1.55 + private val updateStmt = connection.prepareStatement(
1.56 + "update lpit_component set name = ?, node = ?, color = ?, ordinal = ?, description = ?, lead = ? where id = ?"
1.57 + )
1.58 +
1.59 + override fun mapResult(rs: ResultSet): Component {
1.60 + val component = Component(rs.getInt("id"))
1.61 + component.name = rs.getString("name")
1.62 + component.node = rs.getString("node")
1.63 + component.color = try {
1.64 + WebColor(rs.getString("color"))
1.65 + } catch (ex: IllegalArgumentException) {
1.66 + WebColor("000000")
1.67 + }
1.68 + component.ordinal = rs.getInt("ordinal")
1.69 + component.description = rs.getString("description")
1.70 + component.lead = PGUserDao.mapResult(rs).takeUnless { rs.wasNull() }
1.71 + return component
1.72 + }
1.73 +
1.74 + private fun setColumns(stmt: PreparedStatement, instance: Component): Int {
1.75 + var column = 0
1.76 + stmt.setString(++column, instance.name)
1.77 + stmt.setString(++column, instance.node)
1.78 + stmt.setString(++column, instance.color.hex)
1.79 + stmt.setInt(++column, instance.ordinal)
1.80 + Functions.setStringOrNull(stmt, ++column, instance.description)
1.81 + setForeignKeyOrNull(stmt, ++column, instance.lead, User::id)
1.82 + return column
1.83 + }
1.84 +
1.85 + override fun save(instance: Component, parent: Project) {
1.86 + var column = setColumns(insertStmt, instance)
1.87 + insertStmt.setInt(++column, parent.id)
1.88 + insertStmt.executeUpdate()
1.89 + }
1.90 +
1.91 + override fun update(instance: Component): Boolean {
1.92 + var column = setColumns(updateStmt, instance)
1.93 + updateStmt.setInt(++column, instance.id)
1.94 + return updateStmt.executeUpdate() > 0
1.95 + }
1.96 +
1.97 +
1.98 + override fun list(parent: Project): List<Component> {
1.99 + listStmt.setInt(1, parent.id)
1.100 + return super.list(listStmt)
1.101 + }
1.102 +
1.103 + override fun find(id: Int): Component? {
1.104 + findStmt.setInt(1, id)
1.105 + return super.find(findStmt)
1.106 + }
1.107 +
1.108 + override fun findByNode(parent: Project, node: String): Component? {
1.109 + findByNodeStmt.setInt(1, parent.id)
1.110 + findByNodeStmt.setString(2, node)
1.111 + return super.find(findByNodeStmt)
1.112 + }
1.113 +}
1.114 \ No newline at end of file
