Skip to content

Commit f9bbfd9

Browse files
kyleconroykyleconroy
authored
feat(postgresql): Add ALTER VIEW ... SET SCHEMA (#2855)
* feat(postgresql): Add ALTER VIEW ... SET SCHEMA
1 parent 39576d6 commit f9bbfd9

File tree

8 files changed

+116
-1
lines changed

8 files changed

+116
-1
lines changed

‎internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/issue.md

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
https://github.com/sqlc-dev/sqlc/issues/1519

‎internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/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_materialized_views_set_schema/postgresql/pgx/go/models.go

Lines changed: 21 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_materialized_views_set_schema/postgresql/pgx/go/query.sql.go

Lines changed: 36 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_materialized_views_set_schema/postgresql/pgx/query.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
-- name: SomeQuery :many
2+
select id from "computed_tables"."something";

‎internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/schema.sql

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
create table events (
2+
id int,
3+
event_type text not null,
4+
created_at timestamptz
5+
);
6+
7+
CREATE MATERIALIZED VIEW something AS
8+
select * from events
9+
where event_type = 'sale'
10+
order by created_at desc;
11+
12+
create schema computed_tables;
13+
alter materialized view something set schema computed_tables;

‎internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/sqlc.yaml

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
version: "2"
2+
sql:
3+
- engine: "postgresql"
4+
schema: "schema.sql"
5+
queries: "query.sql"
6+
gen:
7+
go:
8+
package: "querytest"
9+
out: "go"
10+
sql_package: "pgx/v5"

‎internal/engine/postgresql/parse.go

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -236,7 +236,7 @@ func translate(node *nodes.Node) (ast.Node, error) {
236236
n := inner.AlterObjectSchemaStmt
237237
switch n.ObjectType {
238238

239-
case nodes.ObjectType_OBJECT_TABLE:
239+
case nodes.ObjectType_OBJECT_TABLE, nodes.ObjectType_OBJECT_VIEW, nodes.ObjectType_OBJECT_MATVIEW:
240240
rel := parseRelationFromRangeVar(n.Relation)
241241
return &ast.AlterTableSetSchemaStmt{
242242
Table: rel.TableName(),

0 commit comments

Comments
 (0)