package unread

import (
	"strings"
	"testing"
)

func TestBuildMetadataPageQueryUsesOnlyMetadataTables(t *testing.T) {
	query, args, err := buildMetadataPageQuery(MetadataPageRequest{
		WorkspaceID: "w1",
		MemberID:    "m1",
		ScopeIDs:    []string{"s2", "s1", "s2"},
		Limit:       25,
	})
	if err != nil {
		t.Fatalf("buildMetadataPageQuery returned error: %v", err)
	}
	if strings.Contains(query, "scope_messages") {
		t.Fatalf("metadata query must not read scope_messages:\n%s", query)
	}
	if strings.Contains(query, "scope_activity_events") {
		t.Fatalf("metadata query must not read scope_activity_events:\n%s", query)
	}
	if strings.Contains(query, "task_message_unread_count") {
		t.Fatalf("metadata query must not read task message unread projection:\n%s", query)
	}
	if strings.Contains(query, "task_activity_unread_count") {
		t.Fatalf("metadata query must not read task activity unread projection:\n%s", query)
	}
	for _, want := range []string{
		"WITH requested_scopes AS",
		"JOIN scopes s",
		"JOIN scope_memberships sm",
		"LEFT JOIN scope_notification_settings sns",
		"LEFT JOIN conversation_member_states cms",
		"s.unread_rewind_generation",
		"sm.unread_generation",
		"COALESCE(sns.unread_generation, 0)",
		"COALESCE(cms.unread_generation, 0)",
		"s.workspace_id = $1",
		"sm.member_id = $2",
		"LIMIT $3",
	} {
		if !strings.Contains(query, want) {
			t.Fatalf("metadata query missing %q:\n%s", want, query)
		}
	}
	if len(args) != 5 {
		t.Fatalf("metadata args length = %d, want 5", len(args))
	}
}

func TestBuildMetadataPageQueryRequiresMemberPageBound(t *testing.T) {
	query, args, err := buildMetadataPageQuery(MetadataPageRequest{
		WorkspaceID:  "w1",
		MemberID:     "m1",
		AfterScopeID: "s10",
		Limit:        25,
	})
	if err != nil {
		t.Fatalf("buildMetadataPageQuery returned error: %v", err)
	}
	for _, want := range []string{
		"s.workspace_id = $1",
		"sm.member_id = $2",
		"s.id > $3",
		"ORDER BY s.id",
		"LIMIT $4",
	} {
		if !strings.Contains(query, want) {
			t.Fatalf("metadata page query missing %q:\n%s", want, query)
		}
	}
	if len(args) != 4 {
		t.Fatalf("metadata page args length = %d, want 4", len(args))
	}
}

func TestBuildSnapshotPageQueryUsesSnapshotTableOnly(t *testing.T) {
	query, args, err := buildSnapshotPageQuery(SnapshotPageRequest{
		WorkspaceID:  "w1",
		MemberID:     "m1",
		AfterScopeID: "s0",
		Limit:        100,
	})
	if err != nil {
		t.Fatalf("buildSnapshotPageQuery returned error: %v", err)
	}
	for _, forbidden := range []string{"scope_messages", "scope_activity_events", "conversation_member_states"} {
		if strings.Contains(query, forbidden) {
			t.Fatalf("snapshot query must not read %s:\n%s", forbidden, query)
		}
	}
	for _, want := range []string{
		"FROM member_scope_unread_runtime_snapshots snap",
		"snap.workspace_id = $1",
		"snap.member_id = $2",
		"snap.scope_id > $3",
		"LIMIT $4",
	} {
		if !strings.Contains(query, want) {
			t.Fatalf("snapshot query missing %q:\n%s", want, query)
		}
	}
	if len(args) != 4 {
		t.Fatalf("snapshot args length = %d, want 4", len(args))
	}
}

func TestBuildActivityTailPageQueryAllowsOnlyOrdinaryNonTaskScopes(t *testing.T) {
	query := buildActivityTailPageQuery()
	for _, want := range []string{
		"FROM scope_activity_events a",
		"JOIN scopes s",
		"a.workspace_id = $1",
		"a.scope_id = $2",
		"a.seq > $3",
		"a.suppressed_at IS NULL",
		"s.type IN ('channel', 'dm', 'thread', 'service_account')",
		"a.activity_ref_type <> 'reaction'",
		"a.activity_type <> 'reaction_added'",
		"ORDER BY a.seq",
		"LIMIT $4",
	} {
		if !strings.Contains(query, want) {
			t.Fatalf("activity tail query missing %q:\n%s", want, query)
		}
	}
	for _, forbidden := range []string{
		"s.type = 'task'",
		"a.activity_ref_type = 'task_event'",
		"task.checkpoint_added",
		"task.status_changed",
	} {
		if strings.Contains(query, forbidden) {
			t.Fatalf("activity tail query must not include task activity predicate %q:\n%s", forbidden, query)
		}
	}
}

func TestBuildVisibleTaskConversationScopeIDsPageQueryUsesMessageHideFrontierOnly(t *testing.T) {
	query := buildVisibleTaskConversationScopeIDsPageQuery()
	for _, want := range []string{
		"FROM im_conversation_index idx",
		"task_scope.type = 'task'",
		"idx.kind = 'task'",
		"idx.archived_at IS NULL",
		"cms.hidden_at IS NOT NULL",
		"COALESCE(task_scope.latest_seq, 0) <= COALESCE(cms.hidden_through_seq, 0)",
		"ORDER BY idx.scope_id",
		"LIMIT $4",
	} {
		if !strings.Contains(query, want) {
			t.Fatalf("visible Task conversation scope query missing %q:\n%s", want, query)
		}
	}
	for _, forbidden := range []string{
		"latest_activity_seq",
		"hidden_through_activity_seq",
	} {
		if strings.Contains(query, forbidden) {
			t.Fatalf("visible Task conversation scope query must not use Activity hide frontier %q:\n%s", forbidden, query)
		}
	}
}

func TestPageRequestsRequirePositiveLimit(t *testing.T) {
	tests := []struct {
		name string
		err  error
	}{
		{
			name: "snapshot",
			err:  SnapshotPageRequest{WorkspaceID: "w1", MemberID: "m1"}.validate(),
		},
		{
			name: "metadata",
			err:  MetadataPageRequest{WorkspaceID: "w1", MemberID: "m1"}.validate(),
		},
		{
			name: "roster",
			err:  RosterPageRequest{WorkspaceID: "w1", ScopeID: "s1"}.validate(),
		},
		{
			name: "tail",
			err:  TailPageRequest{WorkspaceID: "w1", ScopeID: "s1"}.validate(),
		},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			if tt.err == nil || tt.err.Error() != "limit must be positive" {
				t.Fatalf("validate error = %v, want limit must be positive", tt.err)
			}
		})
	}
}