IntegrationTesting.scala

package com.evolutiongaming.bootcamp.testing2

import UserService._
import io.circe.Decoder.state
import java.sql.Connection
import java.sql.DriverManager
import org.openqa.selenium.WebDriver
import org.openqa.selenium.htmlunit.HtmlUnitDriver
import org.scalatest.funsuite.AnyFunSuite
import org.scalatestplus.selenium.HtmlUnit
import org.scalatestplus.selenium.WebBrowser

// This is the most expensive type of the tests, because of potential flakiness
// and the need of the heavyweight machines to execute them.
//
// Nowadays, with advent of Selenium DSL etc., it is quite easy to use integration
// testing DSLs for the applications, and, as consequence, some teams are crazy
// overdoing with these. We recommend to push as much as possible testing towards
// unit and compiler level tests.
//
// Integration tests could be run using embedded servers or using real virtual
// environments using docker containers etc.
//

// *Exercise 1*
//
// Implement a test checking that there is CrazyTime game on Evolution site.
//
// sbt:scala-bootcamp> testOnly *testing2.EvolutionSiteSpec
//
class EvolutionSiteSpec extends AnyFunSuite with WebBrowser {

  implicit val driver: WebDriver = new HtmlUnitDriver

  test("new Evolution Gaming domain could be found using Duck Duck Go") {
    goTo("https://duckduckgo.com/")

    assert(pageTitle.startsWith("DuckDuckGo"))
    textField("q").value = "Evolution Gaming"
    submit()
    assert(pageSource contains "evolution.com")
  }

  test("Evolution site contains Crazy Coin Flip game") {
    ???
  }

}

// *Exercise 2*
//
// Sometimes integration tests could be a necessity or, at least very useful.
// For example, if you need to check your SQL queries are working.
//
// Implement the missing tests for `UserService`.
//
// sbt:scala-bootcamp> testOnly *testing2.UserServiceSpec
//
// Hint: do not use plain JDBC in Scala, there are much more convenient libraries
// for real work, i.e. Doobie, Quill, Slick etc. which provide automatic resource
// management, class mapping etc. You will learn them later during this course.
//
class UserService(connection: Connection) {

  def createTable(): Unit = {
    val statement = connection.createStatement()
    try {
      statement.execute("create table players(id VARCHAR, name VARCHAR, score INT)")
    } finally {
      statement.close()
    }
  }

  def insert(player: Player): Unit = {
    val statement = connection.createStatement()
    try {
      statement.execute(s"insert into players values ('${player.id}', '${player.name}', ${player.score})")
    } finally {
      statement.close()
    }
  }

}
object UserService {
  case class Player(id: String, name: String, score: Int)
}
class UserServiceSpec extends AnyFunSuite {

  class Fixture {
    Class.forName("org.h2.Driver")
    val connection = DriverManager.getConnection("jdbc:h2:mem:UserServiceSpec")
  }

  test("that we can create a table in a database") {
    val f       = new Fixture
    val service = new UserService(f.connection)
    service.createTable()
  }

  test("that we can insert a player") {
    val f       = new Fixture
    val service = new UserService(f.connection)
    ???
  }

  test("that we can select a player") {
    val f       = new Fixture
    val service = new UserService(f.connection)
    ???
  }

}