Skip to content

feat(coderd/database): add ListTasks query - #20282

Merged
johnstcn merged 3 commits into
mainfrom
cj/gh-coder-internal-981-list-tasks
Oct 14, 2025
Merged

johnstcn merged 3 commits into
mainfrom
cj/gh-coder-internal-981-list-tasks

Conversation

@johnstcn

@johnstcn johnstcn commented Oct 13, 2025 •

Copy link
Copy Markdown
Member

@johnstcn johnstcn self-assigned this Oct 13, 2025
@johnstcn
johnstcn force-pushed the cj/gh-coder-internal-981-list-tasks branch 2 times, most recently from e901f8d to 7b6e819 Compare October 13, 2025 20:00
@johnstcn
johnstcn force-pushed the cj/gh-coder-internal-981-list-tasks branch from 7b6e819 to 4c1b0b2 Compare October 14, 2025 11:14
@johnstcn
johnstcn marked this pull request as ready for review October 14, 2025 11:29

@DanielleMaywood DanielleMaywood left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

one non-blocking and one slightly blocking question

Comment thread coderd/database/dbauthz/dbauthz.go Outdated
}

func (q *querier) ListTasks(ctx context.Context, arg database.ListTasksParams) ([]database.Task, error) {
// TODO(Cian): replace this with a sql filter for improved performance.

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

non-blocking: should an issue be created for this?

Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Also non-blocking, this type of filter blocks pagination. But that's not critical yet.

@johnstcn johnstcn Oct 14, 2025 •

Copy link
Copy Markdown
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Will file a follow-up issue (EDIT: coder/internal#1061)

Comment thread coderd/database/querier_test.go Resolved
Comment thread coderd/database/dbauthz/dbauthz.go Outdated
}

func (q *querier) ListTasks(ctx context.Context, arg database.ListTasksParams) ([]database.Task, error) {
// TODO(Cian): replace this with a sql filter for improved performance.

Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Also non-blocking, this type of filter blocks pagination. But that's not critical yet.

Comment thread coderd/database/querier_test.go Resolved
@johnstcn
johnstcn merged commit 9f22937 into main Oct 14, 2025
@johnstcn
johnstcn deleted the cj/gh-coder-internal-981-list-tasks branch October 14, 2025 16:33
@github-actions github-actions Bot locked and limited conversation to collaborators Oct 14, 2025
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants