aboutsummaryrefslogtreecommitdiffstats
path: root/tjp.sh
diff options
context:
space:
mode:
Diffstat (limited to 'tjp.sh')
-rwxr-xr-xtjp.sh6
1 files changed, 5 insertions, 1 deletions
diff --git a/tjp.sh b/tjp.sh
index 88b0595..8b6eaa7 100755
--- a/tjp.sh
+++ b/tjp.sh
@@ -39,10 +39,14 @@ list_personal_entries() {
}
# Function to select all MOD entries
+# list_MOD_entries() {
+# psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT * FROM journal_entries WHERE type = 1;"
+# }
list_MOD_entries() {
- psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT * FROM journal_entries WHERE type = 1;"
+ psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT id, date_added, entry, comment, meeting_id FROM journal_entries WHERE type = 1;"
}
+
# 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;"