Function countParameters

src/utils/parameter-mapper.ts:91–144

(statement: string)

 * @throws Error if numbered/named parameters are not sequential starting from 1
 */
export function countParameters(statement: string): number {
  const style = detectParameterStyle(statement);
  // Strip comments and strings to avoid matching parameters inside them
  const cleanedSQL = stripCommentsAndStrings(statement);

  switch (style) {
    case "numbered": {
      // Extract all $N parameters and get unique indices
      const matches = cleanedSQL.match(/\$\d+/g);
      if (!matches) return 0;
      const numbers = matches.map((m) => parseInt(m.slice(1), 10));
      const uniqueIndices = Array.from(new Set(numbers)).sort((a, b) => a - b);

      // Validate parameters are sequential starting from 1
      const maxIndex = Math.max(...uniqueIndices);
      for (let i = 1; i <= maxIndex; i++) {
        if (!uniqueIndices.includes(i)) {
          throw new Error(
            `Non-sequential numbered parameters detected. Found placeholders: ${uniqueIndices.map(n => `$${n}`).join(', ')}. ` +
            `Parameters must be sequential starting from $1 (missing $${i}).`
          );
        }
      }

      return maxIndex;
    }
    case "named": {
      // Extract all @pN parameters and get unique indices
      const matches = cleanedSQL.match(/@p\d+/g);
      if (!matches) return 0;
      const numbers = matches.map((m) => parseInt(m.slice(2), 10));
      const uniqueIndices = Array.from(new Set(numbers)).sort((a, b) => a - b);

      // Validate parameters are sequential starting from 1
      const maxIndex = Math.max(...uniqueIndices);
      for (let i = 1; i <= maxIndex; i++) {
        if (!uniqueIndices.includes(i)) {
          throw new Error(
            `Non-sequential named parameters detected. Found placeholders: ${uniqueIndices.map(n => `@p${n}`).join(', ')}. ` +
            `Parameters must be sequential starting from @p1 (missing @p${i}).`
          );
        }
      }

      return maxIndex;
    }
    case "positional": {
      // Count question marks (positional parameters don't have this issue)
      return (cleanedSQL.match(/\?/g) || []).length;
    }
    default:
      return 0;
  }
}

/**
 * Validate that parameter definitions match the SQL statement