```object UserRatings: IntIdTable() { val value = long("value") val film = reference("film",...

# exposed

[Richard Romanowski]

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?
}

[Calvin]

does this work?
film = FilmEntity[filmId]

or maybe
film = StarWarsFilm[filmId]

[Richard Romanowski]

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

[Calvin]

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

[Calvin]

Does a get method exist on the StarWarsFilm class? StarWarsFilm.get(filmId)

val rating = UserRating.new {
  film = StarWarsFilm.get(filmId)
}

[hfhbd]

var filmID by UserRatings.film

new {
    this.filmID = filmId
}

[Richard Romanowski]

@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

[Richard Romanowski]

@hfhbd What do I lose by removing referencedOn?

[hfhbd]

You can have both. ReferencedOn reads the whole row from the referenced table

[Richard Romanowski]

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

[hfhbd]

Use both:
If you already have the dao, use new { this.film = filmDao }
If you already have the id, use new { this.filmID = filmId }.

[Richard Romanowski]

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

[hfhbd]

Add var filmID by UserRatings.film

[hfhbd]

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 filmID by UserRatings.film
    var user by User referencedOn UserRatings.user
}
val filmId: UUID = getFilmId()
val rating = UserRating.new {
  filmID = filmId
}

[Richard Romanowski]

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

[Richard Romanowski]

Working. Thanks for the tip

[Maksym]

seems like this syntax stoped working

var filmID by UserRatings.film

[Maksym]

after this declaration the filmID has type Column<EntityID<Int>>