Skip to content

Commit 83eb9d0

Browse files
committed
Add other test from sqlc-dev#1334
1 parent 7c9b194 commit 83eb9d0

6 files changed

Lines changed: 270 additions & 0 deletions

File tree

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

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

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

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

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

Lines changed: 37 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -77,3 +77,40 @@ SELECT a.*, sa.*
7777
FROM authors a
7878
LEFT JOIN super_authors sa
7979
ON a.parent_id = sa.super_id;
80+
81+
-- https://github.com/kyleconroy/sqlc/issues/1334
82+
CREATE TABLE users_2 (
83+
user_id INT PRIMARY KEY,
84+
user_nickname VARCHAR(30) UNIQUE NOT NULL,
85+
user_email TEXT UNIQUE NOT NULL,
86+
user_display_name TEXT NOT NULL,
87+
user_password TEXT NULL,
88+
user_google_id TEXT UNIQUE NULL,
89+
user_apple_id TEXT UNIQUE NULL,
90+
user_bio VARCHAR(160) NOT NULL DEFAULT '',
91+
user_created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
92+
user_avatar_id INT UNIQUE NULL
93+
);
94+
95+
CREATE TABLE media (
96+
media_id INT PRIMARY KEY,
97+
media_created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
98+
media_hash TEXT NOT NULL,
99+
media_directory TEXT NOT NULL,
100+
media_author_id INT NOT NULL,
101+
media_width INT NOT NULL,
102+
media_height INT NOT NULL
103+
);
104+
105+
ALTER TABLE users_2
106+
ADD FOREIGN KEY (user_avatar_id)
107+
REFERENCES media(media_id)
108+
ON DELETE SET DEFAULT
109+
ON UPDATE CASCADE;
110+
111+
-- name: GetSuggestedUsersByID :many
112+
SELECT DISTINCT u.*, m.*
113+
FROM users_2 u
114+
LEFT JOIN media m
115+
ON u.user_avatar_id = m.media_id
116+
WHERE u.user_id != @user_id;

‎internal/endtoend/testdata/join_left/postgresql/go/models.go‎

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

‎internal/endtoend/testdata/join_left/postgresql/go/query.sql.go‎

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

‎internal/endtoend/testdata/join_left/postgresql/query.sql‎

Lines changed: 35 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -76,3 +76,38 @@ SELECT a.*, sa.*
7676
FROM authors a
7777
LEFT JOIN super_authors sa
7878
ON a.parent_id = sa.super_id;
79+
80+
-- https://github.com/kyleconroy/sqlc/issues/1334
81+
CREATE TABLE "users_2" (
82+
"user_id" uuid PRIMARY KEY,
83+
"user_nickname" VARCHAR(30) UNIQUE NOT NULL,
84+
"user_email" TEXT UNIQUE NOT NULL,
85+
"user_display_name" TEXT NOT NULL,
86+
"user_password" TEXT NULL,
87+
"user_google_id" TEXT UNIQUE NULL,
88+
"user_apple_id" TEXT UNIQUE NULL,
89+
"user_bio" VARCHAR(160) NOT NULL DEFAULT '',
90+
"user_created_at" TIMESTAMP NOT NULL DEFAULT (NOW()),
91+
"user_avatar_id" uuid UNIQUE NULL
92+
);
93+
94+
CREATE TABLE "media" (
95+
"media_id" uuid PRIMARY KEY,
96+
"media_created_at" TIMESTAMP NOT NULL DEFAULT (NOW()),
97+
"media_hash" TEXT NOT NULL,
98+
"media_directory" TEXT NOT NULL,
99+
"media_author_id" uuid NOT NULL,
100+
"media_width" INT NOT NULL,
101+
"media_height" INT NOT NULL
102+
);
103+
104+
ALTER TABLE "users_2"
105+
ADD FOREIGN KEY ("user_avatar_id") REFERENCES "media" ("media_id") ON DELETE SET DEFAULT ON UPDATE CASCADE;
106+
107+
-- name: GetSuggestedUsersByID :many
108+
SELECT DISTINCT u.*, m.*
109+
FROM users_2 u
110+
LEFT JOIN media m
111+
ON u.user_avatar_id = m.media_id
112+
WHERE u.user_id != @user_id
113+
LIMIT @user_imit;

0 commit comments

Comments
 (0)