const { PrismaClient } = require("@prisma/client");
const prisma = new PrismaClient();

async function getComponents() {
  try {
    const components = await prisma.component_standards.findMany({
      where: { is_active: "Y" },
      select: {
        component_code: true,
        component_name: true,
        category: true,
        component_config: true,
      },
      orderBy: [{ category: "asc" }, { sort_order: "asc" }],
    });

    console.log("📋 데이터베이스 컴포넌트 목록:");
    console.log("=".repeat(60));

    const grouped = components.reduce((acc, comp) => {
      if (!acc[comp.category]) {
        acc[comp.category] = [];
      }
      acc[comp.category].push(comp);
      return acc;
    }, {});

    Object.entries(grouped).forEach(([category, comps]) => {
      console.log(`\n🏷️  ${category.toUpperCase()} 카테고리:`);
      comps.forEach((comp) => {
        const type = comp.component_config?.type || "unknown";
        console.log(
          `   - ${comp.component_code}: ${comp.component_name} (type: ${type})`
        );
      });
    });

    console.log(`\n총 ${components.length}개 컴포넌트 발견`);
  } catch (error) {
    console.error("Error:", error);
  } finally {
    await prisma.$disconnect();
  }
}

getComponents();