public class Database {

    private static HikariDataSource hikari;

    public void connect() {

        HikariConfig config = new HikariConfig();

        config.setJdbcUrl("jdbc:mysql://" + Login.address + ":" + Login.port + "/" + Login.database + "?useSSL=false");
        config.setUsername(Login.username);
        config.setPassword(Login.password);
        config.setMaximumPoolSize(Login.poolSize);

        config.addDataSourceProperty("characterEncoding", "utf8");
        config.addDataSourceProperty("useUnicode", "true");

        hikari = new HikariDataSource(config);

        setupTables();
    }

    private void setupTables() {
        String query = "CREATE TABLE IF NOT EXISTS securitysuite (uuid char(36) NOT NULL, name TEXT NOT NULL, password TEXT NOT NULL, ip INT NOT NULL, chances INT NOT NULL, online BOOLEAN NOT NULL DEFAULT false, locked BOOLEAN NOT NULL DEFAULT false)";
        updateSQL(query);
    }

    private boolean checkConnection() throws SQLException {
        return hikari != null && !hikari.isClosed();
    }

    public void updateSQL(final String query) {
        ProxyServer.getInstance().getScheduler().runAsync(Login.getInstance(), new Runnable() {
            public void run() {
                try {
                    if (!checkConnection())
                        connect();

                    hikari.getConnection().createStatement().executeUpdate(query);
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        });
    }

    public static HikariDataSource getHikari(){
        return hikari;
    }
}