use of com.mnnyang.gzuclassschedule.data.bean.CsItem in project GzuClassSchedule by mnnyang.
the class CourseDbDao method loadCsNameList.
public ArrayList<CsItem> loadCsNameList() {
ArrayList<CsItem> csItems = new ArrayList<>();
SQLiteDatabase db = new CourseDbHelper(app.mContext).getWritableDatabase();
Cursor cursor = db.query(CoursesPsc.CsNameEntry.TABLE_NAME, null, null, null, null, null, null);
while (cursor.moveToNext()) {
int nameId = cursor.getInt(cursor.getColumnIndex(CoursesPsc.CsNameEntry.COLUMN_NAME_NAME_ID));
String name = cursor.getString(cursor.getColumnIndex(CoursesPsc.CsNameEntry.COLUMN_NAME_NAME));
// TODO 额外数据 例如数据的条数
CsItem csItem = new CsItem();
csItem.setCsName(new CsName().setName(name).setCsNameId(nameId));
csItems.add(csItem);
}
cursor.close();
db.close();
return csItems;
}
use of com.mnnyang.gzuclassschedule.data.bean.CsItem in project GzuClassSchedule by mnnyang.
the class AppUtils method migrateData.
/**
* 迁移旧数据
*/
private static void migrateData(Context context) {
MyOpenHelper myOpenHelper = new MyOpenHelper(context, "coursev2.db", null);
DaoMaster daoMaster = new DaoMaster(myOpenHelper.getWritableDatabase());
DaoSession daoSession = daoMaster.newSession();
CourseGroupDao courseGroupDao = daoSession.getCourseGroupDao();
CourseV2Dao courseV2Dao = daoSession.getCourseV2Dao();
ArrayList<CsItem> csItems = CourseDbDao.instance().loadCsNameList();
for (CsItem csItem : csItems) {
ArrayList<Course> courses = CourseDbDao.instance().loadCourses(csItem.getCsName().getCsNameId());
CourseGroup group = new CourseGroup();
group.setCgName(csItem.getCsName().getName());
long insert1 = courseGroupDao.insert(group);
for (Course course : courses) {
if (course.getNodes() == null || course.getNodes().size() == 0 || course.getEndWeek() == 0) {
continue;
}
CourseV2 courseV2 = new CourseV2().setCouOnlyId(AppUtils.createUUID());
courseV2.setCouName(course.getName());
courseV2.setCouTeacher(course.getTeacher());
courseV2.setCouLocation(course.getClassRoom());
// node
courseV2.setCouStartNode(course.getNodes().get(0));
courseV2.setCouNodeCount(course.getNodes().size());
// day
courseV2.setCouWeek(course.getWeek());
// week
String couAllWeek = getAllWeek(course);
if (couAllWeek.length() > 0) {
couAllWeek = couAllWeek.substring(0, couAllWeek.length() - 1);
}
courseV2.setCouAllWeek(couAllWeek);
courseV2.setCouCgId(insert1);
courseV2Dao.insert(courseV2);
}
}
}
Aggregations