Sun, 20 Dec 2020 11:06:25 +0100
minimize footprint of flexmark - fixes #116
159 | 1 | /* |
2 | * Copyright 2020 Mike Becker. All rights reserved. | |
3 | * | |
4 | * Redistribution and use in source and binary forms, with or without | |
5 | * modification, are permitted provided that the following conditions are met: | |
6 | * | |
7 | * 1. Redistributions of source code must retain the above copyright | |
8 | * notice, this list of conditions and the following disclaimer. | |
9 | * | |
10 | * 2. Redistributions in binary form must reproduce the above copyright | |
11 | * notice, this list of conditions and the following disclaimer in the | |
12 | * documentation and/or other materials provided with the distribution. | |
13 | * | |
14 | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" | |
15 | * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE | |
16 | * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE | |
17 | * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE | |
18 | * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL | |
19 | * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR | |
20 | * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER | |
21 | * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, | |
22 | * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE | |
23 | * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | |
24 | * | |
25 | */ | |
26 | ||
27 | package de.uapcore.lightpit.dao.postgres | |
28 | ||
29 | import de.uapcore.lightpit.dao.AbstractComponentDao | |
30 | import de.uapcore.lightpit.dao.Functions | |
31 | import de.uapcore.lightpit.entities.Component | |
32 | import de.uapcore.lightpit.entities.Project | |
33 | import de.uapcore.lightpit.entities.User | |
34 | import de.uapcore.lightpit.types.WebColor | |
35 | import java.sql.Connection | |
36 | import java.sql.PreparedStatement | |
37 | import java.sql.ResultSet | |
38 | ||
39 | class PGComponentDao(connection: Connection) : AbstractComponentDao() { | |
40 | ||
41 | private val query = "select id, name, node, color, ordinal, description, " + | |
42 | "userid, username, givenname, lastname, mail " + | |
43 | "from lpit_component " + | |
44 | "left join lpit_user on lead = userid" | |
45 | ||
46 | private val listStmt = connection.prepareStatement("$query where project = ? order by ordinal, lower(name)") | |
47 | private val findStmt = connection.prepareStatement("$query where id = ? ") | |
48 | private val findByNodeStmt = connection.prepareStatement("$query where project = ? and node = ?") | |
49 | private val insertStmt = connection.prepareStatement( | |
50 | "insert into lpit_component (name, node, color, ordinal, description, lead, project) values (?, ?, ?, ?, ?, ?, ?)" | |
51 | ) | |
52 | private val updateStmt = connection.prepareStatement( | |
53 | "update lpit_component set name = ?, node = ?, color = ?, ordinal = ?, description = ?, lead = ? where id = ?" | |
54 | ) | |
55 | ||
56 | override fun mapResult(rs: ResultSet): Component { | |
57 | val component = Component(rs.getInt("id")) | |
58 | component.name = rs.getString("name") | |
59 | component.node = rs.getString("node") | |
60 | component.color = try { | |
61 | WebColor(rs.getString("color")) | |
62 | } catch (ex: IllegalArgumentException) { | |
63 | WebColor("000000") | |
64 | } | |
65 | component.ordinal = rs.getInt("ordinal") | |
66 | component.description = rs.getString("description") | |
67 | component.lead = PGUserDao.mapResult(rs).takeUnless { rs.wasNull() } | |
68 | return component | |
69 | } | |
70 | ||
71 | private fun setColumns(stmt: PreparedStatement, instance: Component): Int { | |
72 | var column = 0 | |
73 | stmt.setString(++column, instance.name) | |
74 | stmt.setString(++column, instance.node) | |
75 | stmt.setString(++column, instance.color.hex) | |
76 | stmt.setInt(++column, instance.ordinal) | |
77 | Functions.setStringOrNull(stmt, ++column, instance.description) | |
78 | setForeignKeyOrNull(stmt, ++column, instance.lead, User::id) | |
79 | return column | |
80 | } | |
81 | ||
82 | override fun save(instance: Component, parent: Project) { | |
83 | var column = setColumns(insertStmt, instance) | |
84 | insertStmt.setInt(++column, parent.id) | |
85 | insertStmt.executeUpdate() | |
86 | } | |
87 | ||
88 | override fun update(instance: Component): Boolean { | |
89 | var column = setColumns(updateStmt, instance) | |
90 | updateStmt.setInt(++column, instance.id) | |
91 | return updateStmt.executeUpdate() > 0 | |
92 | } | |
93 | ||
94 | ||
95 | override fun list(parent: Project): List<Component> { | |
96 | listStmt.setInt(1, parent.id) | |
97 | return super.list(listStmt) | |
98 | } | |
99 | ||
100 | override fun find(id: Int): Component? { | |
101 | findStmt.setInt(1, id) | |
102 | return super.find(findStmt) | |
103 | } | |
104 | ||
105 | override fun findByNode(parent: Project, node: String): Component? { | |
106 | findByNodeStmt.setInt(1, parent.id) | |
107 | findByNodeStmt.setString(2, node) | |
108 | return super.find(findByNodeStmt) | |
109 | } | |
110 | } |