@Test public void testGetValidNetworkCountByStage() { init(); List<Network> infosOfDB = readDBByUserId(_info.getUserId()); int countOfDB = 0; for (int i = 0; i < infosOfDB.size(); i++) { if (infosOfDB.get(i).getStatus() == -1 || infosOfDB.get(i).getStatus() == 0) { countOfDB++; } } int countOfOrigin = 0; for (int i = 0; i < _infos.size(); i++) { if (_infos.get(i).getStatus() == -1 || _infos.get(i).getStatus() == 0) { countOfOrigin++; } } int countOfCache = AdapterFactory.getNetworkAdapter() .getValidNetworkCountByStage(_info.getUserId(), _info.getStage()); int countOfReaderCache = AdapterFactory.getNetworkReaderAdapter() .getValidNetworkCountByStage(_info.getUserId(), _info.getStage()); System.out.println( countOfOrigin + " " + countOfDB + " " + countOfCache + " " + countOfReaderCache); Assert.assertEquals(countOfOrigin, countOfDB); Assert.assertEquals(countOfOrigin, countOfCache); Assert.assertEquals(countOfOrigin, countOfReaderCache); }
@Test public void testRemoveNetworkByStage() { init(); _infos.remove(_info); AdapterFactory.getNetworkAdapter().removeNetworkByStage(_info.getUserId(), _info.getStage()); checkAll(); // Writer init(); _infos.remove(_info); AdapterFactory.getNetworkWriterAdapter() .removeNetworkByStage(_info.getUserId(), _info.getStage()); checkAll(); }
@Test public void testGetNetworkListByStage() { init(); List<Network> infosOfDB = readDBByUserId(_info.getUserId()); List<Network> infosOfCache = AdapterFactory.getNetworkAdapter() .getNetworkListByStage(_info.getUserId(), _info.getStage()); List<Network> infosOfReaderCache = AdapterFactory.getNetworkReaderAdapter() .getNetworkListByStage(_info.getUserId(), _info.getStage()); Assert.assertTrue(isEqual(infosOfDB, _infos)); Assert.assertTrue(isEqual(infosOfCache, _infos)); Assert.assertTrue(isEqual(infosOfReaderCache, _infos)); }
@Test public void testGetNetworkCountByStage() { init(); int countOfDB = readDBByUserId(_info.getUserId()).size(); int countOfCache = AdapterFactory.getNetworkAdapter() .getNetworkCountByStage(_info.getUserId(), _info.getStage()); int countOfReaderCache = AdapterFactory.getNetworkReaderAdapter() .getNetworkCountByStage(_info.getUserId(), _info.getStage()); int countOfOrigin = _infos.size(); Assert.assertEquals(countOfOrigin, countOfDB); Assert.assertEquals(countOfOrigin, countOfCache); Assert.assertEquals(countOfOrigin, countOfReaderCache); }
@Test public void testGetNetworkListByStageAndStatus() { init(); Network info = genInfoCopy(1); int status[] = {_info.getStatus(), info.getStatus()}; setDBAndInfos(info.getId(), info); AdapterFactory.getNetworkAdapter().reloadNetworkList(_info.getUserId()); List<Network> infosOfDB = readDBByUserId(_info.getUserId()); List<Network> infosOfCache = AdapterFactory.getNetworkAdapter() .getNetworkListByStageAndStatus(_info.getUserId(), _info.getStage(), status); List<Network> infosOfReaderCache = AdapterFactory.getNetworkReaderAdapter() .getNetworkListByStageAndStatus(_info.getUserId(), _info.getStage(), status); Assert.assertTrue(isEqual(infosOfDB, _infos)); Assert.assertTrue(isEqual(infosOfCache, _infos)); Assert.assertTrue(isEqual(infosOfReaderCache, _infos)); }
/** * 获取一份新的数据 * * @param idStep * @return */ protected Network genInfoCopy(int idStep) { Network result = new Network(); result.setId(_info.getId() + idStep); result.setUserId(_info.getUserId()); result.setStage(_info.getStage()); result.setNetworkId(_info.getNetworkId() + idStep); result.setNetworkName(_info.getNetworkName() + ".new"); result.setInfoId(_info.getInfoId()); result.setJoinTime(_info.getJoinTime()); result.setStatus(_info.getStatus() + idStep); return result; }
protected void setDBAndInfos(int recordId, Network info) { String sql = "replace into network_history(id,userid,stage,network_id,network_name,info_id,join_time,status) values (" + recordId + "," + info.getUserId() + "," + info.getStage() + "," + info.getNetworkId() + ",'" + info.getNetworkName() + "'," + info.getInfoId() + ",'" + DateFormatter.format(info.getJoinTime()) + "'," + info.getStatus() + ")"; writeDB(sql); _infos.add(info); }