Method FindMagicAuthTokensWithUser

admin/database/postgres/postgres.go:1580–1618

(ctx context.Context, projectID string, createdByUserID *string, afterID string, limit int)

}

func (c *connection) FindMagicAuthTokensWithUser(ctx context.Context, projectID string, createdByUserID *string, afterID string, limit int) ([]*database.MagicAuthTokenWithUser, error) {
	n := 1
	where := fmt.Sprintf("t.project_id=$%d", n)
	args := []any{projectID}
	n++

	if createdByUserID != nil {
		where = fmt.Sprintf("%s AND t.created_by_user_id=$%d", where, n)
		args = append(args, *createdByUserID)
		n++
	}

	if afterID != "" {
		where = fmt.Sprintf("%s AND t.id>$%d", where, n)
		args = append(args, afterID)
		n++
	}

	where += " AND (t.expires_on IS NULL OR t.expires_on > now()) AND t.internal=false"

	qry := fmt.Sprintf("SELECT t.*, COALESCE(u.email, '') AS created_by_user_email FROM magic_auth_tokens t LEFT JOIN users u ON t.created_by_user_id=u.id WHERE %s ORDER BY t.id LIMIT $%d", where, n)
	args = append(args, limit)

	var dtos []*magicAuthTokenWithUserDTO
	err := c.getDB(ctx).SelectContext(ctx, &dtos, qry, args...)
	if err != nil {
		return nil, parseErr("magic auth tokens", err)
	}

	res := make([]*database.MagicAuthTokenWithUser, len(dtos))
	for i, dto := range dtos {
		var err error
		res[i], err = c.magicAuthTokenWithUserFromDTO(dto)
		if err != nil {
			return nil, err
		}
	}
	return res, nil
}

func (c *connection) FindMagicAuthToken(ctx context.Context, id string, withSecret bool) (*database.MagicAuthToken, error) {
	res := &magicAuthTokenDTO{}