Function combineConditions

packages/db/src/query/predicate-utils.ts:999–1029

* Combine multiple conditions into a single predicate using AND logic. * Flattens nested AND operations to avoid unnecessary nesting.

(
  conditions: Array<BasicExpression<boolean>>,
)

 * Flattens nested AND operations to avoid unnecessary nesting.
 */
function combineConditions(
  conditions: Array<BasicExpression<boolean>>,
): BasicExpression<boolean> {
  if (conditions.length === 0) {
    return { type: `val`, value: true } as BasicExpression<boolean>
  } else if (conditions.length === 1) {
    return conditions[0]!
  } else {
    // Flatten all conditions, including those that are already AND operations
    const flattenedConditions: Array<BasicExpression<boolean>> = []

    for (const condition of conditions) {
      if (condition.type === `func` && condition.name === `and`) {
        // Flatten nested AND operations
        flattenedConditions.push(...condition.args)
      } else {
        flattenedConditions.push(condition)
      }
    }

    if (flattenedConditions.length === 1) {
      return flattenedConditions[0]!
    } else {
      return {
        type: `func`,
        name: `and`,
        args: flattenedConditions,
      } as BasicExpression<boolean>
    }
  }
}

/**
 * Find a predicate with a specific operator and value