Esempio n. 1
0
  public void testRowDeleteTypes() throws SQLException, NamingException {
    DatabaseConnValueContext dbvc = new BasicDatabaseConnValueContext();
    dbvc.setConnectionProvider(TestUtils.getConnProvider(this.getClass().getPackage().getName()));
    dbvc.setDefaultDataSource(this.getClass().getPackage().getName());

    final Table testTable = populatedSchema.getTables().getByName("Test_Retire");
    assertEquals(
        RowDeleteType.LOGICAL_CASCADE_CHILDREN, testTable.getRowDeleteType().getValueIndex());

    final Row testTableRow = testTable.createRow();
    final ColumnValues testTableRowValues = testTableRow.getColumnValues();
    testTableRowValues.getByName("text").setTextValue("Test 001");

    ConnectionContext cc = dbvc.getConnection(this.getClass().getPackage().getName(), true);
    testTable.insert(cc, testTableRow);

    cc.commitAndClose();

    cc = dbvc.getConnection(this.getClass().getPackage().getName(), true);
    testTable.delete(cc, testTableRow);
    cc.commitAndClose();

    cc = dbvc.getConnection(this.getClass().getPackage().getName(), true);
    assertEquals(
        1, testTable.getCount(cc)); // make sure the record is there (it's status should be updated)
    cc.commitAndClose();

    // TODO: add child cascade tests
  }
Esempio n. 2
0
  public int createEntity1RowAndChildren(
      ConnectionContext cc,
      Table entity1Table,
      EntityHierarchyTable entity1HierarchyTable,
      Object parentId,
      String namePrefix,
      int createChildrenCount,
      int maxDepth,
      int atDepth)
      throws SQLException, NamingException {
    int result = 0;

    if (atDepth > maxDepth) return result;

    for (int i = 0; i < createChildrenCount; i++) {
      final Row entity1Row = entity1Table.createRow();
      final ColumnValues entity1ColumnValues = entity1Row.getColumnValues();
      final String entityName = namePrefix + i;
      entity1ColumnValues.getByName("name").setValue(entityName);
      entity1Table.insert(cc, entity1Row);

      // we've inserted an entity record so keep track
      result++;

      final Object entity1IdValue = entity1ColumnValues.getByName("entity_1_id").getValue();
      if (parentId != null) {
        final Row hierChildRow = entity1HierarchyTable.createRow();
        final ColumnValues entity1HierColumnValues = hierChildRow.getColumnValues();
        entity1HierColumnValues
            .getByName("hier_type_id")
            .setValue(EntityHierarchyTable.RELTYPEID_OBJ_HIERARCHY_PARENT);
        entity1HierColumnValues.getByName("primary_id").setValue(parentId);
        entity1HierColumnValues.getByName("related_id").setValue(entity1IdValue);
        entity1HierarchyTable.insert(cc, hierChildRow);
      }

      result =
          result
              + createEntity1RowAndChildren(
                  cc,
                  entity1Table,
                  entity1HierarchyTable,
                  entity1IdValue,
                  entityName + ".",
                  createChildrenCount,
                  maxDepth,
                  atDepth + 1);
    }

    return result;
  }