Search For Word in Dictionary

DictionaryRepository.kt

val findSpec = SqlQuerySpec().apply {
                queryText = "SELECT Dictionary.word AS word, Dictionary.meaning AS meaning FROM Dictionary WHERE Dictionary.partition = @tag AND contains(Dictionary.search, @query) OFFSET @offset LIMIT @records_per_page"
                parameters = SqlParameterCollection().apply {
                    add(SqlParameter("@tag", query.first().toUpperCase().toString()))
                    add(SqlParameter("@query", query.toLowerCase()))
                    add(SqlParameter("@offset", offset))
                    add(SqlParameter("@records_per_page", RECORDS_PER_PAGE))
                }
            }
val countSpec = SqlQuerySpec().apply {
                queryText = "SELECT COUNT(1) AS TotalRecords FROM Dictionary WHERE Dictionary.partition = @tag AND contains(Dictionary.search, @query)"
                parameters = SqlParameterCollection().apply {
                    add(SqlParameter("@tag", query.first().toUpperCase().toString()))
                    add(SqlParameter("@query", query.toLowerCase()))
                }
            }