Ejemplo n.º 1
0
  @Test
  public void getIdByIndex_tableItemRemoved_resultChanges() throws SQLException {
    Object id = container.getIdByIndex(2);

    assertTrue(container.removeItem(id));
    Assert.assertNotSame(id, container.getIdByIndex(2));
  }
Ejemplo n.º 2
0
  @Test
  public void prevItemId_tableItemRemoved_skipsRemovedItem() throws SQLException {
    Object first = container.getIdByIndex(0);
    Object second = container.getIdByIndex(1);
    Object third = container.getIdByIndex(2);

    assertTrue(container.removeItem(second));
    assertEquals(first, container.prevItemId(third));
  }
Ejemplo n.º 3
0
  @Test
  public void indexOfId_tableItemRemoved_returnsNegOne() throws SQLException {
    Object id = container.getIdByIndex(2);

    assertTrue(container.removeItem(id));
    assertEquals(-1, container.indexOfId(id));
  }
Ejemplo n.º 4
0
  @Test
  public void getIdByIndex_tableOneItemAddedLastIndexInContainer_returnsAddedItem()
      throws SQLException {
    Object id = container.addItem();

    assertEquals(id, container.getIdByIndex(container.size() - 1));
  }
Ejemplo n.º 5
0
  @Test
  public void allIdsFound_table5000RowsLastId_shouldSucceed() throws SQLException {
    DataGenerator.addFiveThousandPeople(connectionPool);

    for (int i = 0; i < 5000; i++) {
      assertTrue(container.containsId(container.getIdByIndex(i)));
    }
  }
Ejemplo n.º 6
0
  @Test
  public void getIdByIndex_tableAddedItemRemoved_resultChanges() throws SQLException {
    Object id = container.addItem();
    container.addItem();
    int index = container.indexOfId(id);

    assertTrue(container.removeItem(id));
    Assert.assertNotSame(id, container.getIdByIndex(index));
  }
Ejemplo n.º 7
0
 @Test
 public void getIdByIndex_table5000rowsIndex1337_returnsRowId1337() throws SQLException {
   DataGenerator.addFiveThousandPeople(connectionPool);
   Object itemId = container.getIdByIndex(1337);
   if (SQLTestsConstants.db == DB.ORACLE) {
     assertEquals(new RowId(new Object[] {1337 + offset}).toString(), itemId.toString());
   } else {
     assertEquals(new RowId(new Object[] {1337 + offset}), itemId);
   }
 }
Ejemplo n.º 8
0
 @Test
 public void prevItemId_tableCurrentItem1337_returns1336() throws SQLException {
   DataGenerator.addFiveThousandPeople(connectionPool);
   Object itemId = container.getIdByIndex(1337);
   if (SQLTestsConstants.db == DB.ORACLE) {
     assertEquals(
         new RowId(new Object[] {1336 + offset}).toString(),
         container.prevItemId(itemId).toString());
   } else {
     assertEquals(new RowId(new Object[] {1336 + offset}), container.prevItemId(itemId));
   }
 }
Ejemplo n.º 9
0
 @Test
 public void nextItemId_tableCurrentItem1337_returnsItem1338() throws SQLException {
   DataGenerator.addFiveThousandPeople(connectionPool);
   SQLContainer container =
       new SQLContainer(new TableQuery("people", connectionPool, SQLTestsConstants.sqlGen));
   Object itemId = container.getIdByIndex(1337);
   if (SQLTestsConstants.db == DB.ORACLE) {
     assertEquals(
         new RowId(new Object[] {1338 + offset}).toString(),
         container.nextItemId(itemId).toString());
   } else {
     assertEquals(new RowId(new Object[] {1338 + offset}), container.nextItemId(itemId));
   }
 }
Ejemplo n.º 10
0
  @Test
  public void commit_tableTwoAddedItems_shouldBeWrittenToDB() throws SQLException {
    Object id = container.addItem();
    Object id2 = container.addItem();
    container.getContainerProperty(id, NAME).setValue("Herbert");
    container.getContainerProperty(id2, NAME).setValue("Larry");
    assertTrue(id2 instanceof TemporaryRowId);
    Assert.assertSame(id2, container.lastItemId());
    container.commit();
    Object nextToLast = container.getIdByIndex(container.size() - 2);

    Assert.assertFalse(nextToLast instanceof TemporaryRowId);
    assertEquals("Herbert", container.getContainerProperty(nextToLast, NAME).getValue());
    Assert.assertFalse(container.lastItemId() instanceof TemporaryRowId);
    assertEquals("Larry", container.getContainerProperty(container.lastItemId(), NAME).getValue());
  }
Ejemplo n.º 11
0
  @Test
  public void sort_tableBufferedItems_sortsBufferedItemsLastInOrderAdded() throws SQLException {
    // Ville, Kalle, Pelle, Börje
    assertEquals("Ville", container.getContainerProperty(container.firstItemId(), NAME).getValue());
    assertEquals("Börje", container.getContainerProperty(container.lastItemId(), NAME).getValue());

    Object id1 = container.addItem();
    container.getContainerProperty(id1, NAME).setValue("Wilbert");
    Object id2 = container.addItem();
    container.getContainerProperty(id2, NAME).setValue("Albert");

    container.sort(new Object[] {NAME}, new boolean[] {true});

    // Börje, Kalle, Pelle, Ville, Wilbert, Albert
    assertEquals("Börje", container.getContainerProperty(container.firstItemId(), NAME).getValue());
    assertEquals(
        "Wilbert",
        container
            .getContainerProperty(container.getIdByIndex(container.size() - 2), NAME)
            .getValue());
    assertEquals("Albert", container.getContainerProperty(container.lastItemId(), NAME).getValue());
  }
Ejemplo n.º 12
0
  @Test
  public void addFilter_tableBufferedItems_alsoFiltersBufferedItems() throws SQLException {
    // Ville, Kalle, Pelle, Börje
    assertEquals(4, container.size());
    assertEquals("Börje", container.getContainerProperty(container.lastItemId(), NAME).getValue());

    Object id1 = container.addItem();
    container.getContainerProperty(id1, NAME).setValue("Palle");
    Object id2 = container.addItem();
    container.getContainerProperty(id2, NAME).setValue("Bengt");

    container.addContainerFilter(new Like(NAME, "%lle"));

    // Ville, Kalle, Pelle, Palle
    assertEquals(4, container.size());
    assertEquals(
        "Ville", container.getContainerProperty(container.getIdByIndex(0), NAME).getValue());
    assertEquals(
        "Kalle", container.getContainerProperty(container.getIdByIndex(1), NAME).getValue());
    assertEquals(
        "Pelle", container.getContainerProperty(container.getIdByIndex(2), NAME).getValue());
    assertEquals(
        "Palle", container.getContainerProperty(container.getIdByIndex(3), NAME).getValue());

    try {
      container.getIdByIndex(4);
      Assert.fail(
          "SQLContainer.getIdByIndex() returned a value for an index beyond the end of the container");
    } catch (IndexOutOfBoundsException e) {
      // should throw exception - item is filtered out
    }
    Assert.assertNull(container.nextItemId(container.getIdByIndex(3)));

    Assert.assertFalse(container.containsId(id2));
    Assert.assertFalse(container.getItemIds().contains(id2));

    Assert.assertNull(container.getItem(id2));
    assertEquals(-1, container.indexOfId(id2));

    Assert.assertNotSame(id2, container.lastItemId());
    Assert.assertSame(id1, container.lastItemId());
  }