如何使用SQL查询将数据库的子集提取到dbunit文件中? [英] How to extract a subset of a database into a dbunit file using a sql query?

问题描述

我有一个很大的Oracle桌子.我想测试一些DAO方法.为此，我使用dbunit.

I have got a big Oracle table. I would like to test some DAO methods. To do so, I use dbunit.

我想使用sql查询将现有数据库的子集提取为dbunit flat xml文件.查询示例:

I would like to extract a subset of an existing database as a dbunit flat xml file using a sql query. Example of query :

Select 
      t1.field1 as field1, t1.field2 as field2, t2.field3 as field3
From 
       table1 t1
       Join table2 t2 on t1.fieldX=t2.fieldX
Where 
       t1.field6='value' and t2.field8='value2'

在这种情况下，它将提取作为查询结果的table1和table2的所有记录，然后还提取这些记录的所有依赖项.

in this case it will extract all records of table1 and table2 which are results of the query and then it also extract all dependencies of these records.

1. 狱卒

我已经测试了Jailer，它是一个很好的工具.问题是我只能对一个表进行查询并提取保持关系的查询.我的sql查询具有多个联接，并且使用此软件无法解决其中的条件.

I've tested Jailer which is a good tool. The problem is that I can only do a query on one table and extract it keeping relations. My sql query have several joins and where conditions that cannot be resolve using this software.

1. DBUnit生成

我也尝试过直接使用DBUnit来生成数据集，但是它需要大量工作，因为我们不能直接从sql查询中生成子集，而只能通过在每个表上指定一系列小的查询来生成. 我有很多人加入，并且在哪里有条件，所以这不是可接受的解决方案.

I've also tried to use DBUnit directly to generate the dataset but it need a lot of work because we cannot generate a subset from a sql query directly but only by specifiyng a succession of little queries on each table. I've got lot of joins and where conditions so it's not an acceptable solutions.

如何使用 sql查询作为导出的基础来生成数据库的子集(并将其导出到dbunit flat xml文件中)?

How to generate a subset of a database (and export it in a dbunit flat xml file) using a sql query as a base for the export ?

推荐答案

我认为您想要的东西可能超出了DBUnit的权限.

I think what you want might be outside of the purview of DBUnit.

我认为最好的方法是设置一系列处理联接的视图，并通过该视图提取数据.拥有视图后，就可以使用SQL查询将数据拉出.

What I think the best way to do this is to set-up a series of views which handle the joins and pull your data out through that. Once you have your views you can use SQL queries to pull the data out.

这篇关于如何使用SQL查询将数据库的子集提取到dbunit文件中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！