yosql-codegen/src/test/java/wtf/metio/yosql/codegen/dao/JdbcBlocksTCK.java

   1 /*
   2  * This file is part of yosql. It is subject to the license terms in the LICENSE file found in the top-level
   3  * directory of this distribution and at https://creativecommons.org/publicdomain/zero/1.0/. No part of yosql,
   4  * including this file, may be copied, modified, propagated, or distributed except according to the terms contained
   5  * in the LICENSE file.
   6  */
   7
   8 package wtf.metio.yosql.codegen.dao;
   9
  10 import org.junit.jupiter.api.Assertions;
  11 import org.junit.jupiter.api.Test;
  12 import wtf.metio.yosql.internals.testing.configs.SqlConfigurations;
  13 import wtf.metio.yosql.models.configuration.ResultRowConverter;
  14 import wtf.metio.yosql.models.immutables.SqlConfiguration;
  15
  16 /**
  17  * Verifies that {@link JdbcBlocks}s work correctly.
  18  */
  19 abstract class JdbcBlocksTCK {
  20
  21     /**
  22      * @return A new {@link JdbcBlocks}.
  23      */
  24     abstract JdbcBlocks generator();
  25
  26     abstract String getConnectionInlineExpectation();
  27
  28     abstract String prepareStatementInlineExpectation();
  29
  30     abstract String prepareCallInlineExpectation();
  31
  32     abstract String getMetaDataStatementExpectation();
  33
  34     abstract String executeQueryInlineExpectation();
  35
  36     abstract String returnExecuteUpdateWithReturnExpectation();
  37
  38     abstract String returnExecuteUpdateWithoutReturnExpectation();
  39
  40     abstract String executeBatchExpectation();
  41
  42     abstract String closeResultSetExpectation();
  43
  44     abstract String closePrepareStatementExpectation();
  45
  46     abstract String closeConnectionExpectation();
  47
  48     abstract String executeStatementExpectation();
  49
  50     abstract String openConnectionExpectation();
  51
  52     abstract String tryPrepareCallableExpectation();
  53
  54     abstract String createStatementExpectation();
  55
  56     abstract String prepareBatchExpectation();
  57
  58     abstract String pickVendorQueryExpectation();
  59
  60     abstract String logExecutedQueryExpectation();
  61
  62     abstract String logExecutedBatchQueryExpectation();
  63
  64     abstract String returnAsMultipleExpectation();
  65
  66     abstract String returnAsSingleExpectation();
  67
  68     abstract String returnAsSingleWithThrowExpectation();
  69
  70     abstract String setParametersExpectation();
  71
  72     abstract String setBatchParametersExpectation();
  73
  74     @Test
  75     final void getConnectionInline() {
  76         Assertions.assertEquals(
  77                 getConnectionInlineExpectation(),
  78                 generator().getConnectionInline().toString());
  79     }
  80
  81     @Test
  82     final void prepareStatementInline() {
  83         Assertions.assertEquals(
  84                 prepareStatementInlineExpectation(),
  85                 generator().prepareStatementInline().toString());
  86     }
  87
  88     @Test
  89     final void prepareCallInline() {
  90         Assertions.assertEquals(
  91                 prepareCallInlineExpectation(),
  92                 generator().prepareCallInline().toString());
  93     }
  94
  95     @Test
  96     final void getMetaDataStatement() {
  97         Assertions.assertEquals(
  98                 getMetaDataStatementExpectation(),
  99                 generator().getMetaDataStatement().toString());
 100     }
 101
 102     @Test
 103     final void executeQueryInline() {
 104         Assertions.assertEquals(
 105                 executeQueryInlineExpectation(),
 106                 generator().executeQueryInline().toString());
 107     }
 108
 109     @Test
 110     final void returnExecuteUpdateWithReturn() {
 111         Assertions.assertEquals(
 112                 returnExecuteUpdateWithReturnExpectation(),
 113                 generator().returnExecuteUpdate(SqlConfiguration.copyOf(SqlConfigurations.sqlConfiguration())
 114                         .withWritesReturnUpdateCount(true)).toString());
 115     }
 116
 117     @Test
 118     final void returnExecuteUpdateWithoutReturn() {
 119         Assertions.assertEquals(
 120                 returnExecuteUpdateWithoutReturnExpectation(),
 121                 generator().returnExecuteUpdate(SqlConfiguration.copyOf(SqlConfigurations.sqlConfiguration())
 122                         .withWritesReturnUpdateCount(false)).toString());
 123     }
 124
 125     @Test
 126     final void executeBatch() {
 127         Assertions.assertEquals(
 128                 executeBatchExpectation(),
 129                 generator().executeBatch().toString());
 130     }
 131
 132     @Test
 133     final void closeResultSet() {
 134         Assertions.assertEquals(
 135                 closeResultSetExpectation(),
 136                 generator().closeResultSet().toString());
 137     }
 138
 139     @Test
 140     final void closePrepareStatement() {
 141         Assertions.assertEquals(
 142                 closePrepareStatementExpectation(),
 143                 generator().closePrepareStatement().toString());
 144     }
 145
 146     @Test
 147     final void closeConnection() {
 148         Assertions.assertEquals(
 149                 closeConnectionExpectation(),
 150                 generator().closeConnection().toString());
 151     }
 152
 153     @Test
 154     final void executeStatement() {
 155         Assertions.assertEquals(
 156                 executeStatementExpectation(),
 157                 generator().executeStatement(SqlConfigurations.sqlConfiguration()).toString());
 158     }
 159
 160     @Test
 161     final void openConnection() {
 162         Assertions.assertEquals(
 163                 openConnectionExpectation(),
 164                 generator().openConnection().toString());
 165     }
 166
 167     @Test
 168     final void tryPrepareCallable() {
 169         Assertions.assertEquals(
 170                 tryPrepareCallableExpectation(),
 171                 generator().tryPrepareCallable().toString());
 172     }
 173
 174     @Test
 175     final void createStatement() {
 176         Assertions.assertEquals(
 177                 createStatementExpectation(),
 178                 generator().createStatement(SqlConfigurations.sqlConfiguration()).toString());
 179     }
 180
 181     @Test
 182     final void prepareBatch() {
 183         Assertions.assertEquals(
 184                 prepareBatchExpectation(),
 185                 generator().prepareBatch(SqlConfigurations.sqlConfiguration()).toString());
 186     }
 187
 188     @Test
 189     final void pickVendorQuery() {
 190         Assertions.assertEquals(
 191                 pickVendorQueryExpectation(),
 192                 generator().pickVendorQuery(SqlConfigurations.sqlStatement()).toString());
 193     }
 194
 195     @Test
 196     final void logExecutedQuery() {
 197         Assertions.assertEquals(
 198                 logExecutedQueryExpectation(),
 199                 generator().logExecutedQuery(SqlConfigurations.sqlConfiguration()).toString());
 200     }
 201
 202     @Test
 203     final void logExecutedBatchQuery() {
 204         Assertions.assertEquals(
 205                 logExecutedBatchQueryExpectation(),
 206                 generator().logExecutedBatchQuery(SqlConfigurations.sqlConfiguration()).toString());
 207     }
 208
 209     @Test
 210     final void returnAsMultiple() {
 211         final var converter = ResultRowConverter.builder()
 212                 .setAlias("converter")
 213                 .setConverterType("com.example.Converter")
 214                 .setMethodName("apply")
 215                 .setResultType("com.example.Domain")
 216                 .build();
 217         Assertions.assertEquals(
 218                 returnAsMultipleExpectation(),
 219                 generator().returnAsMultiple(converter).toString());
 220     }
 221
 222     @Test
 223     final void returnAsSingle() {
 224         Assertions.assertEquals(
 225                 returnAsSingleExpectation(),
 226                 generator().returnAsSingle(SqlConfigurations.sqlConfiguration()).toString());
 227     }
 228
 229     @Test
 230     final void returnAsSingleWithThrow() {
 231         Assertions.assertEquals(
 232                 returnAsSingleWithThrowExpectation(),
 233                 generator().returnAsSingle(SqlConfiguration.copyOf(SqlConfigurations.sqlConfiguration())
 234                         .withThrowOnMultipleResultsForSingle(true)).toString());
 235     }
 236
 237     @Test
 238     final void setParameters() {
 239         Assertions.assertEquals(
 240                 setParametersExpectation(),
 241                 generator().setParameters(SqlConfigurations.sqlConfiguration()).toString());
 242     }
 243
 244     @Test
 245     final void setBatchParameters() {
 246         Assertions.assertEquals(
 247                 setBatchParametersExpectation(),
 248                 generator().setBatchParameters(SqlConfigurations.sqlConfiguration()).toString());
 249     }
 250
 251 }