d8d-vite-starter/src/server/modules/files/file.entity.ts

import { Entity, PrimaryColumn, Column, Index } from 'typeorm';
import { z } from '@hono/zod-openapi';

@Entity('file')
export class File {
  @PrimaryColumn({ name: 'id', type: 'varchar', length: 50 })
  id!: string;

  @Column({ name: 'name', type: 'varchar', length: 255 })
  name!: string;

  @Column({ name: 'type', type: 'varchar', length: 50, nullable: true })
  type?: string;

  @Column({ name: 'size', type: 'int', unsigned: true, nullable: true })
  size?: number;

  @Column({ name: 'path', type: 'varchar', length: 512 })
  path!: string;

  @Column({ name: 'description', type: 'text', nullable: true })
  description?: string;

  @Column({ name: 'upload_user_id', type: 'varchar', length: 50 })
  uploadUserId!: string;

  @Column({ name: 'upload_time', type: 'datetime' })
  uploadTime!: Date;

  @Column({ name: 'last_updated', type: 'datetime', nullable: true })
  lastUpdated?: Date;

  @Column({ name: 'created_at', type: 'timestamp', default: () => 'CURRENT_TIMESTAMP' })
  createdAt!: Date;

  @Column({ 
    name: 'updated_at', 
    type: 'timestamp', 
    default: () => 'CURRENT_TIMESTAMP', 
    onUpdate: 'CURRENT_TIMESTAMP' 
  })
  updatedAt!: Date;
}

export const FileSchema = z.object({
  id: z.string().max(50).openapi({ 
    description: '文件ID',
    example: 'FILE20230001' 
  }),
  name: z.string().max(255).openapi({ 
    description: '文件名称',
    example: '项目计划书.pdf' 
  }),
  type: z.string().max(50).nullable().openapi({ 
    description: '文件类型',
    example: 'application/pdf' 
  }),
  size: z.number().int().positive().nullable().openapi({ 
    description: '文件大小，单位字节',
    example: 102400 
  }),
  path: z.string().max(512).openapi({ 
    description: '文件存储路径',
    example: '/uploads/documents/2023/project-plan.pdf' 
  }),
  description: z.string().nullable().openapi({ 
    description: '文件描述',
    example: '2023年度项目计划书' 
  }),
  uploadUserId: z.string().max(50).openapi({ 
    description: '上传用户ID',
    example: 'U1001' 
  }),
  uploadTime: z.date().openapi({ 
    description: '上传时间',
    example: '2023-01-15T10:30:00Z' 
  }),
  lastUpdated: z.date().nullable().openapi({ 
    description: '最后更新时间',
    example: '2023-01-16T14:20:00Z' 
  }),
  createdAt: z.date().openapi({ 
    description: '创建时间',
    example: '2023-01-15T10:30:00Z' 
  }),
  updatedAt: z.date().openapi({ 
    description: '更新时间',
    example: '2023-01-16T14:20:00Z' 
  })
});

export const CreateFileDto = z.object({
  id: z.string().max(50).openapi({ 
    description: '文件ID',
    example: 'FILE20230001' 
  }),
  name: z.string().max(255).openapi({ 
    description: '文件名称',
    example: '项目计划书.pdf' 
  }),
  type: z.string().max(50).nullable().optional().openapi({ 
    description: '文件类型',
    example: 'application/pdf' 
  }),
  size: z.coerce.number().int().positive().nullable().optional().openapi({ 
    description: '文件大小，单位字节',
    example: 102400 
  }),
  path: z.string().max(512).openapi({ 
    description: '文件存储路径',
    example: '/uploads/documents/2023/project-plan.pdf' 
  }),
  description: z.string().nullable().optional().openapi({ 
    description: '文件描述',
    example: '2023年度项目计划书' 
  }),
  uploadUserId: z.string().max(50).openapi({ 
    description: '上传用户ID',
    example: 'U1001' 
  }),
  uploadTime: z.coerce.date().openapi({ 
    description: '上传时间',
    example: '2023-01-15T10:30:00Z' 
  }),
  lastUpdated: z.coerce.date().nullable().optional().openapi({ 
    description: '最后更新时间',
    example: '2023-01-16T14:20:00Z' 
  })
});

export const UpdateFileDto = z.object({
  name: z.string().max(255).optional().openapi({ 
    description: '文件名称',
    example: '项目计划书_v2.pdf' 
  }),
  type: z.string().max(50).nullable().optional().openapi({ 
    description: '文件类型',
    example: 'application/pdf' 
  }),
  size: z.coerce.number().int().positive().nullable().optional().openapi({ 
    description: '文件大小，单位字节',
    example: 153600 
  }),
  path: z.string().max(512).optional().openapi({ 
    description: '文件存储路径',
    example: '/uploads/documents/2023/project-plan_v2.pdf' 
  }),
  description: z.string().nullable().optional().openapi({ 
    description: '文件描述',
    example: '2023年度项目计划书（修订版）' 
  }),
  uploadUserId: z.string().max(50).optional().openapi({ 
    description: '上传用户ID',
    example: 'U1001' 
  }),
  uploadTime: z.coerce.date().optional().openapi({ 
    description: '上传时间',
    example: '2023-01-15T10:30:00Z' 
  }),
  lastUpdated: z.coerce.date().nullable().optional().openapi({ 
    description: '最后更新时间',
    example: '2023-01-16T14:20:00Z' 
  })
});