sqlcompyre 1.0.0

Tool for comparing and inspecting data in SQL databases.

SQLCompyre

SQLCompyre is a simple Python package that allows you to find and explore the differences between SQL tables, schemas, and entire databases.

Installation

SQLCompyre can be installed via pip or conda:

pip install sqlcompyre
# or
micromamba install sqlcompyre
# or
conda install sqlcompyre

Details on its usage can be found in the documentation.

Development

This project is managed by pixi. You can install the package in development mode using:

git clone https://github.com/quantco/sqlcompyre
cd sqlcompyre

pixi run pre-commit-install
pixi run postinstall

Running Tests Locally

1. Make sure you have msodbcsql18 installed, or install it here

2. Make sure you have Docker installed, or install it here

3. Create a local test database with the following command:

docker compose up

4. Set environment variable

export DB_CONNECTION_STRING="mssql+pyodbc://sa:Passw0rd@localhost:1435/master?driver=ODBC+Driver+18+for+SQL+Server&Encrypt=no"

5. Navigate to the main directory of this repository and run pytest.

pixi run test