package oltp
import (
"fmt"
"path/filepath"
"testing"
"time"
)
func runnerReq(addr, repo string, i int) SignOff {
return SignOff{Agent: RunnerAskerPrefix + addr, Owner: "jva", Op: "ci.worker.token.new", Repo: repo,
Input: fmt.Sprintf(`{"repo":%q,"label":"h%d"}`, repo, i), Summary: "s", Pickup: fmt.Sprintf("%064x", i+1)}
}
// LAPSED RUNNER REQUESTS ARE CLOSED IN THE DATABASE AND NEVER LISTED, SO
// A STRANGER CANNOT PUSH THE OWNER'S REAL REQUESTS OUT OF THE LIST; AND
// THEY DO NOT COUNT AGAINST THEIR ADDRESS.
func TestLapsedRunnerRequestsNeitherFillTheListNorCountAgainstTheAddress(t *testing.T) {
db, err := Open(filepath.Join(t.TempDir(), "o.db"))
if err != nil {
t.Fatal(err)
}
defer db.Close()
for i := 0; i < 60; i++ {
if _, err := db.RequestSignOff(runnerReq(fmt.Sprintf("198.51.100.%d", i), "suit", i)); err != nil {
t.Fatal(err)
}
}
// One address holds twenty, the most an asker may.
for i := 0; i < MaxPendingSignOffs; i++ {
if _, err := db.RequestSignOff(runnerReq("203.0.113.7", "suit", 100+i)); err != nil {
t.Fatal(err)
}
}
old := time.Now().Add(-RunnerLife - time.Minute).UTC().Format(time.RFC3339)
if _, err := db.w.Exec(`UPDATE signoff SET requested = ?`, old); err != nil {
t.Fatal(err)
}
real, err := db.RequestSignOff(SignOff{Agent: "jva-bot", Owner: "jva", Op: "repo.delete", Repo: "suit", Input: "{}", Summary: "real"})
if err != nil {
t.Fatal(err)
}
// The address that held twenty lapsed ones may ask again.
if _, err := db.RequestSignOff(runnerReq("203.0.113.7", "suit", 999)); err != nil {
t.Errorf("FAIL: lapsed requests still count against their address: %v", err)
}
if err := db.CloseLapsedRunnerSignOffs(time.Now()); err != nil {
t.Fatal(err)
}
got, err := db.SignOffsFor("jva", 50)
if err != nil {
t.Fatal(err)
}
var ids []string
for _, s := range got {
ids = append(ids, s.ID)
if s.ID != real.ID && s.Agent[:3] == "run" && s.Requested == old {
t.Errorf("FAIL: a lapsed runner request is listed")
}
}
if len(got) == 0 || got[0].ID != real.ID {
t.Errorf("FAIL: the real request is not first of %d listed", len(got))
}
if len(got) != 1 {
t.Errorf("FAIL: %d listed, want the real request alone: runner requests are listed apart", len(got))
}
runners, err := db.RunnerSignOffsFor("jva", 50)
if err != nil || len(runners) != 1 {
t.Errorf("FAIL: %d open runner requests listed apart, want the one new one (%v)", len(runners), err)
}
var open int
if err := db.db.QueryRow(`SELECT count(*) FROM signoff WHERE state = 'pending' AND agent LIKE 'runner at %' AND requested = ?`, old).Scan(&open); err != nil || open != 0 {
t.Errorf("FAIL: %d lapsed runner requests are still pending in the database (%v)", open, err)
}
if !t.Failed() {
t.Log("ok")
}
}
// OPEN RUNNER REQUESTS, HOWEVER MANY, NEVER TAKE A SLOT OF THE OWNER'S
// OWN LIST; THE READ DOES NOT WRITE.
func TestOpenRunnerRequestsAreListedApartAndAReadClosesNothing(t *testing.T) {
db, err := Open(filepath.Join(t.TempDir(), "o.db"))
if err != nil {
t.Fatal(err)
}
defer db.Close()
for i := 0; i < 300; i++ {
if _, err := db.RequestSignOff(runnerReq(fmt.Sprintf("10.%d.%d.1", i/250, i%250), "suit", i)); err != nil {
t.Fatal(err)
}
}
real, err := db.RequestSignOff(SignOff{Agent: "jva-bot", Owner: "jva", Op: "repo.delete", Repo: "suit", Input: "{}", Summary: "real"})
if err != nil {
t.Fatal(err)
}
got, _ := db.SignOffsFor("jva", 50)
if len(got) != 1 || got[0].ID != real.ID {
t.Errorf("FAIL: %d listed, want only the real request", len(got))
}
old := time.Now().Add(-RunnerLife - time.Minute).UTC().Format(time.RFC3339)
db.w.Exec(`UPDATE signoff SET requested = ? WHERE agent LIKE 'runner at %'`, old)
if _, err := db.SignOffsFor("jva", 50); err != nil {
t.Fatal(err)
}
var open int
db.db.QueryRow(`SELECT count(*) FROM signoff WHERE state = 'pending' AND agent LIKE 'runner at %'`).Scan(&open)
if open != 300 {
t.Errorf("FAIL: a read closed requests (%d still pending, want 300): closing is the sweep's", open)
}
if rs, _ := db.RunnerSignOffsFor("jva", 200); len(rs) != 0 {
t.Errorf("FAIL: %d lapsed runner requests are listed before the sweep runs", len(rs))
}
if err := db.CloseLapsedRunnerSignOffs(time.Now()); err != nil {
t.Fatal(err)
}
db.db.QueryRow(`SELECT count(*) FROM signoff WHERE state = 'pending' AND agent LIKE 'runner at %'`).Scan(&open)
if open != 0 {
t.Errorf("FAIL: the sweep left %d lapsed runner requests pending", open)
}
if !t.Failed() {
t.Log("ok")
}
}