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.

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…

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…

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