package store

import (
	"regexp"
	"sort"
	"strings"
	"testing"
)

// owner names the chapter 10 item a table belongs to, since one with no item makes rule 3 false.
var owner = map[string]string{
	"accounts":          "1. account name to public keys",
	"pubkeys":           "1. account name to public keys",
	"gpgkeys":           "1. account name to public keys",
	"repos":             "2. namespace ownership",
	"tokens":            "3. tokens",
	"challenges":        "3. tokens",
	"signup_challenges": "3. tokens",
	"redirects":         "4. namespace redirects",
	"events":            "6. caches, indexes and derived state",
	"participation":     "6. caches, indexes and derived state",
	"search_docs":       "6. caches, indexes and derived state",
	"runners":           "7. work in flight",
	"jobs":              "7. work in flight",
	"webhooks":          "7. work in flight",
	"webhook_cursor":    "7. work in flight",
}

var createTable = regexp.MustCompile(`CREATE TABLE ([a-z_]+)`)

// Rule 3: nothing is stored that is not a git object, except a closed list. This is that list.
func TestEveryTableIsOnTheClosedList(t *testing.T) {
	found := map[string]bool{}
	for _, m := range migrations {
		for _, hit := range createTable.FindAllStringSubmatch(m.sqlite, -1) {
			found[hit[1]] = true
		}
	}
	if len(found) < 10 {
		t.Fatalf("only found %d tables, so this test is reading the wrong thing", len(found))
	}
	for name := range found {
		if _, ok := owner[name]; !ok {
			t.Errorf("the table %q is on no item of chapter 10's closed list. either it belongs "+
				"to one, or the list has grown and the chapter has to say so", name)
		}
	}
	// The other direction, so a dropped table does not leave a claim about storage that is not made.
	var stale []string
	for name := range owner {
		if !found[name] {
			stale = append(stale, name)
		}
	}
	sort.Strings(stale)
	if len(stale) > 0 {
		t.Errorf("the closed list claims %s, and no migration makes them", strings.Join(stale, ", "))
	}
}