• Home
• uz.scala
• skunk_2.13
• 1.0.5
• source code
• SkunkSession.scala

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

uz.scala.skunk.SkunkSession.scala Maven / Gradle / Ivy

package uz.scala.skunk

import cats.effect.Temporal
import cats.effect.std.Console
import fs2.io.net.Network
import natchez.Trace.Implicits.noop
import org.typelevel.log4cats.Logger
import skunk.Session
import skunk.SessionPool
import skunk.util.Typer
import uz.scala.skunk.syntax.all.skunkSyntaxConnectionOps
import uz.scala.syntax.refined.commonSyntaxAutoUnwrapV

object SkunkSession {
  def make[F[_]: Temporal: Logger: Network: Console](config: DataBaseConfig): SessionPool[F] =
    Session
      .pooled[F](
        host = config.host,
        port = config.port,
        user = config.user,
        password = Some(config.password.value),
        database = config.database,
        max = config.poolSize,
        strategy = Typer.Strategy.SearchPath,
        parameters = config
          .schema
          .map(schema => "search_path" -> schema.value)
          .toList
          .toMap ++ Session.DefaultConnectionParameters,
      )
      .evalTap(_.checkPostgresConnection)
}