Skip to content

Commit deca8fd

Browse files
nickjacksonnickjackson
committed
add tests
1 parent 54207db commit deca8fd

File tree

15 files changed

+943
-0
lines changed

15 files changed

+943
-0
lines changed

‎internal/endtoend/testdata/sqlc_embed/mysql/go/db.go

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

‎internal/endtoend/testdata/sqlc_embed/mysql/go/models.go

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

‎internal/endtoend/testdata/sqlc_embed/mysql/go/query.sql.go

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

‎internal/endtoend/testdata/sqlc_embed/mysql/query.sql

Lines changed: 44 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,44 @@
1+
CREATE SCHEMA IF NOT EXISTS baz;
2+
3+
CREATE TABLE users (
4+
id integer NOT NULL PRIMARY KEY,
5+
name varchar(255) NOT NULL,
6+
age integer NULL
7+
);
8+
9+
CREATE TABLE posts (
10+
id integer NOT NULL PRIMARY KEY,
11+
user_id integer NOT NULL
12+
);
13+
14+
CREATE TABLE baz.users (
15+
id integer NOT NULL PRIMARY KEY,
16+
name varchar(255) NOT NULL
17+
);
18+
19+
20+
-- name: Only :one
21+
SELECT sqlc.embed(users) FROM users;
22+
23+
-- name: WithAlias :one
24+
SELECT sqlc.embed(u) FROM users u;
25+
26+
-- name: WithSubquery :many
27+
SELECT sqlc.embed(users), (SELECT count(*) FROM users) AS total_count FROM users;
28+
29+
-- name: WithAsterisk :one
30+
SELECT sqlc.embed(users), * FROM users;
31+
32+
-- name: Duplicate :one
33+
SELECT sqlc.embed(users), sqlc.embed(users) FROM users;
34+
35+
-- name: Join :one
36+
SELECT sqlc.embed(users), sqlc.embed(posts) FROM posts
37+
INNER JOIN users ON posts.user_id = users.id;
38+
39+
-- name: WithSchema :one
40+
SELECT sqlc.embed(bu) FROM baz.users bu;
41+
42+
-- name: WithCrossSchema :many
43+
SELECT sqlc.embed(users), sqlc.embed(bu) FROM users
44+
INNER JOIN baz.users bu ON users.id = bu.id;

‎internal/endtoend/testdata/sqlc_embed/mysql/sqlc.json

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

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

Lines changed: 25 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)