private[db] def buildWhereClause()

in newswires/app/db/FingerpostWireEntry.scala [339:359]


  private[db] def buildWhereClause(
      searchParams: SearchParams,
      savedSearchParamList: List[SearchParams],
      maybeBeforeId: Option[Int],
      maybeSinceId: Option[Int]
  ): SQLSyntax = {

    val maybeSearch =
      buildWhereClauseParts(List(searchParams), maybeBeforeId, maybeSinceId)

    val maybeSavedSearch =
      buildWhereClauseParts(savedSearchParamList, maybeBeforeId, maybeSinceId)

    (maybeSearch, maybeSavedSearch) match {
      case (None, None)               => sqls""
      case (None, Some(presetSearch)) => sqls"WHERE $presetSearch"
      case (Some(userSearch), None)   => sqls"WHERE $userSearch"
      case (Some(userSearch), Some(presetSearch)) =>
        sqls"WHERE ($userSearch) and ($presetSearch)"
    }
  }