55 lines
1.7 KiB
Go
55 lines
1.7 KiB
Go
package store
|
|
|
|
type Queries struct {
|
|
CreateUser string
|
|
GetUserByID string
|
|
GetUserByEmail string
|
|
GetUserByUsername string
|
|
}
|
|
|
|
var CanonicalQueries Queries = Queries{
|
|
CreateUser: `
|
|
INSERT INTO pase_users (
|
|
id, email, email_verified_at,
|
|
username, username_normalized, display_name, profile_image_url,
|
|
status, status_reason, status_changed_at, status_expires_at,
|
|
failed_login_count, last_failed_login_at,
|
|
created_at, updated_at
|
|
) VALUES (?,?,?, ?,?,?,?, ?,?,?,?, ?,?, ?,?);`,
|
|
GetUserByID: `
|
|
SELECT
|
|
id, email, email_verified_at,
|
|
username, username_normalized, display_name, profile_image_url,
|
|
status, status_reason, status_changed_at, status_expires_at,
|
|
failed_login_count, last_failed_login_at,
|
|
created_at, updated_at
|
|
FROM pase_users
|
|
WHERE id = ?;`,
|
|
GetUserByEmail: `
|
|
SELECT
|
|
id, email, email_verified_at,
|
|
username, username_normalized, display_name, profile_image_url,
|
|
status, status_reason, status_changed_at, status_expires_at,
|
|
failed_login_count, last_failed_login_at,
|
|
created_at, updated_at
|
|
FROM pase_users
|
|
WHERE email = ?;`,
|
|
GetUserByUsername: `
|
|
SELECT
|
|
id, email, email_verified_at,
|
|
username, username_normalized, display_name, profile_image_url,
|
|
status, status_reason, status_changed_at, status_expires_at,
|
|
failed_login_count, last_failed_login_at,
|
|
created_at, updated_at
|
|
FROM pase_users
|
|
WHERE username_normalized = ?;`,
|
|
}
|
|
|
|
func (q Queries) Rebind(d Dialect) Queries {
|
|
return Queries{
|
|
CreateUser: d.Rebind(q.CreateUser),
|
|
GetUserByID: d.Rebind(q.GetUserByID),
|
|
GetUserByEmail: d.Rebind(q.GetUserByEmail),
|
|
GetUserByUsername: d.Rebind(q.GetUserByUsername),
|
|
}
|
|
}
|