Skip to main content

Extras - Doobie Tools for Cats Effect 2

Docs WIP

DbTools.fetchSingleRow

val fetch: F[Option[Example]] = DbTools.fetchSingleRow[F][Example](
sql"""
SELECT id, name, note
FROM db_tools_test.example
"""
)(transactor)

DbTools.updateSingle

val insert: F[Int] = DbTools.updateSingle[F](
sql"""
INSERT INTO db_tools_test.example (id, name, note) VALUES (${example.id}, ${example.name}, ${example.note})
"""
)(transactor)