mirror of
https://github.com/supabase/supabase.git
synced 2026-05-07 09:20:21 -04:00
Charis
d34cc65e30
* fix(studio): check job_run_details size in cron display When cron.job_run_details grows too large (200k+ rows), loading the cron jobs overview can timeout and affect other queries by pulling excessive data into shared buffers. This change: - Estimates table size using pg_stat before fetching cron jobs data - Shows a cleanup notice when the table exceeds the threshold - Provides batched deletion using ctid ranges to avoid buffer pollution - Allows scheduling an automated daily cleanup cron job - Handles timeout errors gracefully with a "suspected overflow" state The useCronJobsData hook now returns a discriminated union status that tracks loading, estimate-error, overflow-confirmed, overflow-suspected, and ready states, allowing the UI to respond appropriately to each case. * fix(studio): use index when querying cron.job_run_details cron.job_run_details is only indexed by runid, not by start_time. Change the query to use the runid index (which gives the same result, since runid is auto-incrementing).
136 lines
3.4 KiB
TypeScript
136 lines
3.4 KiB
TypeScript
/**
|
|
* Semantic versioning utility for comparing version strings.
|
|
* Accepts 1-3 parts (e.g., "1", "1.5", "1.5.0"). Missing parts default to 0.
|
|
*/
|
|
|
|
export interface SemverVersion {
|
|
major: number
|
|
minor: number
|
|
patch: number
|
|
}
|
|
|
|
/**
|
|
* Parses a semver string into its components.
|
|
* Accepts 1-3 parts (e.g., "1", "1.5", "1.5.0"). Missing parts default to 0.
|
|
* @param version - The version string to parse (e.g., "1.2.3")
|
|
* @returns The parsed version components or null if invalid
|
|
*/
|
|
export function parseSemver(version: string): SemverVersion | null {
|
|
if (!version || typeof version !== 'string') {
|
|
return null
|
|
}
|
|
|
|
const parts = version.trim().split('.')
|
|
|
|
if (parts.length === 0 || parts.length > 3) {
|
|
return null
|
|
}
|
|
|
|
const numbers = parts.map((p) => parseInt(p, 10))
|
|
|
|
if (numbers.some(isNaN)) {
|
|
return null
|
|
}
|
|
|
|
if (numbers.some((n) => n < 0)) {
|
|
return null
|
|
}
|
|
|
|
return {
|
|
major: numbers[0],
|
|
minor: numbers[1] ?? 0,
|
|
patch: numbers[2] ?? 0,
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Compares two semver version strings.
|
|
* Missing parts are treated as 0 (e.g., "1.5" equals "1.5.0").
|
|
* @param a - First version string
|
|
* @param b - Second version string
|
|
* @returns -1 if a < b, 0 if a === b, 1 if a > b, or null if either version is invalid
|
|
*/
|
|
export function compareSemver(a: string, b: string): -1 | 0 | 1 | null {
|
|
const versionA = parseSemver(a)
|
|
const versionB = parseSemver(b)
|
|
|
|
if (!versionA || !versionB) {
|
|
return null
|
|
}
|
|
|
|
if (versionA.major !== versionB.major) {
|
|
return versionA.major > versionB.major ? 1 : -1
|
|
}
|
|
|
|
if (versionA.minor !== versionB.minor) {
|
|
return versionA.minor > versionB.minor ? 1 : -1
|
|
}
|
|
|
|
if (versionA.patch !== versionB.patch) {
|
|
return versionA.patch > versionB.patch ? 1 : -1
|
|
}
|
|
|
|
return 0
|
|
}
|
|
|
|
/**
|
|
* Checks if version a is greater than version b
|
|
* @param a - First version string
|
|
* @param b - Second version string
|
|
* @returns true if a > b, false otherwise
|
|
*/
|
|
export function isGreaterThan(a: string, b: string): boolean {
|
|
return compareSemver(a, b) === 1
|
|
}
|
|
|
|
/**
|
|
* Checks if version a is less than version b
|
|
* @param a - First version string
|
|
* @param b - Second version string
|
|
* @returns true if a < b, false otherwise
|
|
*/
|
|
export function isLessThan(a: string, b: string): boolean {
|
|
return compareSemver(a, b) === -1
|
|
}
|
|
|
|
/**
|
|
* Checks if version a is equal to version b
|
|
* @param a - First version string
|
|
* @param b - Second version string
|
|
* @returns true if a === b, false otherwise
|
|
*/
|
|
export function isEqual(a: string, b: string): boolean {
|
|
return compareSemver(a, b) === 0
|
|
}
|
|
|
|
/**
|
|
* Checks if version a is greater than or equal to version b
|
|
* @param a - First version string
|
|
* @param b - Second version string
|
|
* @returns true if a >= b, false otherwise
|
|
*/
|
|
export function isGreaterThanOrEqual(a: string, b: string): boolean {
|
|
const result = compareSemver(a, b)
|
|
return result === 1 || result === 0
|
|
}
|
|
|
|
/**
|
|
* Checks if version a is less than or equal to version b
|
|
* @param a - First version string
|
|
* @param b - Second version string
|
|
* @returns true if a <= b, false otherwise
|
|
*/
|
|
export function isLessThanOrEqual(a: string, b: string): boolean {
|
|
const result = compareSemver(a, b)
|
|
return result === -1 || result === 0
|
|
}
|
|
|
|
/**
|
|
* Checks if a version string is valid
|
|
* @param version - The version string to validate
|
|
* @returns true if the version is valid, false otherwise
|
|
*/
|
|
export function isValidSemver(version: string): boolean {
|
|
return parseSemver(version) !== null
|
|
}
|