api/Makefile at main · fgacyc/api · 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
SHELL := /usr/bin/env bash
DB_MIGRATIONS_DIR="./db/migrations"
DB_SCHEMA_FILE="./db/schema.sql"
DBMATE_MIGRATIONS_TABLE="migrations.schema_migrations"

include .env
export

# Connect to the db using pgcli
pgcli:
	pgcli $(DATABASE_URL)

# Create a new migration
migrate-new:
	dbmate -d $(DB_MIGRATIONS_DIR) -s $(DB_SCHEMA_FILE) --migrations-table $(DBMATE_MIGRATIONS_TABLE) new $(NAME)

# Apply latest migration
migrate-up:
	dbmate -d $(DB_MIGRATIONS_DIR) -s $(DB_SCHEMA_FILE) --migrations-table $(DBMATE_MIGRATIONS_TABLE) up

# Rollback latest migration
migrate-down:
	dbmate -d $(DB_MIGRATIONS_DIR) -s $(DB_SCHEMA_FILE) --migrations-table $(DBMATE_MIGRATIONS_TABLE) down

# Check migration status
migrate-status:
	dbmate -d $(DB_MIGRATIONS_DIR) -s $(DB_SCHEMA_FILE) --migrations-table $(DBMATE_MIGRATIONS_TABLE) status

# Exports the current database schema
dump:
	dbmate -d $(DB_MIGRATIONS_DIR) -s $(DB_SCHEMA_FILE) --migrations-table $(DBMATE_MIGRATIONS_TABLE) dump