1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/src/main/kotlin/de/uapcore/lightpit/dao/AbstractDao.kt Thu Nov 19 13:58:54 2020 +0100 1.3 @@ -0,0 +1,65 @@ 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