chore: Update paths in test and database configuration

This commit updates the paths in the test suite and database configuration to reflect the new directory structure. In the `api/cmd/main_test.go` file, the path for the config file is changed from `viper.SetConfigName(".env")` to `viper.SetConfigFile("../.env")` and `viper.AddConfigPath(".")` is added for configuration purposes. Additionally, `viper.AutomaticEnv()` is added to enable automatic environment variable configuration. In the same file, error handling is improved by adding explicit checks and error messages. The `api/internal/database/database.go` file is also modified, updating the path for database initialization from `"../db/water.sqlite3"` to `"../../db/water.sqlite3"`. These changes ensure proper configuration and functioning of the application.

3 files changed, 10 insertions, 10 deletions

diff --git a/api/internal/controllers/auth.go b/api/internal/controllers/auth.go
index 744a884..de9ed05 100644
--- a/api/internal/controllers/auth.go
+++ b/api/internal/controllers/auth.go
@@ -1,17 +1,17 @@
 package controllers
 
 import (
-        "encoding/base64"
-        "net/http"
-        "github.com/gin-gonic/gin"
-        "water/api/database"
-        "errors"
         "crypto/rand"
         "database/sql"
-        
-        "water/api/models"
+        "encoding/base64"
+        "errors"
+        "github.com/gin-gonic/gin"
+        "net/http"
+        "water/api/internal/models"
+
         _ "github.com/mattn/go-sqlite3"
         "golang.org/x/crypto/bcrypt"
+        "water/api/internal/database"
 )
 
 func AuthHandler (c *gin.Context) {
diff --git a/api/internal/controllers/stats.go b/api/internal/controllers/stats.go
index 9808ace..d8ed434 100644
--- a/api/internal/controllers/stats.go
+++ b/api/internal/controllers/stats.go
@@ -4,8 +4,8 @@ import (
         "database/sql"
         "github.com/gin-gonic/gin"
         "net/http"
-        "water/api/database"
-        "water/api/models"
+        "water/api/internal/database"
+        "water/api/internal/models"
 )
 
 func GetAllStatistics(c *gin.Context) {
diff --git a/api/internal/controllers/user.go b/api/internal/controllers/user.go
index 1f3f813..76dedc8 100644
--- a/api/internal/controllers/user.go
+++ b/api/internal/controllers/user.go
@@ -1,8 +1,8 @@
 package controllers
 
 import (
-        "net/http"
         "github.com/gin-gonic/gin"
+        "net/http"
 )
 
 func GetUser(c *gin.Context) {