How to turn an instance of Cats IO to ConnectionIO

[stefanfromm-allegro]

I'm using doobie 1.0.0-RC2 and Cats Effect 3 and would like to turn an instance of Cats IO to ConnectionIO. In earlier versions this was possible by

Async[ConnectionIO].liftIO(catsIO)

But an instance of Async[ConnectionIO] has gone. In the meanwhile there was an instance of LiftIO[ConnectionIO], but it is also gone. https://stackoverflow.com/a/50481203 states that the following approach worked:

catsIO.to[ConnectionIO]

but I receive the error "No given instance of type cats.effect.LiftIO[doobie.ConnectionIO] was found for parameter F of method to in class IO". I cannot find an instance of LiftIO.

Does anyone know of how to turn an instance of Cats IO to ConnectionIO?

[jatcwang]

For CE3/Doobie 1.x: https://stackoverflow.com/a/71257623

[i-am-the-slime]

I fail to understand this.
It's nice, that I can get the current time with Clock, but I can't mock this time in my tests.

[jatcwang]

@i-am-the-slime If you want to have control over time in your tests, https://typelevel.org/cats-effect/docs/core/test-runtime might help. I don't think there's anything in Doobie that stops you from using the CE TestRuntime?

[i-am-the-slime]

I was getting an error that something uses Async and that I should rewrite my code in order to be able to test it.

[jatcwang]

If you can post a small minimized example I should be able to point you towards the right direction

[i-am-the-slime]

I could work around it by just using Sync. I amended the stack overflow answer.