Hello, Is there a way to get use store and retriev...

# exposed

[Rasheed Sulayman]

Hello,
Is there a way to get use store and retrieve data classes directly with exposed, something like:

object Users : Table() {}

// Get list of users
val usersList: List<User> = Users.select { Users.city.eq("a city") }

//Insert users 

val allUsers: List<User> = //list of users 
val aUser: User = //User instance

Users.insertAll(allUsers) // Inserts everything in to the user table
Users.insert(aUser) // Inserts a single user in to the table.

i.e Something that automatically maps/converts rows to data classes when reading stuff, and vice versa when inserting.

[codec]

depending on the fields your user data class contains.. it could look something like this:

return transaction(db) {
            UsersTable.select { UsersTable.email.eq(email) }
                .map { User(it[UsersTable.id], email, it[UsersTable.first_name], it[UsersTable.last_name], it[UsersTable.password]) }
                .singleOrNull()
        }

[codec]

notice the call to .map { } after the .select { } completion block…

[tjohnn]

I usually have extension functions that convert db record to data classes, do it manually for insertion

[tapac]

There is https://github.com/TouK/krush and also you could vote and suggest for
https://github.com/JetBrains/Exposed/issues/24#issuecomment-566725685

[Rasheed Sulayman]

Thanks for the input @codec and @tjohnn, I was looking for something to automatically do this:

.map { User(it[UsersTable.id], email, it[UsersTable.first_name], it[UsersTable.last_name], it[UsersTable.password]) }

without having to write it manually... Imagine if you have objects/data classes with 30+ fields (i.e 30+ table columns).

[Rasheed Sulayman]

There is <https://github.com/TouK/krush> and also you could vote and suggest for
<https://github.com/JetBrains/Exposed/issues/24#issuecomment-566725685>

Thanks @tapac, this sounds like what i'm looking for.