Limit Flashcard Reviews Per Session

[lewisjwilson]

In DatabaseHelper.kt/dueFlashcards(), change:

val cur = readableDatabase.rawQuery("SELECT * FROM " + TABLE1_NAME +
        " WHERE " + COL8 + "<= date('now')", null) //next_review < date now

to

val reviewNo = 25
try {
        db?.beginTransaction()
        val sql = "SELECT * FROM ? WHERE ? <= date('now') LIMIT ?"
        val statement = db?.compileStatement(sql)
        statement?.bindString(1, TABLE1_NAME)
        statement?.bindString(2, COL8)
        statement?.bindString(3, reviewNo.toString())
        statement?.execute()
        db?.setTransactionSuccessful()
} catch (e: SQLException) {
        Log.w("Exception:", e)
} finally {
        db?.endTransaction()
}

This will limit the number of reviews in each session to reviewNo. Binding done to prevent injection.