summaryrefslogtreecommitdiff
path: root/bin/psql
blob: 932f65dcd5b9a6277eb3fc660d82efd127671ed8 (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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
#!/bin/sh
### CRIMSON --- A simple PHP framework.
### Copyright © 2024 Freya Murphy <contact@freyacat.org>
###
### This file is part of CRIMSON.
###
### CRIMSON is free software; you can redistribute it and/or modify it
### under the terms of the GNU General Public License as published by
### the Free Software Foundation; either version 3 of the License, or (at
### your option) any later version.
###
### CRIMSON is distributed in the hope that it will be useful, but
### WITHOUT ANY WARRANTY; without even the implied warranty of
### MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
### GNU General Public License for more details.
###
### You should have received a copy of the GNU General Public License
### along with CRIMSON. If not, see <http://www.gnu.org/licenses/>.

# `psql`
# This is an alias for running
# $ `compose` exec postgres psql -U $POSTGRES_USER $POSTGRES_DB.
#
# When working on a crimson project, you will likely have to lurk within the
# database at times. This makes it nicer enter it since you dont have to type
# the full command. :)

# Make sure errors fail to avoid nasal demons
set -e

# ========================================================= LOAD ENVIRONMENT ==
# We need to load the environment variables provided by crimson and the user
# making the project.
SCRIPT_DIR="$(dirname "$0")"
source "$SCRIPT_DIR/setup_env"

# ================================================================ BOOTSTRAP ==
# Load `base.env` and `.env`, then launch psql in docker.

$SCRIPT_DIR/compose exec postgres psql -U "${POSTGRES_USER}" "${POSTGRES_DB}" "$@"