Feature/activity logger

backend/repository/addressRepository.js

@@ -62,6 +62,69 @@ async function addAddress(address, peopleId) {
   }
 }
 
+async function updateAddress() {
+  console.log("Update address not implemented!");
+}
+
+/*
+Function to find all address information associated with a person.
+Returns an array of address objects or an empty array if no addresses exist.
+*/
+async function getAddressesForPerson(peopleId) {
+  console.log("Finding addresses for person with ID: ", peopleId);
+
+  try {
+    const query = `
+      SELECT 
+        a.addressId, 
+        a.address1, 
+        a.address2, 
+        a.city, 
+        sl.name AS state, 
+        cl.name AS country, 
+        a.zipCode, 
+        pa.preferredAddress
+      FROM 
+        peopleXAddress pa
+      LEFT JOIN 
+        address a ON pa.addressId = a.addressId
+      LEFT JOIN 
+        stateLookup sl ON a.stateId = sl.stateId
+      LEFT JOIN 
+        countryLookup cl ON a.countryId = cl.countryId
+      WHERE 
+        pa.peopleId = ?;
+    `;
+
+    // Execute the query
+    const [results] = await pool.query(query, [peopleId]);
+
+    if (results.length === 0) {
+      console.log("No addresses found for person with ID:", peopleId);
+      return [];
+    }
+
+    // Map the results to structured address objects
+    const addresses = results.map((row) => ({
+      addressId: row.addressId,
+      address1: row.address1,
+      address2: row.address2,
+      city: row.city,
+      state: row.state,
+      country: row.country,
+      zipCode: row.zipCode,
+      preferredAddress: row.preferredAddress,
+    }));
+
+    console.log("Found addresses: ", addresses);
+
+    return addresses;
+  } catch (error) {
+    console.error("Error fetching addresses for person: ", error);
+    return [];
+  }
+}
+
 // Private helper function to look up the stateId
 async function _lookupStateId(state) {
   // for now return 1 while tables are not populated
@@ -106,4 +169,4 @@ async function _lookupCountryId(country) {
   // }
 }
 
-module.exports = { addAddress };
+module.exports = { addAddress, getAddressesForPerson };