feat(cli): add profiles - default team/project stored in local SQLite

[bougyman]

Summary

Closes #56.

Full design in documents/phase-9-plan.adoc.

• LinearCli.Profiles: named team/project bundles in ~/.linear_cli/profiles.db (separate from Oban's own oban.db), with at most one active profile enforced by a partial unique index. Uses Exqlite.Sqlite3 directly rather than a new Ecto.Repo - interactive mode's supervisor is deliberately empty, and Oban's own migrations are only ever run externally via mix ecto.migrate; neither fits a one-shot CLI with no deploy step.
• New lc profile create/list/use/show/delete.
• issue create/issue list fall back to the active profile's team/project when --team/--project are omitted - an explicit flag still always wins.

Test plan

• mix test - 197/198 passed (1 pre-existing, unrelated failure in LinearCli.GitTest - confirmed it fails identically with these changes stashed out, a local git-environment flake)
• mix format --check-formatted - clean
• Manual smoke test: lc profile create/list/use/show/delete end to end
• New tests: LinearCli.ProfilesTest (data layer) and LinearCli.CLI.ProfileDefaultsTest (the fallback wiring in make_da_issue!/1 and issue_list/1, including that an explicit flag overrides the active profile)
• Fixed a real test-isolation gap found along the way: test_helper.exs now clears the test profiles db once at suite start, since a stray active profile left on disk by an earlier run was leaking into unrelated tests

[Copilot]

Pull request overview

Adds a first-class “profiles” feature to the Linear CLI so users can persist and switch default team/project selections (stored locally in a dedicated SQLite DB) and have issue create / issue list automatically fall back to the active profile when flags are omitted.

Changes:

• Introduces LinearCli.Profiles backed by ~/.linear_cli/profiles.db, including schema bootstrapping and an “exactly one active” invariant via a partial unique index.
• Adds lc profile create/list/use/show/delete wiring (Optimus spec, dispatch, commands) plus profile rendering in Display.
• Wires profile defaults into IssueHelpers.make_da_issue!/1 and Commands.issue_list/1, with new tests and test-suite DB cleanup.

Reviewed changes

Copilot reviewed 12 out of 12 changed files in this pull request and generated 1 comment.

Show a summary per file

File	Description
Readme.adoc	Documents the new profiles feature and basic CLI usage.
documents/phase-9-plan.adoc	Adds the phase-9 design document describing decisions and intended behavior.
app/test/test_helper.exs	Removes the test profiles DB at suite start to prevent cross-run leakage.
app/test/linear_cli/profiles_test.exs	Adds unit tests for LinearCli.Profiles CRUD/activation behavior.
app/test/linear_cli/cli/profile_defaults_test.exs	Adds integration-ish tests for default fallback behavior in issue_list and make_da_issue!.
app/lib/linear_cli/profiles.ex	Implements the profiles SQLite data layer (create/list/activate/active/delete/default_*).
app/lib/linear_cli/cli/issue_helpers.ex	Applies profile fallback for omitted :team/:project during issue creation.
app/lib/linear_cli/cli/display.ex	Adds text output formatting for Profiles.Profile.
app/lib/linear_cli/cli/commands.ex	Adds profile_* commands and applies profile fallback in issue_list/1.
app/lib/linear_cli/cli.ex	Registers the new profile command, aliases, and dispatch clauses.
app/config/runtime.exs	Configures :profiles_db_path per env (dev/test/prod).
app/.gitignore	Ignores local dev/test profiles DB files.

---

💡 Add a code-review agent skill or configure MCP servers for context-aware, tailored reviews. Learn more in the docs.