src/main/kotlin/de/uapcore/lightpit/dao/Extensions.kt@009700915269 (annotated)
src/main/kotlin/de/uapcore/lightpit/dao/Extensions.kt
Wed, 06 Jan 2021 15:39:56 +0100
- author
- Mike Becker <universe@uap-core.de>
- date
- Wed, 06 Jan 2021 15:39:56 +0100
- changeset 180
- 009700915269
- parent 167
- 3f30adba1c63
- permissions
- -rw-r--r--
merge resource bundles
| universe@167 | 1 | /* |
| universe@180 | 2 | * Copyright 2021 Mike Becker. All rights reserved. |
| universe@167 | 3 | * |
| universe@167 | 4 | * Redistribution and use in source and binary forms, with or without |
| universe@167 | 5 | * modification, are permitted provided that the following conditions are met: |
| universe@167 | 6 | * |
| universe@167 | 7 | * 1. Redistributions of source code must retain the above copyright |
| universe@167 | 8 | * notice, this list of conditions and the following disclaimer. |
| universe@167 | 9 | * |
| universe@167 | 10 | * 2. Redistributions in binary form must reproduce the above copyright |
| universe@167 | 11 | * notice, this list of conditions and the following disclaimer in the |
| universe@167 | 12 | * documentation and/or other materials provided with the distribution. |
| universe@167 | 13 | * |
| universe@167 | 14 | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" |
| universe@167 | 15 | * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE |
| universe@167 | 16 | * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE |
| universe@167 | 17 | * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE |
| universe@167 | 18 | * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL |
| universe@167 | 19 | * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR |
| universe@167 | 20 | * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER |
| universe@167 | 21 | * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, |
| universe@167 | 22 | * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
| universe@167 | 23 | * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| universe@167 | 24 | */ |
| universe@167 | 25 | |
| universe@167 | 26 | package de.uapcore.lightpit.dao |
| universe@167 | 27 | |
| universe@167 | 28 | import java.sql.Date |
| universe@167 | 29 | import java.sql.PreparedStatement |
| universe@167 | 30 | import java.sql.ResultSet |
| universe@167 | 31 | import java.sql.Types |
| universe@167 | 32 | |
| universe@167 | 33 | fun PreparedStatement.setStringSafe(idx: Int, str: String) { |
| universe@167 | 34 | setString(idx, str) |
| universe@167 | 35 | } |
| universe@167 | 36 | |
| universe@167 | 37 | fun PreparedStatement.setStringOrNull(idx: Int, str: String?) { |
| universe@167 | 38 | when (str) { |
| universe@167 | 39 | null -> setNull(idx, Types.VARCHAR) |
| universe@167 | 40 | else -> setString(idx, str) |
| universe@167 | 41 | } |
| universe@167 | 42 | } |
| universe@167 | 43 | |
| universe@167 | 44 | fun PreparedStatement.setIntOrNull(idx: Int, value: Int?) { |
| universe@167 | 45 | when (value) { |
| universe@167 | 46 | null -> setNull(idx, Types.INTEGER) |
| universe@167 | 47 | else -> setInt(idx, value) |
| universe@167 | 48 | } |
| universe@167 | 49 | } |
| universe@167 | 50 | |
| universe@167 | 51 | fun PreparedStatement.setDateOrNull(idx: Int, value: Date?) { |
| universe@167 | 52 | when (value) { |
| universe@167 | 53 | null -> setNull(idx, Types.DATE) |
| universe@167 | 54 | else -> setDate(idx, value) |
| universe@167 | 55 | } |
| universe@167 | 56 | } |
| universe@167 | 57 | |
| universe@167 | 58 | fun <T : Enum<T>> PreparedStatement.setEnum(idx: Int, e: Enum<T>) { |
| universe@167 | 59 | setString(idx, e.name) |
| universe@167 | 60 | } |
| universe@167 | 61 | |
| universe@167 | 62 | inline fun <reified T : Enum<T>> ResultSet.getEnum(col: String): T { |
| universe@167 | 63 | return enumValueOf(getString(col)) |
| universe@167 | 64 | } |
