blob: da52e749f812e112ddf36a606b45189725e0aafb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
package controllers
import (
"database/sql"
"net/http"
"water/api/internal/database"
"water/api/internal/models"
"github.com/gin-gonic/gin"
)
func GetSizes(c *gin.Context) {
db, err := database.EstablishDBConnection()
if err != nil {
c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
return
}
defer func(db *sql.DB) {
err := db.Close()
if err != nil {
c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
}
}(db)
rows, err := db.Query("SELECT id, size, unit FROM Sizes")
if err != nil {
c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
return
}
defer func(rows *sql.Rows) {
err := rows.Close()
if err != nil {
c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
return
}
}(rows)
var data []models.Size
for rows.Next() {
var size models.Size
if err := rows.Scan(&size.ID, &size.Size, &size.Unit); err != nil {
c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
return
}
data = append(data, size)
}
c.JSON(http.StatusOK, data)
}
|
