public void testParse02() { List<ReportItemConfigurationInfo> rptItemCfgInfoList = SqlConfigurationUtil.parse("/ExportSQL.properties"); assertEquals(3, rptItemCfgInfoList.size()); ReportItemConfigurationInfo rptItemCfgInfo = rptItemCfgInfoList.get(2); assertEquals("RPT03", rptItemCfgInfo.getId()); assertEquals("Summary_UTD", rptItemCfgInfo.getName()); System.out.println(rptItemCfgInfo.getQuery()); }
public void testParse() { List<ReportItemConfigurationInfo> rptItemCfgInfoList = SqlConfigurationUtil.parse("/ExportSQL.properties"); assertEquals(3, rptItemCfgInfoList.size()); ReportItemConfigurationInfo rptItemCfgInfo = rptItemCfgInfoList.get(0); assertEquals("RPT01", rptItemCfgInfo.getId()); assertEquals("Daily_Today", rptItemCfgInfo.getName()); String expectedSQL = "SELECT (Dir.PARENTDIR + '/' + Dir.DIRNAME ) as PATH, VssFile.FileName, Version.Modifier as Modifier, Version.MODIFIED as LastModified, LOC, Comment, Version.Version, Version.Label" + " FROM Version, VssFile, Dir, VssDB" + " WHERE Version.DirId = (VssFile.DIRID) AND (Version.FILENAME = VssFile.FILENAME) AND (VSSFILE.DIRID = Dir.DIRID) AND ( VssDB.VssId = Dir.VssId)" + " AND VssDB.VssPath LIKE '%Group_3%'" + " AND Dir.ParentDir LIKE '%NEXTBUILD%'" + " AND VERSION.VERSION = (SELECT MAX(VERSION) FROM VERSION WHERE Version.FILENAME = VssFile.FILENAME)" + " AND CONVERT(VARCHAR(10), GetDate(),102) = CONVERT(VARCHAR(10), Version.MODIFIED,102)"; assertEquals(expectedSQL, rptItemCfgInfo.getQuery()); // System.out.println(rptItemCfgInfo.getQuery()); }