Slide 1
Slide 1 text
©2019 Wantedly, Inc.
3PPNBMQIB
4IJCVZBBQL
ٱอग़խढ़
2019/08/01
Slide 2
Slide 2 text
©2019 Wantedly, Inc.
ٱอग़խढ़
8BOUFEMZ
8BOUFEMZ7JTJUͷ"OESPJEΞϓϦΛ։ൃ͍ͯ͠·͢ɻ
,PUMJO
.BHJDUIF(BUIFSJOH
1PLFNPO(P
ࣗݾհ
5XJUUFS
!TXJ[@BSE
(JU)VC
!LVCPEF
Slide 3
Slide 3 text
©2019 Wantedly, Inc.
w 3PPNBMQIBͰ৽ػೳ͕৭ʑ૿͑ͨ
w ৮ͬͯΈͨͷͰհ͍ͨ͠
https://github.com/kubode/sandbox-room-2.2.0-alpha01
͢͜ͱ
Slide 4
Slide 4 text
©2019 Wantedly, Inc.
3PPNBMQIBͷ৽ػೳ
Slide 5
Slide 5 text
©2019 Wantedly, Inc.
1SFQBDLBHFE%BUBCBTF
4DIFNB%FGBVMU7BMVFT
.BOZUP.BOZ3FMBUJPOT
0OFUP0OF3FMBUJPOT
5BSHFU&OUJUZ
(SBEMF*ODSFNFOUBM"OOPUBUJPO1SPDFTTPS
৽ػೳ
Slide 6
Slide 6 text
©2019 Wantedly, Inc.
1SFQBDLBHFE%BUBCBTF
Slide 7
Slide 7 text
©2019 Wantedly, Inc.
w BTTFUTϑΝΠϧ͔Β৽͘͠%#Λ࡞ΕΔ
w ༧ΊॳظσʔλΛ༻ҙͰ͖Δ
આ໌
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
©2019 Wantedly, Inc.
4DIFNB%FGBVMU7BMVFT
Slide 10
Slide 10 text
©2019 Wantedly, Inc.
w !$PMVNO*OGP EFGBVMU7BMVF
w ͕ͦͷ··$3&"5&5"#-&ʹΘΕΔ
આ໌
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
©2019 Wantedly, Inc.
.BOZUP.BOZ3FMBUJPOT
Slide 13
Slide 13 text
©2019 Wantedly, Inc.
w !3FMBUJPO0OFUP.BOZʹ͔͑͠ͳ͔ͬͨ
w BTTPDJBUF#ZͰ.BOZUP.BOZՄೳʹ
આ໌
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
©2019 Wantedly, Inc.
0OFUP0OF3FMBUJPOT
Slide 17
Slide 17 text
©2019 Wantedly, Inc.
w !3FMBUJPO-JTU4FUʹ͔͑͠ͳ͔ͬͨ
w ୯ҰΦϒδΣΫτʹ͑ΔΑ͏ʹͳͬͨ
આ໌
Slide 18
Slide 18 text
©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
)
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
©2019 Wantedly, Inc.
5BSHFU&OUJUZ
Slide 21
Slide 21 text
©2019 Wantedly, Inc.
w *OTFSU6QEBUF%FMFUFʹFOUJUZ͕Ճ͞Εͨ
w ผͷΦϒδΣΫτΛ&OUJUZͱͯ͠อଘͰ͖Δ
આ໌
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` (`id`,`title`)
VALUES (?,?)
UPDATE OR ABORT `Project`
SET `id` = ?,`title` = ?
WHERE `id` = ?
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Ͱ͖Δ
Slide 25
Slide 25 text
©2019 Wantedly, Inc.
w "1*ΩϟογϡతͰ3PPNΛ͍ͬͯΔͳΒศར
w ҰཡͱৄࡉͰใྔ͕ҧ͏߹ͳͲ
w !6QEBUFʹΑΔ෦Ξοϓσʔτ
w ໊લܕมͰ͖Δ
ॴײ
Slide 26
Slide 26 text
©2019 Wantedly, Inc.
*ODSFNFOUBMࢼͯ͠·ͤΜ
Slide 27
Slide 27 text
©2019 Wantedly, Inc.
·ͱΊ
Slide 28
Slide 28 text
©2019 Wantedly, Inc.
w 5BSHFU&OUJUZΊͪΌͪ͘Όཉ͔ͬͨͭ͠
w 3PPNͲΜͲΜศརʹ͍͘͢
w Ҿ͖ଓ͖3FMFBTFOPUFTࢹ͍͖͍ͯͨ͠
·ͱΊ