// TODO: returns weft.NotFound when query result is empty?
func fieldLatestProto(r *http.Request, h http.Header, b *bytes.Buffer) *weft.Result {
typeID := r.URL.Query().Get("typeID")
var err error
var rows *sql.Rows
switch typeID {
case "":
rows, err = dbR.Query(`select deviceID, modelID, typeid, time, value, lower, upper, scale
FROM field.metric_summary
JOIN field.device using (devicePK)
JOIN field.model using (modelPK)
JOIN field.threshold using (devicePK, typePK)
JOIN field.type using (typePK)`)
default:
rows, err = dbR.Query(`select deviceID, modelID, typeid, time, value, lower, upper, scale
FROM field.metric_summary
JOIN field.device using (devicePK)
JOIN field.model using (modelPK)
JOIN field.threshold using (devicePK, typePK)
JOIN field.type using (typePK)
WHERE typeID = $1;`, typeID)
}
if err != nil {
return weft.InternalServerError(err)
}
defer rows.Close()
var t time.Time
var fmlr mtrpb.FieldMetricSummaryResult
for rows.Next() {
var fmr mtrpb.FieldMetricSummary
if err = rows.Scan(&fmr.DeviceID, &fmr.ModelID, &fmr.TypeID, &t, &fmr.Value,
&fmr.Lower, &fmr.Upper, &fmr.Scale); err != nil {
return weft.InternalServerError(err)
}
fmr.Seconds = t.Unix()
fmlr.Result = append(fmlr.Result, &fmr)
}
rows.Close()
var by []byte
if by, err = proto.Marshal(&fmlr); err != nil {
return weft.InternalServerError(err)
}
b.Write(by)
return &weft.StatusOK
}
