/*
 * SonarQube
 * Copyright (C) 2009-2025 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.provisioning;

import java.util.Set;
import org.junit.jupiter.api.Test;
import org.junit.jupiter.api.extension.RegisterExtension;
import org.sonar.db.DbSession;
import org.sonar.db.DbTester;
import org.sonar.db.user.GroupDao;
import org.sonar.db.user.GroupDto;

import static org.assertj.core.api.Assertions.assertThat;

class GithubOrganizationGroupDaoIT {

  private static final String GROUP_UUID = "uuid";
  private static final String ORG_NAME = "org1";

  @RegisterExtension
  private final DbTester db = DbTester.create();

  private final DbSession dbSession = db.getSession();

  private final GroupDao groupDao = db.getDbClient().groupDao();

  private final GithubOrganizationGroupDao underTest = db.getDbClient().githubOrganizationGroupDao();

  @Test
  void insert_savesGithubOrganizationGroup() {
    GroupDto groupDto = insertGroup(GROUP_UUID);
    GithubOrganizationGroupDto githubOrganizationGroupDto = createGithubOrganizationGroupDto(groupDto.getUuid(), ORG_NAME);

    underTest.insert(dbSession, githubOrganizationGroupDto);

    GithubOrganizationGroupDto savedGithubOrganizationGroup = underTest.selectByGroupUuid(dbSession, GROUP_UUID).orElseThrow();
    assertThat(savedGithubOrganizationGroup.organizationName()).isEqualTo(ORG_NAME);
    assertThat(savedGithubOrganizationGroup.groupUuid()).isEqualTo(GROUP_UUID);
  }

  @Test
  void selectByGroupUuid_shouldReturnGithubOrganizationGroup() {
    GroupDto groupDto = insertGroup(GROUP_UUID);
    insertGroup("another group");
    GithubOrganizationGroupDto githubOrganizationGroupDto = createGithubOrganizationGroupDto(groupDto.getUuid(), ORG_NAME);
    underTest.insert(dbSession, githubOrganizationGroupDto);

    GithubOrganizationGroupDto savedGithubOrganizationGroup = underTest.selectByGroupUuid(dbSession, GROUP_UUID).orElseThrow();

    assertThat(savedGithubOrganizationGroup.organizationName()).isEqualTo(ORG_NAME);
    assertThat(savedGithubOrganizationGroup.groupUuid()).isEqualTo(GROUP_UUID);
    assertThat(savedGithubOrganizationGroup.getNameOrThrow()).isEqualTo(groupDto.getName());
  }

  @Test
  void findAll_shouldReturnAllGithubOrganizationGroup() {
    insertGroup("another group");
    GroupDto groupDto = insertGroup(GROUP_UUID);
    GithubOrganizationGroupDto githubOrganizationGroupDto = createGithubOrganizationGroupDto(groupDto.getUuid(), ORG_NAME);
    underTest.insert(dbSession, githubOrganizationGroupDto);
    GroupDto groupDto2 = insertGroup(GROUP_UUID + "2");
    GithubOrganizationGroupDto githubOrganizationGroupDto2 = createGithubOrganizationGroupDto(groupDto2.getUuid(), ORG_NAME + "2");
    underTest.insert(dbSession, githubOrganizationGroupDto2);

    Set<GithubOrganizationGroupDto> all = underTest.findAll(dbSession);

    assertThat(all).hasSize(2)
      .containsExactlyInAnyOrder(
        new GithubOrganizationGroupDto(githubOrganizationGroupDto.groupUuid(), githubOrganizationGroupDto.organizationName(),
          groupDto.getName()),
        new GithubOrganizationGroupDto(githubOrganizationGroupDto2.groupUuid(), githubOrganizationGroupDto2.organizationName(),
          groupDto2.getName()));
  }

  @Test
  void deleteByGroupUuid_shouldDeleteCorrectGroup() {
    GroupDto groupDto = insertGroup(GROUP_UUID);
    GithubOrganizationGroupDto githubOrganizationGroupDto = createGithubOrganizationGroupDto(groupDto.getUuid(), ORG_NAME);
    underTest.insert(dbSession, githubOrganizationGroupDto);
    GroupDto groupDto2 = insertGroup(GROUP_UUID + "2");
    GithubOrganizationGroupDto githubOrganizationGroupDto2 = createGithubOrganizationGroupDto(groupDto2.getUuid(), ORG_NAME + "2");
    underTest.insert(dbSession, githubOrganizationGroupDto2);

    underTest.deleteByGroupUuid(dbSession, githubOrganizationGroupDto.groupUuid());

    assertThat(underTest.selectByGroupUuid(dbSession, githubOrganizationGroupDto.groupUuid())).isEmpty();
    assertThat(underTest.selectByGroupUuid(dbSession, githubOrganizationGroupDto2.groupUuid())).isPresent();
  }

  @Test
  void deleteAll_shouldDeleteEverything() {
    GroupDto groupDto = insertGroup(GROUP_UUID);
    GithubOrganizationGroupDto githubOrganizationGroupDto = createGithubOrganizationGroupDto(groupDto.getUuid(), ORG_NAME);
    underTest.insert(dbSession, githubOrganizationGroupDto);

    GroupDto groupDto2 = insertGroup(GROUP_UUID + "2");
    GithubOrganizationGroupDto githubOrganizationGroupDto2 = createGithubOrganizationGroupDto(groupDto2.getUuid(), ORG_NAME + "2");
    underTest.insert(dbSession, githubOrganizationGroupDto2);

    underTest.deleteAll(dbSession);

    assertThat(underTest.findAll(dbSession)).isEmpty();
  }

  private GroupDto insertGroup(String groupUuid) {
    GroupDto group = new GroupDto();
    group.setUuid(groupUuid);
    group.setName("name" + groupUuid);
    return groupDao.insert(dbSession, group);
  }

  private static GithubOrganizationGroupDto createGithubOrganizationGroupDto(String groupUuid, String organizationName) {
    return new GithubOrganizationGroupDto(groupUuid, organizationName);
  }

}