ProcedureDao { public List<OraclePackage> getAllPackages(String nameFilter, String owner, String projectName, String sourcesTable) { String realNameFilter = getNameFilter(nameFilter); List<OraclePackage> allPackage = getAllRealOraclePackage(realNameFilter, owner, projectName, sourcesTable); allPackage.add(getAllStandaloneProcedureAndFunction(owner, projectName, sourcesTable)); return allPackage; } ProcedureDao(DataSource dataSource); List<Procedure> getAllProcedure(String nameFilter, String owner, String projectName, String sourcesTable); List<Procedure> getAllSimpleFunctionAndProcedure(String owner, String projectName, String sourcesTable); List<Procedure> getAllProcedure(String packageName, String procedureName, String owner, String projectName, String sourcesTable); List<ProcedureArgument> getProcedureArguments(String packageName, String procedureName, String overLoadNo, String owner); List<OraclePackage> getAllPackages(String nameFilter, String owner, String projectName, String sourcesTable);  }
@Test public void testAllPckNoFilter() { List<OraclePackage> allPackages = procedureDao.getAllPackages("ABCDE", "OBRIDGE", null, null); Assert.assertTrue(allPackages.size() == 1); }
@Test public void getAllPackage() { List<OraclePackage> obridge = procedureDao.getAllPackages("", "OBRIDGE", null, null); Assert.assertTrue(obridge.size() > 0); }