private int maxElementCity(String table) {
List<CityVO> results = new ArrayList<>();
CommonDAO<CityVO> city = new CommonDAO<>(mActivity.getMContext(), CityVO.class, table);
city.open();
results = city.runQuery("Select * FROM " + table);
return results.size();
}
private int maxElementPerson(String table) {
List<PersonVO> results = new ArrayList<>();
CommonDAO<PersonVO> person = new CommonDAO<>(mActivity.getMContext(), PersonVO.class, table);
person.open();
results = person.runQuery("Select * FROM " + table);
return results.size();
}
private int maxElementEmail(String table) {
List<EmailVO> results = new ArrayList<>();
CommonDAO<EmailVO> email = new CommonDAO<>(mActivity.getMContext(), EmailVO.class, table);
email.open();
results = email.runQuery("Select * FROM " + table);
return results.size();
}
private int maxElementOrigins(String table) {
List<OriginVO> results = new ArrayList<>();
CommonDAO<OriginVO> origins = new CommonDAO<>(mActivity.getMContext(), OriginVO.class, table);
origins.open();
results = origins.runQuery("Select * FROM " + table);
return results.size();
}
private int maxElementMedia(String table) {
List<MediaVO> results = new ArrayList<>();
CommonDAO<MediaVO> media = new CommonDAO<>(mActivity.getMContext(), MediaVO.class, table);
media.open();
results = media.runQuery("Select * FROM " + table);
return results.size();
}
private int maxElementUser(String table) {
List<UserVO> results = new ArrayList<>();
CommonDAO<UserVO> user = new CommonDAO<>(mActivity.getMContext(), UserVO.class, table);
user.open();
results = user.runQuery("Select * FROM " + table);
return results.size();
}
private int maxElementCareersType(String table) {
List<CareerTypeVO> results = new ArrayList<>();
CommonDAO<CareerTypeVO> careerType =
new CommonDAO<>(mActivity.getMContext(), CareerTypeVO.class, table);
careerType.open();
results = careerType.runQuery("Select * FROM " + table);
return results.size();
}
private List<UserVO> getUsuariosList() {
List<UserVO> userVO;
CommonDAO<UserVO> userDAO =
new CommonDAO<>(getMContext(), UserVO.class, EduscoreOpenHelper.TABLE_DAT_CITY);
userDAO.open();
String sql = "SELECT * FROM " + EduscoreOpenHelper.TABLE_SIS_USER;
userVO = userDAO.runQuery(sql);
return userVO;
}