mike@159: /*
mike@159:  * Copyright 2020 Mike Becker. All rights reserved.
mike@159:  *
mike@159:  * Redistribution and use in source and binary forms, with or without
mike@159:  * modification, are permitted provided that the following conditions are met:
mike@159:  *
mike@159:  * 1. Redistributions of source code must retain the above copyright
mike@159:  * notice, this list of conditions and the following disclaimer.
mike@159:  *
mike@159:  * 2. Redistributions in binary form must reproduce the above copyright
mike@159:  * notice, this list of conditions and the following disclaimer in the
mike@159:  * documentation and/or other materials provided with the distribution.
mike@159:  *
mike@159:  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
mike@159:  * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
mike@159:  * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
mike@159:  * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
mike@159:  * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
mike@159:  * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
mike@159:  * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
mike@159:  * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
mike@159:  * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
mike@159:  * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
mike@159:  *
mike@159:  */
mike@159: 
mike@159: package de.uapcore.lightpit.dao.postgres
mike@159: 
mike@159: import de.uapcore.lightpit.dao.AbstractUserDao
mike@159: import de.uapcore.lightpit.dao.Functions
mike@159: import de.uapcore.lightpit.entities.User
mike@159: import java.sql.Connection
mike@159: import java.sql.ResultSet
mike@159: 
mike@159: class PGUserDao(connection: Connection) : AbstractUserDao() {
mike@159: 
mike@159:     companion object {
mike@159:         fun mapResult(rs: ResultSet): User {
mike@159:             val id = rs.getInt("userid")
mike@159:             return if (rs.wasNull()) {
mike@159:                 User(-1)
mike@159:             } else {
mike@159:                 val user = User(id)
mike@159:                 user.username = rs.getString("username")
mike@159:                 user.givenname = Functions.getSafeString(rs, "givenname")
mike@159:                 user.lastname = Functions.getSafeString(rs, "lastname")
mike@159:                 user.mail = Functions.getSafeString(rs, "mail")
mike@159:                 user
mike@159:             }
mike@159:         }
mike@159:     }
mike@159: 
mike@159:     private val listStmt = connection.prepareStatement(
mike@159:             "select userid, username, lastname, givenname, mail " +
mike@159:                     "from lpit_user where userid >= 0 " +
mike@159:                     "order by username")
mike@159:     private val findStmt = connection.prepareStatement(
mike@159:             "select userid, username, lastname, givenname, mail " +
mike@159:                     "from lpit_user where userid = ? ")
mike@159:     private val findByUsernameStmt = connection.prepareStatement(
mike@159:             "select userid, username, lastname, givenname, mail " +
mike@159:                     "from lpit_user where lower(username) = lower(?) ")
mike@159:     private val insertStmt = connection.prepareStatement("insert into lpit_user (username, lastname, givenname, mail) values (?, ?, ?, ?)")
mike@159:     private val updateStmt = connection.prepareStatement("update lpit_user set lastname = ?, givenname = ?, mail = ? where userid = ?")
mike@159: 
mike@159:     override fun mapResult(rs: ResultSet): User = Companion.mapResult(rs)
mike@159: 
mike@159:     override fun save(instance: User) {
mike@159:         insertStmt.setString(1, instance.username)
mike@159:         Functions.setStringOrNull(insertStmt, 2, instance.lastname)
mike@159:         Functions.setStringOrNull(insertStmt, 3, instance.givenname)
mike@159:         Functions.setStringOrNull(insertStmt, 4, instance.mail)
mike@159:         insertStmt.executeUpdate()
mike@159:     }
mike@159: 
mike@159:     override fun update(instance: User): Boolean {
mike@159:         Functions.setStringOrNull(updateStmt, 1, instance.lastname)
mike@159:         Functions.setStringOrNull(updateStmt, 2, instance.givenname)
mike@159:         Functions.setStringOrNull(updateStmt, 3, instance.mail)
mike@159:         updateStmt.setInt(4, instance.id)
mike@159:         return updateStmt.executeUpdate() > 0
mike@159:     }
mike@159: 
mike@159:     override fun list(): List<User> = super.list(listStmt)
mike@159: 
mike@159:     override fun find(id: Int): User? {
mike@159:         findStmt.setInt(1, id)
mike@159:         return super.find(findStmt)
mike@159:     }
mike@159: 
mike@159:     override fun findByUsername(username: String): User? {
mike@159:         findByUsernameStmt.setString(1, username)
mike@159:         return super.find(findByUsernameStmt)
mike@159:     }
mike@159: }