Skip to main content

Extras - Doobie Tools for Cats Effect 3

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)