can we do database testing in manual testing? then how we
write the test case?
Answer Posted / lakshmanaraj bg
Yes of course,
Many beginner and intermediate database testing examples in any programming language suggest that it is perfectly easy to test your application's logic with simple tests. For database-centric applications this is far away from the reality. Start using Wordpress, TYPO3 or Symfony with Doctrine or Propel, for example, and you will easily experience considerable problems with PHPUnit: just because the database is so tightly coupled to these libraries.
You probably know this scenario from your daily work and projects, where you want to put your fresh or experienced PHPUnit skills to work and get stuck by one of the following problems:
The method you want to test executes a rather large JOIN operation and uses the data to calculate some important results.
Your business logic performs a mix of SELECT, INSERT, UPDATE and DELETE statements.
You need to setup test data in (possibly much) more than two tables to get reasonable initial data for the methods you want to test.
The DbUnit extension considerably simplifies the setup of a database for testing purposes and allows to verify the contents of a database after performing a series of operations.
Sample test case for database testing:
The test case for the above requirement is mentioned below:
Test_Case_Id:1
Test_Case_Name:Check the unique identity of Student.
Description:Test case to check the unique identity of Student.
Prerequisite:
1.Database should be present 2.Student records should be present in student table.
Input Data:1.Open your database(SQl,oracle or any which you are using)
2.Open its command prompt editor.
3.Select the proper database
4.Enter the query as:"Select * from Student_Details"
5.Run the query.
Expected Result: The all unique student records will be displayed.
Validation:Student is should be unique.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How to do manual testing of a E-insurance project (end to end process)
date format and we should 8 digits - not accepted only /accepted write how many in test cases in the date format valid , and in valid
Hi, This is vkram.I had completed my B.E in May 2005 & currently i am undergoing Testing Course. I want to join as a Fresher in any MNC. What should I tell why u r coming to testing field & what u did this 2 years?
what is test strategy,test plan and test policy?Does anyone have dummy documents or any links that gives more idea about these?I am a beginner...interested in learning more abt testing.plz help and encourage me........!
what are metrics and what are metrics did u collect in you are project
hi this is chik here iam showing my current project ERP and am prepair in hr model please tell me details about it and what all function test in hr model and give me some test caserelated to this module.Please tell me am faceing lots of problem in interview am not able to explain in interview please help me out my id is chiku_69@yahoo.in
What is Application Performance testing and Operational performance testing
Can anybody give whole test cases for banking module.it should include from start to end .that will help me more.to do study.it should contain account,deposite,withdraw,fd,atm modules.?please try to give me??
Why do you need to parameterize fields in your virtual user script?
What is localization testing (l10n testing)?
Zenq interview questions for manual testing
Hi to all, im vaibhav i joined a MNC as a tester and i got a banking (HSBC) project can any one tell me as a fresher what kind of strategy i sholud use to perform better. thanx
Could anyone share FAQs for Test Manager position...
What is the test case?
is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?