Questions tagged [database]

an organized collection of data, typically organized to model relevant aspects of reality, in a way that supports processes requiring this information.

Filter by
Sorted by
Tagged with
0 votes
1 answer
295 views

How do you store test data into nosql document database for quick read?

I am currently migrating our currently test data that is stored in excel files to a database. Because the type of data in the test results are going to grow we decided to go with nosql instead of sql. ...
5 votes
7 answers
8k views

Comparing Sqlite databases

I would like to compare Sqlite databases with each other, both schema and data. I know that a rather crude method exists by comparing the database dumps with each other. But are ther any other methods ...
9 votes
6 answers
940 views

Database code unit testing tips

I'm working on developing a big 3-tier application. Database has a lot of code (stored procedures, functions, triggers, etc). I'm looking for a valid approaches how to implement unit testing for the ...
1 vote
2 answers
309 views

Best practice for testing data integrity between server and UI

I am a QA. This is the software chart: Search Engine (Apache Solr) <-> Server (expose itself to UI by an API) <-> UI. The server makes queries on the search engine and send the returned data ...
0 votes
1 answer
241 views

How to check webservice response in database using Selenium or UFT

I have an application. Different web services gets called when any action is performed. Let me explain my scenario: When I update a value in application, it also gets updated in LPS system. The LPS is ...
0 votes
0 answers
21 views

Can a constraint be added to a database if there's data in it that violates it?

I'm setting up a database migration test project for work and among the issues that we want to cover, we have an old issue where some DB constraint was added, and it was overlooked that sometimes ...
3 votes
1 answer
114 views

Should we write a Test Case for every Foreign Key?

Should I write a test case for every Foreign key in the database? Our team is conducting a large database migration project using Java APIs, for eg. inputting CustomerSales. And we have ProductId, ...
3 votes
2 answers
424 views

Designing database reliant tests for parallel execution

Looking for some best practice here: I'm looking to future proof the selenium tests that I'm building. They'll involve shared elements (products/locations/users), and it seems like a bad pattern to ...
2 votes
1 answer
23 views

What is the best way to test values that vary according to database type?

I am working on a program that needs to work on values that are fetched from different database types: currently we support 12 different database types. My code applies some business logic to the ...
1 vote
2 answers
218 views

Using TDD when developing a database schema?

I am fairly new to TDD and database development. If I wanted to use test driven development when I am trying to create a database schema how would I do that? What are the common tools and processes ...
0 votes
2 answers
180 views

How would you test this form designed for adding and editing tables in a relational database?

I am having a problem with test cases. I have never tested before the forms that add tables in relational database and I am not sure what is the good approach - should I write down test cases that ...
1 vote
2 answers
750 views

How to check the data completeness in ETL Testing

I am working on healthcare project. I need to verify the data present in staging tables, DWH tables and target tables. I am checking manually for few records but my management asking to look for a ...
8 votes
6 answers
6k views

Is selenium webdriver capable of database testing?

After reading so many answers and forums it makes me confused. Some people say: Selenium webdriver is a browser automation tool and it has nothing to do with the database. And some other showing JARs ...
5 votes
4 answers
11k views

Are there ready solutions for saving robot framework test results into a database?

I like the level of details and more or less how they look like — report.html and log.html files created as a result of selenium/robot tests run. What I don't like is if I run pybot several times (...
5 votes
1 answer
170 views

Approaches for testing huge data files in text format

My current assignment requires me to test data in a large number of text files ~ 200, usually ranging from 1GB to 20GB. The data is in the same schema with coordinates. As of now, the approach is to ...
0 votes
1 answer
722 views

JMETER: java.lang.OutOfMemoryError: Java heap space

I have configured Jmeter for database load testing, and have been using the CLI to test load on my redshift database. i have increased the memory heap but the same problem remains Below is the Error ...
0 votes
1 answer
399 views

JMETER: How do I run parallel JDBC requests in JMeter?

I have defined the JDBC Connection configuration and have added multiple JDBC requests in JMeter. Currently, when I trigger the requests, the requests are executed one after the other. I would like to ...
1 vote
1 answer
397 views

JMeter - save response to file listener but also ignore result

In JMeter, I am using a post processor running prev.setIgnore() within the setup thread group to ignore those requests. Some of these requests are JDBC requests to select data out of the database and ...
-3 votes
1 answer
93 views

Tool suggestion for Database Testing

Anyone can suggest/recommand a automation tool which will cover DB testing end2end. The tool should support sql queries execution,Test Reports generation and support the CI/CD.
0 votes
2 answers
193 views

Asserting against database during selenium test run

Just wanted to hear some thoughts about asserting against the database during a selenium test suite. For the website I am working on is a SPA with API backend where the majority of the service ...
0 votes
0 answers
61 views

Integration tests and data used in these tests

I read a lot about unit and integration tests and how they work with maven and java and how it works with Continuous Integration. I am using Flyway for db migrations, the schema part is already done. ...
9 votes
6 answers
1k views

How to do more effective database testing?

I am testing a financial web-based application having the back-end built on SQL Server. As far as DB testing is concerned, I test simply whether any value/input entered in the UI application is saved ...
5 votes
2 answers
6k views

How to test CRUD operations in Database Testing?

C: Create R: Retrieve U: Update D: Delete How can a tester verify that CRUD operations are working fine in Web App/Database testing? Please explain with real examples!
12 votes
5 answers
1k views

QA testing - Database privileges

I have a question about DB privileges for QA tester. Our company has set strict rules for DB privileges and QA tester has mostly just privileges to view/read for all tables. There is occasionally ...
17 votes
3 answers
10k views

Controlling database state in Selenium UI Testing

We have a big test suite with around 300+ tests. Nowadays we are manually restoring database and creating few Data Objects and hard coding some data to feed into the tests. However, there are a lot of ...
2 votes
1 answer
65 views

Compare SQL database after delete/update statements

We have had some issues where an update or delete operation on the database would update/delete more records then expected. This has passed multiple layers of testing and reviews. Now I am looking for ...
6 votes
2 answers
130 views

Using a different database engine for testing

This was inspired by the Speeding up Django unit tests with SQLite, keepdb and /dev/shm article that demonstrates how switching from PostgreSQL to an in memory SQLite helps to speed up testing during ...
2 votes
0 answers
358 views

aws data pipeline testing tools

Our team is building an AWS product which uses several sets of tools like Lambda, SNS topics, EC2, data pipelines etc. I would like to know what type of testing tools/strategies that can be used to ...
5 votes
0 answers
134 views

weighing tools/approaches for testing of database components

Currently, the way we do this on LedgerSMB is to have SQL scripts which insert records into a test results table. This table is created in a transaction which runs the tests, and the tests always ...
1 vote
1 answer
312 views

API tests against production DB with no endpoints to set up test data

I'm creating regression tests for one of our APIs. I'd like to discuss how to go about it in my particular situation. I have no problem on the dev environment, but when it gets deployed to a staging ...
2 votes
1 answer
292 views

How to create unit tests for Web app with a database

I'm currently adding unit testing to my project and came across this question, How can I test my database insertion. For example, let's say I have a user table, I want to test if I can create a user, ...
0 votes
2 answers
88 views

How to automate functional regression tests through database data comparisons?

I have a Java batch job application that reads input data from an Oracle database, does a lots of calculations, handles many edge cases, and outputs results back into different database tables. The ...
1 vote
1 answer
70 views

Test scenario of Database components

For one new project we have a requirement to add multiple "Database Collation" support to the system, means the system will create DB on any specified DB Collations for Unicode, ANSI supported ...
0 votes
0 answers
166 views

How can I integrate database validation (queries, updates) in Ruby, Cucumber, Watir project in RubyMine

I have setup a project in RubyMine using Ruby with Cucumber, RSPEC, and Watir for UI automation of feature files. (I also have page objects implemented). In my step_definitions where the actual UI ...
4 votes
3 answers
273 views

Can existing tests and data effectively compare old and new systems?

This idea was presented to me recently: You have a complex legacy ETL system in Java in a TEST environment that no one understands completely. You write some tests that run it and compare the output ...
2 votes
1 answer
1k views

How can I verify text exist within a table with db using Selenium WebDriver?

Using selenium Webdriver+Java- I am looking for a way to identify and or verify a value in a table. There are more columns in the table, but I am only concerned with the Country column, Also the ...
0 votes
2 answers
445 views

Comparing data from from a webservice response with data that is in the database

I am automating testing web services in robot framework RIDE and I am getting the response I am expecting and saving the response to variables. So I would like advice on how to go about comparing the ...
3 votes
2 answers
5k views

How to access database from SoapUI for test-data generation?

The web-services testing would cover more cases if it is data-driven. So it is better to generate random data (but from the same boundary) for each request. E.g. in test case 1 we check users id ...
0 votes
1 answer
57 views

Possible scenarios for a periodic task that is run daily at 11:40 PM to process a data set available globally

I'm testing an e-commerce website and there is a deviation that is occurring on a daily basis for a periodic task that runs daily at 11:40 PM. In essence, what this task does that it picks all orders ...
-2 votes
2 answers
6k views

The result set has no current row while using JDBC [closed]

I am using the following code in selenium, but I am not able to retrieve data from database. I am getting the errors "The result set has no current row" My code is public class Auto { public ...
0 votes
0 answers
19 views

The result set has no current row error (Database automation testing using selenium webdriver [duplicate]

I am using the following code in selenium, but I am not able to retrieve data from database. I am getting the error "The result set has no current row" public class Auto { public static void ...
1 vote
2 answers
38 views

Should I obtain data required for particular test case using appropriate endpoint or read it directly from the DB?

I am implementing automated tests of the system that consists of many microservices. To verify appropriate behaviour of the endpoints using POST and PUT methods, I need to obtain some data (for ...
1 vote
2 answers
322 views

Backend testing

Backend testing is basically a database testing right? Can it be something else? I was asked that question and I have a hard time finding the right answer. Anyone has any ideas? Thanks
4 votes
1 answer
150 views

What is best practise for Data Contract management?

We are implementing a testing framework, covering areas like mentioned in this SE article. But in addition, as part of unit testing (probably), we want to perform data contract testing. The database ...
0 votes
1 answer
70 views

What is the best approach/tools to test data copy from Oracle to SQL Server?

I have test data copy from Oracle database to SQL Server. Data will be copied every hour. Data in Oracle is constantly changed and in SQL Server it will be in read-only mode.
1 vote
3 answers
1k views

How to have Selenium tests which also verify the database information?

I’m now relatively well versed in using Selenium when it comes to UI testing, but there is one area which I’m not too confident on which I haven’t seen covered much in the courses I have taken, and ...
11 votes
5 answers
3k views

Is it necessary to verify databases for functional automation testing?

Currently, after every action that adds or changes data, we verify that that data was successfully added/changed in the database by querying the tables directly. I feel this is redundant because that ...
2 votes
1 answer
2k views

How can I Use JDBC Request/Debug Sampler results match with HTTP Response in JMeter?

How do I use JDBC Request/Debug Sampler results match with HTTP Response in JMeter using response assertions? Can you provide me with an example?
3 votes
1 answer
579 views

How do I put a MySQL fixture in a PHPUnit driving a Selenium2?

I have a Symfony2 web project using PHPUnit for the unit tests. Recently I added functional tests with the package phpunit/phpunit-selenium. I have added tests to do a login, then to create an item ...
2 votes
1 answer
4k views

How to load test MongoDB using JMeter?

I want to load test MongoDb using JMeter, but apparently MongoDB Source Config and MongoDB Script have been deprecated. Please let me know how to load test MongoDB with detailed step by step ...