1.1 --- a/src/main/java/de/uapcore/lightpit/dao/Functions.java Sun Dec 20 11:06:25 2020 +0100
1.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000
1.3 @@ -1,101 +0,0 @@
1.4 -/*
1.5 - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
1.6 - *
1.7 - * Copyright 2018 Mike Becker. All rights reserved.
1.8 - *
1.9 - * Redistribution and use in source and binary forms, with or without
1.10 - * modification, are permitted provided that the following conditions are met:
1.11 - *
1.12 - * 1. Redistributions of source code must retain the above copyright
1.13 - * notice, this list of conditions and the following disclaimer.
1.14 - *
1.15 - * 2. Redistributions in binary form must reproduce the above copyright
1.16 - * notice, this list of conditions and the following disclaimer in the
1.17 - * documentation and/or other materials provided with the distribution.
1.18 - *
1.19 - * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
1.20 - * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
1.21 - * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
1.22 - * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
1.23 - * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
1.24 - * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
1.25 - * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
1.26 - * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
1.27 - * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
1.28 - * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
1.29 - * POSSIBILITY OF SUCH DAMAGE.
1.30 - *
1.31 - */
1.32 -package de.uapcore.lightpit.dao;
1.33 -
1.34 -import java.sql.*;
1.35 -import java.util.ArrayList;
1.36 -import java.util.List;
1.37 -import java.util.Optional;
1.38 -import java.util.function.Function;
1.39 -
1.40 -/**
1.41 - * Some DAO utilities.
1.42 - */
1.43 -public final class Functions {
1.44 -
1.45 - public static String getSafeString(ResultSet rs, String column) throws SQLException {
1.46 - return Optional.ofNullable(rs.getString(column)).orElse("");
1.47 - }
1.48 -
1.49 - public static void setStringOrNull(PreparedStatement stmt, int index, String str) throws SQLException {
1.50 - if (str == null || str.isBlank()) {
1.51 - stmt.setNull(index, Types.VARCHAR);
1.52 - } else {
1.53 - stmt.setString(index, str);
1.54 - }
1.55 - }
1.56 -
1.57 - public static void setDateOrNull(PreparedStatement stmt, int index, Date date) throws SQLException {
1.58 - if (date == null) {
1.59 - stmt.setNull(index, Types.DATE);
1.60 - } else {
1.61 - stmt.setDate(index, date);
1.62 - }
1.63 - }
1.64 -
1.65 - public static <T> void setForeignKeyOrNull(PreparedStatement stmt, int index, T instance, Function<? super T, Integer> keyGetter) throws SQLException {
1.66 - Integer key = Optional.ofNullable(instance).map(keyGetter).orElse(null);
1.67 - if (key == null) {
1.68 - stmt.setNull(index, Types.INTEGER);
1.69 - } else {
1.70 - stmt.setInt(index, key);
1.71 - }
1.72 - }
1.73 -
1.74 - @FunctionalInterface
1.75 - public interface ResultSetMapper<T> {
1.76 - T apply(ResultSet rs) throws SQLException;
1.77 - }
1.78 -
1.79 - public static <T> List<T> list(PreparedStatement stmt, ResultSetMapper<T> mapper) throws SQLException {
1.80 - List<T> results = new ArrayList<>();
1.81 - try (var result = stmt.executeQuery()) {
1.82 - while (result.next()) {
1.83 - final var project = mapper.apply(result);
1.84 - results.add(project);
1.85 - }
1.86 - }
1.87 - return results;
1.88 - }
1.89 -
1.90 - public static <T> T find(PreparedStatement stmt, ResultSetMapper<T> mapper) throws SQLException {
1.91 - try (var result = stmt.executeQuery()) {
1.92 - if (result.next()) {
1.93 - final var ent = mapper.apply(result);
1.94 - return ent;
1.95 - } else {
1.96 - return null;
1.97 - }
1.98 - }
1.99 - }
1.100 -
1.101 - private Functions() {
1.102 -
1.103 - }
1.104 -}
