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.
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.