Skip to content

Commit a442d97

Browse files
coadlercoadler
committed
chore: split queries.sql into files by table
1 parent 50f2fca commit a442d97

40 files changed

+3694
-3521
lines changed

‎Makefile

Lines changed: 12 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@ coderd/database/dump.sql: $(wildcard coderd/database/migrations/*.sql)
1414
go run coderd/database/dump/main.go
1515

1616
# Generates Go code for querying the database.
17-
coderd/database/generate: fmt/sql coderd/database/dump.sql coderd/database/query.sql
17+
coderd/database/generate: fmt/sql coderd/database/dump.sql $(wildcard coderd/database/queries/*.sql)
1818
cd coderd/database && sqlc generate && rm db_tmp.go
1919
cd coderd/database && gofmt -w -r 'Querier -> querier' *.go
2020
cd coderd/database && gofmt -w -r 'Queries -> sqlQuerier' *.go
@@ -30,13 +30,17 @@ else
3030
endif
3131
.PHONY: fmt/prettier
3232

33-
fmt/sql: ./coderd/database/query.sql
34-
npx sql-formatter \
35-
--language postgresql \
36-
--lines-between-queries 2 \
37-
./coderd/database/query.sql \
38-
--output ./coderd/database/query.sql
39-
sed -i 's/@ /@/g' ./coderd/database/query.sql
33+
fmt/sql: $(wildcard coderd/database/queries/*.sql)
34+
for fi in coderd/database/queries/*.sql; do \
35+
npx sql-formatter \
36+
--language postgresql \
37+
--lines-between-queries 2 \
38+
--tab-indent \
39+
$$fi \
40+
--output $$fi; \
41+
done
42+
43+
sed -i 's/@ /@/g' ./coderd/database/queries/*.sql
4044

4145
fmt: fmt/prettier fmt/sql
4246
.PHONY: fmt

‎coderd/database/api_keys.sql.go

Lines changed: 173 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/dump.sql

Lines changed: 4 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/files.sql.go

Lines changed: 67 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/migrations/000002_projects.up.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -30,6 +30,7 @@ CREATE TABLE projects (
3030

3131
-- Enforces no active projects have the same name.
3232
CREATE UNIQUE INDEX ON projects (organization_id, name) WHERE deleted = FALSE;
33+
CREATE UNIQUE INDEX idx_projects_name_lower ON projects USING btree (lower(name));
3334

3435
-- Project Versions store historical project data. When a Project Version is imported,
3536
-- an "import" job is queued to parse parameters. A Project Version

‎coderd/database/migrations/000003_workspaces.up.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,8 @@ CREATE TABLE workspaces (
99
);
1010

1111
-- Enforces no active workspaces have the same name.
12-
CREATE UNIQUE INDEX ON workspaces (owner_id, name) WHERE deleted = FALSE;
12+
CREATE UNIQUE INDEX ON workspaces USING btree (owner_id, name) WHERE deleted = FALSE;
13+
CREATE UNIQUE INDEX idx_workspaces_name_lower ON workspaces USING btree (lower(name));
1314

1415
CREATE TYPE workspace_transition AS ENUM (
1516
'start',

‎coderd/database/organization_members.sql.go

Lines changed: 81 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

0 commit comments

Comments
 (0)