forked from woowacourse/android-shopping-cart
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CartDBHelper.kt
81 lines (71 loc) · 3.25 KB
/
CartDBHelper.kt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
package woowacourse.shopping.data.db
import android.content.ContentValues
import android.content.Context
import android.database.sqlite.SQLiteDatabase
import android.database.sqlite.SQLiteOpenHelper
import woowacourse.shopping.domain.model.CartProduct
class CartDBHelper(context: Context) : SQLiteOpenHelper(context, "cart", null, 1) {
override fun onCreate(db: SQLiteDatabase?) {
db?.execSQL(
"CREATE TABLE ${CartConstract.TABLE_NAME} (" +
" ${CartConstract.TABLE_COLUMN_ID} Int PRIMARY KEY not null," +
" ${CartConstract.TABLE_COLUMN_COUNT} Int not null" +
");",
)
}
override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {
db?.execSQL("DROP TABLE IF EXISTS ${CartConstract.TABLE_NAME}")
onCreate(db)
}
fun insert(id: Int, count: Int) {
val values = ContentValues()
values.put(CartConstract.TABLE_COLUMN_ID, id)
values.put(CartConstract.TABLE_COLUMN_COUNT, count)
writableDatabase.insert(CartConstract.TABLE_NAME, null, values)
}
fun update(id: Int, count: Int) {
writableDatabase.execSQL("UPDATE ${CartConstract.TABLE_NAME} SET ${CartConstract.TABLE_COLUMN_COUNT}=$count WHERE ${CartConstract.TABLE_COLUMN_ID}=$id")
}
fun remove(id: Int) {
writableDatabase.execSQL("DELETE FROM ${CartConstract.TABLE_NAME} WHERE ${CartConstract.TABLE_COLUMN_ID}=$id")
}
fun selectAll(): List<CartProduct> {
val products = mutableListOf<CartProduct>()
val sql = "select * from ${CartConstract.TABLE_NAME}"
val cursor = readableDatabase.rawQuery(sql, null)
while (cursor.moveToNext()) {
val id = cursor.getInt(cursor.getColumnIndexOrThrow(CartConstract.TABLE_COLUMN_ID))
val count = cursor.getInt(cursor.getColumnIndexOrThrow(CartConstract.TABLE_COLUMN_COUNT))
products.add(CartProduct(id, count))
}
cursor.close()
return products
}
fun selectWhereId(id: Int): CartProduct? {
val sql = "select * from ${CartConstract.TABLE_NAME} where ${CartConstract.TABLE_COLUMN_ID}=$id"
val cursor = readableDatabase.rawQuery(sql, null)
while (cursor.moveToNext()) {
val id = cursor.getInt(cursor.getColumnIndexOrThrow(CartConstract.TABLE_COLUMN_ID))
val count = cursor.getInt(cursor.getColumnIndexOrThrow(CartConstract.TABLE_COLUMN_COUNT))
cursor.close()
return CartProduct(id, count)
}
return null
}
fun selectRange(mark: Int, rangeSize: Int): List<CartProduct> {
val products = mutableListOf<CartProduct>()
val sql = "select * from ${CartConstract.TABLE_NAME} limit $rangeSize offset $mark;"
val cursor = readableDatabase.rawQuery(sql, null)
while (cursor.moveToNext()) {
val id = cursor.getInt(cursor.getColumnIndexOrThrow(CartConstract.TABLE_COLUMN_ID))
val count = cursor.getInt(cursor.getColumnIndexOrThrow(CartConstract.TABLE_COLUMN_COUNT))
products.add(CartProduct(id, count))
}
cursor.close()
return products
}
fun getSize(mark: Int): Boolean {
val itemsSize = selectAll().size
return mark in 0 until itemsSize
}
}