迁移未正确处理Room数据库（java.lang.IllegalStateException）

Question

我有致命的异常：java.lang.RuntimeException：计算数据库实时数据时出现异常。在崩溃报告中

为什么TableInfo中的所有内容都是空的

@Entity(tableName = "card_data")
@Keep
public class CardDataEntity {

    @PrimaryKey(autoGenerate = true)
    private int cardId;
    private String cardName;
    private String time;
    private String sqlDate;
    private int cardNumber;
    private String fPathImg;
    private String bPathImg;
    private String cardType;
    @Ignore
    private boolean isHeader;

    public CardDataEntity(String cardName, String time, String sqlDate, int cardNumber, String fPathImg, String bPathImg, String cardType) {

        this.cardName = cardName;
        this.time = time;
        this.sqlDate = sqlDate;
        this.cardNumber = cardNumber;
        this.fPathImg = fPathImg;
        this.bPathImg = bPathImg;
        this.cardType = cardType;
        this.isHeader = false;

    }

    // setter getter here

}

@Database(entities = {ScanDataEntity.class , ScanDataBookmarkEntity.class,
        GenerateDataEntity.class, GenerateBookmarkDataEntity.class, CardDataEntity.class, CardBookmarkDataEntity.class},
        version = 7, exportSchema = false)

public abstract class ScanDatabase extends RoomDatabase {
    public abstract ScanDataDao scanDataDao();
    // DAO classes

    private static ScanDatabase dataBase;

    public static ScanDatabase getInstance(Context context){
        if (null== dataBase){
            dataBase= buildDatabaseInstance(context);
        }
        return dataBase;
    }

    private static final Migration MIGRATION_6_7 = new Migration(6, 7) {
        @Override
        public void migrate(SupportSQLiteDatabase database) {
            try {
                database.execSQL("ALTER TABLE generate_data "
                        + " ADD COLUMN generateImgPath TEXT");
            }catch (Exception e){
                e.printStackTrace();
            }
        }
    };
   
    // same migration for other versions 

    private static ScanDatabase buildDatabaseInstance(Context context) {
        return Room.databaseBuilder(context,
                ScanDatabase.class,
                "scan_database")
                .addMigrations(MIGRATION_6_7,MIGRATION_5_7,MIGRATION_4_7,MIGRATION_3_7,MIGRATION_2_7,MIGRATION_1_7)
//                .fallbackToDestructiveMigration()
                .allowMainThreadQueries().build();

    }

}

谁能帮我一下，我真的不知道我做错了什么或者是不是一个bug。

Answer 1

使用@ColumnInfo批注指定列名，以提供与此字段关联的列数据。就像

@PrimaryKey(autoGenerate = true)
@ColumnInfo(name = "cardId")
private int cardId;
.....