package com.enlight.yaadle.uplift.user;

import java.security.NoSuchAlgorithmException;
import java.security.spec.InvalidKeySpecException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import java.util.UUID;

//import javax.swing.tree.RowMapper;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.security.core.GrantedAuthority;
import org.springframework.security.core.userdetails.UserDetails;
import org.springframework.security.core.userdetails.UserDetailsService;
import org.springframework.security.core.userdetails.UsernameNotFoundException;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import com.enlight.yaadle.uplift.security.StrongPassImpl;
import com.enlight.yaadle.uplift.user.User;

@Component
public class UserDaoImpl implements UserDao,UserDetailsService {

    private final Logger logger = LoggerFactory.getLogger(UserDaoImpl.class);

      @Autowired
      JdbcTemplate jdbcTemplate;

      public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {  this.jdbcTemplate = jdbcTemplate;     }
      public JdbcTemplate jdbcTemplate() {  return jdbcTemplate;   }


      public void register(User user) {
            final String CREATE_USER = "INSERT INTO USERS (username, displayname, email, password, id,enabled) VALUES (?, ?, ?, ? , ?, ?)";

            UUID uuid = UUID.randomUUID();String randomUUIDString = uuid.toString();String id=randomUUIDString;

            try {
                String hashPass = StrongPassImpl.generateHash(user.getPassword());
                int status = jdbcTemplate.update(CREATE_USER,user.getEmail(),user.getUsername(),user.getEmail(),hashPass,id,false);
                //logger.info(hashPass);
                logger.info("User Updated status: "+ status + "nDisplay UserName: "+ user.getUsername() + "nDisplay Email: "+ user.getEmail() +
                        "nDisplay Password: "+ user.getPassword()+  "nDisplay Id:" + id   );

            } catch (NoSuchAlgorithmException e) { e.printStackTrace();}
              catch (InvalidKeySpecException e)  { e.printStackTrace();}
        }

        public User findUserByEmail(User login) {
            logger.info("I am inside findbyemail");
            final String sql = "SELECT EMAIL,PASSWORD FROM USERS WHERE USERNAME='" + login.getUsername() +"'";
            logger.info("Query made " + sql);

            User principal=jdbcTemplate.queryForObject(sql, new UserRowMapper());
            logger.info("Query made " + principal.getUsername());

            return principal;

            }

public class UserRowMapper implements RowMapper<User>
 {
    public User mapRow(ResultSet rs, int rowNum) throws SQLException {
    logger.info("I am inside mapper");
    User user = new User();
    user.setPassword(rs.getString("password"));
    user.setUsername(rs.getString("username"));
    return user;
}
}

        @Override
        public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
            return null;
        }

        @Override
        public User loadUserByUsername(User login) {
            // TODO Auto-generated method stub
            return null;
        }


        }