datasetWriter.write(dbunitConnection.createDataSet());
IDatabaseConnection connection = new DatabaseConnection(conn, schema); configConnection((DatabaseConnection) connection); // dependent tables database export: export table X and all tables that have a // PK which is a FK on X, in the right order for insertion String[] depTableNames = TablesDependencyHelper.getAllDependentTables(connection, "company"); IDataSet depDataset = connection.createDataSet(depTableNames); FlatXmlWriter datasetWriter = new FlatXmlWriter(new FileOutputStream("target/dependents.xml")); datasetWriter.write(depDataset);
/** * Write the specified dataset to the specified writer as xml. */ public static void write(IDataSet dataSet, Writer writer, String encoding) throws DataSetException { if (logger.isDebugEnabled()) { logger.debug("write(dataSet={}, writer={}, encoding={}) - start", new Object[] { dataSet, writer, encoding }); } FlatXmlWriter datasetWriter = new FlatXmlWriter(writer, encoding); datasetWriter.setIncludeEmptyTable(true); datasetWriter.write(dataSet); } }
/** * Write the specified dataset to the specified output stream as xml. */ public static void write(IDataSet dataSet, OutputStream out) throws IOException, DataSetException { logger.debug("write(dataSet={}, out={}) - start", dataSet, out); FlatXmlWriter datasetWriter = new FlatXmlWriter(out); datasetWriter.setIncludeEmptyTable(true); datasetWriter.write(dataSet); }
public static void main(String[] args) throws Exception { //Connect to the database Class.forName( "com.mysql.jdbc.Driver" ); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/easyrec_test", "root", "root"); IDatabaseConnection connection = new DatabaseConnection( conn ); QueryDataSet partialDataSet = new QueryDataSet(connection); //Specify the SQL to run to retrieve the data partialDataSet.addTable("actionarchive1", " SELECT * FROM actionarchive1"); //Specify the location of the flat file(XML) // file is stored in /target folder FlatXmlWriter datasetWriter = new FlatXmlWriter(new FileOutputStream("easyrec-testutils/target/temp.xml")); //Export the data datasetWriter.write( partialDataSet ); }