/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package fr.plil.sio.persistence.jdbc;

import java.util.List;
import java.util.ArrayList;
import fr.plil.sio.persistence.api.Group;
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 fr.plil.sio.persistence.api.Right;
import org.springframework.stereotype.Repository;

@Repository
public class RightRepositoryJdbc implements RightRepository {
    
    private GroupRepository groupRepository;
    
    private RightRepository rightRepository;
    
     private static final Logger logger = LoggerFactory.getLogger(GroupRepository.class);

    @Autowired
    private DataSource dataSource;
    
    @Override
    public List<Right> findByName(String name) {
        Statement stmt = null;
        ResultSet rs = null;
        try {
            stmt = dataSource.getConnection().createStatement();
            rs = stmt.executeQuery("SELECT * FROM RIGHT_T WHERE NAME_R = \'" + name + "\'");
            ArrayList<Right> list = new ArrayList<Right>();
            while (rs.next()) {
                logger.debug("found group " + name);
                Right right = new Right();
                right.setId(rs.getLong("RIGHT_ID"));
                right.setName(rs.getString("NAME_R"));
                if(right!=null){
                    list.add(right);
                }
            }
            return list;
        } catch (SQLException e) {
            throw new UnsupportedOperationException("sql exception", e);
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
            } catch (SQLException e) {
                throw new UnsupportedOperationException("sql exception during close", e);

            }
        }
    }
    
    @Override
    public Right findOne(Long id){
        Statement stmt = null;
        ResultSet rs = null;
        try {
            stmt = dataSource.getConnection().createStatement();
            rs = stmt.executeQuery("SELECT * FROM RIGHT_T WHERE RIGHT_ID = \'" + id + "\' LIMIT 1");

            if (rs.next()) {
                logger.debug("found id " + id);
                Right right = new Right();
                right.setId(rs.getLong("RIGHT_ID"));
                right.setName(rs.getString("NAME_R"));
                return right;
            }

        } catch (SQLException e) {
            throw new UnsupportedOperationException("sql exception", e);
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
            } catch (SQLException e) {
                throw new UnsupportedOperationException("sql exception during close", e);

            }
        }
        return null;
    }

    @Override
    public void save(Right right, int parentId) {
        Statement stmt = null;
        ResultSet rs = null;
        try {
            stmt = dataSource.getConnection().createStatement();
            
            stmt.executeUpdate("INSERT INTO RIGHT_T (NAME_R, PARENT_ID) VALUES (\'" + right.getName() + "\', "+ parentId +")",
                    Statement.RETURN_GENERATED_KEYS);
  
            rs = stmt.getGeneratedKeys();
            if (rs.next()) {
                right.setId(rs.getLong(1));
            } else {
                throw new UnsupportedOperationException("default in key access");
            }
        } catch (SQLException e) {
            throw new UnsupportedOperationException("sql exception", e);
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
            } catch (SQLException e) {
                throw new UnsupportedOperationException("sql exception during close", e);
            }
        }

    }

    @Override
    public boolean delete(Long id) {
        Statement stmt = null;
        ResultSet rs = null;
        if(id==null){
             return false;
        }
        if(findOne(id)==null){
             throw new IllegalArgumentException("droit inexistant");
        }
        try {
            stmt = dataSource.getConnection().createStatement();
            stmt.execute("DELETE FROM RIGHT_T WHERE RIGHT_ID = \'" + id + "\' OR PARENT_ID = " + id + "");
        } catch (SQLException e) {
            throw new UnsupportedOperationException("sql exception", e);
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
            } catch (SQLException e) {
                throw new UnsupportedOperationException("sql exception during close", e);
            }
        }
        return true;
    }
}