ZioJdbcContext

Quill context that executes JDBC queries inside of ZIO. Unlike most other contexts that require passing in a Data Source, this context takes in a java.sql.Connection as a resource dependency which can be provided later (see ZioJdbc for helper methods that assist in doing this).

The resource dependency itself is not just a Connection since JDBC requires blocking. Instead it is a Has[Connection] with Has[Blocking.Service] which is type-alised as QConnection hence methods in this context return ZIO[QConnection, Throwable, T]. The type QIO[T] i.e. Quill-IO is an alias for this.

If you have a zio-app, using this context is fairly straightforward but requires some setup: {{ val zioConn = ZLayer.fromManaged(for { ds <- ZManaged.fromAutoCloseable(Task(JdbcContextConfig(LoadConfig("testPostgresDB")).dataSource)) conn <- ZManaged.fromAutoCloseable(Task(ds.getConnection)) } yield conn)

MyZioContext.run(query[Person]).provideCustomLayer(zioConn) }}

Various methods in the io.getquill.context.ZioJdbc can assist in simplifying it's creation, for example, you can provide a DataSource instead of a Connection like this (note that the resulting Connection has a closing bracket). {{ import ZioJdbc._ val zioConn = QDataSource.fromPrefix("testPostgresDB") >>> QDataSource.toConnection MyZioContext.run(query[Person]).provideCustomLayer(zioConn) }}

If you are using a Plain Scala app however, you will need to manually run it e.g. using zio.Runtime {{ Runtime.default.unsafeRun(MyZioContext.run(query[Person]).provideCustomLayer(zioConn)) }}