gistfile1.md

func (u *UserRepository) ListUserName(ctx context.Context, req *repositories.ListUserRequest) ([]*models.UserModel, error) {
	qb := squirrel.Select("username").From(u.tableName).PlaceholderFormat(PlaceHolder)

	if req.Owner != "" {
		if req.Owner != "root" {
			qb = qb.Where(squirrel.Eq{"owner": req.Owner})
		}
	}

	qb = qb.OrderBy("id DESC")
	query, args, err := qb.ToSql()
	log.Error().Msg("query : " + query + " req.Owner : " + req.Owner)
	if err != nil {
		return nil, fmt.Errorf("failed to build query: %w", err)
	}

	var users []*models.UserModel
	if err = getDBFromCtx(ctx, u.db).SelectContext(ctx, &users, query, args...); err != nil {
		return nil, fmt.Errorf("failed to get list user: %w", handleError(err))
	}

	return users, nil
}