protected void verify() throws TestException { RecordMetaData record = (RecordMetaData) records.firstElement(); if (!CobolTestModel.compareCompositeObjects( record, CobolTestModel.getComplexPicStatementRecord())) { TestErrorException exception = new TestErrorException("The records do not match."); setTestException(exception); } }
/* * This verify method presumes that the stored procedure in EmployeeCustomSQLSystem.buildSQLInsertProcedure * has not changed and still returns an output parameter VERSION with value 952 */ public void verify() { if (this.events.isEmpty()) { throw new TestErrorException("No session events were thrown and some were expected"); } else { if (((Number) ((DatabaseRecord) ((SessionEvent) events.firstElement()).getResult()) .get("EMPLOYEE.VERSION")) .intValue() != 952) { throw new TestErrorException("Wrong value returned"); } if (((WriteObjectQuery) ((SessionEvent) events.firstElement()).getQuery()).getObject() == null) { throw new TestErrorException("Object not set"); } } }
public void test() { // read data back from database literally in order to check contents of database rather than the // driver's TIMESTAMPTZ String sql = "select TEST_ID, to_char(TSTZ_DATA,'MM/DD/YYYY hh24:mi:ss TZR') as TSTZ_DATA FROM " + commonDescriptor().getTableName() + " where TEST_ID = " + getTestId(); Vector result = getSession().executeSQL(sql); if (result != null & !result.isEmpty()) { this.result = (DatabaseRecord) result.firstElement(); } }
public void setup() { if ((getSession().getLogin().getPlatform().isSQLServer())) { throw new TestWarningException( "This test is not supported on SQL Server. Because 'LENGTH' is not a recognized function name on SQL Server."); } Vector employees = getSomeEmployees(); Employee emp = (Employee) employees.firstElement(); String ejbqlString; ejbqlString = "SELECT OBJECT(emp) FROM Employee emp WHERE "; ejbqlString = ejbqlString + emp.getFirstName().length(); ejbqlString = ejbqlString + " = LENGTH(emp.firstName)"; ejbqlString = ejbqlString + " AND "; ejbqlString = ejbqlString + emp.getLastName().length(); ejbqlString = ejbqlString + " = LENGTH(emp.lastName)"; setEjbqlString(ejbqlString); setOriginalOject(emp); super.setup(); }
protected void changeUnitOfWorkWorkingCopy() { Employee employee = (Employee) this.unitOfWorkWorkingCopy; AddressDescription addressDescription = employee.getAddressDescription(); ProjectDescription projectDescription = employee.getProjectDescription(); Language language; Vector languages; // Root object changed employee.setFirstName(null); employee.setLastName(null); // Third level aggregate object changed addressDescription.setPeriodDescription(null); // 1 to 1 mapped object changed projectDescription.getComputer().setValue(null); // 1 level aggregate's 1:M mapping projectDescription.getResponsibilities().setValue(null); languages = (Vector) projectDescription.getLanguages().getValue(); language = (Language) languages.firstElement(); language.setLanguage(null); // 1 level aggregate's M:M mapping, adding a new element // languages.addElement(null); }