Getting an attribute from session and use it in jdbc

23 Views Asked by At

I want to make a scenario in which I delete from my database the cases created with an attribute from a feeder.

The scenario: def jdbcCleanUpScenario(tenant: String, userDetails: BatchableFeederBuilder[String]): ScenarioBuilder = {

scenario(s"JDBC CleanUP scenario $tenant")
  .feed(userDetails)
  .exec { session =>
    val involvedPartyId = session("involvedPartyUuid").as[String]
    session.set("involvedPartyId", involvedPartyId)
  }
  .exec(jdbc("Delete Cases").rawSql(s"DELETE FROM CASES_$tenant WHERE INVOLVED_PARTY_ID='$involvedPartyId'"))

But inside the rawSql I get the error: Cannot resolve symbol involvedPartyId

How can I get an attribute and then exec a jdbc?

0

There are 0 best solutions below