mirror of
https://github.com/supabase/supabase.git
synced 2026-06-12 17:27:58 +08:00
116faefcda
## Summary - Converts ~27 `executeSql` call sites in `apps/studio/data/**` to build SQL through `safeSql` / `ident` / `literal` / `keyword` / `joinSqlFragments` instead of raw template-string interpolation. - Tightens the `useDatabaseCronJobCreateMutation` and `useDatabaseEventTriggerCreateMutation` `sql`/`query` parameter types from `string` to `SafeSqlFragment` (callers already produce one). - Updates `getDeleteEnumeratedTypeSQL` in `packages/pg-meta` to return `SafeSqlFragment`. - Fixes a bug noticed while testing where Queues integration does not correctly handle queues with uppercase names. ## Pages to manually test - Integrations > Cron Jobs - Integrations > Queues - Database > Triggers > Event Triggers - Database > Indexes - Reports > Query Performance - Storage <!-- This is an auto-generated comment: release notes by coderabbit.ai --> ## Summary by CodeRabbit ## Release Notes * **Bug Fixes** * Queue lookups now correctly handle case-insensitive queue names. * Queue table references are now properly managed and consistently applied throughout the queue management interface. * Improved queue name display normalization in the user interface. * **Chores** * Enhanced SQL query safety across the database layer through parameterized query construction and safer templating approaches. <!-- end of auto-generated comment: release notes by coderabbit.ai -->
31 lines
731 B
TypeScript
31 lines
731 B
TypeScript
import z from 'zod'
|
|
|
|
import { QueueNameSchema } from '../Queues.utils'
|
|
|
|
const normalQueueSchema = z.object({
|
|
type: z.literal('basic'),
|
|
})
|
|
|
|
const partitionedQueueSchema = z.object({
|
|
type: z.literal('partitioned'),
|
|
partitionInterval: z.coerce.number().int().positive(),
|
|
retentionInterval: z.coerce.number().int().positive(),
|
|
})
|
|
|
|
const unloggedQueueSchema = z.object({
|
|
type: z.literal('unlogged'),
|
|
})
|
|
|
|
export const FormSchema = z.object({
|
|
name: QueueNameSchema,
|
|
enableRls: z.boolean(),
|
|
values: z.discriminatedUnion('type', [
|
|
normalQueueSchema,
|
|
partitionedQueueSchema,
|
|
unloggedQueueSchema,
|
|
]),
|
|
})
|
|
|
|
export type CreateQueueForm = z.infer<typeof FormSchema>
|
|
export type QueueType = CreateQueueForm['values']
|