【AI全栈】Card Learning Demo——一个全栈数据库学习项目的设计与实现

1
enum CardStatus { todo doing done }
2
enum CardDifficulty { basic medium advanced }

1
export const createCardSchema = z.object({
2
  title: z.string().trim().min(1),
3
  summary: z.string().trim().optional(),
4
  content: z.string().trim().optional(),
5
  category: z.string().trim().min(1).optional(),
6
  difficulty: cardDifficultySchema.default('basic'),
7
  status: cardStatusSchema.default('todo'),
8
}).strict()
9

10
export class CreateCardDto extends createZodDto(createCardSchema) {}

1
export const queryCardsSchema = z.object({
2
  page: z.coerce.number().int().min(1).default(1),
3
  pageSize: z.coerce.number().int().min(1).max(100).default(10),
4
  keyword: z.string().trim().min(1).optional(),
5
  status: cardStatusSchema.optional(),
6
  difficulty: cardDifficultySchema.optional(),
7
  category: z.string().trim().min(1).optional(),
8
  sortBy: cardSortBySchema.default('createdAt'),
9
  sortOrder: sortOrderSchema.default('desc'),
10
}).strict()
11

12
export class QueryCardsDto extends createZodDto(queryCardsSchema) {}

1
export const updateCardSchema = z.object({
2
  title: z.string().trim().min(1).optional(),
3
  /* ... 所有字段都是 optional ... */
4
}).strict()
5
  .refine((data) => Object.keys(data).length > 0, {
6
    message: '至少需要提供一个要更新的字段',
7
  })

1
async findAll(query: QueryCardsDto) {
2
  const { page, pageSize } = query
3
  const skip = (page - 1) * pageSize
4
  const where: Prisma.CardWhereInput = {}
5

6
  // 关键词搜索（三字段 OR）
7
  if (query.keyword) {
8
    where.OR = [
9
      { title: { contains: query.keyword, mode: 'insensitive' } },
10
      { summary: { contains: query.keyword, mode: 'insensitive' } },
11
      { content: { contains: query.keyword, mode: 'insensitive' } },
12
    ]
13
  }
14

15
  // 枚举等值筛选
16
  if (query.status) where.status = query.status
17
  if (query.difficulty) where.difficulty = query.difficulty
18
  if (query.category) where.category = query.category
19

20
  // 动态排序
21
  const orderBy = {
22
    [query.sortBy]: query.sortOrder,
23
  } satisfies Prisma.CardOrderByWithRelationInput
24

25
  // 并发查询：数据 + 总数
26
  const [items, total] = await this.prisma.$transaction([
27
    this.prisma.card.findMany({ where, skip, take: pageSize, orderBy }),
28
    this.prisma.card.count({ where }),
29
  ])
30

31
  return {
32
    items,
33
    meta: { page, pageSize, total, totalPages: Math.ceil(total / pageSize) },
34
  }
35
}

1
// 创建
2
async create(dto: CreateCardDto) {
3
  return this.prisma.card.create({
4
    data: {
5
      title: dto.title,
6
      content: dto.content || '',
7
      category: dto.category,
8
      difficulty: dto.difficulty,
9
      status: dto.status,
10
    },
11
  })
12
}
13

14
// 更新（PATCH 语义：只更新传了的字段）
15
async update(id: string, dto: UpdateCardDto) {
16
  await this.findOne(id)  // 404 保护
17
  return this.prisma.card.update({ where: { id }, data: dto })
18
}
19

20
// 删除
21
async remove(id: string) {
22
  await this.findOne(id)  // 404 保护
23
  return this.prisma.card.delete({ where: { id } })
24
}