Kotlin Programming Cookbook

How to do it…

We will be creating two tables: Requests and customers:

1. For the Requests table, we have the name and message fields, and we can directly create them in the onCreate method of our database helper, as shown:

db.createTable("Requests", true,    "id" to INTEGER + PRIMARY_KEY + UNIQUE,    "name" to TEXT,    "message" to TEXT)

2. For the customers table, we will be using a better coding practice by making a data class and using it to define the columns of the customers table. Given here is the code for our Customer data class:

data class Customer(val id: Int, val name: String, val phone_num: String) {    companion object {        val COLUMN_ID = "id"        val TABLE_NAME = "customers"        val COLUMN_NAME = "name"        val COLUMN_PHONE_NUM = "phone_num"    }}

3. Now, we ...