// TODO: returns weft.NotFound when query result is empty?
func dataLatencySummaryProto(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 siteID, typeID, time, mean, fifty, ninety, lower, upper, scale
FROM data.latency_summary
JOIN data.site USING (sitePK)
JOIN data.latency_threshold USING (sitePK, typePK)
JOIN data.type USING (typePK)`)
default:
rows, err = dbR.Query(`SELECT siteID, typeID, time, mean, fifty, ninety, lower, upper, scale
FROM data.latency_summary
JOIN data.site USING (sitePK)
JOIN data.latency_threshold USING (sitePK, typePK)
JOIN data.type USING (typePK)
WHERE typeID = $1;`, typeID)
}
if err != nil {
return weft.InternalServerError(err)
}
defer rows.Close()
var t time.Time
var dlsr mtrpb.DataLatencySummaryResult
for rows.Next() {
var dls mtrpb.DataLatencySummary
if err = rows.Scan(&dls.SiteID, &dls.TypeID, &t, &dls.Mean, &dls.Fifty, &dls.Ninety,
&dls.Lower, &dls.Upper, &dls.Scale); err != nil {
return weft.InternalServerError(err)
}
dls.Seconds = t.Unix()
dlsr.Result = append(dlsr.Result, &dls)
}
rows.Close()
var by []byte
if by, err = proto.Marshal(&dlsr); err != nil {
return weft.InternalServerError(err)
}
b.Write(by)
return &weft.StatusOK
}
