Java Code Examples for javax.sql.rowset.CachedRowSet#moveToInsertRow()

The following examples show how to use javax.sql.rowset.CachedRowSet#moveToInsertRow() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: CommonCachedRowSetTests.java    From jdk8u-jdk with GNU General Public License v2.0 6 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0053(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.undoInsert();
    // Check to make sure the row is no longer there
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 2
Source File: CommonCachedRowSetTests.java    From TencentKona-8 with GNU General Public License v2.0 6 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0053(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.undoInsert();
    // Check to make sure the row is no longer there
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 3
Source File: CommonCachedRowSetTests.java    From jdk8u60 with GNU General Public License v2.0 6 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0053(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.undoInsert();
    // Check to make sure the row is no longer there
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 4
Source File: CommonCachedRowSetTests.java    From openjdk-jdk8u with GNU General Public License v2.0 6 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0053(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.undoInsert();
    // Check to make sure the row is no longer there
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 5
Source File: CommonCachedRowSetTests.java    From hottub with GNU General Public License v2.0 6 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0053(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.undoInsert();
    // Check to make sure the row is no longer there
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 6
Source File: CommonCachedRowSetTests.java    From openjdk-jdk8u-backup with GNU General Public License v2.0 6 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0053(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.undoInsert();
    // Check to make sure the row is no longer there
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 7
Source File: CommonCachedRowSetTests.java    From openjdk-jdk8u with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
    int rowToDelete = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToDelete);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.deleteRow();
    // Check to make sure the row is no longer there
    //assertTrue(rs.size() ==  COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.setShowDeleted(true);
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoDelete();
    // check that the row is back
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.close();
}
Example 8
Source File: CommonCachedRowSetTests.java    From jdk8u-jdk with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
    int rowToDelete = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToDelete);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.deleteRow();
    // Check to make sure the row is no longer there
    //assertTrue(rs.size() ==  COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.setShowDeleted(true);
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoDelete();
    // check that the row is back
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.close();
}
Example 9
Source File: CommonCachedRowSetTests.java    From hottub with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    // Save off the original column values
    String f2 = rs.getString(2);
    int f3 = rs.getInt(3);
    rs.updateString(2, "SMALLVILLE");
    rs.updateInt(3, 500);
    // Validate the columns have been updated
    assertTrue(rs.columnUpdated(2));
    assertTrue(rs.columnUpdated(3));
    // Undo the update and validate it has taken place
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoUpdate();
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 10
Source File: CommonCachedRowSetTests.java    From openjdk-jdk9 with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
    int rowToDelete = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToDelete);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.deleteRow();
    // Check to make sure the row is no longer there
    //assertTrue(rs.size() ==  COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.setShowDeleted(true);
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoDelete();
    // check that the row is back
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.close();
}
Example 11
Source File: CommonCachedRowSetTests.java    From jdk8u_jdk with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    // Save off the original column values
    String f2 = rs.getString(2);
    int f3 = rs.getInt(3);
    rs.updateString(2, "SMALLVILLE");
    rs.updateInt(3, 500);
    // Validate the columns have been updated
    assertTrue(rs.columnUpdated(2));
    assertTrue(rs.columnUpdated(3));
    // Undo the update and validate it has taken place
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoUpdate();
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 12
Source File: CommonCachedRowSetTests.java    From openjdk-jdk8u-backup with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    // Save off the original column values
    String f2 = rs.getString(2);
    int f3 = rs.getInt(3);
    rs.updateString(2, "SMALLVILLE");
    rs.updateInt(3, 500);
    // Validate the columns have been updated
    assertTrue(rs.columnUpdated(2));
    assertTrue(rs.columnUpdated(3));
    // Undo the update and validate it has taken place
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoUpdate();
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 13
Source File: CommonCachedRowSetTests.java    From openjdk-jdk8u-backup with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
    int rowToDelete = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToDelete);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.deleteRow();
    // Check to make sure the row is no longer there
    //assertTrue(rs.size() ==  COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.setShowDeleted(true);
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoDelete();
    // check that the row is back
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.close();
}
Example 14
Source File: CommonCachedRowSetTests.java    From jdk8u-jdk with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    // Save off the original column values
    String f2 = rs.getString(2);
    int f3 = rs.getInt(3);
    rs.updateString(2, "SMALLVILLE");
    rs.updateInt(3, 500);
    // Validate the columns have been updated
    assertTrue(rs.columnUpdated(2));
    assertTrue(rs.columnUpdated(3));
    // Undo the update and validate it has taken place
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoUpdate();
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 15
Source File: CommonCachedRowSetTests.java    From jdk8u60 with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    // Save off the original column values
    String f2 = rs.getString(2);
    int f3 = rs.getInt(3);
    rs.updateString(2, "SMALLVILLE");
    rs.updateInt(3, 500);
    // Validate the columns have been updated
    assertTrue(rs.columnUpdated(2));
    assertTrue(rs.columnUpdated(3));
    // Undo the update and validate it has taken place
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoUpdate();
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 16
Source File: CommonCachedRowSetTests.java    From jdk8u60 with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
    int rowToDelete = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToDelete);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.deleteRow();
    // Check to make sure the row is no longer there
    //assertTrue(rs.size() ==  COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.setShowDeleted(true);
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoDelete();
    // check that the row is back
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.close();
}
Example 17
Source File: CommonCachedRowSetTests.java    From TencentKona-8 with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    // Save off the original column values
    String f2 = rs.getString(2);
    int f3 = rs.getInt(3);
    rs.updateString(2, "SMALLVILLE");
    rs.updateInt(3, 500);
    // Validate the columns have been updated
    assertTrue(rs.columnUpdated(2));
    assertTrue(rs.columnUpdated(3));
    // Undo the update and validate it has taken place
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoUpdate();
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 18
Source File: CommonCachedRowSetTests.java    From hottub with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
    int rowToDelete = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToDelete);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.deleteRow();
    // Check to make sure the row is no longer there
    //assertTrue(rs.size() ==  COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.setShowDeleted(true);
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoDelete();
    // check that the row is back
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.close();
}
Example 19
Source File: CommonCachedRowSetTests.java    From dragonwell8_jdk with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0055(CachedRowSet rs) throws Exception {
    int rowToInsert = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToInsert);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    // Save off the original column values
    String f2 = rs.getString(2);
    int f3 = rs.getInt(3);
    rs.updateString(2, "SMALLVILLE");
    rs.updateInt(3, 500);
    // Validate the columns have been updated
    assertTrue(rs.columnUpdated(2));
    assertTrue(rs.columnUpdated(3));
    // Undo the update and validate it has taken place
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoUpdate();
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToInsert, 1));
    rs.close();
}
Example 20
Source File: CommonCachedRowSetTests.java    From dragonwell8_jdk with GNU General Public License v2.0 5 votes vote down vote up 
@Test(dataProvider = "rowsetUsingCoffeeHouses")
public void commonCachedRowSetTest0054(CachedRowSet rs) throws Exception {
    int rowToDelete = 1961;
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS);
    // Add new row
    rs.moveToInsertRow();
    rs.updateInt(1, rowToDelete);
    rs.updateString(2, "GOTHAM");
    rs.updateInt(3, 3450);
    rs.updateInt(4, 2005);
    rs.updateInt(5, 5455);
    rs.insertRow();
    rs.moveToCurrentRow();
    // check that the number of rows has increased
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.deleteRow();
    // Check to make sure the row is no longer there
    //assertTrue(rs.size() ==  COFFEE_HOUSES_ROWS);
    assertFalse(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.setShowDeleted(true);
    rs.absolute(COFFEE_HOUSES_ROWS + 1);
    rs.undoDelete();
    // check that the row is back
    assertTrue(rs.size() == COFFEE_HOUSES_ROWS + 1);
    assertTrue(findRowByPrimaryKey(rs, rowToDelete, 1));
    rs.close();
}