@Override public int getValueCount() { try { return getTable().getRowCount(); } catch (KlabIOException e) { // shouldn't happen } return 0; }
@Override public int getRowCount() { return wrapped.getRowCount(); }
public long[] getSize() { size[ROW] = table.getRowCount(); size[COLUMN] = table.getColumnCount(); return size; }
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++; } }
if (i != t.getRowCount() && step != 1) { Logger.logParametricWarning(Messages.ROW_COUNT, t.getName(), String.valueOf(t.getRowCount()), String.valueOf(i));
@Override protected Number executeCountQuery(Table table, List<FilterItem> whereItems, boolean functionApproximationAllowed) { try { com.healthmarketscience.jackcess.Table mdbTable = getDatabase().getTable(table.getName()); return mdbTable.getRowCount(); } catch (Exception e) { throw new MetaModelException(e); } }