database

const (
	// User queries
	GetUserByIDQuery             = "SELECT * FROM users WHERE id = $1"
	GetTokenSignatureKeyKeyQuery = "SELECT s.signature_string FROM tokenbased-auth.signature s  WHERE id = (SELECT MAX(id) FROM tokenbased-auth.signature)"
	GetUserByEmailQuery          = "SELECT id, user_name, display_name, email, spotify_id, apple_id FROM users.user WHERE email = $1"
	GetUserByIdQuery             = "SELECT id, user_name, display_name, email, spotify_id, apple_id FROM users.user WHERE id = $1"
	InsertUserQuery              = "INSERT INTO users (user_name, email) VALUES ($1, $2) RETURNING id"

	// Token queries
	GetUserRefreshTokenQuery      = "SELECT refresh_token FROM tokenbased-auth.token WHERE user_id = $1"
	GetEqualUserRefreshTokenQuery = "SELECT refresh_token FROM tokenbased-auth.token WHERE user_id = $1 AND refresh_token = $2"
	UpdateUserRefreshTokenQuery   = "UPDATE tokenbased-auth.token SET refresh_token = $1, update = NOW() WHERE user_id = $2"
	InsertRefreshTokenQuery       = "" /* 149-byte string literal not displayed */
)