Skip to content
This repository has been archived by the owner on Feb 25, 2022. It is now read-only.

Latest commit

 

History

History
72 lines (51 loc) · 2.65 KB

README.md

File metadata and controls

72 lines (51 loc) · 2.65 KB
Raw

Testing dbt-mysql

Overview

Here are the steps to run the integration tests:

  1. Set environment variables
  2. Run Docker containers (optional)
  3. Run tests

Simple example

Assuming the applicable pytest-dbt-adapter package is installed and environment variables are set:

pytest test/mysql.dbtspec

Full example

Prerequisites

Environment variables

Create the following environment variables (e.g., export {VARIABLE}={value} in a bash shell or via a tool like direnv): * DBT_MYSQL_SERVER_NAME * DBT_MYSQL_USERNAME * DBT_MYSQL_PASSWORD

Docker

Here is one guide on "How to Run MySQL in a Docker Container on macOS with Persistent Local Data".

In the docker commands below, the default MySQL username is root and the default server name is localhost. If they are used unaltered, then you should set the following environment variable values:

DBT_MYSQL_SERVER_NAME=localhost
DBT_MYSQL_USERNAME=root

If you use any bash special characters in your password (like $), then you will need to escape them (like DBT_MYSQL_PASSWORD=pas\$word instead of DBT_MYSQL_PASSWORD=pas$word).

MySQL 8.0

docker run --name mysql8.0 --net dev-network -v /Users/YOUR_USERNAME/Develop/mysql_data/8.0:/var/lib/mysql -p 3306:3306 -d -e MYSQL_ROOT_PASSWORD=$DBT_MYSQL_PASSWORD mysql:8.0

MySQL 5.6

Contents of /Users/YOUR_USERNAME/Develop/mysql_data/5.6/my.cnf:

[mysqld]
explicit_defaults_for_timestamp = true

docker run --name mysql5.6 --net dev-network -v /Users/YOUR_USERNAME/Develop/mysql_data/5.6:/var/lib/mysql -v /Users/YOUR_USERNAME/Develop/mysql_data/5.6/my.cnf:/etc/my.cnf -p 3308:3306 -d -e MYSQL_ROOT_PASSWORD=$DBT_MYSQL_PASSWORD mysql:5.6

MySQL 5.7

Contents of /Users/YOUR_USERNAME/Develop/mysql_data/5.7/my.cnf:

[mysqld]
explicit_defaults_for_timestamp = true
sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

docker run --name mysql5.7 --net dev-network -v /Users/YOUR_USERNAME/Develop/mysql_data/5.7:/var/lib/mysql -v /Users/YOUR_USERNAME/Develop/mysql_data/5.7/my.cnf:/etc/my.cnf -p 3307:3306 -d -e MYSQL_ROOT_PASSWORD=$DBT_MYSQL_PASSWORD mysql:5.7

Run tests

Run the test specs in this repository:

pytest -v test/integration/mysql-5.6.dbtspec && \
pytest -v test/integration/mysql-5.7.dbtspec && \
pytest -v test/integration/mysql-8.0.dbtspec