diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-28 03:15:08 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-28 03:15:08 +0900 |
| commit | 569eb3753db04c2ceca8d005b3e1cef15cfe8eb7 (patch) | |
| tree | 9cb80bf9642e1e7d6146551d81fd57988bb240df /backend/db/query.sql.go | |
| parent | f106dfda762b499af52a741f682c34abb83d27d9 (diff) | |
| download | phperkaigi-2025-albatross-569eb3753db04c2ceca8d005b3e1cef15cfe8eb7.tar.gz phperkaigi-2025-albatross-569eb3753db04c2ceca8d005b3e1cef15cfe8eb7.tar.zst phperkaigi-2025-albatross-569eb3753db04c2ceca8d005b3e1cef15cfe8eb7.zip | |
rename user's display_username to display_name
Diffstat (limited to 'backend/db/query.sql.go')
| -rw-r--r-- | backend/db/query.sql.go | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 72c6502..12651d2 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -12,23 +12,23 @@ import ( ) const getUserAuthByUsername = `-- name: GetUserAuthByUsername :one -SELECT users.user_id, username, display_username, icon_path, is_admin, created_at, user_auth_id, user_auths.user_id, auth_type, password_hash FROM users +SELECT users.user_id, username, display_name, icon_path, is_admin, created_at, user_auth_id, user_auths.user_id, auth_type, password_hash FROM users JOIN user_auths ON users.user_id = user_auths.user_id WHERE users.username = $1 LIMIT 1 ` type GetUserAuthByUsernameRow struct { - UserID int32 - Username string - DisplayUsername string - IconPath pgtype.Text - IsAdmin bool - CreatedAt pgtype.Timestamp - UserAuthID int32 - UserID_2 int32 - AuthType string - PasswordHash pgtype.Text + UserID int32 + Username string + DisplayName string + IconPath pgtype.Text + IsAdmin bool + CreatedAt pgtype.Timestamp + UserAuthID int32 + UserID_2 int32 + AuthType string + PasswordHash pgtype.Text } func (q *Queries) GetUserAuthByUsername(ctx context.Context, username string) (GetUserAuthByUsernameRow, error) { @@ -37,7 +37,7 @@ func (q *Queries) GetUserAuthByUsername(ctx context.Context, username string) (G err := row.Scan( &i.UserID, &i.Username, - &i.DisplayUsername, + &i.DisplayName, &i.IconPath, &i.IsAdmin, &i.CreatedAt, @@ -50,7 +50,7 @@ func (q *Queries) GetUserAuthByUsername(ctx context.Context, username string) (G } const getUserById = `-- name: GetUserById :one -SELECT user_id, username, display_username, icon_path, is_admin, created_at FROM users +SELECT user_id, username, display_name, icon_path, is_admin, created_at FROM users WHERE users.user_id = $1 LIMIT 1 ` @@ -61,7 +61,7 @@ func (q *Queries) GetUserById(ctx context.Context, userID int32) (User, error) { err := row.Scan( &i.UserID, &i.Username, - &i.DisplayUsername, + &i.DisplayName, &i.IconPath, &i.IsAdmin, &i.CreatedAt, |