Files
josh 0806aec4a4 Phase 2a: Prisma schema + shared schemas for v1.0 features
- New models: Attachment, Webhook, Notification, SavedView
- New fields: User.notificationPrefs (Json), indexes on Ticket
- post-push.sql manages the tsvector columns + GIN indexes + triggers for
  FTS on Ticket (title/overview/displayId) and Comment (body); Prisma can't
  express these
- package.json scripts: db:push and start:prod now chain `prisma db execute`
  against post-push.sql after `prisma db push`
- db:migrate script removed — project uses push workflow, not migrations
- Shared Zod schemas: attachment (25MB limit + mimetype allowlist), savedView,
  notification (prefs, mark-read, webhook CRUD)
- Shared type additions: Attachment, Notification, SavedView, Webhook,
  PaginatedResponse<T>
- Test fixtures updated for the new User.notificationPrefs column

Co-Authored-By: Claude Opus 4.7 <noreply@anthropic.com>
2026-04-18 15:52:16 -04:00

29 lines
884 B
TypeScript

import { z } from 'zod';
export const savedViewFiltersSchema = z
.object({
status: z.string().optional(),
severity: z.number().optional(),
assigneeId: z.string().optional(),
createdById: z.string().optional(),
categoryId: z.string().optional(),
typeId: z.string().optional(),
itemId: z.string().optional(),
search: z.string().optional(),
})
.passthrough();
export const createSavedViewSchema = z.object({
name: z.string().min(1).max(80),
filters: savedViewFiltersSchema,
});
export const updateSavedViewSchema = z.object({
name: z.string().min(1).max(80).optional(),
filters: savedViewFiltersSchema.optional(),
});
export type CreateSavedViewInput = z.infer<typeof createSavedViewSchema>;
export type UpdateSavedViewInput = z.infer<typeof updateSavedViewSchema>;
export type SavedViewFilters = z.infer<typeof savedViewFiltersSchema>;