object UserRatings: IntIdTable() {
    val value = long("value")
    val film = reference("film", StarWarsFilms)
    val user = reference("user", Users)
}
class UserRating(id: EntityID<Int>): IntEntity(id) {
    companion object : IntEntityClass<UserRating>(UserRatings)
    var value by UserRatings.value
    var film by StarWarsFilm referencedOn UserRatings.film // use referencedOn for normal references
    var user by User referencedOn UserRatings.user
}

If I have the ID of a film how can I create a new rating with the DAO api? Example:

val filmId: UUID = getFilmId()
val rating = UserRating.new {
  // what goes here to set film?
}

does this work?

film = FilmEntity[filmId]

or maybe

film = StarWarsFilm[filmId]

No, I don't understand what this syntax is trying to do

You have the ID of the entity, so i'm trying to get you a filmentity object from the ID so you can set the reference when creating the UserRating

var filmID by UserRatings.film

new {
    this.filmID = filmId
}

@Calvin I want to avoid another database call if I already have the ID, since the column is just and ID with a FK defined

You can have both.

ReferencedOn

reads the whole row from the referenced table

But if I have

referencedOn

I don't see how to set that field when I'm creating a new record when I have the id of the reference I want to set without making an extra call to the db

Use both: If you already have the dao, use

new { this.film = filmDao }

If you already have the id, use

new { this.filmID = filmId }

.

I get an error that it's expecting the entity instead of just the UUID

Add

var filmID by UserRatings.film

ah, I can put both. cool. let me try that