I want to create test cases for MSSQL Server 2000 Stored procedures on the fly . As far as i know i can create one test case at a time using TUI or GUI tool . Can anyone suggest or have an idea how to do this. - Krishna
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Are you asking if there is currently a tool that will use reflection on MSSQL Server 2000 to generate one or more test stubs within SQLUnit? I don't think such an animal exists, but if I'm wrong I hope someone corrects me on my answer.
I use SQLUnit to test my stored procedures in MS SQL Server 2000, but I don't use the TUI or GUI tool any longer. (I did at first.) Once I understood the syntax of the DTD, I just used XMLSpy (or your favorite text editor) to crank out the tests.
Hope this helps.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes i am more or less looking for a such a tool. I know it doesn't exist as of now but even it means creating "Some sort of skeleton Xml Test cases" . Instead of creating them all from scratch helps i think.
The docs suggest that the "TUI tool" is such a console based tool for manufacturing test cases by running the stored procedure against the database. The tool will generate the XML for the test case" and goes on to say the tool eliminates the drudgery of having to write the XML test cases by hand, speeding up the test building process enormously. The inputs can be either partially or fully driven by the contents of a Java properties file, thereby making it partially or completely non-interactive if desired."
I wonder if anyone has ever attempted to automate test case generation this way .
Please share your thoughts ..Krishna
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am not sure of what level of automation you are looking for, but the TUI/GUI tools allow you to run a stored procedure against the database with different input parameters (to test positive, negative or various edge cases), and return the result, which you can then cut and paste into your XML test file.
However, you will still have to think up the input parameters to exercise the procedure in various ways.
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I want to create test cases for MSSQL Server 2000 Stored procedures on the fly . As far as i know i can create one test case at a time using TUI or GUI tool . Can anyone suggest or have an idea how to do this. - Krishna
Are you asking if there is currently a tool that will use reflection on MSSQL Server 2000 to generate one or more test stubs within SQLUnit? I don't think such an animal exists, but if I'm wrong I hope someone corrects me on my answer.
I use SQLUnit to test my stored procedures in MS SQL Server 2000, but I don't use the TUI or GUI tool any longer. (I did at first.) Once I understood the syntax of the DTD, I just used XMLSpy (or your favorite text editor) to crank out the tests.
Hope this helps.
Yes i am more or less looking for a such a tool. I know it doesn't exist as of now but even it means creating "Some sort of skeleton Xml Test cases" . Instead of creating them all from scratch helps i think.
The docs suggest that the "TUI tool" is such a console based tool for manufacturing test cases by running the stored procedure against the database. The tool will generate the XML for the test case" and goes on to say the tool eliminates the drudgery of having to write the XML test cases by hand, speeding up the test building process enormously. The inputs can be either partially or fully driven by the contents of a Java properties file, thereby making it partially or completely non-interactive if desired."
I wonder if anyone has ever attempted to automate test case generation this way .
Please share your thoughts ..Krishna
Hi Krishna,
I am not sure of what level of automation you are looking for, but the TUI/GUI tools allow you to run a stored procedure against the database with different input parameters (to test positive, negative or various edge cases), and return the result, which you can then cut and paste into your XML test file.
However, you will still have to think up the input parameters to exercise the procedure in various ways.
-sujit