Testing the Repository

private val dbConfig: DatabaseConfig[JdbcProfile] =
    DatabaseConfig.forConfig("database", system.settings.config)
private val repo = new Repository(dbConfig)
override protected def beforeEach(): Unit = {
    flyway.clean()
    val _ = flyway.migrate()
    super.beforeEach()
}
override protected def afterEach(): Unit = {
    flyway.clean()
    super.afterEach()
}
override protected def afterAll(): Unit = {
    repo.close()
    super.afterAll()
} 

"#loadProduct" when {
    "the ID does not exist" must {
        "return an empty list of rows" in {
            val id = UUID.randomUUID
            for {
                rows <- repo.loadProduct(id)
            } yield {
                rows must be(empty)
            }
        }
    }
    
    "the ID exists" must {
        "return a list with all product rows" in {
            genProduct.sample match {
                case None => fail("Could not generate data sample!")
                case Some(p) => 
                    for {
                        _ <- repo.saveProduct(p)
                        rows <- repo.loadProduct(p.id)
                    } yield {
                        Product.fromDatabase(rows) match {
                            case None => fail("No product created from database rows!")
                            case Some(c) => 
                            c.id must be(p.id)
                            c mustEqual p
                        }
                    } 
            }
        }
    }
}