diff options
| -rw-r--r-- | db/db.ts | 4 | ||||
| -rw-r--r-- | db/seeds/menu-v2-seed.js | 231 |
2 files changed, 2 insertions, 233 deletions
@@ -3,8 +3,8 @@ import { Pool } from 'pg'; import * as schema from './schema'; const pool = new Pool({ - // connectionString: process.env.DATABASE_URL as string, - connectionString: "postgresql://dts:dujinDTS2@localhost:5432/evcp", + connectionString: process.env.DATABASE_URL as string, + // connectionString: "postgresql://dts:dujinDTS2@localhost:5432/evcp", max: Number(process.env.DB_POOL_MAX) || 4, }); diff --git a/db/seeds/menu-v2-seed.js b/db/seeds/menu-v2-seed.js deleted file mode 100644 index e332f044..00000000 --- a/db/seeds/menu-v2-seed.js +++ /dev/null @@ -1,231 +0,0 @@ -"use strict"; -var __awaiter = (this && this.__awaiter) || function (thisArg, _arguments, P, generator) { - function adopt(value) { return value instanceof P ? value : new P(function (resolve) { resolve(value); }); } - return new (P || (P = Promise))(function (resolve, reject) { - function fulfilled(value) { try { step(generator.next(value)); } catch (e) { reject(e); } } - function rejected(value) { try { step(generator["throw"](value)); } catch (e) { reject(e); } } - function step(result) { result.done ? resolve(result.value) : adopt(result.value).then(fulfilled, rejected); } - step((generator = generator.apply(thisArg, _arguments || [])).next()); - }); -}; -var __generator = (this && this.__generator) || function (thisArg, body) { - var _ = { label: 0, sent: function() { if (t[0] & 1) throw t[1]; return t[1]; }, trys: [], ops: [] }, f, y, t, g = Object.create((typeof Iterator === "function" ? Iterator : Object).prototype); - return g.next = verb(0), g["throw"] = verb(1), g["return"] = verb(2), typeof Symbol === "function" && (g[Symbol.iterator] = function() { return this; }), g; - function verb(n) { return function (v) { return step([n, v]); }; } - function step(op) { - if (f) throw new TypeError("Generator is already executing."); - while (g && (g = 0, op[0] && (_ = 0)), _) try { - if (f = 1, y && (t = op[0] & 2 ? y["return"] : op[0] ? y["throw"] || ((t = y["return"]) && t.call(y), 0) : y.next) && !(t = t.call(y, op[1])).done) return t; - if (y = 0, t) op = [op[0] & 2, t.value]; - switch (op[0]) { - case 0: case 1: t = op; break; - case 4: _.label++; return { value: op[1], done: false }; - case 5: _.label++; y = op[1]; op = [0]; continue; - case 7: op = _.ops.pop(); _.trys.pop(); continue; - default: - if (!(t = _.trys, t = t.length > 0 && t[t.length - 1]) && (op[0] === 6 || op[0] === 2)) { _ = 0; continue; } - if (op[0] === 3 && (!t || (op[1] > t[0] && op[1] < t[3]))) { _.label = op[1]; break; } - if (op[0] === 6 && _.label < t[1]) { _.label = t[1]; t = op; break; } - if (t && _.label < t[2]) { _.label = t[2]; _.ops.push(op); break; } - if (t[2]) _.ops.pop(); - _.trys.pop(); continue; - } - op = body.call(thisArg, _); - } catch (e) { op = [6, e]; y = 0; } finally { f = t = 0; } - if (op[0] & 5) throw op[1]; return { value: op[0] ? op[1] : void 0, done: true }; - } -}; -Object.defineProperty(exports, "__esModule", { value: true }); -exports.seedMenuTree = seedMenuTree; -// db/seeds/menu-v2-seed.ts -var menuConfig_1 = require("@/config/menuConfig"); -var menu_json_1 = require("@/i18n/locales/ko/menu.json"); -var menu_json_2 = require("@/i18n/locales/en/menu.json"); -var db_1 = require("@/db/db"); -var menu_v2_1 = require("@/db/schema/menu-v2"); -// 중첩 키로 번역 값 가져오기 -function getTranslation(key, locale) { - var translations = locale === 'ko' ? menu_json_1.default : menu_json_2.default; - var keys = key.split('.'); - var value = translations; - for (var _i = 0, keys_1 = keys; _i < keys_1.length; _i++) { - var k = keys_1[_i]; - if (typeof value === 'object' && value !== null) { - value = value[k]; - } - else { - return key; - } - if (value === undefined) - return key; - } - return typeof value === 'string' ? value : key; -} -function seedMenuTree() { - return __awaiter(this, void 0, void 0, function () { - return __generator(this, function (_a) { - switch (_a.label) { - case 0: - console.log('🌱 Starting menu tree seeding...'); - // 기존 데이터 삭제 - return [4 /*yield*/, db_1.default.delete(menu_v2_1.menuTreeNodes)]; - case 1: - // 기존 데이터 삭제 - _a.sent(); - console.log('✅ Cleared existing menu tree data'); - // evcp 도메인 seed - return [4 /*yield*/, seedDomainMenus('evcp', menuConfig_1.mainNav, menuConfig_1.additionalNav)]; - case 2: - // evcp 도메인 seed - _a.sent(); - console.log('✅ Seeded evcp menu tree'); - // partners 도메인 seed - return [4 /*yield*/, seedDomainMenus('partners', menuConfig_1.mainNavVendor, menuConfig_1.additionalNavVendor)]; - case 3: - // partners 도메인 seed - _a.sent(); - console.log('✅ Seeded partners menu tree'); - console.log('🎉 Menu tree seeding completed!'); - return [2 /*return*/]; - } - }); - }); -} -function seedDomainMenus(domain, navConfig, additionalConfig) { - return __awaiter(this, void 0, void 0, function () { - var globalSortOrder, _loop_1, _i, navConfig_1, section, additionalSortOrder, _a, additionalConfig_1, item; - return __generator(this, function (_b) { - switch (_b.label) { - case 0: - globalSortOrder = 0; - _loop_1 = function (section) { - var menuGroup, groupedItems, groupSortOrder, _c, groupedItems_1, _d, groupKey, items, parentId, group, menuSortOrder, _e, items_1, item; - return __generator(this, function (_f) { - switch (_f.label) { - case 0: return [4 /*yield*/, db_1.default.insert(menu_v2_1.menuTreeNodes).values({ - domain: domain, - parentId: null, - nodeType: 'menu_group', - titleKo: getTranslation(section.titleKey, 'ko'), - titleEn: getTranslation(section.titleKey, 'en'), - sortOrder: globalSortOrder++, - isActive: true, - }).returning()]; - case 1: - menuGroup = (_f.sent())[0]; - groupedItems = new Map(); - section.items.forEach(function (item) { - var groupKey = item.groupKey || '__default__'; - if (!groupedItems.has(groupKey)) { - groupedItems.set(groupKey, []); - } - groupedItems.get(groupKey).push(item); - }); - groupSortOrder = 0; - _c = 0, groupedItems_1 = groupedItems; - _f.label = 2; - case 2: - if (!(_c < groupedItems_1.length)) return [3 /*break*/, 9]; - _d = groupedItems_1[_c], groupKey = _d[0], items = _d[1]; - parentId = menuGroup.id; - if (!(groupKey !== '__default__')) return [3 /*break*/, 4]; - return [4 /*yield*/, db_1.default.insert(menu_v2_1.menuTreeNodes).values({ - domain: domain, - parentId: menuGroup.id, - nodeType: 'group', - titleKo: getTranslation(groupKey, 'ko'), - titleEn: getTranslation(groupKey, 'en'), - sortOrder: groupSortOrder++, - isActive: true, - }).returning()]; - case 3: - group = (_f.sent())[0]; - parentId = group.id; - _f.label = 4; - case 4: - menuSortOrder = 0; - _e = 0, items_1 = items; - _f.label = 5; - case 5: - if (!(_e < items_1.length)) return [3 /*break*/, 8]; - item = items_1[_e]; - return [4 /*yield*/, db_1.default.insert(menu_v2_1.menuTreeNodes).values({ - domain: domain, - parentId: parentId, - nodeType: 'menu', - titleKo: getTranslation(item.titleKey, 'ko'), - titleEn: getTranslation(item.titleKey, 'en'), - descriptionKo: item.descriptionKey ? getTranslation(item.descriptionKey, 'ko') : null, - descriptionEn: item.descriptionKey ? getTranslation(item.descriptionKey, 'en') : null, - menuPath: item.href, - icon: item.icon || null, - sortOrder: menuSortOrder++, - isActive: true, - })]; - case 6: - _f.sent(); - _f.label = 7; - case 7: - _e++; - return [3 /*break*/, 5]; - case 8: - _c++; - return [3 /*break*/, 2]; - case 9: return [2 /*return*/]; - } - }); - }; - _i = 0, navConfig_1 = navConfig; - _b.label = 1; - case 1: - if (!(_i < navConfig_1.length)) return [3 /*break*/, 4]; - section = navConfig_1[_i]; - return [5 /*yield**/, _loop_1(section)]; - case 2: - _b.sent(); - _b.label = 3; - case 3: - _i++; - return [3 /*break*/, 1]; - case 4: - additionalSortOrder = 0; - _a = 0, additionalConfig_1 = additionalConfig; - _b.label = 5; - case 5: - if (!(_a < additionalConfig_1.length)) return [3 /*break*/, 8]; - item = additionalConfig_1[_a]; - return [4 /*yield*/, db_1.default.insert(menu_v2_1.menuTreeNodes).values({ - domain: domain, - parentId: null, - nodeType: 'additional', - titleKo: getTranslation(item.titleKey, 'ko'), - titleEn: getTranslation(item.titleKey, 'en'), - descriptionKo: item.descriptionKey ? getTranslation(item.descriptionKey, 'ko') : null, - descriptionEn: item.descriptionKey ? getTranslation(item.descriptionKey, 'en') : null, - menuPath: item.href, - sortOrder: additionalSortOrder++, - isActive: true, - })]; - case 6: - _b.sent(); - _b.label = 7; - case 7: - _a++; - return [3 /*break*/, 5]; - case 8: return [2 /*return*/]; - } - }); - }); -} -// CLI에서 직접 실행 가능하도록 -if (require.main === module) { - seedMenuTree() - .then(function () { - console.log('Seed completed successfully'); - process.exit(0); - }) - .catch(function (error) { - console.error('Seed failed:', error); - process.exit(1); - }); -} |