(김준회) MDG 쿼리 배치처리 도입 (네트워크 왕복 오버헤드 해결 목적), 마이그레이션간 DELETE 제거, 환경변수 정리

1 files changed, 28 insertions, 36 deletions

diff --git a/.env.production b/.env.production
index 17dbaa42..c135e83b 100644
--- a/.env.production
+++ b/.env.production
@@ -1,6 +1,15 @@
+# === DB 설정 ===
 DATABASE_URL=postgresql://dts:dujinDTS2@localhost:5432/evcp
+DB_POOL_MAX=4 # 풀 개수로, 일반적으로 (코어개수 * 1~2) 개 설정, 기본값=4
+
+# === 보안 설정 ===
 JWT_SECRET=dujin2tdofj1241.m
 NEXTAUTH_SECRET=dujinsejinnejinojin1020202310245jldfmoi2eqjldsajfoadmmdlfjmomc.mv0qp3jem.alsmfmc.jl
+NEXT_PUBLIC_URL=https://evcp.dtsolution.io
+NEXT_PUBLIC_BASE_URL=https://evcp.dtsolution.io
+NEXTAUTH_URL=https://evcp.dtsolution.io
+
+# === 이메일 설정 ===
 Email_Host=email-smtp.ap-northeast-2.amazonaws.com
 Email_Port=465
 Email_Secure=true
@@ -8,14 +17,10 @@ Email_User_Name=AKIAVLO5MGBR4764VHHW
 Email_Password=BGs1NJ784I64GoX/itxaQ60FCUEwf0HZhyaCsEUCwFQ/
 Email_From_Name=eVCP
 Email_From_Address=dujin.kim@dtsolution.co.kr
-NEXT_PUBLIC_MUI_KEY=da30586e1f20b93856a9783012fc9258Tz04ODI0MyxFPTE3NDQ0NTM2NzgwMDAsUz1wcmVtaXVtLExNPXN1YnNjcmlwdGlvbixLVj0y
-
-
- NEXT_PUBLIC_URL=https://evcp.dtsolution.io
- NEXT_PUBLIC_BASE_URL=https://evcp.dtsolution.io
- NEXTAUTH_URL=https://evcp.dtsolution.io
 
 # === 상용 소프트웨어 키 ===
+# MUI
+NEXT_PUBLIC_MUI_KEY=da30586e1f20b93856a9783012fc9258Tz04ODI0MyxFPTE3NDQ0NTM2NzgwMDAsUz1wcmVtaXVtLExNPXN1YnNjcmlwdGlvbixLVj0y
 # PDFTRON KEYS
 NEXT_PUBLIC_PDFTRON_WEBVIEW_KEY=demo:1739264618684:616161d7030000000091db1c97c6f386d41d3506ab5b507381ef2ee2bd
 NEXT_PUBLIC_PDFTRON_SERVER_KEY=demo:1740034881027:6175a0fc0300000000f155d153480e5ba091f17922a109cbd7cf6e40b3
@@ -26,68 +31,60 @@ NEXT_PUBLIC_DESIGNER_LICENSE="43.203.251.114|60.101.108.100|evcp.dtsolution.io,2
 # NEXT_PUBLIC_SPREAD_LICENSE="60.101.108.100,674672615555322#B1dbvNkSiJXZDRFRYJVQHFWa6Y6KTVGV5cVWSRVWVlHejFlcvFWUFdGVzVVZVtEcsNjNvo5aHhjcSNVd6kzNvQUT9tCSxEXU6RzRrh5SxsUYqZjertEU7RWQu3yaDNXT5JmRIh7R6YnSGZlMDhkRqB7MIlTYvUWQFFzYulTTm3ENINEV7FWZMl4Q5cXSy96KthkVC3USvYXa8FnbtJWZFdlVSFmYwsEMKRkQxp6TRdGMLdVOTR7TMJEWiRGa6JncDRlWShTN9glc8FmQkBzdvMkUthHUoJGbOJGatVmUxtkRTVmeUlVWxJDN7kXQ6oHUwhEciZXNNJVOPBzc83UaTNmZVZ6aIxUcQdmcOJiOiMlIsICNzgTN5YTQyIiOigkIsYDM6gDN6YjM0IicfJye35XX3JCSJpkQiojIDJCLigTMuYHITpEIkFWZyB7UiojIOJyebpjIkJHUiwiIyQzMxkDMgQjM7ATNyAjMiojI4J7QiwiIwATMugDMx8SMwEjLwYjI0IyctRkIsIShXyetzqekkyesEyOvCyuI0ISYONkIsIiMyMTN5UTNxYjM7YDN7YjI0ICZJJCL35lI4VWZoNFdy3GclJlIsICdyFGaDFGdhRkIsISZsJWYUR7b6lGUiwiI4VWZoNFd49WYHJyW0IyZsZmIsU6csFmZ0IiczRmI1pjIs9WQisnOiQkIsISP3cXVw2meRZ4Yys4YB3UeaJkck9GWjhHUMVlU4gUcndlS63EWCB7YZh7bHBlVwBHe5kVcvEzc5N5aBZUZlJ6SpZHTHRFVjd5dxs6Yuh"
 # NEXT_PUBLIC_DESIGNER_LICENSE="Designer-514482759413237#B1IdxRUVvQnMkFkYVBzLjRzZohUVWZnSiJWUO9WS4pnMLp5KJZ7dX3CelFlW53STTlkdLlzdYBFV6lzTLRGUKVWOU3UbR3GUXFWZxJ5K8lzTnpVcEBHT5p4Yqt6RvEXaTtWMrRmUWpGW5x6dZlzVM5GRjZXMNVGdKxUZptGVUlUWiRnZ7cnTndkWsRGZllTcDpXeVpWRIV5M9BDVkBFNElWUCd5ZzcUWLNjYPNXOl9ESVJTQ756MFlFWzcmcGFDcXt6dDdnV4YmejJHSnNUc6t4MxcXNzQkU9kFSBRGa73WNEtyR6MkZzsEbvRVVHdHWYVlMr2UTGFmZI3mWIdUTihWb43WY78Eaz3SV9d6UzU4R7V5YjJiOiMlIsISMFBjQ8kDRiojIIJCLxITMzUjN5cTN0IicfJye35XX3JCSJpkQiojIDJCLigTMuYHITpEIkFWZyB7UiojIOJyebpjIkJHUiwiI9QTOwMDMgEjM7ATNyAjMiojI4J7QiwiIw8CMuAjLw2icl96ZpNXZkJiOiMXbEJCLikCjGyOoEyOshyOngyOsxqOKFeJ15Or0RSK1xSI12KI1iojIh94QiwiI7MjMzEDN9UzNygDN4ETNiojIklkIs4XXiQXZlh6U4J7bwVmUiwiI4JXYoNUY4FGRiwiIlxmYhRFdvZXaQJCLiQXZlh6U4RnbhdkIbpjInxmZiwSZ5JHd0IiczRmI1pjIs9WQisnOiQkIsISP3E4N82mcKVkdBZ7butkQQNXcMJWNnVVMxE6aUZ4QXBldnZWcrAXM9lmS9FDbp9ERUV7Q9IndiNHd0plb7pmd5debKh"
 
-
-# 기간계 시스템 연동 설정
+# === 기간계 시스템 연동 설정 ===
 ERP_API_URL=https://erp.example.com/api/vendors
 ERP_API_KEY=your-erp-api-key
 ERP_HEALTH_CHECK_URL=https://erp.example.com/api/health
-
+# S-EDP (설계정보)
 SEDP_API_BASE_URL=http://sedpwebapi.ship.samsung.co.kr/api
 SEDP_API_USER_ID=EVCPUSER
 SEDP_API_PASSWORD=evcpusr@2025
 
+# === 오라클 DB ===
 # Oracle DB 연결 설정 (개발용 - 로컬 컨테이너)
 # ORACLE_USER=system
 # ORACLE_PASSWORD=oracle
 # ORACLE_CONNECTION_STRING=localhost:1521/XEPDB1
-
 # Oracle DB 연결 설정 (SHI 품질)
 ORACLE_USER=shievcp
 ORACLE_PASSWORD=evp_2025
 ORACLE_CONNECTION_STRING=60.100.89.191:7971/SEVMQ
 
-
-# 기본 DOLCE 동기화 값
+# 기본 DOLCE 동기화 값 (60.100.99.217=dolce 개발, 60.100.98.68=dolce 운영)
 SYNC_DOLCE_URL=http://60.100.99.217:1111/
 SYNC_DOLCE_BATCH=150        # 없으면 100으로 fallback
 SYNC_DOLCE_TOKEN=
-
 SYNC_DOLCE_ENABLED=true
 DOLCE_UPLOAD_ENABLED=true
 
-
 # 기본 SWP 동기화 값
 SYNC_SWP_URL=https://swp.example.com/api/documents
 SYNC_SWP_BATCH=200
 SYNC_SWP_TOKEN=
+# SYNC_SWP_ENABLED=true # production에는 선언되어 있지 않아서 주석처리해 추가
 
-
+# DOLCE 설정
 IMPORT_DOLCE_ENABLED=true
-
 DOLCE_API_URL=http://60.100.99.217:1111
 DOLCE_UPLOAD_URL=http://60.100.99.217:1111/PWPUploadService.ashx
 DOLCE_DOC_LIST_API_URL=http://60.100.99.217:1111/Services/VDCSWebService.svc/DwgReceiptMgmt
 DOLCE_DOC_DETAIL_API_URL=http://60.100.99.217:1111/Services/VDCSWebService.svc/DetailDwgReceiptMgmt
 DOLCE_FILE_INFO_API_URL=http://60.100.99.217:1111/Services/VDCSWebService.svc/FileInfoList
-
+DOLCE_DOWNLOAD_URL=http://60.100.99.217:1111/Download.aspx
 
 ### S-GIPS ###
 S_GIPS_URL="http://qa.shi-api.com/evcp/Common/verifySgipsUser"
 S_GIPS_TOKEN="eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJrZXlhdXRoLWV2Y3AiLCJuYmYiOjE3NDg2MTcyMDAsImV4cCI6MTc1NjYyNzIwMH0.aMPZn9Et0Q--lC3Av8Sh4VtWW50-Dk05WHzdhbWsr7k"
 S_GIPS_RSA_KEY="MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtHC28Gw0U8taUwI8oJtG1H2JWGJtcsDw8w1oZbs759/Rag7zCF/bBilRtvlOz92wt02RCONetWK9VMgR2cqTJhfSaP92jIx0QQ+W1IrSKAiBxv+WtItsaWFLgYGIYNvrX8+qOnd+rDBvKDP9kk9Zqs1mHF2CbPRmao7/iEfhTb92hCgpFqsj/zU7nV3a8RbyifEMKSXTNanOEK2nTxAjld/csXQayHSaaqoH/lVySK0Qp6A2d2u2gEj/TAQ+Bhe7BsexNs2s5u5rykJqeROqJ7n0UsGgLd+uUDeo2nLqq5KeaXNcmACVcy2AASog78dzKwQmmGuC9Rp3zIoKOGdoQwIDAQAB"
-### S-GIPS ###
 
+### NHN Cloud OCR KEY
 OCR_SECRET_KEY=QVZzbkFtVFV1UWl2THNCY01lYVVGUUxpWmdyUkxHYVA=
 
-
-# === [시작] SSO 설정 ===
-
+# === SSO 설정 ===
 # ! SSO Redirect 주소로 활용되며, 상단에서 적절한 URL을 쓴다면 이 변수는 주석처리할 것
 # NEXTAUTH_URL="http://60.101.108.100"
-
 # SAML 2.0 SP로서 신청할 때 기입하는 사항
 # 메타데이터 XML에서 추출 가능하나, 개발 편의성을 위해 추출로직 제거하고 환경변수에 하드코딩함
-
 ### sp_metadata.xml ###
 SAML_SP_ENTITY_ID="http://60.101.108.100"
 SAML_SP_CALLBACK_URL="http://60.101.108.100/api/saml/callback"
@@ -97,29 +94,25 @@ SAML_SP_ACS_BINDING_PRIMARY="urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST"
 SAML_SP_ACS_BINDING_SECONDARY="urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect"
 SAML_SP_AUTHN_REQUESTS_SIGNED=false
 SAML_SP_WANT_ASSERTIONS_SIGNED=false
-
 ### idp_metadata.xml ###
 SAML_IDP_ENTITY_ID="www.samsung.net"
 SAML_IDP_SSO_URL="https://epsso.samsung.net/sso/saml/SingleSignOnService"
 SAML_IDP_CERT="MIID2zCCAsOgAwIBAgIJAIt4QxV2bA3qMA0GCSqGSIb3DQEBCwUAMIGDMQswCQYDVQQGEwJLUjEPMA0GA1UECAwGSmFtc2lsMQ4wDAYDVQQHDAVTZW91bDETMBEGA1UECgwKU2Ftc3VuZ1NEUzEdMBsGA1UECwwUSW50cmFuZXRCdXNpbmVzc1RlYW0xHzAdBgNVBAMMFm5ldC5zYW1zdW5nLmtub3hwb3J0YWwwHhcNMTcwOTA2MDQ0OTI1WhcNMjcwOTA0MDQ0OTI1WjCBgzELMAkGA1UEBhMCS1IxDzANBgNVBAgMBkphbXNpbDEOMAwGA1UEBwwFU2VvdWwxEzARBgNVBAoMClNhbXN1bmdTRFMxHTAbBgNVBAsMFEludHJhbmV0QnVzaW5lc3NUZWFtMR8wHQYDVQQDDBZuZXQuc2Ftc3VuZy5rbm94cG9ydGFsMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA403a0G0WexaxyscAVFtThKL9X9d6XM5fq6ELIcD+cNQigQK4lqo1oRX+u1NEia+YqJHpCMdSzjmU76+xSytvTI0aNTAbm6wfiXNfkjFwD8H0TT0P4TgeqtIjmH80YLjEPIPGiMMVcbvRgJxGCKDM4XOoM5YOtzRPQaSrQ+6Vy9J5poduafMRamf1uljUfo++P8fPbqwPjamFYxG3HTX02ac11aiuY4xlUFOkvXc6UtEQ79tKmf0SKnkEyWpxyDmQYy5pW36Lkh2FzKo6itYlKaMwJRP1b9IN4g1e/Eexr+6Qb4p8qoKeWq7hTFgtiW321e8+cdeL28m1WkVDPEB5TwIDAQABo1AwTjAdBgNVHQ4EFgQUTSA00p+swYrMz1nGBs6uJ83D7DswHwYDVR0jBBgwFoAUTSA00p+swYrMz1nGBs6uJ83D7DswDAYDVR0TBAUwAwEB/zANBgkqhkiG9w0BAQsFAAOCAQEAmyBNNwzkq/+9r7gwVEe51T0s/e21b5NjQZ1t7Zrg0v43rg1baxZINpc5imGFOGpzyBFhoGCrmnpMk70m0uS284DeLJTB2Z+zsjE8NPlS5fU7lLDqaSJduOwdxmdo3PufgwL3vYXK0KTrsptdNLmP+9mYUdEAUTTyd6rwMyxXv1sgHUBNHHUY4Nlq78Q6vzjMTZ+j2yjRv4kCAueQOyuP1hqXjbfhoEluAM3gXlu7nASNFHR5CkaRyBYeORSJm/jLehGb66aRl6XfI+tNuGmpnMEnXhCq/om8KArBI/hOHgeI/YUoYkfgWjK+cteZ6RMiwlYQALwHd3J2RBMPz3NnIw=="
 
-# === [끝] SSO 설정 ===
-
 # Bizppurio API 설정
 BIZPPURIO_ACCOUNT=shinonsap_evcp
 BIZPPURIO_PASSWORD=shi_2025
 BIZPPURIO_FROM_NUMBER=05563092940
 
+# LINUX CRON SECRET
 CRON_SECRET=dujin@DTS@2025dujin@DTS@2025dujin@DTS@2025dujin@DTS@2025dujin@DTS@2025dujin@DTS@2025
 
 # === SOAP 인터페이스 설정 ===
 # MDG SOAP 인증 정보 (개발/품질/운영 비밀번호가 다름)
-MDG_SOAP_USERNAME=P2038_01 # 개발/품질/운영 공통
-# MDG_SOAP_PASSWORD=STG4857602 # 개발
-MDG_SOAP_PASSWORD=SEW2765890 # 품질
-# MDG_SOAP_PASSWORD=POI9807861 # 운영
-SOAP_LOG_MAX_RECORDS=5000
-# === SOAP 인터페이스 설정 ===
+MDG_SOAP_USERNAME=P2038_01 # 개발/품질/운영 공통, 
+MDG_SOAP_PASSWORD=SEW2765890 # 품질: MDG_SOAP_PASSWORD=SEW2765890, # 운영: MDG_SOAP_PASSWORD=POI9807861 # 개발: MDG_SOAP_PASSWORD=STG4857602
+SOAP_LOG_MAX_RECORDS=5000 # soap.soap_logs 테이블에 몇건의 로그를 남길 것인지 (rotating), 5000개 = 대략 2GB
+SOAP_IGNORE_DELETE_FOR_MIGRATION=false # migration 과정에서 db 부하를 줄이기 위해 서브테이블 delete 과정 생략 여부
 
 # === KNOX API 사용을 위한 설정 ===
 # 임직원 API: 임직원, 조직도, 직급
@@ -138,9 +131,8 @@ MESSENGER_ACCESS_TOKEN=""
 MESSENGER_DEVICE_ID=""
 MESSENGER_BASE_URL="https://openapi.samsung.net"
 
-# NAS 경로 설정
+# === NAS 경로 설정 ===
 NAS_PATH="/evcp_nas"
 
-# 임시 환경변수 --- 요구사항 해소되면 삭제
-READONLY_DB_URL="postgresql://readonly:tempReadOnly_123@localhost:5432/evcp"
-# 임시 환경변수 --- 요구사항 해소되면 삭제
\ No newline at end of file
+# === 임시 환경변수, 나프로 요구사항 해소되면 삭제 ===
+READONLY_DB_URL="postgresql://readonly:tempReadOnly_123@localhost:5432/evcp" # 해당 계정은 별도로 만들어야 함
\ No newline at end of file