can we do database testing in manual testing? then how we
write the test case?
- 2 Answers
- 6394 Views
- I also Faced
- E-Mail Answers
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
What is coverage and what are the different types of coverage techniques?
What are the different levels of manual testing?
tell me 3 defects in FRS document, while doing FRS review which u have found in the last 3 years ? could u plz answer brahma412@yahoo.co.in
discuss black box and white box testing is not widely used if you disagree tell me why?
What about the test case if the field only takes a certain number of characters or a minimum number?
how agile testing is performed and what are the related documents.
If project wants to release in 3months what type of risk analysis you do in test plan?
What is the negative testing and example
hi this is satish can some one help me out by sending the maxium notes on client sesrver ,web server and company architechture project hirearchy and company hirearchy i will happy to recive the answers as early as possible
what are the prerequisite conditins to test clientserver and web applications
Hi, what do you mean by internal auditing? what are the things they do in internal auditing?what they review? THNX in Advance
What do you do (with the project staff) when the schedule fails?
What is the Jar file?
What was a problem you had in your previous assignment (testing if possible)? How did you resolve it?
What is Test Design?
