目录SpesqliteManager4Android改动日志介绍核心设计思想架构设计关配置项JSON:集成步骤核心代码运行效果SpeSqliteManager4Android 改动
2023.2.14 完成SQLiteOpenHelper
2023.2.23 完成room
2023.2.25 完成架构重构
2023.2.26 新增架构设计图说明
一个轻量级无侵入式管理android数据库自动升级的管理类(支持SQLiteOpenHelper、room)
妈妈再也不用担心写一坨坨的migration或是手动sql去升级数据库
1.以静制动:配置项代替代码,保证代码稳定性
1.导入依赖库
implementation 'com.Google.code.gson:gson:2.8.9'
implementation "androidx.room:room-runtime:2.0.0"
annotationProcessor "androidx.room:room-compiler:2.0.0"
2.在assets目录下新建dbupdate.json 注意:dbconfig的配置不要动,自己的表在后面新增
3.SQLiteOpenHelper的调用方法
//1.直接创建SQLiteOpenHelper
SpeSqliteOpenHelperService.getInstance(this);
//2.创建SQLiteOpenHelper且需要监听db
SpeSqliteOpenHelperService.getInstance(this, new SpeSqliteBaseInterface() {
@Override
public <T> void onCreate(T db, RoomDatabase room) {
}
@Override
public <T> void onOpen(T db, RoomDatabase room) {
}
@Override
public <T> void onUpgrade(T db, int oldVersion, int newVersion, RoomDatabase room) {
}
});
4.Room的调用方法
//3.直接创建room
SpeSqliteRoomService.getInstance(this,AppDatabase.class);
//4.创建room,且需要监听db
SpeSqliteRoomService.getInstance(this,AppDatabase.class,new SpeSqliteBaseInterface() {
@Override
public <T> void onCreate(T db, RoomDatabase room) {
//TODO 删除测试插入代码
if(room != null){
ServerModel model = new ServerModel();
model.setId("1");
model.setHost("1");
model.setLang("1");
model.setName("1");
model.setVersion("1");
insert(room,model);
}
}
@Override
public <T> void onOpen(T db, RoomDatabase room) {
}
@Override
public <T> void onUpgrade(T db, int oldVersion, int newVersion, RoomDatabase room) {
}
});
SpeSqliteUpdateManager 负责针对本地db的创建、新建表、表字段升级、删除表,通过配置的方式去升级数据库,减少代码的改动,核心思想:以静制动
public void create(SQLiteDatabase db){
SpeSqliteSettingModel currentDBModel = SpeSqliteUpdateManager.getInstance().currentAppDBSetting();
for(int i=0;i<currentDBModel.dbTables.size();i++){
SpeSqliteTableSettingModel table = currentDBModel.dbTables.get(i);
String sql = " create table if not exists "+table.tableName+" (";
for(int j=0;j<table.columns.size();j++){
SpeSqliteColumnSettingModel column = table.columns.get(j);
sql+=column.key+" ";
sql+=column.keyType;
if(j==table.columns.size()-1){
sql+=" ";
}else {
sql+=",";
}
}
sql+=")";
executeSQL(db,sql);
}
//SQLiteDatabase数据库才需要升级本地数据配置
if(db instanceof SQLiteDatabase){
SQLiteDatabase _db = (SQLiteDatabase)db;
updateConfig2DB(_db,currentDBModel);
}
}
public void upgrade(SQLiteDatabase configdb,SupportSQLiteDatabase db){
SpeSqliteSettingModel newConfig = this.currentAppDBSetting();
SpeSqliteSettingModel localConfig = this.getAppLoclDBSetting(configdb);
//该处判断可以不要,但是加了后(daupdate.json的dbversion字段)效率更高
if(localConfig.dbVersion< newConfig.dbVersion){//通过dbversion直接判断是否要升级
//防止room数据未创建表,就alter
if(db != null){
for(int i=0;i<localConfig.dbTables.size();i++) {
SpeSqliteTableSettingModel _local = localConfig.dbTables.get(i);
createTableSQL(db,_local);
}
}
for(int j=0;j<newConfig.dbTables.size();j++){
SpeSqliteTableSettingModel _new = newConfig.dbTables.get(j);
for(int i=0;i<localConfig.dbTables.size();i++){
SpeSqliteTableSettingModel _local = localConfig.dbTables.get(i);
if(_local.tableName.equals(_new.tableName)){//找到,再判断字段是否有新增
_local.indexed = true;//被比较过,该表不用删除
if(_local.columns.size()<_new.columns.size()){
//执行alert去新增字段 //
alterCoulmns(db != null?db:configdb,_local,_new);
}
break;//只要匹配到就直接跳出该层循环
}
}
//本地数据没找到这个表需要新增
createTableSQL(db != null?db:configdb,_new);
}
//针对被废弃的表需要在本地库中删除
for(int i=0;i<localConfig.dbTables.size();i++){
SpeSqliteTableSettingModel table = localConfig.dbTables.get(i);
if(!table.indexed){
dropTables(db != null?db:configdb,localConfig.dbTables.get(i));
}
}
//只有当是SQLiteDatabase升级时才能本地数据配置
if(db == null){
updateConfig2DB(configdb,newConfig);
}
}
}
private <T> void dropTables(T db,SpeSqliteTableSettingModel table){
String sql = " DROP TABLE IF EXISTS "+table.tableName;
executeSQL(db,sql);
}
private <T> void alterCoulmns(T db,SpeSqliteTableSettingModel _old,SpeSqliteTableSettingModel _new){
for(int i=0;i<_new.columns.size();i++){
if(i>=_old.columns.size()){
SpeSqliteColumnSettingModel column = _new.columns.get(i);
String sql = " alter table "+_old.tableName+" add column ";
sql+=column.key;
sql+=" ";
sql+= column.keyType;
executeSQL(db,sql);
}
}
}
private <T> void createTableSQL(T db,SpeSqliteTableSettingModel table){
String sql = " create table if not exists "+table.tableName+" (";
for(int j=0;j<table.columns.size();j++){
SpeSqliteColumnSettingModel column = table.columns.get(j);
sql+=column.key+" ";
sql+=column.keyType;
if(j==table.columns.size()-1){
sql+=")";
}else {
sql+=",";
}
}
executeSQL(db,sql);
}
以上就是android轻量级无侵入式管理数据库自动升级组件的详细内容,更多关于android数据库管理组件的资料请关注编程网其它相关文章!
--结束END--
本文标题: android轻量级无侵入式管理数据库自动升级组件
本文链接: https://www.lsjlt.com/news/197885.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-01-21
2023-10-28
2023-10-28
2023-10-27
2023-10-27
2023-10-27
2023-10-27
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0