Thanks for this improvement @jatcwang . I'm trying to convert some existing code when migrating from RC6 -> RC7 due to the deprecation and wonder if you have a minute to provide some guidance? 🙏🏻

Old code (RC6):

private def exec(sql: String): ConnectionIO[RawResultSet] = {

  HC.prepareStatement(sql)(HPS.executeQuery {
        for {
          md <- FRS.getMetaData
          rs <- row(md).whileM[List](HRS.next)
        } yield RawResultSet(header(md), rs)
      })

It's unclear to me how to convert this to the FC.prepareStatement / executeWithResultSet style, i've got something like this so far (RC7):

  private def exec(sql: String): ConnectionIO[RawResultSet] = {

    val preparedStatement = FC.prepareStatement(sql)

    doobie.hi.connection.executeWithResultSet(
      create = preparedStatement,
      prep = ???,
      exec = ???,
      process = ???,
      LoggingInfo(sql, NonBatch(List.empty), "fooLabel")
    )

It's unclear to me how to/what to put in prep, exec and process - might you have any pointers? Or a method I'm missing which just takes care of it for me?

My use case here is running (admin) user provided SQL without any bound parameters - just a straight string -> query mapping.

Hi @henricook sorry the documentation for custom JDBC operations isn't really there and I haven't gotten around to #2134 yet.

In your case,

• prep: You don't need a prepare step, so you can use FPS.unit
• exec: FPS.executeQuery
• process:

for {
  md <- FRS.getMetaData
  rs <- row(md).whileM[List](HRS.next)
} yield RawResultSet(header(md), rs)

Hope that works!

Thanks for a super speedy response @jatcwang. I was reading the MR but Doobie novice that I am it took me a while to realise that IFPS FPS etc are all remappings of things like doobie.free.preparedstatement.

Here's my compiling and working final item based on your comments, currently without the 'doobie idiomatic' remapping of doobie.free.preparedstatement to FPS and doobie.hi.connection to IHC - i'll do that next

Notes:

• I have no params to bind, so this isn't suitable if you're reading and hoping to bind parameters.
• mkLabel is a custom method I use just to prefix a repository name onto the label

private def exec(sql: String): ConnectionIO[RawResultSet] = {

    val preparedStatement = FC.prepareStatement(sql)

    doobie.hi.connection.executeWithResultSet(
      create = preparedStatement,
      prep = doobie.free.preparedstatement.unit,
      exec = doobie.free.preparedstatement.executeQuery,
      process = (for {
        md <- FRS.getMetaData
        rs <- row(md).whileM[List](HRS.next)
      } yield RawResultSet(header(md), rs)),
      LoggingInfo(sql, NonBatch(List.empty), mkLabel("executeQuery"))
    )

Thanks for posting an update @henricook glad it worked 🥳