Multitenant Application in Doobie

[guillaumebadin]

Hello,
we have a multi tenant application and we choose doobie for our sql.

Do we have a method in doobie to have a multi tenant application to force a filter for each transaction ?

For example hook transactor ?
Fragment hooks ?

[wedens]

You can modify Strategy.before to execute some ConnectionIO[Unit] in the beginning of each transaction that is executed with the modified Transactor.

val additionalBefore: ConnectionIO[Unit] = sql"SET search_path = ...".run.void 
// append an additional action to an existing one
val transactor0 = Transactor.before.modify(transactor, _ *>  additionalBefore)

[guillaumebadin]

Thank you I'll try it.