import android.content.Context
import android.database.sqlite.SQLiteDatabase
import android.database.sqlite.SQLiteOpenHelper

class DataBaseHelper(context: Context, dbName: String):
    SQLiteOpenHelper(context, dbName, null, 1) {

    override fun onCreate(db: SQLiteDatabase?) {}

    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int,
                          newVersion: Int) {}
}

//Connect to the database
val dbHelper = DataBaseHelper(
    context,
    dbPath + "DatabaseName.sqlite"
)

//SQL query execution
val db = dbHelper.readableDatabase
val cursor = db.rawQuery(
    """SELECT
         Language, Percentage
       FROM countrylanguage
       WHERE
         CountryCode = ? AND
         Percentage > ?""", arrayOf("RUS", "0.5"))

// Get all rows
cursor.moveToFirst()
while (!cursor.isAfterLast()) {
    println(cursor.getString(0) +
            ": " + cursor.getDouble(1))
    cursor.moveToNext()
}

//Close the connection
cursor.close()