Fri, 02 Apr 2021 11:59:14 +0200
completes kotlin migration
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
1 | /* |
180 | 2 | * Copyright 2021 Mike Becker. All rights reserved. |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
3 | * |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
4 | * Redistribution and use in source and binary forms, with or without |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
5 | * modification, are permitted provided that the following conditions are met: |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
6 | * |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
7 | * 1. Redistributions of source code must retain the above copyright |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
8 | * notice, this list of conditions and the following disclaimer. |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
9 | * |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
10 | * 2. Redistributions in binary form must reproduce the above copyright |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
11 | * notice, this list of conditions and the following disclaimer in the |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
12 | * documentation and/or other materials provided with the distribution. |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
13 | * |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
14 | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
15 | * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
16 | * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
17 | * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
18 | * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
19 | * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
20 | * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
21 | * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
22 | * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
23 | * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
24 | */ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
25 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
26 | package de.uapcore.lightpit.dao |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
27 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
28 | import de.uapcore.lightpit.entities.* |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
29 | import de.uapcore.lightpit.types.WebColor |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
30 | import de.uapcore.lightpit.util.* |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
31 | import de.uapcore.lightpit.viewmodel.ComponentSummary |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
32 | import de.uapcore.lightpit.viewmodel.IssueSummary |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
33 | import de.uapcore.lightpit.viewmodel.VersionSummary |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
34 | import java.sql.Connection |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
35 | import java.sql.PreparedStatement |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
36 | import java.sql.ResultSet |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
37 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
38 | class PostgresDataAccessObject(private val connection: Connection) : DataAccessObject { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
39 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
40 | //<editor-fold desc="User"> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
41 | private fun selectUserInfo( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
42 | rs: ResultSet, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
43 | idColumn: String = "userid", |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
44 | usernameColumn: String = "username", |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
45 | givennameColumn: String = "givenname", |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
46 | lastnameColumn: String = "lastname", |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
47 | mailColumn: String = "mail" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
48 | ): User? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
49 | val idval = rs.getInt(idColumn) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
50 | return if (rs.wasNull()) null else { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
51 | User(idval).apply { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
52 | username = rs.getString(usernameColumn) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
53 | givenname = rs.getString(givennameColumn) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
54 | lastname = rs.getString(lastnameColumn) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
55 | mail = rs.getString(mailColumn) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
56 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
57 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
58 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
59 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
60 | private fun selectUsers(stmt: PreparedStatement) = sequence { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
61 | stmt.executeQuery().use { rs -> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
62 | while (rs.next()) selectUserInfo(rs)?.let { yield(it) } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
63 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
64 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
65 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
66 | //language=SQL |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
67 | private val userQuery = "select userid, username, lastname, givenname, mail from lpit_user" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
68 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
69 | private val stmtUsers by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
70 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
71 | """${userQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
72 | where userid > 0 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
73 | order by username |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
74 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
75 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
76 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
77 | private val stmtUserByID by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
78 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
79 | """${userQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
80 | where userid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
81 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
82 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
83 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
84 | private val stmtUserByName by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
85 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
86 | """${userQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
87 | where lower(username) = lower(?) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
88 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
89 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
90 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
91 | private val stmtInsertUser by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
92 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
93 | "insert into lpit_user (username, lastname, givenname, mail) values (?, ?, ?, ?)" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
94 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
95 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
96 | private val stmtUpdateUser by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
97 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
98 | "update lpit_user set lastname = ?, givenname = ?, mail = ? where userid = ?" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
99 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
100 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
101 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
102 | override fun listUsers() = selectUsers(stmtUsers).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
103 | override fun findUser(id: Int): User? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
104 | stmtUserByID.setInt(1, id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
105 | return selectUsers(stmtUserByID).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
106 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
107 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
108 | override fun findUserByName(username: String): User? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
109 | stmtUserByName.setString(1, username) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
110 | return selectUsers(stmtUserByName).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
111 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
112 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
113 | override fun insertUser(user: User) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
114 | with(user) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
115 | stmtInsertUser.setStringSafe(1, username) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
116 | stmtInsertUser.setStringOrNull(2, lastname) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
117 | stmtInsertUser.setStringOrNull(3, givenname) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
118 | stmtInsertUser.setStringOrNull(4, mail) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
119 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
120 | stmtInsertUser.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
121 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
122 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
123 | override fun updateUser(user: User) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
124 | with(user) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
125 | stmtUpdateUser.setStringOrNull(1, lastname) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
126 | stmtUpdateUser.setStringOrNull(2, givenname) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
127 | stmtUpdateUser.setStringOrNull(3, mail) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
128 | stmtUpdateUser.setInt(4, id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
129 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
130 | stmtUpdateUser.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
131 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
132 | //</editor-fold> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
133 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
134 | //<editor-fold desc="Version"> |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
135 | |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
136 | private fun obtainVersion(rs: ResultSet) = |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
137 | Version(rs.getInt("versionid"), rs.getInt("project")).apply { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
138 | name = rs.getString("name") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
139 | node = rs.getString("node") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
140 | ordinal = rs.getInt("ordinal") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
141 | status = rs.getEnum("status") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
142 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
143 | |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
144 | private fun selectVersions(stmt: PreparedStatement) = sequence { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
145 | stmt.executeQuery().use { rs -> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
146 | while (rs.next()) { |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
147 | yield(obtainVersion(rs)) |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
148 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
149 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
150 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
151 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
152 | private fun setVersionFields(stmt: PreparedStatement, obj: Version): Int { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
153 | with(obj) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
154 | stmt.setStringSafe(1, name) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
155 | stmt.setStringSafe(2, node) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
156 | stmt.setInt(3, ordinal) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
157 | stmt.setEnum(4, status) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
158 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
159 | return 5 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
160 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
161 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
162 | //language=SQL |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
163 | private val versionQuery = "select versionid, project, name, node, ordinal, status from lpit_version" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
164 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
165 | private val stmtVersions by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
166 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
167 | """${versionQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
168 | where project = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
169 | order by ordinal desc, lower(name) desc |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
170 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
171 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
172 | } |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
173 | private val stmtVersionSummaries by lazy { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
174 | connection.prepareStatement( |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
175 | """ |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
176 | with version_map(issueid, versionid, isresolved) as ( |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
177 | select issueid, versionid, 1 |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
178 | from lpit_issue_resolved_version |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
179 | union |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
180 | select issueid, versionid, 0 |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
181 | from lpit_issue_affected_version |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
182 | ), |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
183 | issues as ( |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
184 | select versionid, phase, isresolved, count(issueid) as total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
185 | from lpit_issue |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
186 | join version_map using (issueid) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
187 | join lpit_issue_phases using (status) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
188 | group by versionid, phase, isresolved |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
189 | ), |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
190 | summary as ( |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
191 | select versionid, phase, isresolved, total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
192 | from lpit_version v |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
193 | left join issues using (versionid) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
194 | where v.project = ? |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
195 | ) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
196 | select versionid, project, name, node, ordinal, status, phase, isresolved, total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
197 | from lpit_version |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
198 | join summary using (versionid) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
199 | order by ordinal, name |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
200 | """ |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
201 | ) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
202 | } |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
203 | private val stmtVersionByID by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
204 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
205 | """${versionQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
206 | where versionid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
207 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
208 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
209 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
210 | private val stmtVersionByNode by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
211 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
212 | """${versionQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
213 | where project = ? and node = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
214 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
215 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
216 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
217 | private val stmtInsertVersion by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
218 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
219 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
220 | insert into lpit_version (name, node, ordinal, status, project) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
221 | values (?, ?, ?, ?::version_status, ?) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
222 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
223 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
224 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
225 | private val stmtUpdateVersion by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
226 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
227 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
228 | update lpit_version set name = ?, node = ?, ordinal = ?, status = ?::version_status |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
229 | where versionid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
230 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
231 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
232 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
233 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
234 | override fun listVersions(project: Project): List<Version> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
235 | stmtVersions.setInt(1, project.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
236 | return selectVersions(stmtVersions).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
237 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
238 | |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
239 | override fun listVersionSummaries(project: Project): List<VersionSummary> { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
240 | stmtVersionSummaries.setInt(1, project.id) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
241 | return sequence { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
242 | stmtVersionSummaries.executeQuery().use { rs -> |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
243 | while (rs.next()) { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
244 | val versionSummary = VersionSummary(obtainVersion(rs)) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
245 | val phase = rs.getInt("phase") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
246 | val total = rs.getInt("total") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
247 | val issueSummary = |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
248 | if (rs.getBoolean("isresolved")) versionSummary.resolvedTotal else versionSummary.reportedTotal |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
249 | when (phase) { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
250 | 0 -> issueSummary.open = total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
251 | 1 -> issueSummary.active = total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
252 | 2 -> issueSummary.done = total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
253 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
254 | yield(versionSummary) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
255 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
256 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
257 | }.toList() |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
258 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
259 | |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
260 | override fun findVersion(id: Int): Version? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
261 | stmtVersionByID.setInt(1, id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
262 | return selectVersions(stmtVersionByID).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
263 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
264 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
265 | override fun findVersionByNode(project: Project, node: String): Version? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
266 | stmtVersionByNode.setInt(1, project.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
267 | stmtVersionByNode.setString(2, node) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
268 | return selectVersions(stmtVersionByNode).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
269 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
270 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
271 | override fun insertVersion(version: Version) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
272 | val col = setVersionFields(stmtInsertVersion, version) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
273 | stmtInsertVersion.setInt(col, version.projectid) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
274 | stmtInsertVersion.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
275 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
276 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
277 | override fun updateVersion(version: Version) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
278 | val col = setVersionFields(stmtUpdateVersion, version) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
279 | stmtUpdateVersion.setInt(col, version.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
280 | stmtUpdateVersion.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
281 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
282 | //</editor-fold> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
283 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
284 | //<editor-fold desc="Component"> |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
285 | |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
286 | private fun obtainComponent(rs: ResultSet): Component = |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
287 | Component(rs.getInt("id"), rs.getInt("project")).apply { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
288 | name = rs.getString("name") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
289 | node = rs.getString("node") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
290 | color = try { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
291 | WebColor(rs.getString("color")) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
292 | } catch (ex: IllegalArgumentException) { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
293 | WebColor("000000") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
294 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
295 | ordinal = rs.getInt("ordinal") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
296 | description = rs.getString("description") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
297 | lead = selectUserInfo(rs) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
298 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
299 | |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
300 | private fun selectComponents(stmt: PreparedStatement) = sequence { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
301 | stmt.executeQuery().use { rs -> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
302 | while (rs.next()) { |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
303 | yield(obtainComponent(rs)) |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
304 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
305 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
306 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
307 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
308 | private fun setComponentFields(stmt: PreparedStatement, obj: Component): Int { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
309 | with(obj) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
310 | stmt.setStringSafe(1, name) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
311 | stmt.setStringSafe(2, node) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
312 | stmt.setStringSafe(3, color.hex) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
313 | stmt.setInt(4, ordinal) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
314 | stmt.setStringOrNull(5, description) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
315 | stmt.setIntOrNull(6, obj.lead?.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
316 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
317 | return 7 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
318 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
319 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
320 | //language=SQL |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
321 | private val componentQuery = |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
322 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
323 | select id, project, name, node, color, ordinal, description, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
324 | userid, username, givenname, lastname, mail |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
325 | from lpit_component |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
326 | left join lpit_user on lead = userid |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
327 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
328 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
329 | private val stmtComponents by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
330 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
331 | """${componentQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
332 | where project = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
333 | order by ordinal, lower(name) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
334 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
335 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
336 | } |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
337 | private val stmtComponentSummaries by lazy { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
338 | connection.prepareStatement( |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
339 | """ |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
340 | with issues as ( |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
341 | select component, phase, count(issueid) as total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
342 | from lpit_issue |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
343 | join lpit_issue_phases using (status) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
344 | group by component, phase |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
345 | ), |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
346 | summary as ( |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
347 | select c.id, phase, total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
348 | from lpit_component c |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
349 | left join issues i on c.id = i.component |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
350 | where c.project = ? |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
351 | ) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
352 | select c.id, project, name, node, color, ordinal, description, |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
353 | userid, username, givenname, lastname, mail, phase, total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
354 | from lpit_component c |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
355 | left join lpit_user on lead = userid |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
356 | join summary s on c.id = s.id |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
357 | order by ordinal, name |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
358 | """ |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
359 | ) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
360 | } |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
361 | private val stmtComponentById by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
362 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
363 | """${componentQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
364 | where id = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
365 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
366 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
367 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
368 | private val stmtComponentByNode by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
369 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
370 | """${componentQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
371 | where project = ? and node = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
372 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
373 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
374 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
375 | private val stmtInsertComponent by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
376 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
377 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
378 | insert into lpit_component (name, node, color, ordinal, description, lead, project) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
379 | values (?, ?, ?, ?, ?, ?, ?) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
380 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
381 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
382 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
383 | private val stmtUpdateComponent by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
384 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
385 | "update lpit_component set name = ?, node = ?, color = ?, ordinal = ?, description = ?, lead = ? where id = ?" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
386 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
387 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
388 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
389 | override fun listComponents(project: Project): List<Component> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
390 | stmtComponents.setInt(1, project.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
391 | return selectComponents(stmtComponents).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
392 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
393 | |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
394 | override fun listComponentSummaries(project: Project): List<ComponentSummary> { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
395 | stmtComponentSummaries.setInt(1, project.id) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
396 | return sequence { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
397 | stmtComponentSummaries.executeQuery().use { rs -> |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
398 | while (rs.next()) { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
399 | val componentSummary = ComponentSummary(obtainComponent(rs)) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
400 | val phase = rs.getInt("phase") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
401 | val total = rs.getInt("total") |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
402 | when (phase) { |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
403 | 0 -> componentSummary.issueSummary.open = total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
404 | 1 -> componentSummary.issueSummary.active = total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
405 | 2 -> componentSummary.issueSummary.done = total |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
406 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
407 | yield(componentSummary) |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
408 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
409 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
410 | }.toList() |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
411 | } |
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
412 | |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
413 | override fun findComponent(id: Int): Component? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
414 | stmtComponentById.setInt(1, id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
415 | return selectComponents(stmtComponentById).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
416 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
417 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
418 | override fun findComponentByNode(project: Project, node: String): Component? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
419 | stmtComponentByNode.setInt(1, project.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
420 | stmtComponentByNode.setString(2, node) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
421 | return selectComponents(stmtComponentByNode).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
422 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
423 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
424 | override fun insertComponent(component: Component) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
425 | val col = setComponentFields(stmtInsertComponent, component) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
426 | stmtInsertComponent.setInt(col, component.projectid) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
427 | stmtInsertComponent.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
428 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
429 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
430 | override fun updateComponent(component: Component) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
431 | val col = setComponentFields(stmtUpdateComponent, component) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
432 | stmtUpdateComponent.setInt(col, component.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
433 | stmtUpdateComponent.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
434 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
435 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
436 | //</editor-fold> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
437 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
438 | //<editor-fold desc="Project"> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
439 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
440 | private fun selectProjects(stmt: PreparedStatement) = sequence { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
441 | stmt.executeQuery().use { rs -> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
442 | while (rs.next()) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
443 | yield(Project(rs.getInt("projectid")).apply { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
444 | name = rs.getString("name") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
445 | node = rs.getString("node") |
175
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
446 | ordinal = rs.getInt("ordinal") |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
447 | description = rs.getString("description") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
448 | repoUrl = rs.getString("repourl") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
449 | owner = selectUserInfo(rs) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
450 | }) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
451 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
452 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
453 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
454 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
455 | private fun setProjectFields(stmt: PreparedStatement, obj: Project): Int { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
456 | with(obj) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
457 | stmt.setStringSafe(1, name) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
458 | stmt.setStringSafe(2, node) |
175
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
459 | stmt.setInt(3, ordinal) |
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
460 | stmt.setStringOrNull(4, description) |
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
461 | stmt.setStringOrNull(5, repoUrl) |
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
462 | stmt.setIntOrNull(6, owner?.id) |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
463 | } |
175
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
464 | return 7 |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
465 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
466 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
467 | //language=SQL |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
468 | private val projectQuery = |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
469 | """ |
175
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
470 | select projectid, name, node, ordinal, description, repourl, |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
471 | userid, username, lastname, givenname, mail |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
472 | from lpit_project |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
473 | left join lpit_user owner on lpit_project.owner = owner.userid |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
474 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
475 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
476 | private val stmtProjects by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
477 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
478 | """${projectQuery} |
175
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
479 | order by ordinal, lower(name) |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
480 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
481 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
482 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
483 | private val stmtProjectByID by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
484 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
485 | """${projectQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
486 | where projectid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
487 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
488 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
489 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
490 | private val stmtProjectByNode by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
491 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
492 | """${projectQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
493 | where node = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
494 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
495 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
496 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
497 | private val stmtInsertProject by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
498 | connection.prepareStatement( |
175
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
499 | "insert into lpit_project (name, node, ordinal, description, repourl, owner) values (?, ?, ?, ?, ?, ?)" |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
500 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
501 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
502 | private val stmtUpdateProject by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
503 | connection.prepareStatement( |
175
1e6f2aace666
adds project ordering - fixes #34
Mike Becker <universe@uap-core.de>
parents:
167
diff
changeset
|
504 | "update lpit_project set name = ?, node = ?, ordinal = ?, description = ?, repourl = ?, owner = ? where projectid = ?" |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
505 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
506 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
507 | private val stmtIssueSummary by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
508 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
509 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
510 | select phase, count(*) as total |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
511 | from lpit_issue |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
512 | join lpit_issue_phases using(status) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
513 | where project = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
514 | group by phase |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
515 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
516 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
517 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
518 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
519 | override fun listProjects(): List<Project> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
520 | return selectProjects(stmtProjects).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
521 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
522 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
523 | override fun findProject(id: Int): Project? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
524 | stmtProjectByID.setInt(1, id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
525 | return selectProjects(stmtProjectByID).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
526 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
527 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
528 | override fun findProjectByNode(node: String): Project? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
529 | stmtProjectByNode.setString(1, node) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
530 | return selectProjects(stmtProjectByNode).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
531 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
532 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
533 | override fun insertProject(project: Project) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
534 | setProjectFields(stmtInsertProject, project) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
535 | stmtInsertProject.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
536 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
537 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
538 | override fun updateProject(project: Project) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
539 | val col = setProjectFields(stmtUpdateProject, project) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
540 | stmtUpdateProject.setInt(col, project.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
541 | stmtUpdateProject.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
542 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
543 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
544 | override fun collectIssueSummary(project: Project): IssueSummary { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
545 | stmtIssueSummary.setInt(1, project.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
546 | return stmtIssueSummary.executeQuery().use { rs -> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
547 | val summary = IssueSummary() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
548 | while (rs.next()) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
549 | val phase = rs.getInt("phase") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
550 | val total = rs.getInt("total") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
551 | when (phase) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
552 | 0 -> summary.open = total |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
553 | 1 -> summary.active = total |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
554 | 2 -> summary.done = total |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
555 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
556 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
557 | summary |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
558 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
559 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
560 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
561 | //</editor-fold> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
562 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
563 | //<editor-fold desc="Issue"> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
564 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
565 | private fun selectIssues(stmt: PreparedStatement) = sequence { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
566 | stmt.executeQuery().use { rs -> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
567 | while (rs.next()) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
568 | val proj = Project(rs.getInt("project")).apply { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
569 | name = rs.getString("projectname") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
570 | node = rs.getString("projectnode") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
571 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
572 | val comp = rs.getInt("component").let { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
573 | if (rs.wasNull()) null else |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
574 | Component(it, proj.id).apply { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
575 | name = rs.getString("componentname") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
576 | node = rs.getString("componentnode") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
577 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
578 | } |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
579 | val issue = Issue(rs.getInt("issueid"), proj).apply { |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
580 | component = comp |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
581 | status = rs.getEnum("status") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
582 | category = rs.getEnum("category") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
583 | subject = rs.getString("subject") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
584 | description = rs.getString("description") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
585 | assignee = selectUserInfo(rs) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
586 | created = rs.getTimestamp("created") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
587 | updated = rs.getTimestamp("updated") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
588 | eta = rs.getDate("eta") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
589 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
590 | queryAffectedVersions.setInt(1, issue.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
591 | issue.affectedVersions = selectVersions(queryAffectedVersions).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
592 | queryResolvedVersions.setInt(1, issue.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
593 | issue.resolvedVersions = selectVersions(queryResolvedVersions).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
594 | yield(issue) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
595 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
596 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
597 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
598 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
599 | private fun setIssueFields(stmt: PreparedStatement, obj: Issue): Int { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
600 | with(obj) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
601 | stmt.setIntOrNull(1, component?.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
602 | stmt.setEnum(2, status) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
603 | stmt.setEnum(3, category) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
604 | stmt.setStringSafe(4, subject) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
605 | stmt.setStringOrNull(5, description) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
606 | stmt.setIntOrNull(6, assignee?.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
607 | stmt.setDateOrNull(7, eta) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
608 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
609 | return 8 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
610 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
611 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
612 | //language=SQL |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
613 | private val issueQuery = |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
614 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
615 | select issueid, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
616 | i.project, p.name as projectname, p.node as projectnode, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
617 | component, c.name as componentname, c.node as componentnode, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
618 | status, category, subject, i.description, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
619 | userid, username, givenname, lastname, mail, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
620 | created, updated, eta |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
621 | from lpit_issue i |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
622 | join lpit_project p on i.project = projectid |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
623 | left join lpit_component c on component = c.id |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
624 | left join lpit_user on userid = assignee |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
625 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
626 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
627 | private val queryResolvedVersions by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
628 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
629 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
630 | select versionid, project, name, status, ordinal, node |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
631 | from lpit_version v join lpit_issue_resolved_version using (versionid) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
632 | where issueid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
633 | order by ordinal, name |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
634 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
635 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
636 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
637 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
638 | private val queryAffectedVersions by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
639 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
640 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
641 | select versionid, project, name, status, ordinal, node |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
642 | from lpit_version join lpit_issue_affected_version using (versionid) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
643 | where issueid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
644 | order by ordinal, name |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
645 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
646 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
647 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
648 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
649 | private val stmtIssues by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
650 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
651 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
652 | with issue_version as ( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
653 | select issueid, versionid from lpit_issue_affected_version |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
654 | union select issueid, versionid from lpit_issue_resolved_version |
183
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
655 | ), |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
656 | filteterd_issues as ( |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
657 | select distinct issueid from lpit_issue |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
658 | left join issue_version using (issueid) |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
659 | where |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
660 | (not ? or project = ?) and |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
661 | (not ? or versionid = ?) and (not ? or versionid is null) and |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
662 | (not ? or component = ?) and (not ? or component is null) |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
663 | ) |
61669abf277f
fixes issue query returning issues more than once
Mike Becker <universe@uap-core.de>
parents:
180
diff
changeset
|
664 | ${issueQuery} join filteterd_issues using (issueid) |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
665 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
666 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
667 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
668 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
669 | private val fproj = 1 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
670 | private val projectid = 2 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
671 | private val fversion = 3 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
672 | private val versionid = 4 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
673 | private val nversion = 5 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
674 | private val fcomp = 6 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
675 | private val component = 7 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
676 | private val ncomp = 8 |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
677 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
678 | private fun <T : Entity> applyFilter(filter: Filter<T>, fflag: Int, nflag: Int, idcol: Int) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
679 | when (filter) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
680 | is AllFilter -> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
681 | stmtIssues.setBoolean(fflag, false) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
682 | stmtIssues.setBoolean(nflag, false) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
683 | stmtIssues.setInt(idcol, 0) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
684 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
685 | is NoneFilter -> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
686 | stmtIssues.setBoolean(fflag, false) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
687 | stmtIssues.setBoolean(nflag, true) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
688 | stmtIssues.setInt(idcol, 0) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
689 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
690 | is SpecificFilter -> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
691 | stmtIssues.setBoolean(fflag, true) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
692 | stmtIssues.setBoolean(nflag, false) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
693 | stmtIssues.setInt(idcol, filter.obj.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
694 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
695 | else -> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
696 | TODO("Implement range filter.") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
697 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
698 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
699 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
700 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
701 | override fun listIssues(filter: IssueFilter): List<Issue> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
702 | when (filter.project) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
703 | is AllFilter -> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
704 | stmtIssues.setBoolean(fproj, false) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
705 | stmtIssues.setInt(projectid, 0) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
706 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
707 | is SpecificFilter -> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
708 | stmtIssues.setBoolean(fproj, true) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
709 | stmtIssues.setInt(projectid, filter.project.obj.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
710 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
711 | else -> throw IllegalArgumentException() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
712 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
713 | applyFilter(filter.version, fversion, nversion, versionid) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
714 | applyFilter(filter.component, fcomp, ncomp, component) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
715 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
716 | return selectIssues(stmtIssues).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
717 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
718 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
719 | private val stmtFindIssueByID by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
720 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
721 | """${issueQuery} |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
722 | where issueid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
723 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
724 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
725 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
726 | private val stmtInsertIssue by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
727 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
728 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
729 | insert into lpit_issue (component, status, category, subject, description, assignee, eta, project) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
730 | values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?, ?) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
731 | returning issueid |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
732 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
733 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
734 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
735 | private val stmtUpdateIssue by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
736 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
737 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
738 | update lpit_issue set updated = now(), |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
739 | component = ?, status = ?::issue_status, category = ?::issue_category, subject = ?, |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
740 | description = ?, assignee = ?, eta = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
741 | where issueid = ? |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
742 | """ |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
743 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
744 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
745 | private val stmtInsertAffectedVersion by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
746 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
747 | "insert into lpit_issue_affected_version (issueid, versionid) values (?,?)" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
748 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
749 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
750 | private val stmtInsertResolvedVersion by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
751 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
752 | "insert into lpit_issue_resolved_version (issueid, versionid) values (?,?)" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
753 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
754 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
755 | private val stmtClearAffectedVersions by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
756 | connection.prepareStatement("delete from lpit_issue_affected_version where issueid = ?") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
757 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
758 | private val stmtClearResolvedVersions by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
759 | connection.prepareStatement("delete from lpit_issue_resolved_version where issueid = ?") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
760 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
761 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
762 | override fun findIssue(id: Int): Issue? { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
763 | stmtFindIssueByID.setInt(1, id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
764 | return selectIssues(stmtFindIssueByID).firstOrNull() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
765 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
766 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
767 | private fun insertVersionInfo(issue: Issue) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
768 | stmtInsertAffectedVersion.setInt(1, issue.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
769 | stmtInsertResolvedVersion.setInt(1, issue.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
770 | issue.affectedVersions.forEach { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
771 | stmtInsertAffectedVersion.setInt(2, it.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
772 | stmtInsertAffectedVersion.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
773 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
774 | issue.resolvedVersions.forEach { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
775 | stmtInsertResolvedVersion.setInt(2, it.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
776 | stmtInsertResolvedVersion.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
777 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
778 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
779 | |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
780 | override fun insertIssue(issue: Issue): Int { |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
781 | val col = setIssueFields(stmtInsertIssue, issue) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
782 | stmtInsertIssue.setInt(col, issue.project.id) |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
783 | val id = stmtInsertIssue.executeQuery().use { rs -> |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
784 | rs.next() |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
785 | rs.getInt(1) |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
786 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
787 | insertVersionInfo(issue) |
184
e8eecee6aadf
completes kotlin migration
Mike Becker <universe@uap-core.de>
parents:
183
diff
changeset
|
788 | return id |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
789 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
790 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
791 | override fun updateIssue(issue: Issue) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
792 | val col = setIssueFields(stmtUpdateIssue, issue) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
793 | stmtUpdateIssue.setInt(col, issue.id) |
176
4da5b783aa2d
fixes missing execute() in updateIssue()
Mike Becker <universe@uap-core.de>
parents:
175
diff
changeset
|
794 | stmtUpdateIssue.execute() |
167
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
795 | // TODO: improve by only inserting / deleting changed version information |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
796 | stmtClearAffectedVersions.setInt(1, issue.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
797 | stmtClearResolvedVersions.setInt(1, issue.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
798 | stmtClearAffectedVersions.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
799 | stmtClearResolvedVersions.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
800 | insertVersionInfo(issue) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
801 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
802 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
803 | //</editor-fold> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
804 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
805 | //<editor-fold desc="IssueComment"> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
806 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
807 | private fun selectComments(stmt: PreparedStatement) = sequence { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
808 | stmt.executeQuery().use { rs -> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
809 | while (rs.next()) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
810 | yield(IssueComment(rs.getInt("commentid"), rs.getInt("issueid")).apply { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
811 | created = rs.getTimestamp("created") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
812 | updated = rs.getTimestamp("updated") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
813 | updateCount = rs.getInt("updatecount") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
814 | comment = rs.getString("comment") |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
815 | author = selectUserInfo(rs) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
816 | }) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
817 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
818 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
819 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
820 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
821 | private val stmtComments by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
822 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
823 | "select * from lpit_issue_comment left join lpit_user using (userid) where issueid = ? order by created" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
824 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
825 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
826 | private val stmtInsertComment by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
827 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
828 | "insert into lpit_issue_comment (issueid, comment, userid) values (?, ? ,?)" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
829 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
830 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
831 | private val stmtUpdateIssueDate by lazy { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
832 | connection.prepareStatement( |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
833 | "update lpit_issue set updated = now() where issueid = ?" |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
834 | ) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
835 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
836 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
837 | override fun listComments(issue: Issue): List<IssueComment> { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
838 | stmtComments.setInt(1, issue.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
839 | return selectComments(stmtComments).toList() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
840 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
841 | |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
842 | override fun insertComment(issueComment: IssueComment) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
843 | with(issueComment) { |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
844 | stmtUpdateIssueDate.setInt(1, issueid) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
845 | stmtInsertComment.setInt(1, issueid) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
846 | stmtInsertComment.setStringSafe(2, comment) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
847 | stmtInsertComment.setIntOrNull(3, author?.id) |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
848 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
849 | stmtInsertComment.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
850 | stmtUpdateIssueDate.execute() |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
851 | } |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
852 | //</editor-fold> |
3f30adba1c63
major refactoring of DAO architecture - also fixes #114
Mike Becker <universe@uap-core.de>
parents:
diff
changeset
|
853 | } |