bjonnh
01/03/2019, 7:58 PMkotlin
fun getCitation(code: String, offset: Int = 0): Citation? {
var result: Citation? = null
transaction(db) {
result = Citation.wrapRows(Citations
.select { Citations.code eq code }.limit(1)).toList().getOrNull(0)
}
return result
}
tKw
01/04/2019, 1:28 AMobject Citations : IntIdTable("citations") {
data class Citation(val id: Int, val code: String, val citation: String)
val code = text("code").uniqueIndex()
val citation = text("citation")
private fun toCitation(row: ResultRow): Citation =
Citation(
row[Citations.id].value,
row[Citations.code],
row[Citations.citation]
)
fun getCitation(code: String): Citation? =
transaction {
Citations.select { Citations.code eq code }
.mapNotNull { toCitation(it) }
.singleOrNull()
}
}
tapac
01/09/2019, 1:55 PMfun getCitation(code: String, offset: Int = 0): Citation?
= transaction(db) {
Citation.find { Citations.code eq code }.limit(1)).toList().singleOrNull()
}