private Object[] getOneRow() throws KettleException { try { if ( meta.isFileField() ) { while ( ( data.readrow == null || ( ( data.rw = data.t.getNextRow() ) == null ) ) ) { if ( !openNextFile() ) { return null; while ( ( data.file == null || ( ( data.rw = data.t.getNextRow() ) == null ) ) ) { if ( !openNextFile() ) { return null;
@Override public Row getNextRow() throws IOException { return wrapped.getNextRow(); }
xhtml.startElement("tbody"); Row r = table.getNextRow(); r = table.getNextRow();
Table RESOURCES = Database.open(new File("TargetFile.mdb")).getTable("RESOURCES"); int pcount = RESOURCES.getRowCount(); String csvFilename = "C:\\STATS\\APEX\\report.csv"; CSVReader csvReader = new CSVReader(new FileReader(csvFilename)); List<String[]> content = csvReader.readAll(); Map<ValueKey, Integer> csvValuesCount = new HashMap<ValueKey, Integer>(); for (String[] rowcsv : content) { ValueKey key = new ValueKey(rowcsv[6], rowcsv[1]); Integer count = csvValuesCount.get(key); csvValuesCount.put(key,count == null ? 1: count + 1); } int count = 0; // Taking 1st resource data for (int i = 0; i < pcount; i++) { Map<String, Object> row = RESOURCES.getNextRow(); TEAM = row.get("TEAM").toString(); MDMID = row.get("MDM ID").toString(); NAME = row.get("RESOURCE NAME").toString(); PGNAME = row.get("PG NAME").toString(); PGTARGET = row.get("PG TARGET").toString(); int PGTARGETI = Integer.parseInt(PGTARGET); Integer countInteger = csvValuesCount.get(new ValueKey(MDMID, PGNAME)); count = countInteger == null ? 0: countInteger; }
//open csv and make lookup set Set<String> mdmids = new HashSet<String>() String[] rowcsv = null; String csvFilename = "C:\\STATS\\APEX\\report.csv"; CSVReader csvReader = new CSVReader(new FileReader(csvFilename)); List content = csvReader.readAll(); for (Object object : content) { rowcsv = (String[]) object; mdmids.add(rowcsv[6]) } Table RESOURCES = Database.open(new File("TargetFile.mdb")).getTable("RESOURCES"); pcount = RESOURCES.getRowCount(); count = 0; // Taking 1st resource data for (i = 0; i < pcount; i++){ Map<String, Object> row = RESOURCES.getNextRow(); TEAM = row.get("TEAM").toString(); MDMID = row.get("MDM ID").toString(); NAME = row.get("RESOURCE NAME").toString(); PGNAME = row.get("PG NAME").toString(); PGTARGET = row.get("PG TARGET").toString(); int PGTARGETI = Integer.parseInt(PGTARGET); // use lookup set if(mdmids.contains(MDMID)) { count++; } }
private static Map<String, Term> buildTermMap(ResourceService service) throws IOException { LOG.info(CMECSService.class.getSimpleName() + " instantiating..."); String uri = "https://cmecscatalog.org/cmecs/documents/cmecs4.accdb"; LOG.info("CMECS data [" + uri + "] downloading ..."); URI resourceURI = service.getResourceURI(uri); if (resourceURI == null) { throw new IOException("failed to access [" + uri + "]"); } Database db = new DatabaseBuilder() .setFile(new File(resourceURI)) .setReadOnly(true) .open(); Map<String, Term> aquaticSettingsTerms = new HashMap<>(); Table table = db.getTable("Aquatic Setting"); Map<String, Object> row; while ((row = table.getNextRow()) != null) { Integer id = (Integer) row.get("AquaticSetting_Id"); String name = (String) row.get("AquaticSettingName"); String termId = TaxonomyProvider.ID_CMECS + id; aquaticSettingsTerms.put(StringUtils.lowerCase(StringUtils.strip(name)), new TermImpl(termId, name)); } LOG.info(CMECSService.class.getSimpleName() + " instantiated."); return aquaticSettingsTerms; }
xhtml.startElement("tbody"); Row r = table.getNextRow(); r = table.getNextRow();
xhtml.startElement("tbody"); Row r = table.getNextRow(); r = table.getNextRow();