8
votes
Accepted
QA testing - Database privileges
It depends on how your process is set up. It makes sense to have read-only access to the Production environment for investigation.
Does QA have own copy of the system for integration testing (...
6
votes
Can existing tests and data effectively compare old and new systems?
Yes this is a useful strategy in converting from one system to another as a one time event (it might span a couple of iterations but the idea is very short term).
You could effectively view this as ...
- 25.2k
5
votes
What to do if a QA tester mistakenly deleted a table from the QA Database?
If you read enough tech Twitter or other tech blogs, you'll come across the sentiment:
"You're not a true software developer until you delete production!"
Yes, QA testers are developers. ...
- 2,250
4
votes
Accepted
Should I obtain data required for particular test case using appropriate endpoint or read it directly from the DB?
This depends on what type of testing you implement:
If it is a component testing (or if your goal is to test the particular end-point) you should isolate your component from the possible impact of ...
- 11.6k
4
votes
What to do if a QA tester mistakenly deleted a table from the QA Database?
It shouldn't be a big deal.
Consider another event. You deploy a build to your QA test environment and it has a defect which leads to rows being deleted or even a table being dropped. Should this be a ...
- 1,581
3
votes
Accepted
Using a different database engine for testing
I'm a little out of date using sqllite but data types and stored procedures come to mind as feature gaps between sqllite and something like PostgreSQL. Beyond features, configuration settings (ex: ...
- 1,189
3
votes
What all do we need to test in the application is undergoing a Mongo upgrade?
With any kind of framework or database upgrade like this, after I'd covered system sanity and critical path regression, I would go through the release notes looking for any changes likely to impact my ...
- 31.5k
3
votes
Accepted
Functional Difference between NUnit and MSTest in VS
Check out the answer to this question over at StackOverflow.
(From the accepted answer) NUnit has few advantages over MS-Test
Suite attribute - can aggregate tests and execute them separately (...
- 4,090
3
votes
How to perform databse testing in selenium webdriver
Selenium is used for automating user-browser interaction with the HTML and Javascript on websites.
It does not have any functionality to test databases other than indirectly through web applications ...
- 25.2k
3
votes
Accepted
How to create unit tests for Web app with a database
Database shared between tests is a common obstacle.
One way ("orthodox") is to insist that unit test should NOT test database (just exercise the tested library), and mock the DB interface.
Another ...
3
votes
Accepted
Backend testing
Back-end and back-end testing per se is a complex mechanism. Basically anything that communicates with the server or database is back-end. Another definition can be anything under the hood is back-end....
- 917
3
votes
Can existing tests and data effectively compare old and new systems?
Comparing the old system to the new system given identical inputs and expecting identical outputs is a legitimate test. There are problems, however:
a) When the legacy system is retired, the Source ...
- 1,011
2
votes
Is it necessary to verify databases for functional automation testing?
I believe it is a very good idea read back from the database. The reason is that things sometimes (or often) are not quite as simple as they may look.
In the example above: what happens if the phone ...
- 191
2
votes
Should data validation be automated in a rapid development environment
(Full Disclosure.... I work for Pragmatic Works)
Pragmatic Works' LegiTest allows for automated Data Validation to quickly verify your data is accurate, error-free, and up-to-date between any two ...
- 21
2
votes
Data Validation Testing using selenium
This application fetches huge amount of data from database and displays it on the platform after some simple calculations.
Please define huge
Please define simple
The developers will be able to ...
- 9,942
2
votes
Accepted
Cannot load JDBC driver class 'com.mysql.jdbc.Driver' in Jmeter
Most probably you forgot to add MySQL JDBC driver to JMeter (JMeter doesn't include it by default)
Download MySQL Connector/J
Extract mysql-connector-java-x.x.xx-bin.jar and drop it somewhere to ...
- 13.5k
2
votes
Efficient way to test data quality of database through java?
You might want to take look at the DataTable of cucumber-jvm since you've been using it anyway. The idea is to use one of its diff methods to compare the expected to the actual state of the database.
...
- 256
2
votes
Accepted
Compare MySQL and Cassandra?
It's not a difficult problem, as long as you have an OLEDB or ADO.net connector to both your database and Cassandra, then you can write queries on both your source (mySQL) and your target (Cassandra ...
- 320
2
votes
Accepted
How can I Use JDBC Request/Debug Sampler results match with HTTP Response in JMeter?
General recommendation: there are Variable names and Result variable name fields under JDBC Request sampler:
Using them you can get "interesting" parts of the JDBC response (or whole response) stored ...
- 13.5k
2
votes
Automating database testing
I don't think you should be testing each and every record in the database, I would rather suggest considering the following testing types:
Positive testing: use criteria which definitely return ...
- 13.5k
2
votes
Backend testing
Almost all web application will have two components
Front end layer (GUI),
Backend layer that would contain business logic layer (API), and database layer
Backend testing means testing what we ...
- 793
2
votes
API tests against production DB with no endpoints to set up test data
Reading your question it seems you have a messed up DevOps pipeline. The fix should not be for the testing strategy but the DevOps implementation itself. Few things that needs to be restructured are:
...
- 11.1k
2
votes
Accepted
JMeter - save response to file listener but also ignore result
According to JMeter Test Elements execution order listeners are being executed after post processors and your prev.setIgnore() instruction prevents passing the sample result to the listeners.
One of ...
- 13.5k
2
votes
Should we write a Test Case for every Foreign Key?
I would not use test cases for a database conversion project.
The task at-hand is database validation to see if foreign key constrinsta have been enforced. This can be developed reagrdles of the ...
- 25.2k
2
votes
What to do if a QA tester mistakenly deleted a table from the QA Database?
If they were not supposed to be able to delete a table, then your QA tester has done their job. That's a pretty major bug and potential security hole; report it, and give your QA tester a gold star.
...
- 189
1
vote
Comparing data from from a webservice response with data that is in the database
Do you have direct access to the DB, the DB is is not changing too often, and you know the mapping between the DB status and the response you got ? If so just query it directly
Other options might be ...
- 7,089
1
vote
Using a different database engine for testing
Using a different database engine makes sense only if you use just a bland simple SQL, avoiding any performance-enhancing tricks your chosen database provides.
IMHO that would be sub-optimal: you ...
1
vote
aws data pipeline testing tools
Let me revive this topic so others can contribute and I'll share few cents of my recent experience.
Firstly I think the important bit is to TEST the application under test - could be an API, a process ...
- 11
1
vote
Approaches for testing huge data files in text format
If you are using HDD: 10000 mb * 200 / 40 mb/s = 50000 seconds to read all files from single hdd which is around 15 hours. If you are using SSD, it is around 5 hours. You can speed up by using ...
- 221
1
vote
How to load test MongoDB using JMeter?
Just add the next line to user.properties file (lives in the "bin" folder of your JMeter installation)
not_in_menu=
This way you will get "deprecated" elements including MongoDB Source Config and ...
- 13.5k
Only top scored, non community-wiki answers of a minimum length are eligible