Mercurial > hg > LightPIT / file diff

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/main/kotlin/de/uapcore/lightpit/dao/Extensions.kt	Mon Dec 21 18:29:34 2020 +0100
@@ -0,0 +1,64 @@
+/*
+ * Copyright 2020 Mike Becker. All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * 1. Redistributions of source code must retain the above copyright
+ * notice, this list of conditions and the following disclaimer.
+ *
+ * 2. Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
+ * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
+ * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
+ * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
+ * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
+ * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
+ * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ */
+
+package de.uapcore.lightpit.dao
+
+import java.sql.Date
+import java.sql.PreparedStatement
+import java.sql.ResultSet
+import java.sql.Types
+
+fun PreparedStatement.setStringSafe(idx: Int, str: String) {
+    setString(idx, str)
+}
+
+fun PreparedStatement.setStringOrNull(idx: Int, str: String?) {
+    when (str) {
+        null -> setNull(idx, Types.VARCHAR)
+        else -> setString(idx, str)
+    }
+}
+
+fun PreparedStatement.setIntOrNull(idx: Int, value: Int?) {
+    when (value) {
+        null -> setNull(idx, Types.INTEGER)
+        else -> setInt(idx, value)
+    }
+}
+
+fun PreparedStatement.setDateOrNull(idx: Int, value: Date?) {
+    when (value) {
+        null -> setNull(idx, Types.DATE)
+        else -> setDate(idx, value)
+    }
+}
+
+fun <T : Enum<T>> PreparedStatement.setEnum(idx: Int, e: Enum<T>) {
+    setString(idx, e.name)
+}
+
+inline fun <reified T : Enum<T>> ResultSet.getEnum(col: String): T {
+    return enumValueOf(getString(col))
+}