Skip to content

Commit 8d082e4

Browse files
linux2647linux2647
authored
Implement ALTER TYPE SET SCHEMA (sqlc-dev#2027)
1 parent ed5ffbc commit 8d082e4

20 files changed

Lines changed: 674 additions & 0 deletions

File tree

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v4/go/db.go‎

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

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v4/go/models.go‎

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

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v4/go/query.sql.go‎

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

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v4/query.sql‎

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
CREATE SCHEMA old;
2+
CREATE SCHEMA new;
3+
4+
CREATE TYPE event AS enum ('START', 'STOP');
5+
CREATE TYPE old.level AS enum ('DEBUG', 'INFO', 'WARN', 'ERROR', 'FATAL');
6+
7+
CREATE TABLE log_lines (
8+
id BIGSERIAL PRIMARY KEY,
9+
status event NOT NULL,
10+
level old.level NOT NULL
11+
);
12+
13+
ALTER TYPE event SET SCHEMA new;
14+
ALTER TYPE old.level SET SCHEMA public;
15+
16+
-- name: ListAuthors :many
17+
SELECT * FROM log_lines;

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v4/sqlc.json‎

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
{
2+
"version": "1",
3+
"packages": [
4+
{
5+
"path": "go",
6+
"engine": "postgresql",
7+
"sql_package": "pgx/v4",
8+
"name": "querytest",
9+
"schema": "query.sql",
10+
"queries": "query.sql"
11+
}
12+
]
13+
}

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v5/go/db.go‎

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

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v5/go/models.go‎

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

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v5/go/query.sql.go‎

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

‎internal/endtoend/testdata/ddl_alter_type_set_schema/postgresql/pgx/v5/query.sql‎

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
CREATE SCHEMA old;
2+
CREATE SCHEMA new;
3+
4+
CREATE TYPE event AS enum ('START', 'STOP');
5+
CREATE TYPE old.level AS enum ('DEBUG', 'INFO', 'WARN', 'ERROR', 'FATAL');
6+
7+
CREATE TABLE log_lines (
8+
id BIGSERIAL PRIMARY KEY,
9+
status event NOT NULL,
10+
level old.level NOT NULL
11+
);
12+
13+
ALTER TYPE event SET SCHEMA new;
14+
ALTER TYPE old.level SET SCHEMA public;
15+
16+
-- name: ListAuthors :many
17+
SELECT * FROM log_lines;

0 commit comments

Comments
 (0)