Makefile

.PHONY:build

include .env

# Container management
######################
up:
	docker compose up -d

up_mysql:
	mkdir -p tmp/db
	docker compose up -d mysql

up_app: 
	docker compose up -d app

down:
	docker compose down

reup: down up

logs: 
	docker compose logs -f

build:
	docker compose build --no-cache
	make up
	make composer_install
	make db_mysql_create_database
	make app_database_migrate
	make exec_app_cmd CMD="php bin/console.php storage:link"

# Container interaction
#######################
exec_app_bash:
	docker compose exec app bash

exec_app_cmd:
	docker compose exec app bash -c "${CMD}"

exec_mysql_cli:
	docker compose exec mysql sh -c "mysql -u${DB_USER} -p${DB_PASSWORD} ${DATABASE_MYSQL_NAME}"

exec_mysql_query:
	docker compose exec mysql bash -c "mysql -uroot -p${DATABASE_MYSQL_ROOT_PASSWORD} -e \"$(QUERY)\""

# Composer
##########
composer_install:
	make exec_app_cmd CMD="composer install"

composer_update:
	make exec_app_cmd CMD="composer update"

composer_test:
	make exec_app_cmd CMD="composer test"

# Database
##########
db_mysql_create_database:
	make exec_mysql_query QUERY="CREATE DATABASE IF NOT EXISTS $(DATABASE_MYSQL_NAME)"
	make exec_mysql_query QUERY="GRANT ALL PRIVILEGES ON $(DATABASE_MYSQL_NAME).* TO $(DATABASE_MYSQL_USER)@'%'"
	make exec_mysql_query QUERY="FLUSH PRIVILEGES;"
	make app_database_migrate

db_mysql_import:
	docker cp storage/dump.sql movary-mysql-1:/tmp/dump.sql
	docker compose exec mysql bash -c 'mysql -uroot -p${DATABASE_MYSQL_ROOT_PASSWORD} movary < /tmp/dump.sql'

db_mysql_export:
	docker compose exec mysql bash -c 'mysqldump --databases --add-drop-database -uroot -p$(DATABASE_MYSQL_ROOT_PASSWORD) $(DATABASE_MYSQL_NAME) > /tmp/dump.sql'
	docker cp movary-mysql-1:/tmp/dump.sql storage/dump.sql
	chown $(USER_ID):$(USER_ID) storage/dump.sql

db_migration_create:
	make exec_app_cmd CMD="vendor/bin/phinx create Migration -c ./settings/phinx.php"

# App commands
##############
app_sync_all: app_sync_trakt app_sync_tmdb

app_database_migrate:
	make exec_app_cmd CMD="php bin/console.php database:migration:migrate "

app_database_rollback:
	make exec_app_cmd CMD="php bin/console.php database:migration:rollback"

app_user_create_test:
	make exec_app_cmd CMD="php bin/console.php user:create testUser@movary.org password123 testUser"

app_user_change_password_test:
	make exec_app_cmd CMD="php bin/console.php user:update 1 --password=password123"

app_user_import_trakt:
	make exec_app_cmd CMD="php bin/console.php trakt:import --overwrite --userId=1"

app_tmdb_sync_movie:
	make exec_app_cmd CMD="php bin/console.php tmdb:movie:sync --threshold=100"

app_tmdb_sync_person:
	make exec_app_cmd CMD="php bin/console.php tmdb:movie:sync --threshold=100"

app_imdb_sync_rating:
	make exec_app_cmd CMD="php bin/console.php imdb:sync --threshold=1"

app_jobs_process:
	make exec_app_cmd CMD="php bin/console.php jobs:process"

# Shortcuts
php: exec_app_bash
test: composer_test