loicdescotte / purewebappsample

Minimal http4s + Doobie + ZIO + Circe Scala application to show how to build a purely functional web application in Scala.

Simple ZIO + HTTP4s + Doobie + Circe POC to show how to build a purely functional web application in Scala, using functional effects with ZIO.

This is just an example to show how to retrieve and update a stock value in a database, validate this value ( > 0) and return a result as json.

How to run the sample :

• sbt run
• open http://localhost:8080/stock/1

purewebappsample's Issues

Tests faling randomly

Fiber: x was supposed to continue to [...]

App crashes, when a not existing stock id is chosen

When you call an HTTP-GET on http://localhost:8080/stock/5 an SQL error occurs due to the fact, that an empty result is returned.

Error
ResultSet exhausted; more rows expected

Response

{
"Error": "org.h2.jdbc.JdbcSQLException: Table \"STOCK\" already exists; SQL statement:\nCREATE TABLE stock\r\n(\r\n    id INT NOT NULL AUTO_INCREMENT,\r\n    value INT NOT NULL,\r\n    PRIMARY KEY(id)\r\n) [42101-196]"
}```

It looks like the transactor driver manager restarts and tries to re-run the ```create.sql`` even though the database was not reseted. 

Can't kill run without killing sbt too

It's not possible to kill/stop the app from sbt without killing sbt too.

sbt:pureWebAppSample> run

Any ideas?