aboutsummaryrefslogtreecommitdiffstats
path: root/dashboard/app/entities_spanner.go
blob: cf21e43eb241ac56be81be95e23ee3880aed8e65 (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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
// Copyright 2024 syzkaller project authors. All rights reserved.
// Use of this source code is governed by Apache 2 LICENSE that can be found in the LICENSE file.

package main

import (
	"context"
	"fmt"

	"cloud.google.com/go/civil"
	"cloud.google.com/go/spanner"
	"github.com/google/syzkaller/pkg/coveragedb"
	"github.com/google/syzkaller/pkg/coveragedb/spannerclient"
	"google.golang.org/api/iterator"
)

// This file contains definitions of entities stored in spanner.

type CoverageHistory struct {
	instrumented map[string]int64
	covered      map[string]int64
	periods      map[coveragedb.TimePeriod]struct{}
}

// MergedCoverage uses dates, not time.
func MergedCoverage(ctx context.Context, client spannerclient.SpannerClient, ns, periodType string,
) (*CoverageHistory, error) {
	minDays, maxDays, err := coveragedb.MinMaxDays(periodType)
	if err != nil {
		return nil, fmt.Errorf("coveragedb.MinMaxDays: %w", err)
	}
	pOps, err := coveragedb.PeriodOps(periodType)
	if err != nil {
		return nil, fmt.Errorf("coveragedb.PeriodOps: %w", err)
	}
	stmt := spanner.Statement{
		SQL: `
select
  dateto as targetdate,
  duration as days,
  cast(sum(instrumented) as INTEGER) as instrumented,
  cast(sum(covered) as INTEGER) as covered
from merge_history join files
  on merge_history.session = files.session
where namespace=$1 and duration>=$2 and duration<=$3 and manager='*'
group by dateto, duration`,
		Params: map[string]any{
			"p1": ns,
			"p2": minDays,
			"p3": maxDays,
		},
	}

	iter := client.Single().Query(ctx, stmt)
	defer iter.Stop()
	res := &CoverageHistory{
		instrumented: map[string]int64{},
		covered:      map[string]int64{},
		periods:      map[coveragedb.TimePeriod]struct{}{},
	}
	for {
		row, err := iter.Next()
		if err == iterator.Done {
			break
		}
		if err != nil {
			return nil, fmt.Errorf("failed to iter.Next() spanner DB: %w", err)
		}
		var r struct {
			Targetdate   civil.Date
			Days         int64
			Instrumented int64
			Covered      int64
		}
		if err = row.ToStruct(&r); err != nil {
			return nil, fmt.Errorf("failed to row.ToStruct() spanner DB: %w", err)
		}
		period := coveragedb.TimePeriod{DateTo: r.Targetdate, Days: int(r.Days)}
		if !pOps.IsValidPeriod(period) {
			continue
		}
		res.instrumented[r.Targetdate.String()] = r.Instrumented
		res.covered[r.Targetdate.String()] = r.Covered
		if _, found := res.periods[period]; found {
			return nil, fmt.Errorf("db error: only one period expected for date %s, days %d",
				period.DateTo.String(), period.Days)
		}
		res.periods[period] = struct{}{}
	}
	return res, nil
}