DbUnit Extractor

Compatible with: IntelliJ IDEA PhpStorm WebStorm PyCharm RubyMine AppCode CLion Gogland DataGrip Rider MPS Android Studio
18.11.2016
3 538
DbUnit Extractor - copy selected rows from SQL Console as DbUnit XML.

Authors
  • Pawel Salata
  • Robert Kapala
Source code and documentation Screen cast

Download plugin

Recent change notes

fixes @NotNull exception

General usage instructions

paypal
Copy query results

  1. Install plugin and set up database connection

  2. Write SQL query and execute it

  3. Select rows and columns you want to export

  4. Right click on selection

  5. Select "Copy to clipboard as DbUnit XML" from context menu

  6. Paste result in your .xml file


In-place convert

  1. Install plugin and set up database connection

  2. Open xml file for dbunit sample data (it has to starts with "<dataset>")

  3. Write query you want to convert

  4. Select query, press ALT+ENTER and choose "Convert query to XML".