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