Slick Database => doobie Transactor

DoobieSlickCompat.scala

import cats.effect.Async
import doobie.util.transactor.Transactor

import scala.concurrent.ExecutionContext

trait DoobieSlickCompat {

  /** Create a Doobie Transactor backed by the same Jdbc DataSource as the live slick Database */
  def transactorFromSlick[F[_]: Async](
      slickDb: slick.jdbc.JdbcBackend#Database,
      connectEc: ExecutionContext
  ): Option[Transactor[F]] = {
    val jdbcSource = slickDb.source match {
      case s: slick.jdbc.hikaricp.HikariCPJdbcDataSource => Some(s.ds)
      case s: slick.jdbc.DataSourceJdbcDataSource        => Some(s.ds)
      case _                                             => None
    }
    jdbcSource.map(Transactor.fromDataSource[F](_, connectEc))
  }
}

object DoobieSlickCompat extends DoobieSlickCompat

Updated CE2 -> CE3