blob: 431ba78cda37f1d277b3b6b03b5525c493f3620d (
plain)
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
|
#!/usr/bin/env bash
set -euo pipefail
cd $(dirname "$0")/..
DB_PATH="database.db"
if [ "$1" == "init" ]; then
if [ -f "$DB_PATH" ]; then
rm "$DB_PATH"
fi
for MIGRATION in $(ls sql/migrations); do
printf "\n- Applying sql/migrations/$MIGRATION\n\n"
sqlite3 database.db < "sql/migrations/$MIGRATION"
done
printf "\n- Applying sql/fixtures.sql\n\n"
sqlite3 database.db < sql/fixtures.sql
else
echo "Usage: $0 init"
exit 1
fi
|
