I won’t tell you how to create a test plan, select/build test strategy and so on. A lot of articles describing this. Below I will give strict details based on our experience and share tips what we collect during database testing.

Image for post
Image for post

Our test team had following starting points:
- back end build using Oracle schemas;
- incomplete or outdated data mapping documentation.

Schemas structure:

  1. Schema A: 11 tables with columns range from 15 till 700+. It collects data from external source system as 1-to-1 relation.
  2. Schema B: 12 tables having approximately the same columns range but data in some columns received from schema A being aggregated, filtered and converted based on some simple rules.

Over a recent time I got stuck trying to connect Robot Framework and Oracle Db over a Python to use for Db test automation. “Googling” this question also did not provide me strict steps. So after having processed information from various sources and obtained the desired result I decided to share my experience.

Preconditions: Python 2.7, Robot Framework 1.2.0, cx_Oracle library, Oracle Db odbc driver and Windows 10.

  1. Python.
    Python can be downloaded from www.python.org. After installation is completed, by default, python can be found in “C:\Python27” folder. Remember it, it will be needed later.
    Next step will be adding python path to variables. To do that you need to:
    - open the Start Search, type in “variables”, and choose “Edit the system environment variables”;
    - in opened window click the “Environment Variables” button;
    - in the “System Variables” section, find the row with “Path” in the first column, and click edit button.
    - on next view, click “New” button and type path to python: “C:\Python27”, click Enter, then click “New” button one more time and add: “C:\Python27\Scripts”, click OK button to save changes. …

About

Sergey Domnenko

Test lead with various experience in testing. Trying myself in sharing aggregated practical knowledge with wide audience.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store