SELECT single record

[alizarei95]

Hey guys, is there any way to select only one record with kotlin exposed? Currently I'm using below code to select a user from DB, but is there any function like selectSingle() to get an object (not list) ?

fun getUser(userId: Int): User? {

    var user: User? = null

    transaction {
        user = UserTable.select { UserTable.id eq userId }.limit(1).map { User.fromRow(it) }[0]
    }

    return user
}

It is not duplicate issue , I have not found any solution in issues

[hfazai]

You can use single() method:

fun getUser(userId: Int): User? {

    var user: User? = null

    val user = transaction {
       user = UserTable.select { UserTable.id eq userId }.limit(1).single().let { User.fromRow(it) }
    }

    return user
}

PS : single() will throw NoSuchElementException if there is no result and IllegalArgumentException if there is more than one resulted row.

also you can omit the user variable

fun getUser(userId: Int): User = 
        transaction {
                UserTable.select { UserTable.id eq userId }.limit(1).single().let { User.fromRow(it) }
        }