DbUnit Extractor点击查看中文文档

Export database data to XML DbUnit dataset.

Download

Jetbrains DbUnit Extractor plugin page

Usage

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".

Copy selected rows from SQL Console as DbUnit XML. Change SQL query to XML in-place.

Inspired by @rakk web tool for generating DbUnit XML lines.

Known issues

• Schema name is empty when using "Copy to clipboard as DbUnit XML".

Please synchronize your database. Intellij doesn't return metadata if datasource isn't synchronized.

• "Only one table queries are supported" error when using jTds.

This driver doesn't return metadata by default (issue: https://sourceforge.net/p/jtds/bugs/546/). Please add useCursors=true parameter to your database connection url.

Example: jdbc:jtds:sqlserver://localhost/db;instance=TEST;useCursors=true

• "Only one table queries are supported" error when using Microsoft driver.

Please add selectMethod=cursor parameter to your database connection url.

Example: jdbc:sqlserver://localhost/db;instance=TEST;selectMethod=cursor

License

This project is licensed under the MIT License.