Md Sadique Inam
04/15/2024, 4:46 AMwith()
? For example, we have a field signifying a soft-deleted row: `deleted`; is there a way to specify that we don't want to eager-fetch rows whose deleted = 't'
? or by giving expression with reference in Entity class.
example
object Users : UUIDTable("x") {
val deleted: Column<Boolean> = bool("deleted").default(false)
val teamId: Column<UUID> = reference("team_id", Teams)
}
class User(id: EntityID<UUID>) : UUIDEntity(id) {
companion object : UUIDEntityClass<User>(Users)
var deleted by Users.deleted
}
object Teams : UUIDTable("y") {
val deleted: Column<Boolean> = bool("deleted").default(false)
}
class Team(id: EntityID<UUID>) : UUIDEntity(id) {
companion object : UUIDEntityClass<Team>(Teams)
var deleted by table.deleted
val members by User referrersOn Users.teamId
}