Skip to main content

Query Testing framework

Project description


codecov Build Status PyPi Version

⠀⣾⣷⣶⠇⠀⠀⣤⣄⣀⡀⠈⠻⣿⣿⣿⣿⣿⣿⣿⣿⣿⣿⡇⠀⠀⠀⠀⠀⠀  Tests have layers
⠀⠉⠈⠉⠀⠀⢦⡈⢻⣿⣿⣿⣶⣶⣶⣶⣤⣽⡹⣿⣿⣿⣿⡇⠀⠀⠀⠀⠀⠀  Ogres have layers
⠀⠀⠀⠀⠀⠀⠀⠉⠲⣽⡻⢿⣿⣿⣿⣿⣿⣿⣷⣜⣿⣿⣿⡇⠀⠀⠀⠀⠀⠀        ~ Anonymous


Query testing framework.

Currently supports only Exasol DB.

This project uses Poetry for dependency management and packaging.


To setup your virtual environment run the following command. The default location for poetry venvs is ~/Library/Caches/pypoetry/virtualenvs

poetry install

To run tests and lint checks:

make checks

To format on all files:

make fmt



Currently we only support Exasol connections. To run local instance of Exasol as docker container run:

docker run  -p 8999:8888 --detach --privileged --stop-timeout 120  exasol/docker-db:6.0.13-d1

(MacOS) Keep in mind that Exasol is memory-heavy and you need to increase docker memory limit to at least 4GB


ShreQT uses following environment variables to connect to database.

Variable Default Value
SHREQT_DSN localhost:8999


The example directory contains simple example which illustrates the example usage.

  • includes simple User schema and code which sets up the database for test session.
  • includes a tested function.
  • include example test function.

You can run the example with:

make run-example

Build && Deploy

Setup ~/.pypirc with credentials.

Run checks and build package:

make build

Deploy package to pypi using poetry:

make deploy


  • Automate deployment step with travis
  • Decorator functionality for temporary layer

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

shreqt-0.6.2.tar.gz (6.2 kB view hashes)

Uploaded source

Built Distribution

shreqt-0.6.2-py3-none-any.whl (6.8 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page