如何从 Web 界面向用户提供 DBUnit DatabaseOperation 方法的功能？
我目前正在更新一个基于 java 的 Web 应用程序，它允许数据库开发人员为数据库测试创建存储过程回归测试套件。
目前，对于测试设置、执行和清理阶段，为用户提供了文本框，他们可以在其中输入由 isql 命令执行的 SQL 代码。
我想扩展应用程序以使用 DB Unit 的 DatabaseOperation 方法来提供更多方法来设置数据库状态，而不仅仅是 SQL 语句。使用 Db Unit 而不仅仅是 SQL 语句的主要原因是能够在服务器上创建和存储 xml 和 xls 数据集，在服务器上它们可以与测试用例关联并用于数据设置。
我的问题是：
如何从 Web 界面向用户提供 DBUnit DatabaseOperation 方法的功能？
我考虑过：
创建一种简单的编程语言和解析器读取一些涉及 DB 单元方法名称的简单语法，该方法名称接受作为 xml 或 xls 数据集的文件位置的参数。我正在考虑允许用户使用 Web 应用程序注册他们需要的文件，该应用程序会对它们进行编目，并为每个文件提供一个标识符，该标识符可以作为参数传递给这种简单编程语言中的方法。
创建 XML DTD，使用户能够指定操作和参数。如果我采用这种方法，如何执行从 XML 文档解析的方法及其参数？
- 一个表，用于存储方法以及与编目数据集文件的 FK 关系，但是我认为这不是一个好的解决方案，因为数据输入会很繁琐。
感谢您的帮助。
I am currently updating a java-based web application which allows database developers to create stored procedure regression test suites for database testing.
Currently, for test setup, execution and clean-up stages, the user is provided with text boxes where they are able to enter SQL code which is executed by the isql command.
I would like to extend the application to use DB Unit’s DatabaseOperation methods to provide more ways to setup the state of the database than just SQL statements. The main reason for using Db Unit rather than just SQL statements is to be able to create and store xml and xls DataSets on a server where they can be associated with their test cases and used for data setup.
My question is:
How can I provide users with the functionality of the DBUnit DatabaseOperation methods from a web interface?
I have considered:
Creating a simple programming language and a parser to read some simple syntax involving the DB Unit method names which accept a parameter being the file location to an xml or xls DataSet. I was thinking of allowing the user to register the files they need with the web app which would catalogue them and provide each file with an identifier which could passed as a parameter to the methods in this simple programming language.
Creating an XML DTD which provides the user with the ability to specify operations and parameters. If I went this approach, how can I execute the methods and their parameters that I parse from the XML document?
Creating a table in the database which stores the method and a FK relation to a catalogued DataSet file, however I don’t think this would be good solution due to the fact that data entry would be tedious.
Thanks for your help.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当我再次思考时，这实际上似乎是一个相当简单的问题。
DBUnit 有用于 Maven 和 Ant 集成的插件，可以在 Maven POM 文件中运行以 XML 编写的测试。
我将采用类似的方法，继续使用 Xerces-J 解析器的 XML 选项，并创建按顺序运行的操作、导出和比较对象的集合。
This actually seems like rather simple problem when I think about it again.
DBUnit has plugins for Maven and Ant integration which run tests written in XML in the Maven POM file.
I'm going to take a similar approach and go ahead with the XML option using the Xerces-J parser and create a collection of Operation, Export and Compare objects which are run in order.