1 files changed, 106 insertions, 30 deletions

diff --git a/app/api/admin/clear-test-data/route.ts b/app/api/admin/clear-test-data/route.ts
index 9a5c8458..8442e5de 100644
--- a/app/api/admin/clear-test-data/route.ts
+++ b/app/api/admin/clear-test-data/route.ts
@@ -1,44 +1,107 @@
 // app/api/admin/clear-test-data/route.ts
-import  db  from '@/db/db'
-import { formEntries, forms, formMetas, tags } from '@/db/schema/vendorData'
+import db from '@/db/db'
+import { 
+  formEntries, 
+  forms, 
+  formMetas, 
+  tags,
+  tagTypes,
+  tagSubfields,
+  tagSubfieldOptions,
+  tagClasses,
+  tagClassAttributes,
+  tagTypeClassFormMappings,
+  vendorDataReportTemps
+} from '@/db/schema/vendorData'
 import { NextRequest } from 'next/server'
 
 export async function DELETE(request: NextRequest) {
-
   try {
-    // 외래키 참조 순서를 고려하여 삭제 (자식 테이블부터)
-    console.log('Clearing test data...')
+    // 외래키 참조 순서를 고려하여 삭제 (자식 테이블부터 부모 테이블 순)
+    console.log('Clearing all test data...')
     
-    // 1. form_entries 삭제
+    const deletedCounts = {
+      tagClassAttributes: 0,
+      tagClasses: 0,
+      tagSubfieldOptions: 0,
+      tagSubfields: 0,
+      tagTypes: 0,
+      tagTypeClassFormMappings: 0,
+      vendorDataReportTemps: 0,
+      formEntries: 0,
+      tags: 0,
+      forms: 0,
+      formMetas: 0
+    }
+
+    // 1. tagClassAttributes 삭제 (가장 하위 자식)
+    const deletedTagClassAttributes = await db.delete(tagClassAttributes)
+    deletedCounts.tagClassAttributes = deletedTagClassAttributes.rowCount || 0
+    console.log('Deleted tag class attributes:', deletedCounts.tagClassAttributes)
+
+    // 2. tagClasses 삭제
+    const deletedTagClasses = await db.delete(tagClasses)
+    deletedCounts.tagClasses = deletedTagClasses.rowCount || 0
+    console.log('Deleted tag classes:', deletedCounts.tagClasses)
+
+    // 3. tagSubfieldOptions 삭제
+    const deletedTagSubfieldOptions = await db.delete(tagSubfieldOptions)
+    deletedCounts.tagSubfieldOptions = deletedTagSubfieldOptions.rowCount || 0
+    console.log('Deleted tag subfield options:', deletedCounts.tagSubfieldOptions)
+
+    // 4. tagSubfields 삭제
+    const deletedTagSubfields = await db.delete(tagSubfields)
+    deletedCounts.tagSubfields = deletedTagSubfields.rowCount || 0
+    console.log('Deleted tag subfields:', deletedCounts.tagSubfields)
+
+    // 5. tagTypes 삭제
+    const deletedTagTypes = await db.delete(tagTypes)
+    deletedCounts.tagTypes = deletedTagTypes.rowCount || 0
+    console.log('Deleted tag types:', deletedCounts.tagTypes)
+
+    // 6. tagTypeClassFormMappings 삭제
+    const deletedMappings = await db.delete(tagTypeClassFormMappings)
+    deletedCounts.tagTypeClassFormMappings = deletedMappings.rowCount || 0
+    console.log('Deleted tag type class form mappings:', deletedCounts.tagTypeClassFormMappings)
+
+    // 7. vendorDataReportTemps 삭제
+    const deletedVendorReports = await db.delete(vendorDataReportTemps)
+    deletedCounts.vendorDataReportTemps = deletedVendorReports.rowCount || 0
+    console.log('Deleted vendor data report temps:', deletedCounts.vendorDataReportTemps)
+
+    // 8. formEntries 삭제
     const deletedEntries = await db.delete(formEntries)
-    console.log('Deleted form entries')
-    
-    // 2. tags 삭제  
+    deletedCounts.formEntries = deletedEntries.rowCount || 0
+    console.log('Deleted form entries:', deletedCounts.formEntries)
+
+    // 9. tags 삭제
     const deletedTags = await db.delete(tags)
-    console.log('Deleted tags')
-    
-    // 3. forms 삭제
+    deletedCounts.tags = deletedTags.rowCount || 0
+    console.log('Deleted tags:', deletedCounts.tags)
+
+    // 10. forms 삭제
     const deletedForms = await db.delete(forms)
-    console.log('Deleted forms')
-    
-    // 4. form_metas 삭제
+    deletedCounts.forms = deletedForms.rowCount || 0
+    console.log('Deleted forms:', deletedCounts.forms)
+
+    // 11. formMetas 삭제
     const deletedMetas = await db.delete(formMetas)
-    console.log('Deleted form metas')
-    
-    return Response.json({ 
-      success: true, 
+    deletedCounts.formMetas = deletedMetas.rowCount || 0
+    console.log('Deleted form metas:', deletedCounts.formMetas)
+
+    console.log('All test data cleared successfully')
+
+    return Response.json({
+      success: true,
       message: 'All test data cleared successfully',
-      deleted: {
-        formEntries: deletedEntries,
-        tags: deletedTags, 
-        forms: deletedForms,
-        formMetas: deletedMetas
-      }
+      deleted: deletedCounts,
+      totalDeleted: Object.values(deletedCounts).reduce((sum, count) => sum + count, 0)
     })
+
   } catch (error) {
     console.error('Error clearing test data:', error)
-    return Response.json({ 
-      error: 'Failed to clear data', 
+    return Response.json({
+      error: 'Failed to clear data',
       details: error instanceof Error ? error.message : 'Unknown error'
     }, { status: 500 })
   }
@@ -47,14 +110,27 @@ export async function DELETE(request: NextRequest) {
 // GET 요청도 지원 (브라우저에서 직접 접근 시)
 export async function GET() {
   if (process.env.NODE_ENV !== 'development') {
-    return Response.json({ 
-      error: 'Not allowed in production' 
+    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'
+    method: 'DELETE',
+    tables: [
+      'tagClassAttributes',
+      'tagClasses', 
+      'tagSubfieldOptions',
+      'tagSubfields',
+      'tagTypes',
+      'tagTypeClassFormMappings',
+      'vendorDataReportTemps',
+      'formEntries',
+      'tags',
+      'forms',
+      'formMetas'
+    ]
   })
 }
\ No newline at end of file