libraryDependencies += "io.kaizen-solutions" %% "virgil-kyo" % "<see badge for latest version>"

import io.kaizensolutions.virgil.*
import io.kaizensolutions.virgil.codecs.*
import io.kaizensolutions.virgil.cql.*
import kyo.*

val program: Unit < (Envs[CQLExecutor] & Fibers) =
  val one = 1
  val two = 2
  val Alice = "Alice"
  val Bob = "Bob"

  val insertAlice = cql"INSERT INTO example (id, info) VALUES ($one, $Alice)".mutation
  val insertBob   = cql"INSERT INTO example (id, info) VALUES ($two, $Bob)".mutation
  val query       = cql"SELECT id, info FROM example".query[ExampleRow]
  for
    _                 <- CQLExecutor.executeMutation(insertAlice)
    _                 <- CQLExecutor.executeMutation(insertBob)
    (aliceAndBob, _)  <- CQLExecutor.execute(query).runSeq
  yield ()