package iad.dataAccess;

import iad.beans.CheckBean;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;

import java.util.ArrayList;

public class DBService {
    private static DBService instance;
    private final SessionFactory sessionFactory;

    public static DBService getInstance() {
        if (instance == null) {
            instance = new DBService();
        }

        return instance;
    }

    public DBService() {
        Configuration configuration = getConfiguration();
        sessionFactory = createSessionFactory(configuration);
    }

    private Configuration getConfiguration() {
        Configuration configuration = new Configuration();
        configuration.addAnnotatedClass(CheckBean.class);
        configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
        configuration.setProperty("hibernate.connection.driver_class", "com.mysql.cj.jdbc.Driver");
        configuration.setProperty("hibernate.connection.url", "jdbc:mysql://localhost/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC");
        configuration.setProperty("hibernate.connection.username", "root");
        configuration.setProperty("hibernate.connection.password", "");
        configuration.setProperty("hibernate.hbm2ddl.auto", "update");
        return configuration;
    }


    public ArrayList<CheckBean> getChecks() {
            Session session = sessionFactory.openSession();
            CheckDAO dao = new CheckDAO(session);
        ArrayList<CheckBean> dataSet = dao.getChecks();
            session.close();
            return dataSet;

    }

    public void addCheck(CheckBean CheckBean) {
            Session session = sessionFactory.openSession();
            Transaction transaction = session.beginTransaction();
            CheckDAO dao = new CheckDAO(session);
        dao.addCheck(CheckBean);
            transaction.commit();
            session.close();
    }

    private static SessionFactory createSessionFactory(Configuration configuration) {
        StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder();
        builder.applySettings(configuration.getProperties());
        ServiceRegistry serviceRegistry = builder.build();
        return configuration.buildSessionFactory(serviceRegistry);
    }

}