Room 2.2.0-alpha01

Transcript

1. ©2019 Wantedly, Inc. 3PPN
   BMQIB 4IJCVZBBQL
    ٱอग़խढ़ 2019/08/01
2. ©2019 Wantedly, Inc. ٱอग़խढ़ 8BOUFEMZ 8BOUFEMZ
   7JTJUͷ"OESPJEΞϓϦΛ։ൃ͍ͯ͠·͢ɻ
   ,PUMJO
   .BHJD
   UIF
   (BUIFSJOH
   1PLFNPO
   (P ࣗݾ঺հ 5XJUUFS
   !TXJ[@BSE (JU)VC
   !LVCPEF
3. ©2019 Wantedly, Inc. w 3PPN
   BMQIBͰ৽ػೳ͕৭ʑ૿͑ͨ
   w ৮ͬͯΈͨͷͰ঺հ͍ͨ͠
   https://github.com/kubode/sandbox-room-2.2.0-alpha01 ࿩͢͜ͱ
4. ©2019 Wantedly, Inc. 3PPN
   BMQIBͷ৽ػೳ
5. ©2019 Wantedly, Inc.  1SFQBDLBHFE
   %BUBCBTF
    4DIFNB
   %FGBVMU
   7BMVFT
    .BOZUP.BOZ
   3FMBUJPOT
    0OFUP0OF
   3FMBUJPOT
    5BSHFU
   &OUJUZ
    (SBEMF
   *ODSFNFOUBM
   "OOPUBUJPO
   1SPDFTTPS ৽ػೳ
6. ©2019 Wantedly, Inc. 1SFQBDLBHFE
   %BUBCBTF
7. ©2019 Wantedly, Inc. w BTTFUT΍ϑΝΠϧ͔Β৽͘͠%#Λ࡞ΕΔ
   w ༧ΊॳظσʔλΛ༻ҙͰ͖Δ આ໌
8. ©2019 Wantedly, Inc. Code // createFromAsset/File can't use with inMemoryDb Room.databaseBuilder(…) .createFromAsset("assets-path-to.db") // OR .createFromFile(File("path-to.db")) .build() Room.inMemoryDatabaseBuilder ͸ϥϯλΠϜΤϥʔʹͳΔ
9. ©2019 Wantedly, Inc. 4DIFNB
   %FGBVMU
   7BMVFT
10. ©2019 Wantedly, Inc. w !$PMVNO*OGP EFGBVMU7BMVF
    w ஋͕ͦͷ··$3&"5&
    5"#-&ʹ࢖ΘΕΔ આ໌
11. ©2019 Wantedly, Inc. Code @Entity data class Memo( @PrimaryKey(autoGenerate = true) val id: Long, val text: String, @ColumnInfo(defaultValue = "('Created at ' || CURRENT_TIMESTAMP)") val createdAt: String ) @Dao interface MemoDao { @Query("INSERT INTO Memo (text) VALUES (:text)") fun insertNewRecord(text: String) } ੑ্࣭@Insertʹ͸࢖͑ͳ͍
12. ©2019 Wantedly, Inc. .BOZUP.BOZ
    3FMBUJPOT
13. ©2019 Wantedly, Inc. w !3FMBUJPO͸0OFUP.BOZʹ͔͠࢖͑ͳ͔ͬͨ
    w
    BTTPDJBUF#ZͰ.BOZUP.BOZ΋Մೳʹ આ໌
14. ©2019 Wantedly, Inc. Code @Entity data class Playlist( @PrimaryKey(autoGenerate = true) val playlistId: Long, val title: String ) @Entity data class Song( @PrimaryKey(autoGenerate = true) val songId: Long, val title: String ) @Entity(primaryKeys = ["playlistId", "songId"]) data class PlaylistSongRef( val playlistId: Long, val songId: Long )
15. ©2019 Wantedly, Inc. Code data class PlaylistWithSongs( @Embedded val playlist: Playlist, @Relation( parentColumn = "playlistId", entity = Song::class, entityColumn = "songId", associateBy = Junction(PlaylistSongRef::class) ) val songs: List<Song> ) @Dao interface MusicDao { @Transaction @Query("""SELECT * FROM Playlist""") fun loadAllPlaylistWithSongs(): List<PlaylistWithSongs> } ORDER BY͸ࢦఆͰ͖ͳ͍
16. ©2019 Wantedly, Inc. 0OFUP0OF
    3FMBUJPOT
17. ©2019 Wantedly, Inc. w !3FMBUJPO͸-JTU4FUʹ͔͠࢖͑ͳ͔ͬͨ
    w
    ୯ҰΦϒδΣΫτʹ΋࢖͑ΔΑ͏ʹͳͬͨ આ໌
18. ©2019 Wantedly, Inc. Code @Entity data class User( @PrimaryKey val userId: Long, val name: String ) @Entity data class Profile( @PrimaryKey val userId: Long, val selfIntroduction: String )
19. ©2019 Wantedly, Inc. Code data class UserWithProfile( @Embedded val user: User, @Relation( parentColumn = "userId", entity = Profile::class, entityColumn = "userId" ) val profile: Profile? ) @Dao interface UserDao { @Transaction @Query("""SELECT * FROM User""") fun loadAllUserWithProfile(): List<UserWithProfile> } Nullableʹ͢Ε͹1:0..1΋දݱͰ͖Δ
20. ©2019 Wantedly, Inc. 5BSHFU
    &OUJUZ
21. ©2019 Wantedly, Inc. w *OTFSU6QEBUF%FMFUFʹFOUJUZ͕௥Ճ͞Εͨ
    w ผͷΦϒδΣΫτΛ&OUJUZͱͯ͠อଘͰ͖Δ આ໌
22. ©2019 Wantedly, Inc. Code @Entity data class Project( @PrimaryKey val id: Long, val title: String, @ColumnInfo(defaultValue = "''") val longDescription: String ) data class ProjectMiniApiEntity( var id: Long, var title: String ) PartialʹͳΔColumn͸ Nullable͔defaultValueඞਢ
23. ©2019 Wantedly, Inc. Code @Dao interface ProjectDao { @Insert(entity = Project::class) fun insertNewProject(projectMini: ProjectMiniApiEntity) @Update(entity = Project::class) fun updateProject(projectMini: ProjectMiniApiEntity) } INSERT OR ABORT INTO `Project` (`id`,`title`) VALUES (?,?) UPDATE OR ABORT `Project` SET `id` = ?,`title` = ? WHERE `id` = ?
24. ©2019 Wantedly, Inc. Code class CharSequenceConverter { @TypeConverter fun toString(value: CharSequence?): String? = value?.toString() } data class ProjectMiniApiEntity( var id: Long, @ColumnInfo(name = "title") var title2: CharSequence, @Ignore var list: List<String> ) TypeConverter͕͋Ε͹ม׵ͯ͘͠ΕΔ @ColumnInfoͰ໊લͷม׵΋Ͱ͖Δ Ignore΋Ͱ͖Δ
25. ©2019 Wantedly, Inc. w "1*Ωϟογϡ໨తͰ3PPNΛ࢖͍ͬͯΔͳΒศར
    w ҰཡͱৄࡉͰ৘ใྔ͕ҧ͏৔߹ͳͲ
    w !6QEBUFʹΑΔ෦෼Ξοϓσʔτ
    w ໊લ΍ܕ΋ม׵Ͱ͖Δ
    ॴײ
26. ©2019 Wantedly, Inc. *ODSFNFOUBM͸ࢼͯ͠·ͤΜ
    
27. ©2019 Wantedly, Inc. ·ͱΊ
28. ©2019 Wantedly, Inc. w 5BSHFU
    &OUJUZΊͪΌͪ͘Όཉ͔ͬͨ͠΍ͭ
    w 3PPN͸ͲΜͲΜศརʹ࢖͍΍͘͢
    w Ҿ͖ଓ͖3FMFBTF
    OPUFT؂ࢹ͍͖͍ͯͨ͠ ·ͱΊ