Advertisement
Guest User

Untitled

a guest
Mar 10th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.33 KB | None | 0 0
  1. public class UserTest extends DBTestCase {
  2. private IDatabaseTester databaseTester;
  3.  
  4. public UserTest(String testName) throws Exception {
  5. super(testName);
  6.  
  7. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_DRIVER_CLASS,
  8. "com.mysql.jdbc.Driver");
  9. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_CONNECTION_URL,
  10. "jdbc:mysql://localhost:3632");
  11. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_USERNAME,
  12. "root");
  13. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_PASSWORD,
  14. "root");
  15. System.setProperty(PropertiesBasedJdbcDatabaseTester.DBUNIT_SCHEMA,
  16. "sqllab");
  17. }
  18.  
  19. @Override
  20. protected void setUp() throws Exception
  21. {
  22. databaseTester = new JdbcDatabaseTester("com.mysql.jdbc.Driver",
  23. "jdbc:mysql://localhost:3632/sqllab", "root", "root");
  24.  
  25. databaseTester.setDataSet(getDataSet());
  26. databaseTester.onSetup();
  27. }
  28.  
  29.  
  30. @Override
  31. protected IDataSet getDataSet() throws Exception {
  32. // InputStream is = getClass().getResourceAsStream("/user.xml");
  33. FileInputStream is = new FileInputStream("src/test/resources/user.xml");
  34. return new FlatXmlDataSetBuilder().build(is);
  35.  
  36. }
  37.  
  38. public void test() throws Exception {
  39.  
  40. // UserService userService = new UserService();
  41. // userService.delete();
  42.  
  43. IDataSet databaseDataSet = getConnection().createDataSet();
  44. ITable actualTable = databaseDataSet.getTable("user");
  45.  
  46. System.out.println(actualTable);
  47.  
  48. IDataSet expectedDataSet = new FlatXmlDataSet(getClass().getResourceAsStream("/user.xml"));
  49.  
  50. ITable expectedTable = expectedDataSet.getTable("user");
  51. ITable filteredActualTable = DefaultColumnFilter.includedColumnsTable(actualTable, expectedTable.getTableMetaData().getColumns());
  52.  
  53. Assertion.assertEquals(expectedTable, filteredActualTable);
  54. }
  55.  
  56. }
  57.  
  58. return new FlatXmlDataSetBuilder().build(is);
  59.  
  60. java.lang.NullPointerException
  61. at org.dbunit.dataset.xml.FlatXmlProducer.isNewTable(FlatXmlProducer.java:255)
  62. at org.dbunit.dataset.xml.FlatXmlProducer.startElement(FlatXmlProducer.java:429)
  63. at java.xml/com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:509)
  64. at java.xml/com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:746)
  65. at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1395)
  66. at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1252)
  67. at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3058)
  68. at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:821)
  69. at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
  70. at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:532)
  71. at java.xml/com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:888)
  72. at java.xml/com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:824)
  73. at java.xml/com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
  74. at java.xml/com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
  75. at java.xml/com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:635)
  76. at org.dbunit.dataset.xml.FlatXmlProducer.produce(FlatXmlProducer.java:365)
  77. at org.dbunit.dataset.CachedDataSet.<init>(CachedDataSet.java:80)
  78. at org.dbunit.dataset.xml.FlatXmlDataSet.<init>(FlatXmlDataSet.java:110)
  79. at org.dbunit.dataset.xml.FlatXmlDataSetBuilder.buildInternal(FlatXmlDataSetBuilder.java:264)
  80. at org.dbunit.dataset.xml.FlatXmlDataSetBuilder.build(FlatXmlDataSetBuilder.java:147)
  81. at com.company.ppp.UserTest.getDataSet(UserTest.java:48)
  82. at com.company.ppp.UserTest.setUp(UserTest.java:39)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement