package com.videosambo.motimaa.cellsystem.database;

import java.sql.SQLException;

import javax.sql.DataSource;

import com.mysql.jdbc.Connection;
import com.videosambo.motimaa.cellsystem.Handler;
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

public class DBConnectionPool {

    private Handler handler;
    private static String url, user, pass;
    private static DataSource dataSource;

    public DBConnectionPool(Handler handler, String url, String user, String pass) {
        this.handler = handler;
        this.url = url;
        this.user = user;
        this.pass = pass;
    }

    public static DataSource getDataSource() {
        if(dataSource == null) {
                HikariConfig config = new HikariConfig();

        config.setJdbcUrl(url);
        config.setUsername(pass);
        config.setPassword(pass);

        config.setMaximumPoolSize(10);
        config.setAutoCommit(false);
        config.addDataSourceProperty("cachePrepStmts", "true");
        config.addDataSourceProperty("prepStmtCacheSize", "250");
        config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");

        dataSource = new HikariDataSource(config);
        }
        return dataSource;
    }

    public static Connection getConnection() {
        return (Connection) getDataSource();
    }

}