jczuchnowski

trait DatabaseProvider {
  def databaseProvider: DatabaseProvider.Service
}

object DatabaseProvider {
  trait Service {
    def db: UIO[BasicBackend#DatabaseDef]
  }
}

jczuchnowski

import zio.IO

trait AssetRepository {
  def add(name: String, price: BigDecimal): IO[RepositoryFailure, AssetId]
    
  def getById(id: AssetId): IO[RepositoryFailure, Option[Asset]]

  def update(id: AssetId, name: String, price: BigDecimal): IO[RepositoryFailure, Unit]
}

jczuchnowski

val db = Database.forConfig("h2mem1")

val queryAction: DBIO[Option[Int]] = ...

val result: Future[Option[Int]] = db.run(queryAction)