Examples of org.dbunit.database.QueryDataSet

org.dbunit.database.QueryDataSet
Holds collection of tables resulting from database query. @author Eric Pugh @author gommma @author Last changed by: $Author: gommma $ @version $Revision: 912 $ $Date: 2008-12-06 17:01:42 +0100 (sab, 06 dic 2008) $ @since Dec 4, 2002

     */
    private void checkQuery(String table, String query,
                            IDatabaseConnection expectedConnection,
                            IDatabaseConnection actualConnection)
            throws Exception {
        QueryDataSet expectedDataSet = new QueryDataSet(expectedConnection);
        expectedDataSet.addTable(table, query);


        QueryDataSet actualDataSet = new QueryDataSet(actualConnection);
        actualDataSet.addTable(table, query);


        // new FlatXmlWriter(System.out).write(expectedDataSet);
        // new FlatXmlWriter(System.out).write(actualDataSet);


        // make sure there is actually data to compare against

View Full Code Here

      conn = new DatabaseConnection(ds.getConnection());
       
      if(filteredTableToExport.size() >0)
      {      
        String targetDbName = DatabaseConnectionFactory.getDatabaseName();        
        QueryDataSet partialDataSet = new QueryDataSet(conn);  
        
        // build the data-set. NOTE: the new inserted value will be inserted in the model only when the editable cell lose the focuc 
        for(int i=0;i<filteredTableToExport.size();i++){          
             //System.out.println(filteredTableToExport.get(i).isIncludeTable());
             //System.out.println("ADD: "+filteredTableToExport.get(i).getTableName()+","+filteredTableToExport.get(i).getExportQuery());
             partialDataSet.addTable(filteredTableToExport.get(i).getTableName(),filteredTableToExport.get(i).getExportQuery());
          }    
                
        FlatXmlDataSet.write(partialDataSet, new FileOutputStream(outputFolder+File.separator+targetDbName+".xml"));   
        
      }else

View Full Code Here

    public void assertEqualsTable(final String tableName, final String orderColumnName) {
      this.dbDataUtil.execute(new DbUnitWork() {
        @Override
        public void execute(IDatabaseConnection conn) {
          try {
            QueryDataSet tableDataSet = new QueryDataSet(conn);
            tableDataSet.addTable(tableName, String.format("select * from %s order by %s", tableName, orderColumnName));
            
            Assertion.assertEquals(flatXmlDataSet, tableDataSet);
          } catch (Exception ex) {
            throw new JuDbException("Couldn't assert DB data", ex);
          }

View Full Code Here

    public void assertEqualsTable(final String tableName, final String orderColumnName) {
      this.dbDataUtil.execute(new DbUnitWork() {
        @Override
        public void execute(IDatabaseConnection conn) {
          try {
            QueryDataSet tableDataSet = new QueryDataSet(conn);
            tableDataSet.addTable(tableName, String.format("select * from %s order by %s", tableName, orderColumnName));
            
            Assertion.assertEquals(flatXmlDataSet, tableDataSet);
          } catch (Exception ex) {
            throw new JuDbException("Couldn't assert DB data", ex);
          }

View Full Code Here

    public void assertEqualsTable(final String tableName, final String orderColumnName) {
      this.dbDataUtil.execute(new DbUnitWork() {
        @Override
        public void execute(IDatabaseConnection conn) {
          try {
            QueryDataSet tableDataSet = new QueryDataSet(conn);
            tableDataSet.addTable(tableName, String.format("select * from %s order by %s", tableName, orderColumnName));
            
            Assertion.assertEquals(flatXmlDataSet, tableDataSet);
          } catch (Exception ex) {
            throw new JuDbException("Couldn't assert DB data", ex);
          }

View Full Code Here

      IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);
      DatabaseConfig config = connection.getConfig();
      config.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new MySqlDataTypeFactory());
      System.out.print("mysql connection set...");


      dataSet = new QueryDataSet(connection);
      for (String table : tables) {
        dataSet.addTable(table);
      }
      System.out.print("dataset ready.\n");
    }

View Full Code Here

   * @throws FileNotFoundException
   * @throws SQLException
   * @throws IOException
   */
  public void exportFromDBToFile(String tableName,String sqlQuery,File flatXMLFile) throws DataSetException, FileNotFoundException, SQLException, IOException {
    QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection());
    partialDataSet.addTable(tableName,sqlQuery);
    FlatXmlDataSet.write(partialDataSet, new FileOutputStream(flatXMLFile));
  }

View Full Code Here

   * @throws DataSetException
   * @throws FileNotFoundException
   * @throws IOException
   */  
  public void exportFromDBToFile(String[] tableNames,File flatXMLFile) throws SQLException, DataSetException, FileNotFoundException, IOException {
    QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection());
    for(int i = 0; i < tableNames.length; i++ ) {
      partialDataSet.addTable(tableNames[i]);
    }
    FlatXmlDataSet.write(partialDataSet, new FileOutputStream(flatXMLFile));
  }

View Full Code Here

 * @return 
 */
public static IDataSet getDataSetFromDataBase(IDatabaseConnection databaseConnection,String querySqlsSplitBySemicolon){
  //分割多个sql语句
  String[] querySqls = querySqlsSplitBySemicolon.split(";");
  QueryDataSet queryDataSet=null;
  try {
    queryDataSet = new QueryDataSet(databaseConnection);
    //处理多个语句情况
    for (int i = 0; i < querySqls.length; i++) {
      queryDataSet.addTable(getTableNameFromQuerySql(querySqls[i]), querySqls[i]);
    }
  } catch (Exception e) {
    log.error("查询数据失败!");
    log.error(e.getMessage());
  }

View Full Code Here

        if(refid != null) {
            QuerySet referenced = (QuerySet)getProject().getReference(refid);
            copyQueriesFrom(referenced);
        }
        
        QueryDataSet partialDataSet = new QueryDataSet(connection);
        
        Iterator queriesIter = getQueries().iterator();
        while(queriesIter.hasNext()) {
            Query query = (Query)queriesIter.next();
            partialDataSet.addTable(query.getName(), query.getSql());
        }
        
        return partialDataSet;
        
    }

View Full Code Here

0 1

TOP

Related Classes of org.dbunit.database.QueryDataSet

ch.inftec.ju.testing.db.DbDataUtil$AssertBuilder

ch.inftec.ju.testing.db.ExportItems

cn.baiweigang.qtaf.toolkit.dbunit.DbUnitUtil

cn.org.rapid_framework.test.dbunit.DBUnitFlatXmlHelper

com.common.test.DBUnitFlatXmlHelper

mydatagenerator.core.database.operations.DatabaseExporter

org.dbunit.ant.AbstractStep

org.dbunit.ant.QuerySet

org.exolab.jms.tools.migration.ExportImportTest

org.zanata.DBUnitDataExtractor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.