Ejemplo n.º 1
0
  @Test
  public void isLastId_tableTwoItemsAdded_returnsTrueForLastAddedItem() throws SQLException {
    container.addItem();

    Object id2 = container.addItem();

    assertTrue(container.isLastId(id2));
  }
Ejemplo n.º 2
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.º 3
0
  @Test
  public void prevItemId_tableAddedItemRemoved_skipsRemovedItem() throws SQLException {
    Object first = container.lastItemId();
    Object second = container.addItem();
    Object third = container.addItem();

    assertTrue(container.removeItem(second));
    assertEquals(first, container.prevItemId(third));
  }
Ejemplo n.º 4
0
  @Test
  public void firstItemId_tableNewlyAddedFirstItemRemoved_resultChanges() throws SQLException {
    SQLContainer garbageContainer = getGarbageContainer();

    Object first = garbageContainer.addItem();
    Object second = garbageContainer.addItem();

    Assert.assertSame(first, garbageContainer.firstItemId());
    assertTrue(garbageContainer.removeItem(first));
    Assert.assertSame(second, garbageContainer.firstItemId());
  }
Ejemplo n.º 5
0
  @Test
  public void isFirstId_tableAddedFirstItemRemoved_returnsFalse() throws SQLException {
    SQLContainer garbageContainer = getGarbageContainer();

    Object first = garbageContainer.addItem();
    garbageContainer.addItem();

    Assert.assertSame(first, garbageContainer.firstItemId());
    assertTrue(garbageContainer.removeItem(first));
    Assert.assertFalse(garbageContainer.isFirstId(first));
  }
Ejemplo n.º 6
0
 @Test
 public void lastItemId_tableNewlyAddedItem_returnsNewlyAdded() throws SQLException {
   Object lastId = container.lastItemId();
   Object id = container.addItem();
   assertEquals(id, container.lastItemId());
   Assert.assertNotSame(lastId, container.lastItemId());
 }
Ejemplo n.º 7
0
 @Test
 public void addItem_tableAddOneNewItem_autoCommit_sizeIsIncreased() throws SQLException {
   container.setAutoCommit(true);
   int originalSize = container.size();
   container.addItem();
   assertEquals(originalSize + 1, container.size());
 }
Ejemplo n.º 8
0
  @Test
  public void prevItemId_tableTwoNewlyAddedItems_returnsFirstAddedItem() throws SQLException {
    Object id1 = container.addItem();
    Object id2 = container.addItem();

    assertEquals(id1, container.prevItemId(id2));
  }
Ejemplo n.º 9
0
  @Test
  public void getIdByIndex_tableOneItemAddedLastIndexInContainer_returnsAddedItem()
      throws SQLException {
    Object id = container.addItem();

    assertEquals(id, container.getIdByIndex(container.size() - 1));
  }
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 indexOfId_tableAddedItemRemoved_returnsNegOne() throws SQLException {
    Object id = container.addItem();

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

    Assert.assertNotNull(container.getItem(id));
    assertTrue(container.removeItem(id));
    Assert.assertNull(container.getItem(id));
  }
Ejemplo n.º 13
0
 @Test
 public void addItem_tableAddOneNewItem_autoCommit_returnsFinalItemId() throws SQLException {
   container.setAutoCommit(true);
   Object itemId = container.addItem();
   Assert.assertNotNull(itemId);
   assertTrue(itemId instanceof RowId);
   Assert.assertFalse(itemId instanceof TemporaryRowId);
 }
Ejemplo n.º 14
0
  @Test
  public void isLastId_tableAddedLastItemRemoved_returnsFalse() throws SQLException {
    Object last = container.addItem();

    Assert.assertSame(last, container.lastItemId());
    assertTrue(container.removeItem(last));
    Assert.assertFalse(container.isLastId(last));
  }
Ejemplo n.º 15
0
  @Test
  public void containsId_tableAddedItemRemoved_returnsFalse() throws SQLException {
    Object id = container.addItem();

    assertTrue(container.containsId(id));
    assertTrue(container.removeItem(id));
    Assert.assertFalse(container.containsId(id));
  }
Ejemplo n.º 16
0
  @Test
  public void lastItemId_tableAddedLastItemRemoved_resultChanges() throws SQLException {
    Object last = container.addItem();

    Assert.assertSame(last, container.lastItemId());
    assertTrue(container.removeItem(last));
    Assert.assertNotSame(last, container.lastItemId());
  }
Ejemplo n.º 17
0
 @Test
 public void getContainerProperty_tableNewlyAddedItem_returnsPropertyOfNewlyAddedItem()
     throws SQLException {
   Object id = container.addItem();
   Item item = container.getItem(id);
   item.getItemProperty(NAME).setValue("asdf");
   assertEquals("asdf", container.getContainerProperty(id, NAME).getValue());
 }
Ejemplo n.º 18
0
  @Test
  public void removeAllItems_tableAddedItems_shouldSucceed() throws SQLException {
    container.addItem();
    container.addItem();

    assertTrue(container.removeAllItems());
    assertEquals(0, container.size());
  }
Ejemplo n.º 19
0
  @Test
  public void getItemIds_tableAddedItemRemoved_shouldNotContainRemovedItem() throws SQLException {
    Object id = container.addItem();

    assertTrue(container.getItemIds().contains(id));
    assertTrue(container.removeItem(id));
    Assert.assertFalse(container.getItemIds().contains(id));
  }
Ejemplo n.º 20
0
  @Test
  public void isFirstId_tableEmptyResultSet_returnsFirstAddedItem() throws SQLException {
    SQLContainer garbageContainer = getGarbageContainer();

    Object id = garbageContainer.addItem();

    assertTrue(garbageContainer.isFirstId(id));
  }
Ejemplo n.º 21
0
  @Test
  public void firstItemId_tableEmptyResultSet_returnsFirstAddedItem() throws SQLException {
    SQLContainer garbageContainer = getGarbageContainer();

    Object id = garbageContainer.addItem();

    Assert.assertSame(id, garbageContainer.firstItemId());
  }
Ejemplo n.º 22
0
 @Test
 public void addItem_tableAddTwoNewItems_shouldChangeSize() throws SQLException {
   int size = container.size();
   Object id1 = container.addItem();
   Object id2 = container.addItem();
   assertEquals(size + 2, container.size());
   Assert.assertNotSame(id1, id2);
   Assert.assertFalse(id1.equals(id2));
 }
Ejemplo n.º 23
0
  @Test
  public void removeItem_tableOneAddedItem_removesTheAddedItem() throws SQLException {
    Object id = container.addItem();
    int size = container.size();

    assertTrue(container.removeItem(id));
    Assert.assertFalse(container.containsId(id));
    assertEquals(size - 1, container.size());
  }
Ejemplo n.º 24
0
  @Test
  public void newItemIsAdded() throws SQLException {
    Object id = container.addItem();
    getItem(id).getItemProperty(NAME).setValue("foo");

    container.commit();

    Item item = getItem(container.lastItemId());
    assertThat(item.getItemProperty(NAME).getValue().toString(), is("foo"));
  }
Ejemplo n.º 25
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());
  }
Ejemplo n.º 26
0
  @Test
  public void itemSetChangeListeners_table_shouldFire() throws SQLException {
    ItemSetChangeListener listener = EasyMock.createMock(ItemSetChangeListener.class);
    listener.containerItemSetChange(EasyMock.isA(ItemSetChangeEvent.class));
    EasyMock.replay(listener);

    container.addListener(listener);
    container.addItem();

    EasyMock.verify(listener);
  }
Ejemplo n.º 27
0
  @Test
  public void removeListener_table_shouldNotFire() throws SQLException {
    ItemSetChangeListener listener = EasyMock.createMock(ItemSetChangeListener.class);
    EasyMock.replay(listener);

    container.addListener(listener);
    container.removeListener(listener);
    container.addItem();

    EasyMock.verify(listener);
  }
Ejemplo n.º 28
0
 @Test
 public void rollback_tableItemAdded_discardsAddedItem() throws SQLException {
   int size = container.size();
   Object id = container.addItem();
   container.getContainerProperty(id, NAME).setValue("foo");
   assertEquals(size + 1, container.size());
   container.rollback();
   assertEquals(size, container.size());
   Assert.assertFalse(
       "foo".equals(container.getContainerProperty(container.lastItemId(), NAME).getValue()));
 }
Ejemplo n.º 29
0
  @Test
  public void commit_tableAddedItem_shouldBeWrittenToDB() throws SQLException {
    Object id = container.addItem();
    container.getContainerProperty(id, NAME).setValue("New Name");

    assertTrue(id instanceof TemporaryRowId);
    Assert.assertSame(id, container.lastItemId());
    container.commit();
    Assert.assertFalse(container.lastItemId() instanceof TemporaryRowId);
    assertEquals(
        "New Name", container.getContainerProperty(container.lastItemId(), NAME).getValue());
  }
Ejemplo n.º 30
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());
  }