repo

gistfile1.txt

package com.example.mockie.tigaer.database.repository

import android.content.Context
import com.example.mockie.tigaer.database.database
import org.jetbrains.anko.db.*
import com.example.mockie.tigaer.database.model.User as UserModel

/**
 * Created by mockie on 18/12/17.
 */

class User (val context: Context) {

    fun getUserByUid(uid: Int): UserModel?
    {
        val data = context.database.use {
            val db = context.database.readableDatabase
            val columns = UserModel.COLUMN_ID + "," + UserModel.COLUMN_NAME + "," + UserModel.COLUMN_API_KEY

            val query = db.select(UserModel.TABLE_NAME, columns)
                    .whereArgs("(uid = {userId})",
                            "userId" to uid)

            query.exec {
                val rowParser = classParser<UserModel>()
                parseList(rowParser)
            }
        }

        return data.firstOrNull()
    }

    fun isLogin(): Boolean
    {
        val data = context.database.use {
            val db = context.database.readableDatabase
            val columns = UserModel.COLUMN_ID + "," + UserModel.COLUMN_NAME + "," + UserModel.COLUMN_API_KEY

            val query = db.select(UserModel.TABLE_NAME, columns)

            query.exec {
                val rowParser = classParser<UserModel>()
                parseList(rowParser)
            }
        }

        return data.firstOrNull() != null
    }

    fun add(id: Int, name: String, apiKey: String)
    {
        context.database.use {
            val db = context.database.writableDatabase
            db.insert(UserModel.TABLE_NAME,
                    UserModel.COLUMN_ID to id,
                    UserModel.COLUMN_NAME to name,
                    UserModel.COLUMN_API_KEY to apiKey
            )
        }
    }

}