zero_coding
08/23/2020, 8:37 AMobject Genders : Table() {
val gender: Column<String> = varchar("gender", 1)
val description: Column<String> = varchar("description", 20)
override val primaryKey = PrimaryKey(gender)
}
object Interests : IntIdTable() {
val interest: Column<String> = varchar("interest", 30)
}
object Users : UUIDTable() {
val gender: Column<String> = reference("gender_id", Genders.gender)
val birthday: Column<Long> = long("birthday")
}
class User(id: EntityID<UUID>) : UUIDEntity(id) {
companion object : UUIDEntityClass<User>(Users)
var gender by Users.gender
var birthday by Users.birthday
}
object UserInterests : Table() {
val user = reference("user_id", Users)
val interest = reference("interest_id", Interests)
}
and I would like to create a record for UserInterests
UserInterests.insert {
it[user] = TODO("What comes here?")
it[interest] = TODO("What comes here?")
}