1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
// /api/attachment-delete/route.ts
import { NextRequest, NextResponse } from 'next/server'
import db from '@/db/db'
import { documentAttachments } from '@/db/schema' // 실제 스키마에 맞게 수정
import { eq, and } from 'drizzle-orm'
import fs from 'fs/promises'
import path from 'path'
export async function DELETE(request: NextRequest) {
try {
const { attachmentId, revisionId } = await request.json()
if (!attachmentId || !revisionId) {
return NextResponse.json(
{ error: 'attachmentId and revisionId are required' },
{ status: 400 }
)
}
// 1. 데이터베이스에서 첨부파일 정보 조회
const attachment = await db
.select()
.from(documentAttachments)
.where(
and(
eq(documentAttachments.id, attachmentId),
eq(documentAttachments.revisionId, revisionId)
)
)
.limit(1)
if (!attachment || attachment.length === 0) {
return NextResponse.json(
{ error: 'Attachment not found' },
{ status: 404 }
)
}
const attachmentData = attachment[0]
// 2. dolceFilePath 체크 - 있으면 삭제 불가
if (attachmentData.dolceFilePath && attachmentData.dolceFilePath.trim() !== '') {
return NextResponse.json(
{ error: 'Cannot delete processed file' },
{ status: 403 }
)
}
// 4. 데이터베이스에서 첨부파일 레코드 삭제
await db
.delete(documentAttachments)
.where(
and(
eq(documentAttachments.id, attachmentId),
eq(documentAttachments.revisionId, revisionId)
)
)
return NextResponse.json({
success: true,
message: 'Attachment deleted successfully',
deletedAttachmentId: attachmentId
})
} catch (error) {
console.error('Attachment deletion error:', error)
return NextResponse.json(
{
error: 'Internal server error',
details: error instanceof Error ? error.message : 'Unknown error'
},
{ status: 500 }
)
}
}
|
