The roomdemo from magicer

roomdemo's Introduction

Note

记得在build.gradle添加 apply plugin: 'kotlin-kapt'

    kapt "androidx.room:room-compiler:$room_version" // For Kotlin use kapt instead of annotationProcessor
    androidTestImplementation "androidx.room:room-testing:$room_version"

Tips

建表语句可以直接复制AppDatabase_Impl.java-> createAllTables的。需要注意的就是改变了表结构之后重新Build一下

Relations

Database relations with Room

注意Dao文件中@Transaction的使用

Many-to-Many

当两个类的PrimaryKey都叫id时 join表里又自定义了两个字段的id：如下：

      @Entity
      data class PersonSubjectJoin(
      
          @ColumnInfo(name = "p_id")
          val personId: Int,
          
          @ColumnInfo(name = "s_id")
          val subjectId: Int
      )

这个时候定义PersonWithSubjects或者 SubjectWithPerson类的时候需要指定associateBy的parentColumn、entityColumn，像下边这样：

 data class PersonWithSubjects(
 
     @Embedded val person: Person,
 
     @Relation(
         parentColumn = "id",
         entityColumn = "id",
         associateBy = Junction(
             PersonSubjectJoin::class,
             parentColumn = "p_id", //note
             entityColumn = "s_id"  //note
         )
     )
     val subjects: List<Subject>
 )

Migration

Migration测试 https://medium.com/androiddevelopers/testing-room-migrations-be93cdb0d975

Migration测试官方Sample

TypeConverter

//官方Simple中的Converter例子
public class DateConverter {
    @TypeConverter
    public static Date toDate(Long timestamp) {
        return timestamp == null ? null : new Date(timestamp);
    }

    @TypeConverter
    public static Long toTimestamp(Date date) {
        return date == null ? null : date.getTime();
    }
}