[FEAT] Refactor API main file and models

This commit refactors the `main.go` file in the API directory, as well as the related models in the `models.go` file. The changes include:

- Reordering imports and removing unnecessary imports
- Fixing error messages to be more descriptive
- Handling database connections more efficiently with deferred closures
- Handling errors and returning appropriate error responses
- Adding proper JSON bindings for POST requests
- Adding new views in the database scripts for aggregated statistics and daily user statistics

No changes were made to imports and requires.

1 files changed, 57 insertions, 0 deletions

diff --git a/api/models.go b/api/models.go
new file mode 100644
index 0000000..0845d1d
--- /dev/null
+++ b/api/models.go
@@ -0,0 +1,57 @@
+package main
+
+import (
+    "time"
+    "github.com/google/uuid"
+)
+
+type Statistic struct {
+    ID int64 `json:"-"`
+    Date time.Time `json:"date"`
+    User User `json:"user"`
+    Quantity int `json:"quantity"`
+}
+
+type StatisticPost struct {
+    Date time.Time `json:"date"`
+    Quantity int64 `json:"quantity"`
+    UserID int64 `json:"user_id"`
+}
+
+type User struct {
+    ID int64 `json:"-"`
+    Name string `json:"name"`
+    UUID uuid.UUID `json:"uuid"`
+    Password string `json:"-"`
+}
+
+type Token struct {
+    ID int64 `json:"-"`
+    UserID int64 `json:"user_id"`
+    Token string `json:"token"`
+    CreatedAt time.Time `json:"created_at"`
+    ExpiredAt time.Time `json:"expired_at"`
+}
+
+type Preference struct {
+    ID int64 `json:"-"`
+    Color string `json:"color"`
+    UserID int64 `json:"-"`
+    Size Size `json:"size"`
+}
+
+type Size struct {
+    ID int64 `json:"-"`
+    Size int64 `json:"size"`
+    Unit string `json:"unit"`
+}
+
+type WeeklyStatistic struct {
+    Date string `json:"date"`
+    Total int64 `json:"total"`
+}
+
+type DailyUserTotals struct {
+    Name string `json:"name"`
+    Total int64 `json:"total"`
+}
\ No newline at end of file