Makefile

.DEFAULT_GOAL := help
ESC := $(shell printf '\033')
BOLD := $(ESC)[1m
INFO := $(ESC)[0;34m
NC := $(ESC)[0m

define banner
	@echo "$(BOLD)$(1)--------------------------------------------"
	@echo "$(2)"
	@echo "--------------------------------------------$(NC)"
endef

.PHONY: help
help: ## Show this help
	$(call banner,$(INFO),Available targets:)
	@grep -E '^[a-zA-Z_-]+:.*?## .*$$' $(MAKEFILE_LIST) | sort | awk 'BEGIN {FS = ":.*?## "}; {printf "\033[36m%-30s\033[0m %s\n", $$1, $$2}'

.PHONY: orders
orders: ## Remove shipping_number column from orders table
	$(call banner,$(INFO),Removing shipping_number column from orders table...)
	python3 sql_column_remover.py entries.sql orders_without_shipping_number.sql ps_orders shipping_number

.PHONY: product_attribute
product_attribute: ## Remove location and quantity column from product_attribute table
	$(call banner,$(INFO),Removing shipping_number column from orders table...)
	python3 sql_column_remover.py entries.sql output.sql ps_product_attribute location,quantity