Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

chore: add db query to retrieve workspaces & their agents#14792

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Conversation

ethanndickson
Copy link
Member

@ethanndicksonethanndickson commentedSep 25, 2024•
edited
Loading

Second PR for#14716.

Adds a query that, given a user ID, returns all the workspaces they own, that can also beActionRead by the requesting user.

type GetWorkspacesAndAgentsByOwnerIDRow struct {WorkspaceID      uuid.UUID            `db:"workspace_id" json:"workspace_id"`WorkspaceName    string               `db:"workspace_name" json:"workspace_name"`JobStatus        ProvisionerJobStatus `db:"job_status" json:"job_status"`Transition       WorkspaceTransition  `db:"transition" json:"transition"`Agents           []AgentIDNamePair    `db:"agents" json:"agents"`}

JobStatus andTransition are set using the latest build/job of the workspace. Deleted workspaces are not included.

@ethanndicksonGraphite App
Copy link
MemberAuthor

ethanndickson commentedSep 25, 2024•
edited
Loading

@ethanndicksonethanndickson marked this pull request as ready for reviewSeptember 25, 2024 07:46
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch 3 times, most recently from6e44f26 to97ac5bcCompareSeptember 26, 2024 08:28
@@ -28,6 +28,9 @@ sql:
emit_enum_valid_method: true
emit_all_enum_values: true
overrides:
- db_type: "agent_name_pair"
go_type:
type: "AgentIDNamePair"
Copy link
MemberAuthor

@ethanndicksonethanndicksonSep 26, 2024•
edited
Loading

Choose a reason for hiding this comment

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

Required due tosqlc-dev/sqlc#2760

@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch 3 times, most recently fromaacd023 to22985f7CompareSeptember 27, 2024 05:11
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch 2 times, most recently fromdb04bcf to50f874cCompareSeptember 30, 2024 09:35
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch 5 times, most recently from2bc6e69 to54cbfafCompareOctober 3, 2024 15:07
@alwaysmeticulousalwaysmeticulous
Copy link

Meticulous was unable to execute a test run for this PR because the most recent commit is associated with multiple PRs. To execute a test run, please try pushing up a new commit that is only associated with this PR.

Last updated for commit701c1b6. This comment will update as new commits are pushed.

@ethanndicksonethanndickson changed the base branch frommain toethan/owner-pubsubOctober 3, 2024 15:07
@ethanndicksonethanndickson marked this pull request as draftOctober 3, 2024 15:35
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch from54cbfaf toaad36cfCompareOctober 4, 2024 03:45
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch fromaad36cf tob5f7529CompareOctober 4, 2024 05:51
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch fromaafb31a to21fa63cCompareOctober 22, 2024 10:04
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch 2 times, most recently fromcfa32d5 to3a95c19CompareOctober 24, 2024 04:41
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch from3a95c19 to22db890CompareOctober 28, 2024 12:04
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch from22db890 toc55e54bCompareOctober 28, 2024 15:23
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch fromc55e54b to45225e4CompareOctober 29, 2024 03:14
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch frome05b286 toa45a43cCompareOctober 29, 2024 09:53
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch froma45a43c to744633fCompareNovember 1, 2024 03:02
@ethanndicksonethanndickson changed the base branch fromethan/owner-pubsub tographite-base/14792November 1, 2024 03:17
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch from744633f to54ceea2CompareNovember 1, 2024 03:17
@ethanndicksonethanndickson changed the base branch fromgraphite-base/14792 tomainNovember 1, 2024 03:18
@ethanndicksonethanndicksonforce-pushed the09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branch from54ceea2 to8be52edCompareNovember 1, 2024 03:18
@ethanndicksonethanndickson merged commitf941e78 intomainNov 1, 2024
27 checks passed
@ethanndicksonethanndickson deleted the 09-25-chore_add_db_query_to_retrieve_workspaces_their_agents branchNovember 1, 2024 03:36
@github-actionsgithub-actionsbot locked and limited conversation to collaboratorsNov 1, 2024
Sign up for freeto subscribe to this conversation on GitHub. Already have an account?Sign in.
Reviewers

@deansheatherdeansheatherdeansheather left review comments

@spikecurtisspikecurtisspikecurtis approved these changes

@sreyasreyaAwaiting requested review from sreya

Assignees

@ethanndicksonethanndickson

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

4 participants
@ethanndickson@spikecurtis@deansheather@matifali
[8]ページ先頭
©2009-2025 Movatter.jp