Sample Query SQLite Kotlin

MySqlHelper

    fun getListCat(): ArrayList<ItemMenu> {
        var query = "SELECT * FROM  " + CATEGORY
        var cursor :Cursor = database.rawQuery(query, null)
        var arrCategory = ArrayList<ItemMenu>()
        if (cursor.moveToFirst()) {
            do {
                var item = ItemMenu(cursor.getString(0), cursor.getString(1))
                arrCategory.add(item)
            } while (cursor.moveToNext())
        }
        cursor.close()
        return arrCategory

    }