coder/coderd/database/queries
Kayla Washburn-Love d8e0be6ee6
feat: add support for multiple banners (#13081)
2024-05-08 15:40:43 -06:00
..
README.md chore: split queries.sql into files by table (#762) 2022-04-01 15:45:23 -05:00
activitybump.sql feat: add template activity_bump property (#11734) 2024-02-13 07:00:35 +00:00
apikeys.sql chore: move app proxying code to workspaceapps pkg (#6998) 2023-04-05 13:41:55 -05:00
auditlogs.sql fix: respect uppercase letters in username filter for audit (#7880) 2023-06-07 05:48:08 -07:00
dbcrypt.sql fix(enterprise/dbcrypt): do not skip deleted users when encrypting or deleting (#9694) 2023-09-15 15:09:40 +01:00
externalauth.sql feat: add endpoints to list all authed external apps (#10944) 2023-12-05 14:03:44 -06:00
files.sql fix: Users that can update a template can also read the file (#6776) 2023-03-27 09:21:41 -05:00
gitsshkeys.sql feat: audit git ssh key regeneration (#4544) 2022-10-14 16:25:46 -05:00
groupmembers.sql feat: set groupsync to use default org (#12146) 2024-02-16 11:09:19 -06:00
groups.sql feat: add owner groups to workspace data (#12841) 2024-04-05 15:06:17 -04:00
insights.sql fix(coderd/database): improve perf of `GetTemplateInsightsByInterval` (#12773) 2024-03-27 14:10:46 +02:00
jfrog.sql feat: add backend for jfrog xray support (#11829) 2024-01-29 19:30:02 -06:00
licenses.sql feat: Add initial AuthzQuerier implementation (#5919) 2023-02-14 14:27:06 +00:00
lock.sql feat: add provisioner job hang detector (#7927) 2023-06-25 13:17:00 +00:00
oauth2.sql feat: add oauth2 token exchange (#12196) 2024-02-20 14:58:43 -09:00
organizationmembers.sql feat: add audit diffing for all user editable types (#1413) 2022-05-16 11:20:11 -05:00
organizations.sql fix: fix GetOrganizationsByUserID error when multiple organizations exist (#12257) 2024-02-22 08:14:48 -06:00
parameterschemas.sql feat!: drop support for legacy parameters (#7663) 2023-06-02 11:16:46 +02:00
provisionerdaemons.sql chore: add organization_id column to provisioner daemons (#12356) 2024-03-06 12:04:50 -06:00
provisionerjoblogs.sql feat: add startup script logs to the ui (#6558) 2023-03-23 14:09:13 -05:00
provisionerjobs.sql chore: enforce that provisioners can only acquire jobs in their own organization (#12600) 2024-03-18 12:48:13 -05:00
proxies.sql feat(coderd): store workspace proxy version in the database (#10790) 2023-11-21 11:21:25 +00:00
quotas.sql feat: expose Everyone group through UI (#9117) 2023-08-17 13:25:16 -05:00
replicas.sql chore: add derpserver to wsproxy, add proxies to derpmap (#7311) 2023-07-27 02:21:04 +10:00
siteconfig.sql feat: add support for multiple banners (#13081) 2024-05-08 15:40:43 -06:00
tailnet.sql chore: remove unused query failing to prepare (#11167) 2023-12-12 15:02:15 -06:00
templates.sql chore: remove max_ttl from templates (#12644) 2024-03-20 10:37:57 -05:00
templateversionparameters.sql feat(coderd): support ephemeral parameters (#8367) 2023-07-10 13:44:03 +02:00
templateversions.sql chore: add archive column to template versions (#10178) 2023-10-10 10:52:42 -05:00
templateversionvariables.sql feat: Expose managed variables via API (#6134) 2023-02-15 18:24:15 +01:00
user_links.sql fix: do not query user_link for deleted accounts (#12112) 2024-02-13 13:02:21 -06:00
users.sql fix: add postgres triggers to remove deleted users from user_links (#12117) 2024-02-20 13:19:38 -06:00
workspaceagentportshare.sql feat: allow setting port share protocol (#12383) 2024-03-06 09:23:57 -05:00
workspaceagents.sql perf(coderd/database): optimize `GetWorkspaceAgentAndLatestBuildByAuthToken` (#12809) 2024-03-28 19:38:16 +02:00
workspaceagentstats.sql chore(coderd/database): reduce dbpurge load with smaller batches of agent stats (#13049) 2024-04-23 15:01:56 +03:00
workspaceapps.sql feat: support `order` property of `coder_app` resource (#12077) 2024-02-12 15:11:31 +01:00
workspaceappstats.sql feat(coderd): add `coder_app` usage stats (#9001) 2023-08-16 15:22:00 +03:00
workspacebuildparameters.sql fix(coderd/database): fix limit in `GetUserWorkspaceBuildParameters` (#11954) 2024-01-31 13:56:36 +02:00
workspacebuilds.sql fix(coderd/database): avoid clobbering workspace build state (#9826) 2023-09-22 16:22:07 +01:00
workspaceresources.sql fix: preserve workspace resource metadata order (#5421) 2022-12-14 19:08:22 +00:00
workspaces.sql feat: expose workspace statuses (with details) as a prometheus metric (#12762) 2024-04-02 09:57:36 +02:00
workspacescripts.sql feat: add support for `coder_script` (#9584) 2023-09-25 16:47:17 -05:00

README.md

queries

Database queries are generated using sqlc. See: sqlc docs

Run make gen to generate models and query functions.