.PHONY: install install-dev install-devc install-devc-release install-pre-commit bench bench-parse bench-transpile bench-optimize test test-fast unit testc unitc leakcheck style check docs docs-serve hidec showc clean resolve-integration-conflicts update-fixtures

ifdef UV

PIP := uv pip

else

PIP := pip

endif

SO_BACKUP := /tmp/sqlglot_so_backup

FIND_SO := find sqlglot -name "*.so"

NPROC := $(shell python -c "import os; print(os.cpu_count() or 1)")

hidec:

rm -rf $(SO_BACKUP) && $(FIND_SO) | tar cf $(SO_BACKUP) -T - 2>/dev/null && $(FIND_SO) -delete; true

showc:

tar xf $(SO_BACKUP) 2>/dev/null; rm -f $(SO_BACKUP); true

clean:

rm -rf build sqlglotc/build sqlglotc/dist sqlglotc/*.egg-info sqlglotc/sqlglot

$(FIND_SO) -delete 2>/dev/null; true

install:

$(PIP) install -e .

install-dev:

$(PIP) install -e ".[dev]"

git submodule update --init 2>/dev/null || true

@if ! command -v gh >/dev/null 2>&1; then \

echo ""; \

echo "gh (GitHub CLI) is not installed. It is needed to auto-create PRs for integration tests."; \

printf "Install it via brew? [y/N] "; \

read answer; \

if [ "$$answer" = "y" ] || [ "$$answer" = "Y" ]; then \

brew install gh; \

else \

echo "Skipping. You can install it later: https://cli.github.com/"; \

fi; \

fi

install-devc:

cd sqlglotc && MYPYC_OPT=0 python setup.py build_ext --inplace -j $(NPROC)

install-devc-release: clean

cd sqlglotc && python setup.py build_ext --inplace -j $(NPROC)

install-pre-commit:

pre-commit install

pre-commit install --hook-type post-checkout

pre-commit install --hook-type pre-push

pre-commit install --hook-type post-merge

@printf '#!/bin/bash\n.github/scripts/integration_tests_sync.sh post-commit\n' > .git/hooks/post-commit

@chmod +x .git/hooks/post-commit

bench: bench-parse bench-transpile bench-optimize

bench-parse:

python -m benchmarks.parse

bench-transpile:

python -m benchmarks.parse --mode transpile

bench-optimize:

python -m benchmarks.optimize

test: hidec

trap '$(MAKE) showc' EXIT; python -m unittest

test-fast:

python -m unittest --failfast

unit: hidec

trap '$(MAKE) showc' EXIT; SKIP_INTEGRATION=1 python -m unittest

testc: install-devc

python -m unittest

unitc: install-devc

SKIP_INTEGRATION=1 python -m unittest

leakcheck: install-devc

python -m tests.leakcheck

style:

pre-commit run --all-files

@if [ -f sqlglot-integration-tests/Makefile ]; then $(MAKE) -C sqlglot-integration-tests check-submodule; fi

check: style test testc

docs:

python pdoc/cli.py -o docs

docs-serve:

python pdoc/cli.py --port 8002

resolve-integration-conflicts:

cd sqlglot-integration-tests && git pull --rebase --autostash

update-fixtures:

python sqlglot-integration-tests/scripts/update_dbt_fixtures.py