Mon, 05 Aug 2024 19:38:47 +0200
fix removing filter not working
fixes #407
/* * Copyright 2021 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)) }