db-tools/dbtools.mk at master · g4code/db-tools · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
# g4/db-tools related targets
# include this into project's makefile with
#    include vendor/g4/db-tools/dbtools.mk

# if PHP_VERSION is defined per project then use it, otherwise use default 'php'

ifdef PHP_VERSION
PHP_BIN = $(PHP_VERSION)
else
PHP_BIN = php
endif

db: db-clean db-migrate

db-clean: environment db-drop db-create db-import

db-create: environment
	@/bin/echo -e "${TITLE} create database..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/tools.php create:database env=$(env) ini=${APPLICATION_INI} ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} database created"

db-drop:
	@/bin/echo -e "${TITLE} drop database..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/tools.php drop:database env=$(env) ini=${APPLICATION_INI}  ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} database dropped"

db-import:
	@/bin/echo -e "${TITLE} import data from source..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/tools.php import:data env=$(env) sql-dump=${ND_API_SQL_DUMP} ini=${APPLICATION_INI} ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} data imported"

db-migrate: environment
	@/bin/echo -e "${TITLE} migrating database..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/ruckus.php db:migrate env=$(env) ini=${APPLICATION_INI} ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} database migrated"

db-migrate-version: environment
	@/bin/echo -e "${TITLE} migrating database..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/ruckus.php db:migrate VERSION=$(VERSION) env=$(env) ini=${APPLICATION_INI}  ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} database migrated"

db-migrate-down: environment
	@/bin/echo -e "${TITLE} migrating database..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/ruckus.php db:migrate VERSION=-1 env=$(env) ini=${APPLICATION_INI}  ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} database migrated"

db-re-migrate: environment
	@/bin/echo -e "${TITLE} rollback all migrations..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/ruckus.php db:migrate VERSION=-1000000000 env=$(env) ini=${APPLICATION_INI}  ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} rollback done" \
	&& cd - \
	&& $(MAKE) db-migrate

db-migration-new: environment
	@/bin/echo -e "${TITLE} create new migration script...${APPLICATION_INI}" \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/ruckus.php nd:generateplatformspecific $(name) env=$(env) ini=${APPLICATION_INI}  ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} new migration script created"

db-migration-status: environment
	@/bin/echo -e "${TITLE} checking status of database migrations..." \
	&& $(PHP_BIN) vendor/g4/db-tools/bin/ruckus.php db:status $(name) env=$(env) ini=${APPLICATION_INI} ruckusing_dir=${RUCKUSING_DIR} \
	&& /bin/echo -e "${TITLE} status end."


help-db:
	@  /bin/echo -e "${TITLE} Database related commands ..." \
	&& /bin/echo -e "Database import commands:" \
	&& /bin/echo -e "db                     Create and populate database." \
	&& /bin/echo -e "db-drop                Drop database." \
	&& /bin/echo -e "db-create              Only create database." \
	&& /bin/echo -e "db-clean               Reinitialize database." \
	&& /bin/echo -e "db-import              Import initial database from \"${CURDIR}/$(ND_API_SQL_DUMP)\".\n" \
	&& /bin/echo -e "Misc commands:" \
	&& /bin/echo -e "environment  attribute-migrate \n" \
	&& /bin/echo -e "Migration commands:" \
	&& /bin/echo -e "db-migration-new       Create new migration. Execute migration with db-migrate" \
	&& /bin/echo -e "db-migration-status    Check migration status." \
	&& /bin/echo -e "db-migrate             Migrate all pending migrations." \
	&& /bin/echo -e "db-migrate-down        Migrate one migration DOWN." \
	&& /bin/echo -e "db-migrate-version     Migrate to specific version. Add parametar VERSION=<version number>" \
	&& /bin/echo -e "db-remigrate           Execute all migrations again."