Implement functionality for getPartitioningsEndpointV2

[salamonpavel]

Implement missing functionality for the endpoint below on all levels - Controller, Service, Repository, Fa-DB, SQL.

case class PartitioningWithIdDTO (
  id: Long,
  partitioning: PartitioningDTO,
  parentPartitioning: Option[PartitioningDTO],
  author: String
)

object PartitioningWithIdDTO {
  implicit val encoderPartitioningWithIdDTO: Encoder[PartitioningWithIdDTO] = deriveEncoder
  implicit val decoderPartitioningWithIdDTO: Decoder[PartitioningWithIdDTO] = deriveDecoder
}

// Endpoints
protected val getPartitioningsEndpointV2: PublicEndpoint[
    (Option[String], Option[String], Option[String]),
    ErrorResponse,
    PaginatedResponse[PartitioningWithIdDTO],
    Any
  ] = {
    apiV2.get
      .in(V2Paths.Partitionings)
      .in(query[Option[String]]("partitions"))
      .in(query[Option[String]]("limit"))
      .in(query[Option[String]]("offset"))
      .out(statusCode(StatusCode.Ok))
      .out(jsonBody[PaginatedResponse[PartitioningWithIdDTO]])
  }

// Routes
createServerEndpoint[
        (Option[String], Option[String], Option[String]),
        ErrorResponse,
        PaginatedResponse[PartitioningWithIdDTO]
      ](
        getPartitioningsEndpointV2,
        { case (partitions: Option[String], limit: Option[String], offset: Option[String]) =>
          PartitioningController.getPartitioningsV2(partitions, limit, offset)
        }
      )

// Controller
override def getPartitioningsV2(
    partitions: Option[String],
    limit: Option[String],
    offset: Option[String]
  ): IO[ErrorResponse, PaginatedResponse[PartitioningWithIdDTO]]

// Service
override def getPartitionings(
    partitions: Option[String],
    limit: Option[String],
    offset: Option[String]
  ): IO[ServiceError, PaginatedResult[PartitioningWithIdDTO]]

// Repository
def getPartitionings(
    partitions: Option[String],
    limit: Option[String],
    offset: Option[String]
  ): IO[DatabaseError, PaginatedResult[PartitioningWithIdDTO]]

[benedeki]

Duplicate of #268