Room 2.2.0-alpha01 - Speaker Deck

Slide 1

Slide 1 text

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

Slide 8

Slide 8 text

©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 ͸ϥϯλΠϜΤϥʔʹͳΔ

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

©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ʹ͸࢖͑ͳ͍

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

©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 )

Slide 15

Slide 15 text

©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 ) @Dao interface MusicDao { @Transaction @Query("""SELECT * FROM Playlist""") fun loadAllPlaylistWithSongs(): List } ORDER BY͸ࢦఆͰ͖ͳ͍

Slide 16

Slide 16 text

Slide 17

Slide 17 text

Slide 18

Slide 18 text

Slide 19

Slide 19 text

©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 } Nullableʹ͢Ε͹1:0..1΋දݱͰ͖Δ

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

©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ඞਢ

Slide 23

Slide 23 text

©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` (ìd`,`title`) VALUES (?,?) UPDATE OR ABORT `Project` SET ìd` = ?,`title` = ? WHERE ìd` = ?

Slide 24

Slide 24 text

©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 ) TypeConverter͕͋Ε͹ม׵ͯ͘͠ΕΔ @ColumnInfoͰ໊લͷม׵΋Ͱ͖Δ Ignore΋Ͱ͖Δ