10
votes
Can a proportionately scaled down testing environment find performance load issues?
No. The items you mention scale very differently and there are far too many factors and resources that will get used.
For instance if I time requests on a local server using an application I'll find ...
- 24.3k
10
votes
Accepted
Can a proportionately scaled down testing environment find performance load issues?
Does this actually catch, before production, many of the "surprise"
problems we might anticipate? Or is there a more fundamental flaw in
the approach that will cause deleterious changes to pass ...
- 13.9k
7
votes
Controlling database state in Selenium UI Testing
As UI tests are slowish I think its important to be able to run them in parallel. In order to be able to run them in parallel, your data-management becomes even more complex, since if the tests use ...
7
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
Accepted
Is selenium webdriver capable of database testing?
Selenium itself is only a framework to drive web-browsers, but you can combine it with some code to check and or manipulate the database the application under test uses.
If you use Selenium with a ...
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 ...
- 24.3k
5
votes
Is selenium webdriver capable of database testing?
Selenium Webdriver is a web test automation framework and primarily used for functional testing of front-end part of the application (that piece, that the user sees in his/her browser).
Since this ...
- 497
5
votes
Controlling database state in Selenium UI Testing
This is a really interesting question. I don't think we're entirely happy with our approach, and we discuss it regularly, but these are our constraints and what we've done so far (framework has been ...
- 5,085
4
votes
Controlling database state in Selenium UI Testing
It's hard to provide input on your specific processes, but here's how I generally deal with Selenium automation. Maybe it can help you out.
One separate database which contains all the data for the ...
- 5,834
4
votes
Comparing Sqlite databases
I have always loved using Scooter Software - Beyond Compare (limited to 2 links) to visually compare between folder, files etc. Group of them or single.
This should help with an easy to use Visual ...
- 141
4
votes
How to test CRUD operations in Database Testing?
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 ...
- 4,520
4
votes
Can a proportionately scaled down testing environment find performance load issues?
Presumably the database is just a piece of your overall system, and your goal is to determine whether database changes break things or slow the system down.
Using a downsized database is a reasonable ...
- 22.8k
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.4k
3
votes
Accepted
How to do more effective database testing?
Reposting from my blog notes
Database Testing involves the following Activities for a OLTP System
Verify Table Schema, Column names as per Design Document
Verify Column Length and DataType
Verify ...
- 2,726
3
votes
Is selenium webdriver capable of database testing?
Selenium WebDriver itself cannot be used to test databases, but the language you are using to code your WebDriver tests (eg. C# or Java, etc.) can.
- 183
3
votes
Proper pattern for setting up tests of basic database operations
Based on your response to my comment, you're not actually looking to test database operations but an application that employs the operations. That makes things a little simpler.
If you have access to ...
- 30.7k
3
votes
Can a proportionately scaled down testing environment find performance load issues?
Test environment will NOT scale proportionally.
But what you can do is:
make test environment as similar to PROD as you possibly can (with possibly less servers, that's what we do: have about half ...
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 ...
- 24.3k
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,030
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 ...
- 30.7k
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
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....
- 897
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 ...
- 991
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
Standard set of unit tests for data layer code
From application perspective you need to look at below states for DB to be validated with basic cases
Clean up Scripts (Clearing Previous Run Data)
Initial Data population (From a fresh install ...
- 2,726
2
votes
Robot Framework data-driven automation testing: Can data derived from a database be used as a data source for a test template?
Since this question was cross-posted to stackoverflow, I'll cross-post my answer:
Unfortunately, the use of test templates more-or-less require that the data is hard-coded in the test case. However, ...
- 914
2
votes
Accepted
How to test database as a manual tester?
Database can be tested various ways,
If we are using SQL server then open the SQL query analyzer and write the queries to retrieve the data. Then verify whether the expected result is correct or not. ...
- 338
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
Accepted
Handle conflicts in parallel execution of jUnit testruns using the same database
No magic bullet. If you have a "multi-tenant" schema -- a schema that represents multiple, independent sets of data -- you may be able to run each concurrent test in a different data set.
It is ...
- 22.8k
Only top scored, non community-wiki answers of a minimum length are eligible