1.1 --- a/src/main/kotlin/de/uapcore/lightpit/dao/AbstractDao.kt Sun Dec 20 11:06:25 2020 +0100
1.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000
1.3 @@ -1,65 +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
1.31 -
1.32 -import java.sql.PreparedStatement
1.33 -import java.sql.ResultSet
1.34 -import java.sql.Types
1.35 -
1.36 -abstract class AbstractDao<T> {
1.37 -
1.38 - abstract fun mapResult(rs: ResultSet): T
1.39 -
1.40 - protected fun list(stmt: PreparedStatement): List<T> {
1.41 - return sequence {
1.42 - stmt.executeQuery().use { result ->
1.43 - while (result.next()) yield(mapResult(result))
1.44 - }
1.45 - }.toList()
1.46 - }
1.47 -
1.48 - protected fun find(stmt: PreparedStatement): T? {
1.49 - stmt.executeQuery().use { result ->
1.50 - return if (result.next()) {
1.51 - mapResult(result)
1.52 - } else {
1.53 - null
1.54 - }
1.55 - }
1.56 - }
1.57 -
1.58 - // TODO: create PreparedStatement abstraction that provides some features
1.59 -
1.60 - // TODO: remove the following legacy code helper function
1.61 - protected fun <T> setForeignKeyOrNull(stmt: PreparedStatement, index: Int, instance: T?, keyGetter: (obj: T) -> Int) {
1.62 - if (instance == null) {
1.63 - stmt.setNull(index, Types.INTEGER)
1.64 - } else {
1.65 - stmt.setInt(index, keyGetter(instance))
1.66 - }
1.67 - }
1.68 -}
1.69 \ No newline at end of file
