Index: pom.xml =================================================================== diff -u -r3bdd902ff67d96fd205d1926c558b2eac47cd0ad -rb0de5dc79b2d9748a0db6dbda80266685bd6ebda --- pom.xml (.../pom.xml) (revision 3bdd902ff67d96fd205d1926c558b2eac47cd0ad) +++ pom.xml (.../pom.xml) (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -10,7 +10,7 @@ 4.0.0 313devgrp java-service-tree-framework-backend-server - 22.06.18 + 22.06.19 pom java-service-tree-framework Index: web-module/pom.xml =================================================================== diff -u -r3bdd902ff67d96fd205d1926c558b2eac47cd0ad -rb0de5dc79b2d9748a0db6dbda80266685bd6ebda --- web-module/pom.xml (.../pom.xml) (revision 3bdd902ff67d96fd205d1926c558b2eac47cd0ad) +++ web-module/pom.xml (.../pom.xml) (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -7,7 +7,7 @@ 313devgrp java-service-tree-framework-backend-server - 22.06.18 + 22.06.19 ../pom.xml FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/ddl/oracle/egovframework/api/Arms_DeviceList_DDL_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/ddl/oracle/egovframework/api/Arms_PdServiceJira_DDL_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/ddl/oracle/egovframework/api/Arms_PdService_DDL_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/ddl/oracle/egovframework/api/Arms_PdVersionService_DDL_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/ddl/oracle/egovframework/api/Menu_DDL_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/ddl/oracle/egovframework/api/Monitor_DDL_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/dml/oracle/egovframework/api/Arms_DeviceList_DML_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/dml/oracle/egovframework/api/Arms_PdServiceJira_DML_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/dml/oracle/egovframework/api/Arms_PdService_DML_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/dml/oracle/egovframework/api/Arms_PdVersionService_DML_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/dml/oracle/egovframework/api/Menu_DML_Oracle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/dml/oracle/egovframework/api/Monitor_DML_ORacle.sql'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/client/filebeat.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/client/heartbeat.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/client/metricbeat.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/client/packetbeat.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/client/scouter-2.8.1.conf'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/client/topbeat.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/allinone.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/allinone/apm-server.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/allinone/es-limits.conf'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/allinone/fluent.conf'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/allinone/influxdb.conf'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/allinone/logstash.conf'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/allinone/logstash.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/auth.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/devtool.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/portainer.yml'. FishEye: No comparison available. Pass `N' to diff? FishEye: Tag b0de5dc79b2d9748a0db6dbda80266685bd6ebda refers to a dead (removed) revision in file `web-module/script/yml/monitoring/server/spinnaker.yml'. FishEye: No comparison available. Pass `N' to diff? Index: web-module/src/main/resources/script/ddl/oracle/arms/DeviceList_Oracle_DDL.sql =================================================================== diff -u --- web-module/src/main/resources/script/ddl/oracle/arms/DeviceList_Oracle_DDL.sql (revision 0) +++ web-module/src/main/resources/script/ddl/oracle/arms/DeviceList_Oracle_DDL.sql (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -0,0 +1,120 @@ +CREATE TABLE T_ARMS_MONITOR_DEVICELIST_LOG +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_METHOD VARCHAR2(4000 BYTE), + C_STATE VARCHAR2(4000 BYTE), + C_DATE DATE NOT NULL + +); + +COMMENT ON TABLE T_ARMS_MONITOR_DEVICELIST_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST_LOG.C_DATE IS '노드 변경 시'; + +CREATE TABLE T_ARMS_MONITOR_DEVICELIST +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_LINK VARCHAR2(4000 BYTE), + + c_monitor_name VARCHAR2(4000 BYTE), + c_monitor_update_date VARCHAR2(4000 BYTE), + c_monitor_update_beatname VARCHAR2(4000 BYTE), + c_monitor_device_hostname VARCHAR2(4000 BYTE), + c_monitor_device_ip VARCHAR2(4000 BYTE), + + c_monitor_url_filebeat VARCHAR2(4000 BYTE), + c_monitor_url_packetbeat VARCHAR2(4000 BYTE), + c_monitor_url_heartbeat VARCHAR2(4000 BYTE), + c_monitor_url_metricbeat VARCHAR2(4000 BYTE), + c_monitor_url_topbeat VARCHAR2(4000 BYTE), + c_monitor_url_apm VARCHAR2(4000 BYTE), + c_monitor_url_scouter VARCHAR2(4000 BYTE), + + CONSTRAINT T_ARMS_MONITOR_DEVICELISTU_PK PRIMARY KEY (C_ID) +); + +COMMENT ON TABLE T_ARMS_MONITOR_DEVICELIST IS '기본 트리 스키마'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.C_TYPE IS '노드 타입'; + +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_name IS '모니터링 이름'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_update_date IS '모니터링 최초 업데이트 날짜'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_update_beatname IS '모니터링 데이터 푸쉬 에이전트 이름'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_device_hostname IS '모니터링 데이터 푸쉬 호스트 이름'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_device_ip IS '모니터링 데이터 푸쉬 아이피 주소'; + +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_filebeat IS '파일비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_packetbeat IS '패킷비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_heartbeat IS '하트비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_metricbeat IS '메트릭비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_topbeat IS '탑비트 로그 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_apm IS '성능 모니터링 접속 주소'; +COMMENT ON COLUMN T_ARMS_MONITOR_DEVICELIST.c_monitor_url_scouter IS '스카우터 모니터링 접속 주소'; + + +CREATE SEQUENCE S_ARMS_MONITOR_DEVICELIST + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + + +CREATE OR REPLACE TRIGGER "TG_ARMS_MONITOR_DEVICELIST" +BEFORE DELETE OR INSERT OR UPDATE +ON T_ARMS_MONITOR_DEVICELIST_LOG +REFERENCING NEW AS NEW OLD AS OLD +FOR EACH ROW +DECLARE +tmpVar NUMBER; +BEGIN + tmpVar := 0; + IF UPDATING THEN + insert into T_ARMS_MONITOR_DEVICELIST_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate); + insert into T_ARMS_MONITOR_DEVICELIST_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate); + END IF; + IF DELETING THEN + insert into T_ARMS_MONITOR_DEVICELIST_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate); + END IF; + IF INSERTING THEN + insert into T_ARMS_MONITOR_DEVICELIST_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate); + END IF; + + EXCEPTION + WHEN OTHERS THEN + RAISE; +END TG_ARMS_MONITOR_DEVICELIST; \ No newline at end of file Index: web-module/src/main/resources/script/ddl/oracle/arms/Menu_Oracle_DDL.sql =================================================================== diff -u --- web-module/src/main/resources/script/ddl/oracle/arms/Menu_Oracle_DDL.sql (revision 0) +++ web-module/src/main/resources/script/ddl/oracle/arms/Menu_Oracle_DDL.sql (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -0,0 +1,130 @@ +/* + * JsTree 추적 로그 테이블 + * 트리거 Log를 저장합니다. + */ +CREATE TABLE T_JSTREE_MENU_LOG +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_METHOD VARCHAR2(4000 BYTE), + C_STATE VARCHAR2(4000 BYTE), + C_DATE DATE NOT NULL +); + +COMMENT ON TABLE T_JSTREE_MENU_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_JSTREE_MENU_LOG.C_DATE IS '노드 변경 시'; + +/* + * JsTree + */ +CREATE TABLE T_JSTREE_MENU +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_LINK VARCHAR2(4000 BYTE), + CONSTRAINT T_JSTREE_MENU_PK PRIMARY KEY (C_ID) + /* + * CONSTRAINT T_JSTREE_MENU_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_JSTREE_MENU(C_ID) ON DELETE CASCADE + */ +); + +COMMENT ON TABLE T_JSTREE_MENU IS '기본 트리 스키마'; +COMMENT ON COLUMN T_JSTREE_MENU.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MENU.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MENU.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_JSTREE_MENU.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MENU.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MENU.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_JSTREE_MENU.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_JSTREE_MENU.C_TYPE IS '노드 타입'; + +/* + * 인덱스는 되도록 걸지 말것. + * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_JSTREE_MENU + * ("C_ID" ASC) + */ + /* +*DROP SEQUENCE S_JSTREE_MENU; + */ +CREATE SEQUENCE S_JSTREE_MENU + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + +/* + * JsTree 트리거 + */ +CREATE OR REPLACE TRIGGER "TRIGGER_TREE_MENU" +BEFORE DELETE OR INSERT OR UPDATE +ON T_JSTREE_MENU +REFERENCING NEW AS NEW OLD AS OLD +FOR EACH ROW +DECLARE +tmpVar NUMBER; +/****************************************************************************** + NAME: TRIGGER_COMPREHENSIVETREE + PURPOSE: + + REVISIONS: + Ver Date Author Description + --------- ---------- --------------- ------------------------------------ + 1.0 2012-08-29 1. Created this trigger. + + NOTES: + + Automatically available Auto Replace Keywords: + Object Name: TRIGGER_COMPREHENSIVETREE + Sysdate: 2012-08-29 + Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44 + Username: (set in TOAD Options, Proc Templates) + Table Name: T_JSTREE_MENU (set in the "New PL/SQL Object" dialog) + Trigger Options: (set in the "New PL/SQL Object" dialog) +******************************************************************************/ +BEGIN + tmpVar := 0; + IF UPDATING THEN + insert into T_JSTREE_MENU_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate); + insert into T_JSTREE_MENU_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate); + END IF; + IF DELETING THEN + insert into T_JSTREE_MENU_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate); + END IF; + IF INSERTING THEN + insert into T_JSTREE_MENU_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate); + END IF; + + EXCEPTION + WHEN OTHERS THEN + -- Consider logging the error and then re-raise + RAISE; +END TRIGGER_TREE_MENU; +/ \ No newline at end of file Index: web-module/src/main/resources/script/ddl/oracle/arms/Monitor_Oracle_DDL.sql =================================================================== diff -u --- web-module/src/main/resources/script/ddl/oracle/arms/Monitor_Oracle_DDL.sql (revision 0) +++ web-module/src/main/resources/script/ddl/oracle/arms/Monitor_Oracle_DDL.sql (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -0,0 +1,130 @@ +/* + * JsTree 추적 로그 테이블 + * 트리거 Log를 저장합니다. + */ +CREATE TABLE T_JSTREE_MONITOR_LOG +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_METHOD VARCHAR2(4000 BYTE), + C_STATE VARCHAR2(4000 BYTE), + C_DATE DATE NOT NULL +); + +COMMENT ON TABLE T_JSTREE_MONITOR_LOG IS '기본 트리 스키마 트리거 로그'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_TYPE IS '노드 타입'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_METHOD IS '노드 변경 행위'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)'; +COMMENT ON COLUMN T_JSTREE_MONITOR_LOG.C_DATE IS '노드 변경 시'; + +/* + * JsTree + */ +CREATE TABLE T_JSTREE_MONITOR +( + C_ID NUMBER NOT NULL, + C_PARENTID NUMBER NOT NULL, + C_POSITION NUMBER NOT NULL, + C_LEFT NUMBER NOT NULL, + C_RIGHT NUMBER NOT NULL, + C_LEVEL NUMBER NOT NULL, + C_TITLE VARCHAR2(4000 BYTE), + C_TYPE VARCHAR2(4000 BYTE), + C_LINK VARCHAR2(4000 BYTE), + CONSTRAINT T_JSTREE_MONITOR_PK PRIMARY KEY (C_ID) + /* + * CONSTRAINT T_JSTREE_MONITOR_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_JSTREE_MONITOR(C_ID) ON DELETE CASCADE + */ +); + +COMMENT ON TABLE T_JSTREE_MONITOR IS '기본 트리 스키마'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_ID IS '노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_PARENTID IS '부모 노드 아이디'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_POSITION IS '노드 포지션'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_LEFT IS '노드 좌측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_RIGHT IS '노드 우측 끝 포인트'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_LEVEL IS '노드 DEPTH '; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_TITLE IS '노드 명'; +COMMENT ON COLUMN T_JSTREE_MONITOR.C_TYPE IS '노드 타입'; + +/* + * 인덱스는 되도록 걸지 말것. + * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_JSTREE_MONITOR + * ("C_ID" ASC) + */ + /* +*DROP SEQUENCE S_JSTREE_MONITOR; + */ +CREATE SEQUENCE S_JSTREE_MONITOR + START WITH 10 + MAXVALUE 999999999999999999999999999 + MINVALUE 0 + NOCYCLE + CACHE 20 + NOORDER; + +/* + * JsTree 트리거 + */ +CREATE OR REPLACE TRIGGER "TRIGGER_TREE_MONITOR" +BEFORE DELETE OR INSERT OR UPDATE +ON T_JSTREE_MONITOR +REFERENCING NEW AS NEW OLD AS OLD +FOR EACH ROW +DECLARE +tmpVar NUMBER; +/****************************************************************************** + NAME: TRIGGER_COMPREHENSIVETREE + PURPOSE: + + REVISIONS: + Ver Date Author Description + --------- ---------- --------------- ------------------------------------ + 1.0 2012-08-29 1. Created this trigger. + + NOTES: + + Automatically available Auto Replace Keywords: + Object Name: TRIGGER_COMPREHENSIVETREE + Sysdate: 2012-08-29 + Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44 + Username: (set in TOAD Options, Proc Templates) + Table Name: T_JSTREE_MONITOR (set in the "New PL/SQL Object" dialog) + Trigger Options: (set in the "New PL/SQL Object" dialog) +******************************************************************************/ +BEGIN + tmpVar := 0; + IF UPDATING THEN + insert into T_JSTREE_MONITOR_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate); + insert into T_JSTREE_MONITOR_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate); + END IF; + IF DELETING THEN + insert into T_JSTREE_MONITOR_LOG + values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate); + END IF; + IF INSERTING THEN + insert into T_JSTREE_MONITOR_LOG + values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate); + END IF; + + EXCEPTION + WHEN OTHERS THEN + -- Consider logging the error and then re-raise + RAISE; +END TRIGGER_TREE_MONITOR; +/ \ No newline at end of file Index: web-module/src/main/resources/script/dml/oracle/arms/DeviceList_Oracle_DML.sql =================================================================== diff -u --- web-module/src/main/resources/script/dml/oracle/arms/DeviceList_Oracle_DML.sql (revision 0) +++ web-module/src/main/resources/script/dml/oracle/arms/DeviceList_Oracle_DML.sql (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -0,0 +1,49 @@ +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (1, 0, 0, 1, 8, + 0, 'Root Node', 'root', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (2, 1, 0, 2, 7, + 1, 'First Child', 'drive', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (3, 2, 0, 3, 4, + 2, 'Leaf Node', 'default', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +Insert into T_ARMS_MONITOR_DEVICELIST + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, + c_monitor_name, c_monitor_update_date, c_monitor_update_beatname, c_monitor_device_hostname, c_monitor_device_ip, + c_monitor_url_filebeat, c_monitor_url_packetbeat, c_monitor_url_heartbeat, c_monitor_url_metricbeat, + c_monitor_url_topbeat, c_monitor_url_apm, c_monitor_url_scouter) +Values + (4, 2, 1, 5, 6, + 2, 'Branch Node', 'folder', + 'c_monitor_name', 'c_monitor_update_date', 'c_monitor_update_beatname', 'c_monitor_device_hostname', 'c_monitor_device_ip', + 'c_monitor_url_filebeat', 'c_monitor_url_packetbeat', 'c_monitor_url_heartbeat', 'c_monitor_url_metricbeat', + 'c_monitor_url_topbeat', 'c_monitor_url_apm', 'c_monitor_url_scouter'); +COMMIT; \ No newline at end of file Index: web-module/src/main/resources/script/dml/oracle/arms/Menu_Oracle_DML.sql =================================================================== diff -u --- web-module/src/main/resources/script/dml/oracle/arms/Menu_Oracle_DML.sql (revision 0) +++ web-module/src/main/resources/script/dml/oracle/arms/Menu_Oracle_DML.sql (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -0,0 +1,25 @@ +Insert into T_JSTREE_MENU + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (1, 0, 0, 1, 8, + 0, 'Root Node', 'root', 'blank_url'); +Insert into T_JSTREE_MENU + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (2, 1, 0, 2, 7, + 1, 'First Child', 'drive', 'blank_url'); +Insert into T_JSTREE_MENU + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (3, 2, 0, 3, 4, + 2, 'Leaf Node', 'default', 'blank_url'); +Insert into T_JSTREE_MENU + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (4, 2, 1, 5, 6, + 2, 'Branch Node', 'folder', 'blank_url'); +COMMIT; \ No newline at end of file Index: web-module/src/main/resources/script/dml/oracle/arms/Monitor_Oracle_DML.sql =================================================================== diff -u --- web-module/src/main/resources/script/dml/oracle/arms/Monitor_Oracle_DML.sql (revision 0) +++ web-module/src/main/resources/script/dml/oracle/arms/Monitor_Oracle_DML.sql (revision b0de5dc79b2d9748a0db6dbda80266685bd6ebda) @@ -0,0 +1,25 @@ +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (1, 0, 0, 1, 8, + 0, 'Root Node', 'root', 'blank_url'); +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (2, 1, 0, 2, 7, + 1, 'First Child', 'drive', 'blank_url'); +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (3, 2, 0, 3, 4, + 2, 'Leaf Node', 'default', 'blank_url'); +Insert into T_JSTREE_MONITOR + (C_ID, C_PARENTID, C_POSITION, C_LEFT, C_RIGHT, + C_LEVEL, C_TITLE, C_TYPE, C_LINK) +Values + (4, 2, 1, 5, 6, + 2, 'Branch Node', 'folder', 'blank_url'); +COMMIT; \ No newline at end of file