1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 */ 20 package fvt.uno.ffc; 21 22 import java.io.File; 23 import java.io.FilenameFilter; 24 import java.util.HashMap; 25 import java.util.List; 26 import java.util.Map; 27 28 import junit.framework.Assert; 29 30 import org.junit.After; 31 import org.junit.Before; 32 import org.junit.BeforeClass; 33 import org.junit.Rule; 34 import org.junit.Test; 35 import org.junit.runner.RunWith; 36 import org.openoffice.test.OpenOffice; 37 import org.openoffice.test.common.FileProvider; 38 import org.openoffice.test.common.FileProvider.FileRepos; 39 import org.openoffice.test.common.FileUtil; 40 import org.openoffice.test.common.Logger; 41 import org.openoffice.test.common.SystemUtil; 42 import org.openoffice.test.common.Testspace; 43 import org.openoffice.test.uno.UnoApp; 44 45 import com.sun.star.beans.PropertyValue; 46 import com.sun.star.document.MacroExecMode; 47 import com.sun.star.frame.XComponentLoader; 48 import com.sun.star.frame.XStorable; 49 import com.sun.star.io.IOException; 50 import com.sun.star.lang.IllegalArgumentException; 51 import com.sun.star.lang.XComponent; 52 import com.sun.star.uno.UnoRuntime; 53 /** 54 * Pls place a suite file in directory "suite" which is same level with test uno. like bewlow 55 * -suite 56 * -testuno 57 * The suite file content is like this format 58 * ftp://user:password@192.168.0.1/public/sample/testsample.doc 59 * .. 60 * .. 61 * ftp://user:password@192.168.0.1/public/sample/testsample2.doc 62 *This script is used to test FFC by UNO API 63 *It cover below scenario: 64 *MS2003/2010 format->ODF format 65 *New Saved ODF Format file -> MS 2003 Format 66 *New Saved ODF Format file -> PDF 67 * 68 */ 69 @RunWith(FileProvider.class) 70 public class FFCTest { 71 @Rule 72 public Logger log = Logger.getLogger(this, false); 73 74 private static final UnoApp app = new UnoApp(); 75 private static Map<String, String> filterMap = new HashMap<String, String>(); 76 @FileRepos 77 public static String suiteDir = "../suite/"; 78 private String fileURL = ""; 79 private String operateFilePath = ""; 80 private static Map<String, String> formatMap = new HashMap<String, String>(); 81 private static File testSpaceFile = Testspace.getFile(); 82 private boolean isSucceed = false; 83 private static String tempFolder = testSpaceFile.getAbsolutePath() + File.separator + "temp"; 84 85 private static String failedFilesDir = "output/failedSampleFiles/";; 86 // @Parameters 87 // public static Collection<String[]> data() throws Exception{ 88 // initMap(); 89 // ArrayList<String[]> list = new ArrayList<String[]>(); 90 // List<String> suitePathList = new ArrayList<String>(); 91 // FileReader fileReader = null; 92 // BufferedReader reader = null; 93 // File suites = new File(suiteDir); 94 // if (suites.exists() && suites.list().length > 0) { 95 // isSuiteFileExist = true; 96 // for(File file: suites.listFiles()){ 97 // if(FileUtil.getFileExtName(file.getName()).toLowerCase().equals("suite")){ 98 // suitePathList.add(file.getAbsolutePath()); 99 // } 100 // } 101 // try{ 102 // for (String suitePath : suitePathList) { 103 // fileReader = new FileReader(suitePath); 104 // reader = new BufferedReader(fileReader); 105 // String line = null; 106 // while((line = reader.readLine()) != null){ 107 // if (!"".equals(line)) { 108 // list.add(new String[]{line}); 109 // } 110 // } 111 // if(reader != null){ 112 // reader.close(); 113 // reader = null; 114 // } 115 // if(fileReader != null){ 116 // fileReader.close(); 117 // fileReader = null; 118 // } 119 // } 120 // 121 // }catch(Exception e){ 122 // throw new Exception("throw exception when read suite file. " + e.getMessage()); 123 // }finally{ 124 // try{ 125 // if(reader != null){ 126 // reader.close(); 127 // reader = null; 128 // } 129 // if(fileReader != null){ 130 // fileReader.close(); 131 // fileReader = null; 132 // } 133 // }catch(Exception io){ 134 // } 135 // } 136 // } else {// run files from ffc data directory 137 // File ffcDataHome = new File("data\\ffc"); 138 // getFileList(ffcDataHome, list); 139 // } 140 // 141 // return list; 142 // } 143 // 144 public static void getFileList(File dir, List<String[]> list) { 145 File[] files = dir.listFiles(new FilenameFilter() { 146 @Override 147 public boolean accept(File dir, String name) { 148 File file = new File(dir.getAbsolutePath() + File.separator + name); 149 String filename = new File(name).getName().toLowerCase(); 150 boolean accept; 151 if (file.isDirectory()) { 152 accept = true; 153 } else { 154 accept = filename.endsWith(".docx") 155 || filename.endsWith(".pptx") 156 || filename.endsWith(".xlsx") 157 || filename.endsWith(".ppt") 158 || filename.endsWith(".xls") 159 || filename.endsWith(".doc") ; 160 } 161 162 return accept; 163 } 164 165 }); 166 if (files == null) 167 return; 168 169 for (File file : files) { 170 if (file.isDirectory()) { 171 getFileList(file, list); 172 } else { 173 list.add(new String[] {file.getAbsolutePath().replace(dir.getParentFile().getAbsolutePath(), "").replace("\\", "/")}); 174 175 } 176 } 177 } 178 179 public FFCTest(String url) { 180 this.fileURL = url; 181 } 182 183 @BeforeClass 184 public static void init() { 185 initMap(); 186 //Disable automation 187 OpenOffice.getDefault().setAutomationPort(-1); 188 OpenOffice.getDefault().addArgs("-invisible", "-conversionmode", "-headless", "-hidemenu"); 189 190 File failedDirec = Testspace.getFile(failedFilesDir); 191 failedDirec.mkdirs(); 192 } 193 194 @Before 195 public void setUp() throws Exception { 196 operateFilePath = Testspace.prepareData(fileURL); 197 198 app.start(); 199 } 200 @After 201 public void tearDown() throws Exception { 202 if (!isSucceed) { 203 FileUtil.copyFile(operateFilePath, Testspace.getFile(failedFilesDir).getAbsolutePath()); 204 FileUtil.appendStringToFile( Testspace.getFile(failedFilesDir + File.separator + "failedFiles.files").getAbsolutePath(), fileURL +"\r\n"); 205 app.close(); 206 SystemUtil.killProcess("WerFault.*"); 207 SystemUtil.sleep(2); 208 SystemUtil.killProcess("EQNEDT32.*"); 209 //WerFault.exe 210 //EQNEDT32.EXE 211 } 212 } 213 214 215 216 @Test(timeout=1000*60*5) 217 public void exportTest() throws Exception { 218 //MS Office Format ->ODF 219 boolean flag = false; 220 221 String saveAsODF = exportAsODF(operateFilePath); 222 System.out.println("MS ->ODF finished"); 223 //ODF->MS 224 String savedMSFilePath = exportAsODF(saveAsODF); 225 File savedMSFile = new File(savedMSFilePath); 226 Assert.assertTrue("FFC Test for file : "+ savedMSFilePath, savedMSFile.exists()); 227 System.out.println("ODF->MS Finished"); 228 229 230 //Export ODF->PDF 231 exportAsPDF(saveAsODF); 232 System.out.println("ODF->PDF Finished"); 233 flag = true; 234 Assert.assertTrue("FFC Test for file : "+ operateFilePath, flag); 235 isSucceed = true; 236 } 237 private String getSuffix(String file) { 238 String lowerCaseName = file.toLowerCase(); 239 String suffix = lowerCaseName.substring(lowerCaseName.lastIndexOf(".")); 240 return suffix; 241 } 242 /** 243 * return the Export ODF file path 244 * @throws IOException 245 * @throws IllegalArgumentException 246 */ 247 private String exportAsODF(String testFile) throws IOException, IllegalArgumentException { 248 XComponent document = loadSampleFile(testFile); 249 String suffix = getSuffix(testFile); 250 String filterName = filterMap.get(suffix); 251 PropertyValue[] lProperties = null; 252 lProperties = new PropertyValue[3]; 253 lProperties[0] = new PropertyValue(); 254 lProperties[0].Name = "FilterName"; 255 lProperties[0].Value = filterName; 256 lProperties[1] = new PropertyValue(); 257 lProperties[1].Name = "Overwrite"; 258 lProperties[1].Value = Boolean.TRUE; 259 lProperties[2] = new PropertyValue(); 260 lProperties[2].Name = "AsyncMode"; 261 lProperties[2].Value = new Boolean(false); 262 263 XStorable store = (XStorable) UnoRuntime.queryInterface(XStorable.class, document); 264 File file = new File(testFile); 265 String fileName = file.getName(); 266 String saveAsFilePath = file.getParentFile().getAbsolutePath() + File.separator + fileName + "." + formatMap.get(suffix);//TODO 267 store.storeAsURL(Testspace.getUrl(saveAsFilePath), lProperties); 268 app.closeDocument(document); 269 return saveAsFilePath; 270 } 271 272 private void exportAsPDF(String testFilePath) throws Exception { 273 XComponent xComponent = loadSampleFile(testFilePath); 274 XStorable xStorable = (XStorable) UnoRuntime.queryInterface( 275 XStorable.class, xComponent); 276 277 PropertyValue[] aMediaDescriptor = new PropertyValue[1]; 278 aMediaDescriptor[0] = new PropertyValue(); 279 aMediaDescriptor[0].Name = "FilterName"; 280 aMediaDescriptor[0].Value = "writer_pdf_Export"; 281 File file = new File(testFilePath); 282 String fileName = file.getName(); 283 String saveAsFilePath = file.getParentFile().getAbsolutePath() + File.separator + fileName + ".pdf" ; 284 // export to pdf 285 xStorable.storeToURL(Testspace.getUrl(saveAsFilePath), aMediaDescriptor); 286 287 // close this document 288 app.closeDocument(xComponent); 289 File pdfFile = new File(saveAsFilePath); 290 Assert.assertTrue("Verify sampe file " + testFilePath + " exprot to pdf!", pdfFile.exists()); 291 } 292 293 public static void initMap() { 294 filterMap.put(".doc", "writer8"); 295 filterMap.put(".docx", "writer8"); 296 filterMap.put(".odt", "MS Word 97"); 297 filterMap.put(".ppt", "impress8"); 298 filterMap.put(".pptx", "impress8"); 299 filterMap.put(".odp", "MS PowerPoint 97"); 300 filterMap.put(".xls", "calc8"); 301 filterMap.put(".xlsx", "calc8"); 302 filterMap.put(".ods", "MS Excel 97"); 303 304 formatMap.put(".doc", "odt"); 305 formatMap.put(".docx", "odt"); 306 formatMap.put(".odt", "doc"); 307 308 formatMap.put(".ppt", "odp"); 309 formatMap.put(".pptx", "odp"); 310 formatMap.put(".odp", "ppt"); 311 312 formatMap.put(".xls", "ods"); 313 formatMap.put(".xlsx", "ods"); 314 formatMap.put(".ods", "xls"); 315 } 316 private XComponent loadSampleFile(String filePath) throws IOException, IllegalArgumentException { 317 if (!"".equals(filePath)) { 318 PropertyValue[] loadProps = null; 319 if (filePath.endsWith("x")) {//ooxml sample file 320 loadProps = new PropertyValue[4]; 321 loadProps[0] = new PropertyValue(); 322 loadProps[0].Name = "Hidden"; 323 loadProps[0].Value = Boolean.TRUE; 324 loadProps[1] = new PropertyValue(); 325 loadProps[1].Name = "FilterName"; 326 String filePathLowCase = filePath.toLowerCase(); 327 if(filePathLowCase.endsWith("docx")) { 328 loadProps[1].Value = "MS Word 2007 XML"; 329 } 330 if(filePathLowCase.endsWith("pptx")){ 331 loadProps[1].Value = "MS PowerPoint 2007 XML"; 332 } 333 if(filePathLowCase.endsWith("xlsx")) { 334 loadProps[1].Value = "MS Excel 2007 XML"; 335 } 336 loadProps[2] = new PropertyValue(); 337 loadProps[2].Name = "ReadOnly"; 338 loadProps[2].Value = true; 339 loadProps[3] = new PropertyValue(); 340 loadProps[3].Name = "MacroExecutionMode"; 341 loadProps[3].Value = MacroExecMode.NEVER_EXECUTE; 342 } else { 343 loadProps = new PropertyValue[3]; 344 loadProps[0] = new PropertyValue(); 345 loadProps[0].Name = "Hidden"; 346 loadProps[0].Value = Boolean.TRUE; 347 loadProps[1] = new PropertyValue(); 348 loadProps[1].Name = "ReadOnly"; 349 loadProps[1].Value = Boolean.TRUE; 350 loadProps[2] = new PropertyValue(); 351 loadProps[2].Name = "AsyncMode"; 352 loadProps[2].Value = new Boolean(false); 353 } 354 355 String urlPath = Testspace.getUrl(filePath); 356 XComponentLoader componentLoader = (XComponentLoader) UnoRuntime.queryInterface(XComponentLoader.class, app.getDesktop()); 357 return componentLoader.loadComponentFromURL(urlPath, "_blank", 0, loadProps); 358 } 359 return null; 360 } 361 /** 362 * the url is like this format: 363 * ftp://user:password@192.168.0.1/public/sample/testsample.doc 364 * @param url 365 * @return 366 */ 367 public String downloadFile(String url) { 368 File urlFile = new File( new File(url.replaceAll("%20", " ")).getName()); 369 370 File tempFolderFile = new File(tempFolder); 371 if (!tempFolderFile.exists()) { 372 tempFolderFile.mkdir(); 373 } 374 String testFile = testSpaceFile.getAbsolutePath() + File.separator + "temp" + File.separator + urlFile.getName(); 375 FileUtil.download(url, new File(testFile)); 376 return testFile; 377 } 378 379 380 381 } 382