Search in sources :

Example 1 with CsItem

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;
}
Also used : SQLiteDatabase(android.database.sqlite.SQLiteDatabase) CsName(com.mnnyang.gzuclassschedule.data.bean.CsName) ArrayList(java.util.ArrayList) Cursor(android.database.Cursor) CsItem(com.mnnyang.gzuclassschedule.data.bean.CsItem)

Example 2 with CsItem

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);
        }
    }
}
Also used : MyOpenHelper(com.mnnyang.gzuclassschedule.data.greendao.MyOpenHelper) CourseV2Dao(com.mnnyang.gzuclassschedule.data.greendao.CourseV2Dao) CourseGroupDao(com.mnnyang.gzuclassschedule.data.greendao.CourseGroupDao) CourseGroup(com.mnnyang.gzuclassschedule.data.beanv2.CourseGroup) CsItem(com.mnnyang.gzuclassschedule.data.bean.CsItem) DaoMaster(com.mnnyang.gzuclassschedule.data.greendao.DaoMaster) CourseV2(com.mnnyang.gzuclassschedule.data.beanv2.CourseV2) Course(com.mnnyang.gzuclassschedule.data.bean.Course) DaoSession(com.mnnyang.gzuclassschedule.data.greendao.DaoSession)

Aggregations

CsItem (com.mnnyang.gzuclassschedule.data.bean.CsItem)2 Cursor (android.database.Cursor)1 SQLiteDatabase (android.database.sqlite.SQLiteDatabase)1 Course (com.mnnyang.gzuclassschedule.data.bean.Course)1 CsName (com.mnnyang.gzuclassschedule.data.bean.CsName)1 CourseGroup (com.mnnyang.gzuclassschedule.data.beanv2.CourseGroup)1 CourseV2 (com.mnnyang.gzuclassschedule.data.beanv2.CourseV2)1 CourseGroupDao (com.mnnyang.gzuclassschedule.data.greendao.CourseGroupDao)1 CourseV2Dao (com.mnnyang.gzuclassschedule.data.greendao.CourseV2Dao)1 DaoMaster (com.mnnyang.gzuclassschedule.data.greendao.DaoMaster)1 DaoSession (com.mnnyang.gzuclassschedule.data.greendao.DaoSession)1 MyOpenHelper (com.mnnyang.gzuclassschedule.data.greendao.MyOpenHelper)1 ArrayList (java.util.ArrayList)1