Skip to content

Commit fc10954

Browse files
committed
test: Add case for #2364
1 parent d50c424 commit fc10954

8 files changed

Lines changed: 126 additions & 0 deletions

File tree

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/2364
Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
{
2+
"contexts": ["managed-db"]
3+
}

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

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

‎internal/endtoend/testdata/func_star_expansion/postgresql/pgx/go/query.sql.go‎

Lines changed: 45 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.
Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,8 @@
1+
-- name: TestFuncGetTime :one
2+
select * from test_func_get_time();
3+
4+
-- name: TestFuncSelectString :one
5+
select * from test_func_select_string($1);
6+
7+
-- name: TestFuncSelectBlog :one
8+
select * from test_func_select_blog($1);
Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
create function test_func_get_time ()
2+
returns timestamp AS $$
3+
Begin
4+
return now();
5+
End;
6+
$$ language plpgsql;
7+
8+
create function test_func_select_string (in p_string text)
9+
returns text AS $$
10+
Begin
11+
return p_string;
12+
End;
13+
$$ language plpgsql;
14+
15+
create function test_func_select_blog(in p_id int)
16+
returns table (id int, name text, created_at timestamp, updated_at timestamp) AS $$
17+
BEGIN RETURN QUERY
18+
select id, name, created_at, updated_at from blog where id = p_id;
19+
END;
20+
$$ language plpgsql;
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"

0 commit comments

Comments
 (0)