git.basschouten.com Git - openhab-addons.git/blob

   1 /**
   2  * Copyright (c) 2010-2023 Contributors to the openHAB project
   3  *
   4  * See the NOTICE file(s) distributed with this work for additional
   5  * information.
   6  *
   7  * This program and the accompanying materials are made available under the
   8  * terms of the Eclipse Public License 2.0 which is available at
   9  * http://www.eclipse.org/legal/epl-2.0
  10  *
  11  * SPDX-License-Identifier: EPL-2.0
  12  */
  13 package org.openhab.persistence.dynamodb.internal;
  14
  15 import static org.junit.jupiter.api.Assertions.*;
  16 import static org.junit.jupiter.api.Assumptions.assumeTrue;
  17
  18 import java.time.ZoneId;
  19 import java.time.ZonedDateTime;
  20 import java.util.Iterator;
  21
  22 import org.eclipse.jdt.annotation.NonNullByDefault;
  23 import org.eclipse.jdt.annotation.Nullable;
  24 import org.junit.jupiter.api.Test;
  25 import org.openhab.core.persistence.FilterCriteria;
  26 import org.openhab.core.persistence.FilterCriteria.Operator;
  27 import org.openhab.core.persistence.FilterCriteria.Ordering;
  28 import org.openhab.core.persistence.HistoricItem;
  29 import org.openhab.core.types.State;
  30
  31 /**
  32  * This is abstract class helping with integration testing the persistence service. Different kind of queries are tested
  33  * against actual dynamo db database.
  34  *
  35  *
  36  * Inheritor of this base class needs to store two states of one item in a static method annotated with @BeforeAll.
  37  * This
  38  * static
  39  * class should update the private static fields
  40  * beforeStore (date before storing anything), afterStore1 (after storing first item, but before storing second item),
  41  * afterStore2 (after storing second item). The item name must correspond to getItemName. The first state needs to be
  42  * smaller than the second state.
  43  *
  44  * To have more comprehensive tests, the inheritor class can define getQueryItemStateBetween to provide a value between
  45  * the two states. Null can be used to omit the additional tests.
  46  *
  47  *
  48  * See DimmerItemIntegrationTest for example how to use this base class.
  49  *
  50  * @author Sami Salonen - Initial contribution
  51  *
  52  */
  53 @NonNullByDefault
  54 public abstract class AbstractTwoItemIntegrationTest extends BaseIntegrationTest {
  55
  56     protected static ZonedDateTime beforeStore = ZonedDateTime.of(2100, 1, 1, 0, 0, 0, 0, ZoneId.systemDefault());
  57     protected static ZonedDateTime afterStore1 = ZonedDateTime.of(1900, 1, 1, 0, 0, 0, 0, ZoneId.systemDefault());
  58     protected static ZonedDateTime afterStore2 = ZonedDateTime.of(1900, 1, 1, 0, 0, 0, 0, ZoneId.systemDefault());
  59
  60     protected abstract String getItemName();
  61
  62     /**
  63      * State of the time item stored first, should be smaller than the second value
  64      *
  65      * @return
  66      */
  67     protected abstract State getFirstItemState();
  68
  69     /**
  70      * State of the time item stored second, should be larger than the first value
  71      *
  72      * @return
  73      */
  74     protected abstract State getSecondItemState();
  75
  76     /**
  77      * State that is between the first and second. Use null to omit extended tests using this value.
  78      *
  79      * @return
  80      */
  81     protected abstract @Nullable State getQueryItemStateBetween();
  82
  83     protected void assertStateEquals(State expected, State actual) {
  84         assertEquals(expected, actual);
  85     }
  86
  87     /**
  88      * Asserts that iterable contains correct items and nothing else
  89      *
  90      */
  91     protected void assertIterableContainsItems(Iterable<HistoricItem> iterable, boolean ascending) {
  92         Iterator<HistoricItem> iterator = iterable.iterator();
  93         assertTrue(iterator.hasNext());
  94         HistoricItem actual1 = iterator.next();
  95         assertTrue(iterator.hasNext());
  96         HistoricItem actual2 = iterator.next();
  97         assertFalse(iterator.hasNext());
  98
  99         for (HistoricItem actual : new HistoricItem[] { actual1, actual2 }) {
 100             assertEquals(getItemName(), actual.getName());
 101         }
 102         HistoricItem storedFirst;
 103         HistoricItem storedSecond;
 104         if (ascending) {
 105             storedFirst = actual1;
 106             storedSecond = actual2;
 107         } else {
 108             storedFirst = actual2;
 109             storedSecond = actual1;
 110         }
 111
 112         assertStateEquals(getFirstItemState(), storedFirst.getState());
 113         assertTrue(storedFirst.getTimestamp().toInstant().isBefore(afterStore1.toInstant()));
 114         assertTrue(storedFirst.getTimestamp().toInstant().isAfter(beforeStore.toInstant()));
 115
 116         assertStateEquals(getSecondItemState(), storedSecond.getState());
 117         assertTrue(storedSecond.getTimestamp().toInstant().isBefore(afterStore2.toInstant()));
 118         assertTrue(storedSecond.getTimestamp().toInstant().isAfter(afterStore1.toInstant()));
 119     }
 120
 121     @Test
 122     public void testQueryUsingName() {
 123         waitForAssert(() -> {
 124             FilterCriteria criteria = new FilterCriteria();
 125             criteria.setOrdering(Ordering.ASCENDING);
 126             criteria.setItemName(getItemName());
 127             @SuppressWarnings("null")
 128             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 129             assertIterableContainsItems(iterable, true);
 130         });
 131     }
 132
 133     @Test
 134     public void testQueryUsingNameAndStart() {
 135         waitForAssert(() -> {
 136             FilterCriteria criteria = new FilterCriteria();
 137             criteria.setOrdering(Ordering.ASCENDING);
 138             criteria.setItemName(getItemName());
 139             criteria.setBeginDate(beforeStore);
 140             @SuppressWarnings("null")
 141             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 142             assertIterableContainsItems(iterable, true);
 143         });
 144     }
 145
 146     @Test
 147     public void testQueryUsingNameAndStartNoMatch() {
 148         waitForAssert(() -> {
 149
 150             FilterCriteria criteria = new FilterCriteria();
 151             criteria.setItemName(getItemName());
 152             criteria.setBeginDate(afterStore2);
 153             @SuppressWarnings("null")
 154             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 155             assertFalse(iterable.iterator().hasNext());
 156         });
 157     }
 158
 159     @Test
 160     public void testQueryUsingNameAndEnd() {
 161         waitForAssert(() -> {
 162             FilterCriteria criteria = new FilterCriteria();
 163             criteria.setOrdering(Ordering.ASCENDING);
 164             criteria.setItemName(getItemName());
 165             criteria.setEndDate(afterStore2);
 166             @SuppressWarnings("null")
 167             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 168             assertIterableContainsItems(iterable, true);
 169         });
 170     }
 171
 172     @Test
 173     public void testQueryUsingNameAndEndNoMatch() {
 174         waitForAssert(() -> {
 175             FilterCriteria criteria = new FilterCriteria();
 176             criteria.setItemName(getItemName());
 177             criteria.setEndDate(beforeStore);
 178             @SuppressWarnings("null")
 179             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 180             assertFalse(iterable.iterator().hasNext());
 181         });
 182     }
 183
 184     @Test
 185     public void testQueryUsingNameAndStartAndEnd() {
 186         waitForAssert(() -> {
 187             FilterCriteria criteria = new FilterCriteria();
 188             criteria.setOrdering(Ordering.ASCENDING);
 189             criteria.setItemName(getItemName());
 190             criteria.setBeginDate(beforeStore);
 191             criteria.setEndDate(afterStore2);
 192             @SuppressWarnings("null")
 193             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 194             assertIterableContainsItems(iterable, true);
 195         });
 196     }
 197
 198     @Test
 199     public void testQueryUsingNameAndStartAndEndDesc() {
 200         waitForAssert(() -> {
 201             FilterCriteria criteria = new FilterCriteria();
 202             criteria.setOrdering(Ordering.DESCENDING);
 203             criteria.setItemName(getItemName());
 204             criteria.setBeginDate(beforeStore);
 205             criteria.setEndDate(afterStore2);
 206             @SuppressWarnings("null")
 207             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 208             assertIterableContainsItems(iterable, false);
 209         });
 210     }
 211
 212     @Test
 213     public void testQueryUsingNameAndStartAndEndWithNEQOperator() {
 214         waitForAssert(() -> {
 215             FilterCriteria criteria = new FilterCriteria();
 216             criteria.setOperator(Operator.NEQ);
 217             criteria.setState(getSecondItemState());
 218             criteria.setItemName(getItemName());
 219             criteria.setBeginDate(beforeStore);
 220             criteria.setEndDate(afterStore2);
 221             @SuppressWarnings("null")
 222             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 223             Iterator<HistoricItem> iterator = iterable.iterator();
 224             assertTrue(iterator.hasNext());
 225             HistoricItem actual1 = iterator.next();
 226             assertFalse(iterator.hasNext());
 227             assertStateEquals(getFirstItemState(), actual1.getState());
 228             assertTrue(actual1.getTimestamp().toInstant().isBefore(afterStore1.toInstant()));
 229             assertTrue(actual1.getTimestamp().toInstant().isAfter(beforeStore.toInstant()));
 230         });
 231     }
 232
 233     @Test
 234     public void testQueryUsingNameAndStartAndEndWithEQOperator() {
 235         waitForAssert(() -> {
 236             FilterCriteria criteria = new FilterCriteria();
 237             criteria.setOperator(Operator.EQ);
 238             criteria.setState(getFirstItemState());
 239             criteria.setItemName(getItemName());
 240             criteria.setBeginDate(beforeStore);
 241             criteria.setEndDate(afterStore2);
 242             @SuppressWarnings("null")
 243             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 244             Iterator<HistoricItem> iterator = iterable.iterator();
 245             assertTrue(iterator.hasNext());
 246             HistoricItem actual1 = iterator.next();
 247             assertFalse(iterator.hasNext());
 248             assertStateEquals(getFirstItemState(), actual1.getState());
 249             assertTrue(actual1.getTimestamp().toInstant().isBefore(afterStore1.toInstant()));
 250             assertTrue(actual1.getTimestamp().toInstant().isAfter(beforeStore.toInstant()));
 251         });
 252     }
 253
 254     @Test
 255     public void testQueryUsingNameAndStartAndEndWithLTOperator() {
 256         waitForAssert(() -> {
 257             FilterCriteria criteria = new FilterCriteria();
 258             criteria.setOperator(Operator.LT);
 259             criteria.setState(getSecondItemState());
 260             criteria.setItemName(getItemName());
 261             criteria.setBeginDate(beforeStore);
 262             criteria.setEndDate(afterStore2);
 263             @SuppressWarnings("null")
 264             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 265             Iterator<HistoricItem> iterator = iterable.iterator();
 266             assertTrue(iterator.hasNext());
 267             HistoricItem actual1 = iterator.next();
 268             assertFalse(iterator.hasNext());
 269             assertStateEquals(getFirstItemState(), actual1.getState());
 270             assertTrue(actual1.getTimestamp().toInstant().isBefore(afterStore1.toInstant()));
 271             assertTrue(actual1.getTimestamp().toInstant().isAfter(beforeStore.toInstant()));
 272         });
 273     }
 274
 275     @Test
 276     public void testQueryUsingNameAndStartAndEndWithLTOperatorNoMatch() {
 277         waitForAssert(() -> {
 278             FilterCriteria criteria = new FilterCriteria();
 279             criteria.setOperator(Operator.LT);
 280             criteria.setState(getFirstItemState());
 281             criteria.setItemName(getItemName());
 282             criteria.setBeginDate(beforeStore);
 283             criteria.setEndDate(afterStore2);
 284             @SuppressWarnings("null")
 285             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 286             Iterator<HistoricItem> iterator = iterable.iterator();
 287             assertFalse(iterator.hasNext());
 288         });
 289     }
 290
 291     @Test
 292     public void testQueryUsingNameAndStartAndEndWithLTEOperator() {
 293         waitForAssert(() -> {
 294             FilterCriteria criteria = new FilterCriteria();
 295             criteria.setOperator(Operator.LTE);
 296             criteria.setState(getFirstItemState());
 297             criteria.setItemName(getItemName());
 298             criteria.setBeginDate(beforeStore);
 299             criteria.setEndDate(afterStore2);
 300             @SuppressWarnings("null")
 301             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 302             Iterator<HistoricItem> iterator = iterable.iterator();
 303             assertTrue(iterator.hasNext());
 304             HistoricItem actual1 = iterator.next();
 305             assertFalse(iterator.hasNext());
 306             assertStateEquals(getFirstItemState(), actual1.getState());
 307             assertTrue(actual1.getTimestamp().toInstant().isBefore(afterStore1.toInstant()));
 308             assertTrue(actual1.getTimestamp().toInstant().isAfter(beforeStore.toInstant()));
 309         });
 310     }
 311
 312     @Test
 313     public void testQueryUsingNameAndStartAndEndWithGTOperator() {
 314         waitForAssert(() -> {
 315             // Skip for subclasses which have null "state between"
 316             assumeTrue(getQueryItemStateBetween() != null);
 317
 318             FilterCriteria criteria = new FilterCriteria();
 319             criteria.setOperator(Operator.GT);
 320             criteria.setState(getQueryItemStateBetween());
 321             criteria.setItemName(getItemName());
 322             criteria.setBeginDate(beforeStore);
 323             criteria.setEndDate(afterStore2);
 324             @SuppressWarnings("null")
 325             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 326             Iterator<HistoricItem> iterator = iterable.iterator();
 327             assertTrue(iterator.hasNext());
 328             HistoricItem actual1 = iterator.next();
 329             assertFalse(iterator.hasNext());
 330             assertStateEquals(getSecondItemState(), actual1.getState());
 331             assertTrue(actual1.getTimestamp().toInstant().isBefore(afterStore2.toInstant()));
 332             assertTrue(actual1.getTimestamp().toInstant().isAfter(afterStore1.toInstant()));
 333         });
 334     }
 335
 336     @Test
 337     public void testQueryUsingNameAndStartAndEndWithGTOperatorNoMatch() {
 338         waitForAssert(() -> {
 339             FilterCriteria criteria = new FilterCriteria();
 340             criteria.setOperator(Operator.GT);
 341             criteria.setState(getSecondItemState());
 342             criteria.setItemName(getItemName());
 343             criteria.setBeginDate(beforeStore);
 344             criteria.setEndDate(afterStore2);
 345             @SuppressWarnings("null")
 346             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 347             Iterator<HistoricItem> iterator = iterable.iterator();
 348             assertFalse(iterator.hasNext());
 349         });
 350     }
 351
 352     @Test
 353     public void testQueryUsingNameAndStartAndEndWithGTEOperator() {
 354         waitForAssert(() -> {
 355             FilterCriteria criteria = new FilterCriteria();
 356             criteria.setOperator(Operator.GTE);
 357             criteria.setState(getSecondItemState());
 358             criteria.setItemName(getItemName());
 359             criteria.setBeginDate(beforeStore);
 360             criteria.setEndDate(afterStore2);
 361             @SuppressWarnings("null")
 362             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 363             Iterator<HistoricItem> iterator = iterable.iterator();
 364             assertTrue(iterator.hasNext());
 365             HistoricItem actual1 = iterator.next();
 366             assertFalse(iterator.hasNext());
 367             assertStateEquals(getSecondItemState(), actual1.getState());
 368             assertTrue(actual1.getTimestamp().toInstant().isBefore(afterStore2.toInstant()));
 369             assertTrue(actual1.getTimestamp().toInstant().isAfter(afterStore1.toInstant()));
 370         });
 371     }
 372
 373     @Test
 374     public void testQueryUsingNameAndStartAndEndFirst() {
 375         waitForAssert(() -> {
 376             FilterCriteria criteria = new FilterCriteria();
 377             criteria.setOrdering(Ordering.ASCENDING);
 378             criteria.setItemName(getItemName());
 379             criteria.setBeginDate(beforeStore);
 380             criteria.setEndDate(afterStore1);
 381             @SuppressWarnings("null")
 382             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 383
 384             Iterator<HistoricItem> iterator = iterable.iterator();
 385             assertTrue(iterator.hasNext());
 386             HistoricItem actual1 = iterator.next();
 387             assertFalse(iterator.hasNext());
 388             assertStateEquals(getFirstItemState(), actual1.getState());
 389             assertTrue(actual1.getTimestamp().toInstant().isBefore(afterStore1.toInstant()));
 390             assertTrue(actual1.getTimestamp().toInstant().isAfter(beforeStore.toInstant()));
 391         });
 392     }
 393
 394     @Test
 395     public void testQueryUsingNameAndStartAndEndNoMatch() {
 396         waitForAssert(() -> {
 397             FilterCriteria criteria = new FilterCriteria();
 398             criteria.setItemName(getItemName());
 399             criteria.setBeginDate(beforeStore);
 400             criteria.setEndDate(beforeStore); // sic
 401             @SuppressWarnings("null")
 402             Iterable<HistoricItem> iterable = BaseIntegrationTest.service.query(criteria);
 403             assertFalse(iterable.iterator().hasNext());
 404         });
 405     }
 406 }