Optimize join tables from different databases #469

	name: run unit tests

	on:
	pull_request:
	branches:
	- staging

	jobs:
	test:
	runs-on: ${{ matrix.os }}
	strategy:
	matrix:
	os: [ubuntu-latest, windows-latest]
	python-version: [3.8,3.9,'3.10']
	steps:
	- uses: actions/checkout@v2
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v2
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements.txt
	pip install -r requirements_test.txt
	pip install pytest-cov
	pip install --no-cache-dir -e .[test]
	- name: Run unit tests
	run: pytest -v
	shell: bash


	coverage:
	needs: test
	runs-on: ubuntu-latest
	permissions:
	pull-requests: write
	steps:
	- uses: actions/checkout@v3
	- name: Set up Python 3.8
	uses: actions/setup-python@v2
	with:
	python-version: 3.8

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install flake8 pytest pytest-cov
	pip install -r requirements.txt
	pip install -r requirements_test.txt

	- name: Build coverage file
	run: \|
	pytest --junitxml=pytest.xml --cov-report=term-missing:skip-covered --cov=mindsdb_sql tests/ \| tee pytest-coverage.txt

	- name: Pytest coverage comment
	uses: MishaKav/pytest-coverage-comment@main
	with:
	pytest-coverage-path: ./pytest-coverage.txt
	junitxml-path: ./pytest.xml

Provide feedback