src/main/java/net/tylermurphy/hideAndSeek/database/connections/MySQLConnection.java


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

/*
 * This file is part of Kenshins Hide and Seek
 *
 * Copyright (c) 2022 Tyler Murphy.
 *
 * Kenshins Hide and Seek free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * he Free Software Foundation version 3.
 *
 * Kenshins Hide and Seek is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 *
 */

package net.tylermurphy.hideAndSeek.database.connections;

import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
import net.tylermurphy.hideAndSeek.Main;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import static net.tylermurphy.hideAndSeek.configuration.Config.*;

public class MySQLConnection implements DatabaseConnection {

    private final HikariDataSource ds;

    public MySQLConnection(){

        HikariConfig config = new HikariConfig();

        Main.getInstance().getLogger().info("Database host: " + databaseHost);
        Main.getInstance().getLogger().info("Database port: " + databasePort);
        Main.getInstance().getLogger().info("Database user: " + databaseUser);
        Main.getInstance().getLogger().info("Database pass: xxxxxxxxxxx");
        Main.getInstance().getLogger().info("Database name: " + databaseName);


        config.setDriverClassName(org.mariadb.jdbc.Driver.class.getName());
        config.setJdbcUrl("jdbc:mariadb://"+databaseHost+":"+databasePort+"/"+databaseName.trim());
        config.addDataSourceProperty("cachePrepStmts", "true");
        config.addDataSourceProperty("prepStmtCacheSize", "250");
        config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
        config.addDataSourceProperty("user", databaseUser);
        config.addDataSourceProperty("password",databasePass);
        config.addDataSourceProperty("autoCommit", "true");
        config.setAutoCommit(true);
        config.setMaximumPoolSize(20);

        ds = new HikariDataSource(config);

    }

    @Override
    public Connection connect() throws SQLException {
        return ds.getConnection();
    }

}