// src/test/scala/Example.scala

import doobie.imports._
import doobie.scalatest.imports._
import org.scalatest._

class Example extends WordSpec with QueryChecker {
  import Example._

  val transactor = DriverManagerTransactor[IOLite](
    "org.postgresql.Driver", "jdbc:postgresql:world", "postgres", ""
  )

  "trivial" should { "check" in { check(trivial) } }
  "biggerThan" should { "check" in { check(biggerThan(0)) } }
}

object Example {
  case class Country(code: String, name: String, pop: Int, gnp: Option[BigDecimal])

  val trivial = sql"""
  select 42, 'foo'::varchar
""".query[(Int, String)]

  def biggerThan(minPop: Int) = sql"""
  select code, name, population, gnp
  from country
  where population > $minPop
""".query[Country]
}