aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMatthew Lemon <y@yulqen.org>2024-12-13 08:59:59 +0000
committerMatthew Lemon <y@yulqen.org>2024-12-13 08:59:59 +0000
commit129b55ca4deb9d41cff52157e882b41fb3eb5391 (patch)
tree49a3a1af205d7c55e592fe74af2813ecd4cf73b8
parent3555bc87b9117aea41faad310aea887433e633a9 (diff)
Removed reference to the contacts database
-rwxr-xr-xtjp.sh4
1 files changed, 2 insertions, 2 deletions
diff --git a/tjp.sh b/tjp.sh
index ec433b8..a3333ae 100755
--- a/tjp.sh
+++ b/tjp.sh
@@ -15,7 +15,7 @@ add_MOD_contact() {
read mod_first_name
echo "Enter last name:"
read mod_last_name
- contact_id=$(psql -h "$HOST" -U "$USER" -d "$DB_CONTACTS" -c "INSERT INTO contacts (first_name, last_name, contact_type) VALUES ('$mod_first_name', '$mod_last_name', 3) RETURNING id;")
+ contact_id=$(psql -h "$HOST" -U "$USER" -d "$DB" -c "INSERT INTO contacts (first_name, last_name, contact_type) VALUES ('$mod_first_name', '$mod_last_name', 3) RETURNING id;")
echo "MOD contact added with ID: $contact_id. Feel free to go in and add comments, email and phone number separately."
}
@@ -70,7 +70,7 @@ list_MOD_meeting_entries() {
# Function to list all MOD contacts
list_MOD_contacts() {
- psql -h "$HOST" -U "$USER" -d "$DB_CONTACTS" -c "SELECT id, first_name, last_name, email, phone, contact_comments FROM contacts WHERE contact_type = 3;"
+ psql -h "$HOST" -U "$USER" -d "$DB" -c "SELECT id, first_name, last_name, email, phone, contact_comments FROM contacts WHERE contact_type = 3;"
}
# Function to list all MOD meetings