https://kotlinlang.org logo
#exposed
Title
# exposed
m

mmaillot

08/18/2020, 2:35 PM
Hi! I have a
UUIDTable
`Intervention`with a child:
val foreignEnterprise = reference("foreign_enterprise", ForeignEnterprises.id)
. I want to get the foreign enteprise for an intervention. I have the
InterventionUuid
. How can I do ? In SQL, I do: SELECT foreign_enterprise.* from foreign_enterprise, intervention WHERE intervention.foreign_enteprise_id = foreign_enterprise_id AND intervention.id ='`INPUT_UUID`'.
Ok, after review the doc, I did this :
Copy code
ForeignEnterprises.join(
            Interventions,
            JoinType.INNER
        )
            .slice(ForeignEnterprises.columns)
            .select { Interventions.id eq interventionId.value }
            .map { ForeignEnterprises.toModel(it) }
            .first()
j

Joel

08/18/2020, 5:47 PM
ForeignEnterprises innerJoin Interventions
should also be valid. The
reference
you've added ties them together.
m

mmaillot

08/19/2020, 8:18 AM
Ok, I have this now:
Copy code
ForeignEnterprises.innerJoin(Interventions)
            .slice(ForeignEnterprises.columns)
            .select { Interventions.id eq interventionId.value }
            .map { ForeignEnterprises.toModel(it) }
            .first()
Is it what you mean ?
2 Views