How can a tester verify that CRUD operations are working fine in Web App/Database testing? Please explain with real examples!
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It only takes a minute to sign up.Sign up to join this community
CRUD stands for Create, Read, Update and Delete. (Retrieve may occasionally be substituted for Read.)
Different users may have different CRUD cycles based upon the requirements of the system. A customer, for instance, might have the ability to create an account, retrieve it upon return to a website, update billing information, or delete it if necessary. An operations manager, by contrast, might create product records, (Read) call them up as needed, (Update) modify packaging or raw materials details or delete it if the product was discontinued.
You should test such operations from both Front-end (User Interface) and Backend (Database queries) e.g. you have a web application where you as an Admin create users and maintain their data. So,
For the next level, you can create your own Stored Procedures (SP) for verifying these CRUD operations, once you know about the queries and tables being used, you can create these SP where on firing the Delete SP, it will itself verify the main and referenced tables and provide you with the results.
For the DB testing, you need to read about the queries, syntax and keywords required for creating and executing queries. Syntax of different DB differs from each other in one or more respect, so you should first read about the DB on which you want to perform the DB testing.
CRUD operations are the root of Database testing qa services and we need to understand the meaning of the same with a common example.
Create – INSERT an entry into Database.
Read or Retrieve – SELECT the entry from the Database and then View it.
Update – UPDATE the entry completely or partially into Database.
Delete or Destroy – DROP/DELETE the entry into Database.
First we try to understand it more with a day to day example:
Facebook, the most famous social networking website.
We can create a new account
We can View the account details
We can Edit account details
We can Delete the account
We can create comments
We can View them
We can Edit them
We can Delete them
So we are using CRUD in day to day life.