sugar 数据库升级，保存原有数据 步骤（使用了contentProvider）

最近用SugarOrm创建了数据表userInfo，用contentProvider暴露数据，后来userInfo中增加了两个字段，升级数据库时遇到了找不到字段的异常。

下面记录了解决的方法

原来的数据表：

public class UserInfo extends SugarRecord {
    private int userId;
    private String userName;
    private String sex;
    private String userImg;
    private String birthday;
    private float height;
    private float weight;
    private String phone;
  
    @Ignore
    private boolean isSelect;//是否选中

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserImg() {
        return userImg;
    }

    public void setUserImg(String userImg) {
        this.userImg = userImg;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public float getHeight() {
        return height;
    }

    public void setHeight(float height) {
        this.height = height;
    }

    public float getWeight() {
        return weight;
    }

    public void setWeight(float weight) {
        this.weight = weight;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }


    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }
}

1. 新的userInfo表：

public class UserInfo extends SugarRecord {
    private int userId;
    private String userName;
    private String sex;
    private String userImg;
    private String birthday;
    private float height;
    private float weight;
    private String tags;
    private String phone;
    private String faceId;
    private boolean isMain;//是否是主帐号
    private String mainPhone;//关联主帐号
    private String facePosition;//脸部位置
    private String facepath;//人脸图片路径
    private String mac;//冰箱mac
    private String tagIds;
    private String isLogin;//1:登录；0:未登录
    private String isDefault;//1:是默认帐户；0:不是默认账户
    @Ignore
    private boolean isSelect;//是否选中

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserImg() {
        return userImg;
    }

    public void setUserImg(String userImg) {
        this.userImg = userImg;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public float getHeight() {
        return height;
    }

    public void setHeight(float height) {
        this.height = height;
    }

    public float getWeight() {
        return weight;
    }

    public void setWeight(float weight) {
        this.weight = weight;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }


    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public boolean isSelect() {
        return isSelect;
    }

    public void setSelect(boolean select) {
        isSelect = select;
    }

    public String getIsLogin() {
        return isLogin;
    }

    public void setIsLogin(String isLogin) {
        this.isLogin = isLogin;
    }

    public String getIsDefault() {
        return isDefault;
    }

    public void setIsDefault(String isDefault) {
        this.isDefault = isDefault;
    }
}

2.  sugar数据库升级：

在src/main目录下，新建accests/sugar_upgrades目录，创建文件2.sql，将要添加的字段写进2.sql，

alter table USER_INFO add IS_LOGIN VARCHAR;
alter table USER_INFO add IS_DEFAULT VARCHAR;

3.  ContentProvier文件：

public class FamilyProvider extends ContentProvider {
    //这里的AUTHORITY就是我们在AndroidManifest.xml中配置的authorities，这里的authorities可以随便写
    private static final String AUTHORITY = "com.privider.Family";
    //匹配成功后的匹配码
    private static final int MATCH_ALL_CODE = 200;
//    private static final String MATCH_ONE_CODE = "101";
    private static UriMatcher uriMatcher;
    private Cursor cursor = null;
    private static final Uri FAMILY_URI = Uri.parse("content://"+AUTHORITY+"/USER_INFO");

    private SQLiteFamilyUtil sqLiteFamilyUtil;
    private SQLiteDatabase db;
    //在静态代码块中添加要匹配的 Uri
    static {
        //匹配不成功返回NO_MATCH(-1)
        uriMatcher = new UriMatcher(UriMatcher.NO_MATCH);

        uriMatcher.addURI(AUTHORITY,"USER_INFO",MATCH_ALL_CODE);
    }


    @Override
    public boolean onCreate() {
        sqLiteFamilyUtil = new SQLiteFamilyUtil(getContext());
        db = sqLiteFamilyUtil.getReadableDatabase();
        return false;
    }

    @Nullable
    @Override
    public Cursor query(@NonNull Uri uri, @Nullable String[] strings, @Nullable String s,
                        @Nullable String[] strings1, @Nullable String s1) {
        Cursor cursor = null;
        switch (uriMatcher.match(uri)){
            case MATCH_ALL_CODE:
                cursor = db.query("USER_INFO",null,null,null,null,null,null);
                Log.e("wangchm","cursor.getCount()="+cursor.getCount());
                break;
        }
        return cursor;
    }

    @Nullable
    @Override
    public String getType(@NonNull Uri uri) {
        return null;
    }

    @Nullable
    @Override
    public Uri insert(@NonNull Uri uri, @Nullable ContentValues contentValues) {
        return null;
    }

    @Override
    public int delete(@NonNull Uri uri, @Nullable String s, @Nullable String[] strings) {
        return 0;
    }

    @Override
    public int update(@NonNull Uri uri, @Nullable ContentValues contentValues, @Nullable String s, @Nullable String[] strings) {
        return 0;
    }
}

SQLiteFamilyUtil.java文件：

public class SQLiteFamilyUtil extends SQLiteOpenHelper{
    private static final int VERSION = 2;  // 版本号
    public static final String DB_NAME ="/data/data/com.unilife.fridge.haierbase.tft/databases/user.db";
    public SQLiteFamilyUtil(Context context, String name, CursorFactory factory,
                            int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        //创建数据库和表
        String family="create table if not exists USER_INFO(ID INTEGER PRIMARY KEY AUTOINCREMENT,USER_ID Integer,USER_NAME varchar(100),"+
                "SEX varchar(10),USER_IMG varchar(100),BIRTHDAY varchar(100),HEIGHT Float," +
                "WEIGHT Float,TAGS varchar(100),PHONE varchar(100),"+
                ",IS_LOGIN varchar(100)"+
                ",IS_DEFAULT varchar(100)"+
                ")";
        sqLiteDatabase.execSQL(family);
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
        Log.e("wangchm","onUpgrade "+i+",i1="+i1);
        //OnUpgrade() 方法中的 switch 语句是没有 break 的，会一直执行到语句结束。为什么要这么写想想就明白了。
        // 比如用户手上的版本是 1，新版 App 的版本是 5，那么就会有 4 个版本的数据库升级，switch() 自然不能中途 break，
        // 必须执行这 4 个版本的数据库升级语句。
        switch (i){
            case 1:
                sqLiteDatabase.execSQL("alter table USER_INFO add IS_LOGIN VARCHAR;");  // 增加字段
                sqLiteDatabase.execSQL("alter table USER_INFO add IS_DEFAULT VARCHAR;");  // 增加字段
            default:
                break;
        }
//        sqLiteDatabase.execSQL("drop table if exists USER_INFO;");
//        onCreate(sqLiteDatabase);
    }

    public SQLiteFamilyUtil(Context context, String name, int version) {
        this(context, name, null, version);
    }

    public SQLiteFamilyUtil(Context context, String name) {
        this(context, name, VERSION);
    }
    public SQLiteFamilyUtil(Context context){
        super(context, DB_NAME, null, VERSION);
    }

}

将第一行的版本号改为2；并在onUpgrade中利用旧版本号做判断。

4.  在AndroidManifest.xml中，把版本号改为2