func dataCompletenessSummaryProto(r *http.Request, h http.Header, b *bytes.Buffer) *weft.Result { typeID := r.URL.Query().Get("typeID") var err error var rows *sql.Rows var expected int switch typeID { case "": rows, err = dbR.Query(`SELECT siteID, typeID, count, expected FROM data.completeness_summary JOIN data.site USING (sitePK) JOIN data.completeness_type USING (typePK)`) default: var typePK int if err = dbR.QueryRow(`SELECT typePK FROM data.completeness_type WHERE typeID = $1`, typeID).Scan(&typePK); err != nil { if err == sql.ErrNoRows { return &weft.NotFound } return weft.InternalServerError(err) } rows, err = dbR.Query(`SELECT siteID, typeID, count, expected FROM data.completeness_summary JOIN data.site USING (sitePK) JOIN data.completeness_type USING (typePK) WHERE typeID = $1;`, typeID) } if err != nil { return weft.InternalServerError(err) } defer rows.Close() var t time.Time var dcr mtrpb.DataCompletenessSummaryResult for rows.Next() { var count int var siteID string if err = rows.Scan(&siteID, &typeID, &count, &expected); err != nil { return weft.InternalServerError(err) } c := float32(count) / (float32(expected) / 288) dc := mtrpb.DataCompletenessSummary{TypeID: typeID, SiteID: siteID, Completeness: c, Seconds: t.Unix()} dcr.Result = append(dcr.Result, &dc) } var by []byte if by, err = proto.Marshal(&dcr); err != nil { return weft.InternalServerError(err) } b.Write(by) return &weft.StatusOK }