package fr.plil.sio.persistence.jdbc;
  
  import fr.plil.sio.persistence.api.Right;

  import fr.plil.sio.persistence.api.Group;

  import fr.plil.sio.persistence.api.User;
  import fr.plil.sio.persistence.api.UserService;

  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Statement;
  import javax.sql.DataSource;
  import org.slf4j.Logger;
  import org.slf4j.LoggerFactory;

  import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.stereotype.Service;
  
  @Service
  public class UserServiceJdbc implements UserService {
  
      @Autowired

      private UserRepository userRepository;

      
      @Autowired

      private GroupRepository groupRepository;

      
      @Autowired
      private RightRepository rightRepository;

      @Autowired
      private DataSource dataSource;
      
      private static final Logger logger = LoggerFactory.getLogger(UserRepository.class);
      

      @Override

      public User create(String name, String groupName) {

          if(name==null || groupName==null){

              throw new IllegalArgumentException("name cannot be null");
          }

          Group group = new Group();
          group = groupRepository.findByName(groupName);

          User user = userRepository.findByName(name);

          if(group==null){
              throw new IllegalArgumentException("group does not exist");
          }

          if(user!=null){

              throw new IllegalStateException("a user with the same name already exists");

          }
          user = new User();
          user.setName(name);

          if(group!=null)
              user.setGroup(group);

          userRepository.save(user, group);
          return user;

      }
  
      @Override

      public boolean delete(String name) {

          if(name == null){

              throw new IllegalArgumentException("name cannot be null");

          }
          User user = findByName(name);
          if(user==null){
              return false;
          }
          userRepository.delete(user.getId());
          return true;

      }
  
      @Override
      public User findByName(String name) {

          if(name==null){
              throw new IllegalArgumentException("name cannot be null");
          }
          return userRepository.findByName(name);

      }
  

      @Override
      public boolean isUserHasRight(String userName, Right right) {

          if(userName==null){

              throw new IllegalArgumentException("name cannot be null");
          }

          if(right==null){
              throw new IllegalArgumentException("right cannot be null");
          }

          if(rightRepository.findByName(right.getName()).size()==0){
              throw new IllegalArgumentException("right not in database");

          }

          return userRepository.isUserHasRight(userRepository.findByName(userName).getId(), right.getId());

      }
  }