/*
 * SonarQube
 * Copyright (C) 2009-2023 SonarSource SA
 * mailto:info AT sonarsource DOT com
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 3 of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program; if not, write to the Free Software Foundation,
 * Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 */
package org.sonar.db.user;

import java.util.List;
import javax.annotation.CheckForNull;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.ResultHandler;
import org.sonar.db.Pagination;

public interface UserMapper {

  @CheckForNull
  UserDto selectByUuid(String uuid);

  @CheckForNull
  UserDto selectByLogin(String login);

  /**
   * Search for a user by SCM account, login or email.
   * Can return multiple results if an email is used by many users (For instance, technical account can use the same email as a none technical account)
   */
  @CheckForNull
  List<UserDto> selectNullableByScmAccountOrLoginOrEmail(@Param("scmAccount") String scmAccountOrLoginOrEmail);

  List<UserIdDto> selectActiveUsersByScmAccountOrLoginOrEmail(@Param("scmAccount") String scmAccountOrLoginOrEmail);

  /**
   * Select user by login. Note that disabled users are ignored.
   */
  @CheckForNull
  UserDto selectUserByLogin(String login);

  List<UserDto> selectUsers(@Param("query") UserQuery query, @Param("pagination") Pagination pagination);

  int countByQuery(@Param("query") UserQuery query);

  List<UserTelemetryDto> selectUsersForTelemetry();

  List<UserDto> selectByLogins(List<String> logins);

  List<UserDto> selectByUuids(List<String> uuids);

  List<UserDto> selectByEmail(String email);

  @CheckForNull
  UserDto selectByExternalIdAndIdentityProvider(@Param("externalId") String externalId, @Param("externalIdentityProvider") String externalExternalIdentityProvider);

  List<UserDto> selectByExternalIdsAndIdentityProvider(@Param("externalIds") List<String> externalIds, @Param("externalIdentityProvider") String externalExternalIdentityProvider);

  @CheckForNull
  UserDto selectByExternalLoginAndIdentityProvider(@Param("externalLogin") String externalLogin, @Param("externalIdentityProvider") String externalExternalIdentityProvider);

  List<String> selectExternalIdentityProviders();

  void scrollAll(ResultHandler<UserDto> handler);

  void updateSonarlintLastConnectionDate(@Param("login") String login, @Param("now") long now);

  void insert(@Param("user") UserDto userDto);

  void update(@Param("user") UserDto userDto);

  void deactivateUser(@Param("login") String login, @Param("now") long now);

  void clearHomepages(@Param("homepageType") String type, @Param("homepageParameter") String value, @Param("now") long now);

  void clearHomepage(@Param("login") String login, @Param("now") long now);

  long countActiveSonarlintUsers(@Param("sinceDate") long sinceDate);

  long countActiveUsers();

  void insertScmAccount(@Param("userUuid") String userUuid, @Param("scmAccount") String scmAccount);

  void deleteAllScmAccounts(@Param("userUuid") String userUuid);
}
