Databases 2015-03-12T14:00:58+00:00

Backend testing generally deals with all the testable items which are generally hidden from the user for viewership. These include but are not limited to RDBMS (MySQL, MS SSQL Server, and Oracle), and NoSQL style datastores (Memcache, MongoDB, and CouchDB). The ATF can be connected to any “Backend” that has an API that allows access. Backend testing can be integrated into the ATF as either a separate test phase or by pulling verification data from the backend while inside a Selenium functional test. The ATF uses simple JDBC connections inside the architecture to connect to the SQL database and allow SQL scripts to be run.

Backend testing involves validating the following:
— Structural database testing
— Schema testing
— Database table, column testing
— Stored procedures testing
— Trigger testing
— Database server validations
— Checking data integrity and consistency
— Login and user security
— Validating data duplication

This sort of testing should have been started in the unit testing phase, so that by the time you are in the functional testing phase you should only be verifying that your automated deployment has succeeded.