File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
<dataConfig>
<dataSource driver="core.log.jdbc.driver.MysqlDriver" url="jdbc:mysql://119.193.215.98:3306/kopostmysql_new" user="kopost" password="kopost" />
<document>
<entity name="item"
query="SELECT a.NTT_ID AS NTT_ID,
a.BBS_ID AS BBS_ID,
a.NTT_SJ AS NTT_SJ,
a.NTT_SJ AS NTT_SJ_HL,
SUBSTR(a.NTT_CN, 1, 2000) AS NTT_CN,
DATE_FORMAT(a.FRST_REGIST_PNTTM, '%Y-%m-%d') AS FRST_REGIST_PNTTM,
REPLACE(GETMENUCOURS(h.MENU_NO), '|', ' > ') AS MENU_COURS,
h.MENU_NM AS MENU_NM,
f.URL AS URL
FROM LETTNBBS a
INNER JOIN LETTNBBSMASTER BBM
ON A.BBS_ID = BBM.BBS_ID
LEFT OUTER JOIN LETTNPROGRMLIST f
ON a.BBS_ID = f.PROGRM_FILE_NM
LEFT OUTER JOIN LETTNMENUINFO h
ON f.PROGRM_FILE_NM = h.PROGRM_FILE_NM
LEFT OUTER JOIN
(SELECT a.ATCH_FILE_ID,
COUNT(b.FILE_SN) AS ATCH_FILE_CNT,
MIN(b.FILE_SN) AS FILE_SN
FROM LETTNFILE a
LEFT OUTER JOIN LETTNFILEDETAIL b
ON a.ATCH_FILE_ID = b.ATCH_FILE_ID
WHERE a.USE_AT = 'Y'
GROUP BY a.ATCH_FILE_ID
)
c
ON a.ATCH_FILE_ID = c.ATCH_FILE_ID
LEFT OUTER JOIN
(SELECT CODE_ID,
CODE,
CODE_NM
FROM LETTCCMMNDETAILCODE
WHERE CODE_ID = 'ITN004'
AND USE_AT ='Y'
)
d
ON a.REPORT_TY_CD = d.CODE
LEFT OUTER JOIN
(SELECT CODE_ID,
CODE,
CODE_NM
FROM LETTCCMMNDETAILCODE
WHERE CODE_ID = 'ITN006'
AND USE_AT ='Y'
)
f
ON a.DD_TY_CD = f.CODE
WHERE a.USE_AT = 'Y'
AND f.URL IS NOT NULL
AND f.PROGRM_FILE_NM NOT IN ('BBSMSTR_000000000004',
'BBSMSTR_000000000023',
'BBSMSTR_000000000540') "
deltaImportQuery="SELECT a.NTT_ID AS NTT_ID,
a.BBS_ID AS BBS_ID,
a.NTT_SJ AS NTT_SJ,
a.NTT_SJ AS NTT_SJ_HL,
SUBSTR(a.NTT_CN, 1, 2000) AS NTT_CN,
DATE_FORMAT(a.FRST_REGIST_PNTTM, '%Y-%m-%d') AS FRST_REGIST_PNTTM,
REPLACE(GETMENUCOURS(h.MENU_NO), '|', ' > ') AS MENU_COURS,
h.MENU_NM AS MENU_NM,
f.URL AS URL
FROM LETTNBBS a
INNER JOIN LETTNBBSMASTER BBM
ON A.BBS_ID = BBM.BBS_ID
LEFT OUTER JOIN LETTNPROGRMLIST f
ON a.BBS_ID = f.PROGRM_FILE_NM
LEFT OUTER JOIN LETTNMENUINFO h
ON f.PROGRM_FILE_NM = h.PROGRM_FILE_NM
LEFT OUTER JOIN
(SELECT a.ATCH_FILE_ID,
COUNT(b.FILE_SN) AS ATCH_FILE_CNT,
MIN(b.FILE_SN) AS FILE_SN
FROM LETTNFILE a
LEFT OUTER JOIN LETTNFILEDETAIL b
ON a.ATCH_FILE_ID = b.ATCH_FILE_ID
WHERE a.USE_AT = 'Y'
GROUP BY a.ATCH_FILE_ID
)
c
ON a.ATCH_FILE_ID = c.ATCH_FILE_ID
LEFT OUTER JOIN
(SELECT CODE_ID,
CODE,
CODE_NM
FROM LETTCCMMNDETAILCODE
WHERE CODE_ID = 'ITN004'
AND USE_AT ='Y'
)
d
ON a.REPORT_TY_CD = d.CODE
LEFT OUTER JOIN
(SELECT CODE_ID,
CODE,
CODE_NM
FROM LETTCCMMNDETAILCODE
WHERE CODE_ID = 'ITN006'
AND USE_AT ='Y'
)
f
ON a.DD_TY_CD = f.CODE
WHERE a.USE_AT = 'Y'
AND f.URL IS NOT NULL
AND f.PROGRM_FILE_NM NOT IN ('BBSMSTR_000000000004',
'BBSMSTR_000000000023',
'BBSMSTR_000000000540')
AND a.NTT_ID = '${dataimporter.delta.id}' "
deltaQuery="SELECT a.NTT_ID AS NTT_ID,
a.BBS_ID AS BBS_ID,
a.NTT_SJ AS NTT_SJ,
a.NTT_SJ AS NTT_SJ_HL,
SUBSTR(a.NTT_CN, 1, 2000) AS NTT_CN,
DATE_FORMAT(a.FRST_REGIST_PNTTM, '%Y-%m-%d') AS FRST_REGIST_PNTTM,
REPLACE(GETMENUCOURS(h.MENU_NO), '|', ' > ') AS MENU_COURS,
h.MENU_NM AS MENU_NM,
f.URL AS URL
FROM LETTNBBS a
INNER JOIN LETTNBBSMASTER BBM
ON A.BBS_ID = BBM.BBS_ID
LEFT OUTER JOIN LETTNPROGRMLIST f
ON a.BBS_ID = f.PROGRM_FILE_NM
LEFT OUTER JOIN LETTNMENUINFO h
ON f.PROGRM_FILE_NM = h.PROGRM_FILE_NM
LEFT OUTER JOIN
(SELECT a.ATCH_FILE_ID,
COUNT(b.FILE_SN) AS ATCH_FILE_CNT,
MIN(b.FILE_SN) AS FILE_SN
FROM LETTNFILE a
LEFT OUTER JOIN LETTNFILEDETAIL b
ON a.ATCH_FILE_ID = b.ATCH_FILE_ID
WHERE a.USE_AT = 'Y'
GROUP BY a.ATCH_FILE_ID
)
c
ON a.ATCH_FILE_ID = c.ATCH_FILE_ID
LEFT OUTER JOIN
(SELECT CODE_ID,
CODE,
CODE_NM
FROM LETTCCMMNDETAILCODE
WHERE CODE_ID = 'ITN004'
AND USE_AT ='Y'
)
d
ON a.REPORT_TY_CD = d.CODE
LEFT OUTER JOIN
(SELECT CODE_ID,
CODE,
CODE_NM
FROM LETTCCMMNDETAILCODE
WHERE CODE_ID = 'ITN006'
AND USE_AT ='Y'
)
f
ON a.DD_TY_CD = f.CODE
WHERE a.USE_AT = 'Y'
AND f.URL IS NOT NULL
AND f.PROGRM_FILE_NM NOT IN ('BBSMSTR_000000000004',
'BBSMSTR_000000000023',
'BBSMSTR_000000000540')
AND a.LAST_UPDT_PNTTM > ${dataimporter.last_index_time} "
transformer="ClobTransformer,HTMLStripTransformer">
<field column="NTT_ID" name="id" />
<field column="BBS_ID" name="bbsId" />
<field column="NTT_SJ" name="nttSj" />
<field column="NTT_SJ_HL" name="nttSjHl" />
<field column="NTT_CN" name="text" clob="true" stripHTML="true" />
<field column="FRST_REGIST_PNTTM" name="frstRegistPnttm" />
<field column="MENU_COURS" name="menuCours" />
<field column="MENU_NM" name="menuNm" />
<field column="URL" name="url" />
</entity>
</document>
</dataConfig>