From 129b55ca4deb9d41cff52157e882b41fb3eb5391 Mon Sep 17 00:00:00 2001 From: Matthew Lemon Date: Fri, 13 Dec 2024 08:59:59 +0000 Subject: Removed reference to the contacts database --- tjp.sh | 4 ++-- 1 file 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 -- cgit v1.2.3