How to Access Databases from Squish Test Scripts

Squish test scripts can access databases where the underlying scripting language provides a suitable library. In the case of JavaScript, which has no such library, Squish provides one—see SQL.

Python-specific

The binary releases of Squish include a stripped down build of Python which may be missing some libraries, and is not integrated with your OS package manager. You can use pip to install the missing packages, but if the Squish-built Python is not sufficient for your needs, you can choose a different install of Python used by Squish, and use pip or your package manager with that.

Incidentally, PyPI (Python Package Index) provides many different database bindings packages, and pip can be used to install them, so you are not limited to standard libraries when using Python.

For examples, see Accessing Databases via External Tools on our Knowledge Base.

How to Log Test Results Directly into a Database

We recommend using Test Center to log test results for further analysis. See Automated Batch Testing for an example.