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