suffixWithLimit() — supabase Function Reference

Architecture documentation for the suffixWithLimit() function in SQLEditor.utils.ts from the supabase codebase.

Function typescript ContentManagement MediaManagement calls 1 called by 1

Entity Profile

ContentManagement→ MediaManagement→ suffixWithLimit() — supabase Function Reference

Dependency Diagram

graph TD
  6896e8f8_40ca_e4c1_b90f_e8414a5a4a65["suffixWithLimit()"]
  5429b87d_ef53_7e21_26c6_6b167a463ebc["SQLEditor()"]
  5429b87d_ef53_7e21_26c6_6b167a463ebc -->|calls| 6896e8f8_40ca_e4c1_b90f_e8414a5a4a65
  64a0b59f_f05e_f70e_222b_79edb442a130["checkIfAppendLimitRequired()"]
  6896e8f8_40ca_e4c1_b90f_e8414a5a4a65 -->|calls| 64a0b59f_f05e_f70e_222b_79edb442a130
  style 6896e8f8_40ca_e4c1_b90f_e8414a5a4a65 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

apps/studio/components/interfaces/SQLEditor/SQLEditor.utils.ts lines 145–153

export const suffixWithLimit = (sql: string, limit: number = 0) => {
  const { cleanedSql, appendAutoLimit } = checkIfAppendLimitRequired(sql, limit)
  const formattedSql = appendAutoLimit
    ? cleanedSql.endsWith(';')
      ? sql.replace(/[;]+$/, ` limit ${limit};`)
      : `${sql} limit ${limit};`
    : sql
  return formattedSql
}