Advertisement
Guest User

Untitled

a guest
Jan 24th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.24 KB | None | 0 0
  1. public class TestDataService extends DBTestCase {
  2.  
  3. @Override
  4. protected IDataSet getDataSet() throws Exception {
  5. return new FlatXmlDataSetBuilder().build(new File("C:\Users\Игарек\IdeaProjects\proff1_examples_boot\src\test\resorces\TestDataSet.xml"));
  6.  
  7. }
  8. public TestDataService(String testName) throws Exception {
  9. super(testName);
  10.  
  11. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_DRIVER_CLASS,
  12. "com.mysql.cj.jdbc.Driver");
  13. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_CONNECTION_URL,
  14. "jdbc:mysql://localhost:3306/spring_boot?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC");
  15. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_USERNAME,
  16. "root");
  17. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_PASSWORD,
  18. "root");
  19. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_SCHEMA,
  20. "data");
  21. }
  22. public void test() throws Exception {
  23.  
  24. DataService dataService = new DataService();
  25. Data data = new Data();
  26. data.setIdObject((long) 1);
  27. data.setDateModified("2018-09-19T13:12:21.136263+03:00");
  28. data.setDatePublished("2018-09-19T13:12:21.136232+03:00");
  29. data.setDocumentOf("tender");
  30. data.setDocumentType("subContract");
  31. data.setFormat("text/plain");
  32. data.setHash("md5:232dba893a22ac722249ad92f8bccf22");
  33. data.setId("4f6d6dc59d1844bb80143ccc2e727a2f");
  34. data.setTitle("11.09.2018.xlsx");
  35. data.setUrl("https://public-docs-sandbox.prozorro.gov.ua/get/3500487074064bd98f1076c21fe69e9a?KeyID=1331dc52&Signature=w%252BTQLJCiU%2FDQXfp%2FxB0VfDNRzImPv7zch3e8H1jfVOZrDJZuam%2FOTVLlvpdUiz9WVLHdUzdMrQJclbl4Vs28CQ%253D%253D");
  36. dataService.save(data);
  37. IDataSet databaseDataSet = getConnection().createDataSet();
  38. ITable actualTable = databaseDataSet.getTable("data");
  39.  
  40. IDataSet expectedDataSet = new FlatXmlDataSet(getClass().getResourceAsStream("/dataSalaryTestDataSet_Expected.xml"));
  41.  
  42. ITable expectedTable = expectedDataSet.getTable("data");
  43. ITable filteredActualTable = DefaultColumnFilter.includedColumnsTable(actualTable, expectedTable.getTableMetaData().getColumns());
  44.  
  45. Assertion.assertEquals(expectedTable, filteredActualTable);
  46.  
  47.  
  48. } }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement