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
|
// app/api/admin/clear-test-data/route.ts
import db from '@/db/db'
import { formEntries, forms, formMetas, tags } from '@/db/schema/vendorData'
import { NextRequest } from 'next/server'
export async function DELETE(request: NextRequest) {
try {
// 외래키 참조 순서를 고려하여 삭제 (자식 테이블부터)
console.log('Clearing test data...')
// 1. form_entries 삭제
const deletedEntries = await db.delete(formEntries)
console.log('Deleted form entries')
// 2. tags 삭제
const deletedTags = await db.delete(tags)
console.log('Deleted tags')
// 3. forms 삭제
const deletedForms = await db.delete(forms)
console.log('Deleted forms')
// 4. form_metas 삭제
const deletedMetas = await db.delete(formMetas)
console.log('Deleted form metas')
return Response.json({
success: true,
message: 'All test data cleared successfully',
deleted: {
formEntries: deletedEntries,
tags: deletedTags,
forms: deletedForms,
formMetas: deletedMetas
}
})
} catch (error) {
console.error('Error clearing test data:', error)
return Response.json({
error: 'Failed to clear data',
details: error instanceof Error ? error.message : 'Unknown error'
}, { status: 500 })
}
}
// GET 요청도 지원 (브라우저에서 직접 접근 시)
export async function GET() {
if (process.env.NODE_ENV !== 'development') {
return Response.json({
error: 'Not allowed in production'
}, { status: 403 })
}
return Response.json({
message: 'Use DELETE method to clear test data',
endpoint: '/api/admin/clear-test-data',
method: 'DELETE'
})
}
|
