Files
multica/server/pkg/db/generated/issue_identifier_alias.sql.go
Naiyuan Qing afc7ac4bd0 feat: space rollout — space-first navigation, per-user membership, move-to-space (MUL-4142)
Squashed history of PR #4892 (pr-4784-fix). Makes spaces the primary
navigation and working surface, on the "associations bind at creation
time only" model.

Model
- Issue <-> space is the only enforced ownership (per-space numbering).
  Parent/child and project<->space associations only seed defaults at
  creation; cross-space/child and project-association validations are
  removed.
- Moving an issue renumbers it and records the old identifier in
  issue_identifier_alias; API/CLI lookups and GitHub branch/PR
  auto-linking fall back to the alias, so old identifiers resolve forever.
- Membership drives only the sidebar and personal defaults — never
  access. Anyone can configure any space's member set wholesale
  (PUT /api/spaces/{id}/members); saving an empty set archives the
  space behind a confirm.
- Per-user space order (workspace_space_member.sort_order, fractional):
  drag-sorted sidebar, "my first space" is the personal issue-creation
  default; the workspace default space backs headless creation
  (agents/CLI/Slack) and system placement.

Surfaces
- Sidebar: joined-spaces section (drag reorder, row -> space page,
  per-group persisted collapse), Workspace group with a More menu,
  Settings demoted to a footer icon.
- /space/:key/{issues,projects,autopilots,settings} — space surfaces
  reuse shared page components; a routed /space/new create page
  (replacing the earlier create-space modal), reserved key "NEW" so it
  can never collide with a real space's /space/:key detail page.
- Issue detail moves to /issue/:id (identifier-first, Linear-style; old
  /issues/:id redirects); create dialogs lead with a required space pill.
- Agent runtime brief now carries Space context (id/key/name) through
  the daemon claim -> TaskContextForEnv -> prompt pipeline, with a
  "## Space Context" section and --space on issue create/update in both
  brief renderers, matching Project's existing treatment.
- zh-Hans: Space translated to 空间 across locales and conventions.zh.mdx.

Fixes along the way
- Cache membership judgment gains the space dimension + space_changed
  WS flag.
- Silent skip on default-space lookup during invite acceptance is now a
  hard failure (no space-less members).
- Backfilled space_id into ~28 raw-SQL Go test fixtures across
  internal/handler and cmd/server that predated migration 132's NOT
  NULL cutover.
- Fixed a resolve-loop bug in the IssueDetail identifier wrapper (mount/
  unmount cycle on resolution failure) and gave it its own loading
  skeleton instead of a blank screen while resolving.
- reserved-slugs generator's stale hardcoded doc-comment example synced
  back to /create-space.

Verification
- go build ./..., go vet ./..., go test ./... all clean.
- pnpm typecheck (core/views/web/desktop) clean.
- packages/views: 162 files / 1656 tests passing.
- pnpm generate:reserved-slugs produces no diff.

Follow-ups tracked in docs/follow-ups/space-rollout.md.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-07-08 20:57:38 +08:00

85 lines
2.4 KiB
Go

// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.31.1
// source: issue_identifier_alias.sql
package db
import (
"context"
"github.com/jackc/pgx/v5/pgtype"
)
const getIssueByIdentifierAlias = `-- name: GetIssueByIdentifierAlias :one
SELECT i.id, i.workspace_id, i.title, i.description, i.status, i.priority, i.assignee_type, i.assignee_id, i.creator_type, i.creator_id, i.parent_issue_id, i.acceptance_criteria, i.context_refs, i.position, i.due_date, i.created_at, i.updated_at, i.number, i.project_id, i.origin_type, i.origin_id, i.first_executed_at, i.start_date, i.metadata, i.stage, i.space_id FROM issue_identifier_alias a
JOIN issue i ON i.id = a.issue_id
WHERE a.workspace_id = $1
AND a.space_key_lower = $2
AND a.number = $3
`
type GetIssueByIdentifierAliasParams struct {
WorkspaceID pgtype.UUID `json:"workspace_id"`
SpaceKeyLower string `json:"space_key_lower"`
Number int32 `json:"number"`
}
func (q *Queries) GetIssueByIdentifierAlias(ctx context.Context, arg GetIssueByIdentifierAliasParams) (Issue, error) {
row := q.db.QueryRow(ctx, getIssueByIdentifierAlias, arg.WorkspaceID, arg.SpaceKeyLower, arg.Number)
var i Issue
err := row.Scan(
&i.ID,
&i.WorkspaceID,
&i.Title,
&i.Description,
&i.Status,
&i.Priority,
&i.AssigneeType,
&i.AssigneeID,
&i.CreatorType,
&i.CreatorID,
&i.ParentIssueID,
&i.AcceptanceCriteria,
&i.ContextRefs,
&i.Position,
&i.DueDate,
&i.CreatedAt,
&i.UpdatedAt,
&i.Number,
&i.ProjectID,
&i.OriginType,
&i.OriginID,
&i.FirstExecutedAt,
&i.StartDate,
&i.Metadata,
&i.Stage,
&i.SpaceID,
)
return i, err
}
const upsertIssueIdentifierAlias = `-- name: UpsertIssueIdentifierAlias :exec
INSERT INTO issue_identifier_alias (workspace_id, space_key_lower, number, issue_id)
VALUES ($1, $2, $3, $4)
ON CONFLICT (workspace_id, space_key_lower, number)
DO UPDATE SET issue_id = EXCLUDED.issue_id
`
type UpsertIssueIdentifierAliasParams struct {
WorkspaceID pgtype.UUID `json:"workspace_id"`
SpaceKeyLower string `json:"space_key_lower"`
Number int32 `json:"number"`
IssueID pgtype.UUID `json:"issue_id"`
}
func (q *Queries) UpsertIssueIdentifierAlias(ctx context.Context, arg UpsertIssueIdentifierAliasParams) error {
_, err := q.db.Exec(ctx, upsertIssueIdentifierAlias,
arg.WorkspaceID,
arg.SpaceKeyLower,
arg.Number,
arg.IssueID,
)
return err
}