Function uniqueSlug

internal/app/add.go:331–351

uniqueSlug returns base if no row with that slug exists in table; otherwise appends -2, -3, ... until it finds an unused one.

(db *sql.DB, table, base string)

// uniqueSlug returns base if no row with that slug exists in table;
// otherwise appends -2, -3, ... until it finds an unused one.
func uniqueSlug(db *sql.DB, table, base string) (string, error) {
	slug := base
	n := 2
	for {
		var exists int
		// nolint:gosec — table name is hardcoded ("projects" or "tasks").
		q := "SELECT 1 FROM " + table + " WHERE slug = ?"
		err := db.QueryRow(q, slug).Scan(&exists)
		if errors.Is(err, sql.ErrNoRows) {
			return slug, nil
		}
		if err != nil {
			return "", err
		}
		slug = fmt.Sprintf("%s-%d", base, n)
		n++
		if n > 1000 {
			return "", fmt.Errorf("slug %q: too many collisions", base)
		}
	}
}

func isValidPriority(p string) bool {
	return p == "high" || p == "medium" || p == "low"