/*
 * 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 sikd.ikonsol.ejb.session;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.annotation.PostConstruct;
import javax.ejb.Stateless;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.postgresql.copy.CopyManager;
import org.postgresql.core.BaseConnection;
import sikd.ikonsol.ejb.dao.HeaderDataKonsolidasiDao;
import sikd.ikonsol.model.HeaderDataKonsolidasi;
import sikd.ikonsol.model.RawData;
import sikd.ikonsol.model.RawDataLak;
import sikd.ikonsol.model.RawDataLpe;
import sikd.ikonsol.model.RawDataLpsal;
import sikd.sikd5.sikd5ejb.session.util.MyBatisConnectionFactory;

/**
 *
 * @author Imam Bhoim
 */
@Stateless
public class HeaderDataKonsolidasiEjbHomeImpl implements HeaderDataKonsolidasiEjbHome {

    private SqlSessionFactory sqlSessionFactory;
    private SqlSession session = null;

    private HeaderDataKonsolidasiDao dao;

    @PostConstruct
    public void init() {
        try {
            System.out.println("-------- Load MyBatis Factory IKonsol ------- ");
            sqlSessionFactory = MyBatisConnectionFactory.getSqlSessionFactoryIkonsol();
            dao = new HeaderDataKonsolidasiDao(sqlSessionFactory);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    @Override
    public List<HeaderDataKonsolidasi> findAll() {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        return dao.findAll();
    }

    @Override
    public HeaderDataKonsolidasi findByID(int id) {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        return dao.findByID(id);
    }

    @Override
    public HeaderDataKonsolidasi createNew() {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        return new HeaderDataKonsolidasi();
    }

    @Override
    public HeaderDataKonsolidasi save(HeaderDataKonsolidasi obj) {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        return dao.save(obj);
    }

    @Override
    public HeaderDataKonsolidasi findByKode(String kode) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    @Override
    public HeaderDataKonsolidasi update(HeaderDataKonsolidasi obj) {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        return dao.update(obj);
    }

    @Override
    public void delete(int id) {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        dao.deleteByID(id);
    }

    @Override
    public RawData saveImportRawdata(RawData obj) {
        return dao.saveImportRawdata(obj);

    }

    @Override
    public List<HeaderDataKonsolidasi> findByPemdaCount(int header) {
        // throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        return dao.findAllByPemdaCount(header);
    }

    @Override
    public RawDataLak saveImportRawdataLak(RawDataLak obj) {
        return dao.saveImportRawdataLak(obj);
    }

    @Override
    public RawDataLpe saveImportRawdataLpe(RawDataLpe obj) {
        return dao.saveImportRawdataLpe(obj);
    }

    @Override
    public RawDataLpsal saveImportRawdataLpsal(RawDataLpsal obj) {
        return dao.saveImportRawdataLpsal(obj);
    }

    @Override
    public List<HeaderDataKonsolidasi> findByPemdaCountLak(int header) {
        return dao.findAllByPemdaCountLak(header);
    }

    @Override
    public List<HeaderDataKonsolidasi> findByPemdaCountLpe(int header) {
        return dao.findAllByPemdaCountLpe(header);
    }

    @Override
    public List<HeaderDataKonsolidasi> findByPemdaCountLpsal(int header) {
        return dao.findAllByPemdaCountLpsal(header);
    }

    public HeaderDataKonsolidasi copyData(HeaderDataKonsolidasi obj) {
        try {
            long a = new CopyManager((BaseConnection) sqlSessionFactory.openSession().getConnection()).copyIn(
                    "COPY imported_reports FROM STDIN (FORMAT csv, HEADER)" ,
                    new BufferedReader(new FileReader("G:/AAA.csv"))
            );
        } catch (SQLException ex) {
            Logger.getLogger(HeaderDataKonsolidasiEjbHomeImpl.class.getName()).log(Level.SEVERE, null, ex);
        } catch (IOException ex) {
            Logger.getLogger(HeaderDataKonsolidasiEjbHomeImpl.class.getName()).log(Level.SEVERE, null, ex);
        }

        return obj;

    }
    
//     public static void readInputData(String inputDataFile)
//            throws FileNotFoundException, IOException, SQLException {
//        Connection connection = DriverManager.getConnection(
//                "jdbc:postgresql://localhost:5433/ikonsol", "postgres", "haromain182");
//        String sql = "COPY imported_reports FROM stdin CSV HEADER DELIMITER ','";
//        BaseConnection pgcon = (BaseConnection) SqlSessionFactory;
//        CopyManager mgr = new CopyManager(pgcon);
//        try {
//            Reader in = new BufferedReader(new FileReader(new File(inputDataFile)));
//            long rowsaffected = mgr.copyIn(sql, in);
//        } catch (SQLException ex) {
//            System.err.println(ex.getClass().getName() + ": " + ex.getMessage());
//            System.exit(0);
//        }
//    }

    @Override
    public RawData saveImportRawdataUpdate(RawData obj) {
   return dao.saveImportRawdataUpdate(obj);
}

}
