When i use the debugger the metricId returns the Metric Object with all 0 or null values (same as the output).

what am i doing wrong here?

The Database connection works.

func GetMetricById(c *gin.Context) {
    metricId := c.Param("id")

    conn := config.DatabaseConnect()

    var obj models.Metric

    rows := conn.QueryRow("SELECT * FROM Metric WHERE id = ?", metricId)

    err := rows.Scan(&obj.Id, &obj.Sms, &obj.Absence, &obj.Pregnant, &obj.Uwv_notifications, &obj.Wia_dossiers_started, &obj.Employees, &obj.Data_id, &obj.Date, &obj.Type)

    if err != nil {
        fmt.Println(err.Error())
    }

    fmt.Println(obj, "Metric Object that is called.")

    c.JSON(http.StatusOK, obj)
}

OUTPUT:

{
    "Id": 0,
    "Sms": 0,
    "Absence": 0,
    "Pregnant": 0,
    "Uwv_notifications": 0,
    "Wia_dossiers_started": 0,
    "Employees": 0,
    "Data_id": 0,
    "Date": "",
    "Type": 0
}

CodePudding user response：

I think the solution may be to use metricId := c.Params.ByName("id") instead of metricId := c.Param("id")

CodePudding user response：

[ANSWER]

func GetMetricsByDataId(c *gin.Context) {
    queryParams := c.Request.URL.Query()
    
    conn := config.DatabaseConnect()
    var metrObject []models.Metric

    rows, _ := conn.Query("SELECT * FROM Metric WHERE data_id = ?", queryParams.Get("data_id"))

    defer rows.Next()

    for rows.Next() {
        var obj models.Metric
        if err := rows.Scan(&obj.Id, &obj.Sms, &obj.Absence, &obj.Pregnant, &obj.Uwv_notifications, &obj.Wia_dossiers_started, &obj.Employees, &obj.Data_id, &obj.Date, &obj.Type); err != nil {
            _ = fmt.Errorf(err.Error())
        }
        metrObject = append(metrObject, obj)
    }
    if err := rows.Err(); err != nil {
        _ = fmt.Errorf(err.Error())
    }

    c.JSON(http.StatusOK, metrObject)
}

Like this it works

localhost:8082/billing/getmetricbydataid?data_id=150295

With this API call