需求
做一个需求,里面的数据只保存最近3天的,超过第3天的自动删除最早一天的数据
流程图
代码逻辑
/**
* 例如 MAX = 3 天 NightModeDataManageDbInfo的管理规则如下
* 第一天:whitch_day = 0; dayOfYear = 1;
* 第二天:whitch_day = 1; dayOfYear = 2;
* 第三天:whitch_day = 2; dayOfYear = 3;
* 第四天:whitch_day = 0; 删除旧的whitch_day,再插入新数据,dayOfYear = 4;
* 第五天:whitch_day = 1; 删除旧的whitch_day,再插入新数据,dayOfYear = 5;
*
* 这样就可以保证和维持数据库存储最近 MAX 天的亮灭屏数据了
*/
public void collectNightModeData(Context mContext, String action) {
NightModeDao mNightModeDao = new NightModeDao(mContext);
NightModeDataManageDbInfo mMDbInfo = mNightModeDao.getDataManagerData();
long curTime = System.currentTimeMillis();
int curDayOfYear = DateTimeUtil.getDayOfYear();
NightModeInfo mInfo = new NightModeInfo();
mInfo.time_long = curTime;
mInfo.time_string = DateTimeUtil.getSysDate(curTime);
mInfo.type = action;
mInfo.battery_level = mBatteryLevel;
mInfo.charge_status = mPlugged;
if (mMDbInfo == null) {
// 表示:第一次加载数据库,所以数据库全部都是空空的
Log.d(Constant.TAG, "Fist loading night mode db");
mMDbInfo = new NightModeDataManageDbInfo();
mMDbInfo.whitchDay = NightModeDataBase.DataManager.DEFAULT_WHITCH_DAY;
mMDbInfo.dayOfYear = curDayOfYear;
mNightModeDao.insertDataManagerData(mMDbInfo);
mInfo.whitch_day = mMDbInfo.whitchDay;
} else {
// 新增数据,但是要进一步进行区分是当天还是下一天的场景
int dayOfYear_db = mMDbInfo.dayOfYear;
int whitch_day_db = mMDbInfo.whitchDay;
if (curDayOfYear == dayOfYear_db) {
// 表示:当天数据新增,直接新增原始数据即可
mInfo.whitch_day = whitch_day_db;
} else {
// 表示:下一天数据
int newWhitch_day_db = whitch_day_db + 1;
if (newWhitch_day_db == NightModeDataBase.DataManager.MAX_COUNT) {
newWhitch_day_db = NightModeDataBase.DataManager.DEFAULT_WHITCH_DAY;
}
// 更新数据库管理文件内容
mMDbInfo.dayOfYear = curDayOfYear;
mMDbInfo.whitchDay = newWhitch_day_db;
mNightModeDao.updateDataManagerData(mMDbInfo);
if (mNightModeDao.isExitSourceNightData(newWhitch_day_db)) {
// 代表:新增的数据已经超过 NightModeDataBase.DataManager.MAX_COUNT 天了,由于这里要保持固定天数所以要删除旧的数据
mNightModeDao.deleteSourceNightData(newWhitch_day_db);
} else {
// 代表: 目前数据还是 NightModeDataBase.DataManager.MAX_COUNT 天内的数据新增
}
mInfo.whitch_day = newWhitch_day_db;
}
mNightModeDao.insertSourceNightData(mInfo);
}
}
效果实现
部分源码
public class NightModeDataBase {
public final static String DB_NAME = "night_mode.db";
public final static int DB_VESION = 1;
public static class SourceData implements BaseColumns {
public final static String TABLE_NAME = "source_data";
public static final String WHITCH_DAY = "whitch_day";
public static final String TIME_LONG = "time_long";
public static final String TIME_STRING = "time_string";
public static final String TYPE = "type";
public static final String BATTERY_LEVEL = "battery_level";
public static final String CHARGE_STATUS = "charge_status";
}
public static class DataManager implements BaseColumns {
public final static String TABLE_NAME = "data_manager";
public static final int MAX_COUNT = 3;
public static final int DEFAULT_WHITCH_DAY = 0;
public static final String WHITCH_DAY = "whitch_day";
public static final String DAY_OF_YEAR = "day_of_year";
}
}
结语
这里主要是收集数据用途,最近 x 天的数据不断更新,便于变更即时策略