The tag has no wiki summary.

learn more… | top users | synonyms

5
votes
5answers
740 views

What are some good approaches to separating test data from test scripts?

We're working on test code (mainly UI tests with a few different tools). One thing that's really stumping me is how to best separate test data from test scripts. By test data, I mean values that get ...
5
votes
3answers
270 views

SQL “sandbox” for new QA staff training: DB structure, approach, deployment and maintenance?

Complex DB solutions are not rare nowadays, so I have an idea to deploy a SQL "sandbox" for staff training before real projects come. Mainly I interested in 2 things to have: Oracle 11+ DB instance. ...
4
votes
4answers
232 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 ...
4
votes
1answer
55 views

Standard set of unit tests for data layer code

While designing test cases for an application's database code (the data layer), I would like to determine a good subset of tests to run in order to guarantee its proper function. In essence, the goal ...
3
votes
2answers
84 views

Is it OK to use the classes under test to initialize the database for the tests?

I am working at a small in-house dev department in a non-IT organisation. Me and another junior dev are creating a mid-sized CRUD web application in ASP MVC. There is no formal test process in our ...
3
votes
2answers
317 views

How do I test injection attacks similar to SQL injection for non sql solutions, or do I?

My team is testing some products where we have forgone SQL as the back-end. This means that we have stopped executing any security tests around SQL injection. I have this nagging suspicion that ...
3
votes
2answers
89 views

Proper pattern for setting up tests of basic database operations

Trying to write tests for basic database operation, I'd like to understand what is the standard or proper pattern for setting up the data, so that only the functionality that should be tested is ...
3
votes
1answer
74 views

Monitoring DB setup in a way convenient for DBA

Our DBA is very eager to help us with monitoring DB status. We had recently some problems with buggy deployments scripts (both manual and automated) that set up DB incorrectly or incompletely. So his ...
2
votes
3answers
1k 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 ...
2
votes
2answers
392 views

Should data validation be automated in a rapid development environment

I would like to understand Data Validation for Automation in case of (Weekly/ Frequent Builds) In case of frequent code changes (Weekly builds) since the code base would change frequently Automation ...
2
votes
3answers
1k 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 ...
1
vote
2answers
61 views

What are the leading policies on limiting bug reporting redundancy?

Currently automated reports run on recurring monitors based on user encounters. At the start the automated errors were for the most part useless because there were 400 low priority bugs, 50 major, two ...
1
vote
1answer
447 views

How to use databases within the python unittest framework?

I have a bunch of unittests written in python in which messages (text) of any kind is used. Instead of 'hardcoding' the text examples used for the tests I would like to use a database of some kind ...
1
vote
1answer
139 views

Loading test data from MySQL database

I use Ruby with Selenium to do test automation on a web application that has a MySQL DB behind it. I need a good way to load data into the DB from a Ruby script. So far in my research I have found ...
1
vote
0answers
55 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 roll ...
0
votes
3answers
72 views

Can db2 scripts be automated?

I have a scenario where it is necessary to execute some scripts daily.Is it possible to automate the execution via some tools.?
-2
votes
1answer
65 views

A tool that migrates data from database A to B has been developed [duplicate]

A tool that migrates data from database A to B has been developed. The tool will be used to migrate all production data from version 1.0 of our app (operating on A) to version 2.0, currently being ...