Changes between Version 1 and Version 2 of DatabaseProgramming

Timestamp:

05/26/26 11:15:32 (6 hours ago)

Author:

231550

Comment:

--

DatabaseProgramming

@@ -1 @@
-== Procedures/Functions/Triggers ==
+== !Procedures/Functions/Triggers ==
 
 -- 1. FUNCTION: Calculate total calories for a user on a specific date
@@ -323 +323 @@
 END;
 $$ LANGUAGE plpgsql;
+
+1. !get_user_daily_calories (Function)
+
+* This function calculates a user's total caloric intake for a specific date by joining logged food portions with their respective nutritional content. It handles edge cases by converting empty log results into a baseline value of zero using COALESCE. Its main purpose is to serve as a reusable calculator for the application's dashboard. It isolates the mathematical conversion formula ($(\text{Calories} \times \text{Quantity}) / 100$) entirely within the database layer.