diff options
Diffstat (limited to 'src/main/java/net/tylermurphy/hideAndSeek/database/connections')
3 files changed, 0 insertions, 159 deletions
diff --git a/src/main/java/net/tylermurphy/hideAndSeek/database/connections/DatabaseConnection.java b/src/main/java/net/tylermurphy/hideAndSeek/database/connections/DatabaseConnection.java deleted file mode 100644 index 466bda5..0000000 --- a/src/main/java/net/tylermurphy/hideAndSeek/database/connections/DatabaseConnection.java +++ /dev/null @@ -1,29 +0,0 @@ -/* - * 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 java.sql.Connection; -import java.sql.SQLException; - -public interface DatabaseConnection { - - Connection connect() throws SQLException; - -} diff --git a/src/main/java/net/tylermurphy/hideAndSeek/database/connections/MySQLConnection.java b/src/main/java/net/tylermurphy/hideAndSeek/database/connections/MySQLConnection.java deleted file mode 100644 index 20e7c8e..0000000 --- a/src/main/java/net/tylermurphy/hideAndSeek/database/connections/MySQLConnection.java +++ /dev/null @@ -1,66 +0,0 @@ -/* - * 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 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(); - } - -} diff --git a/src/main/java/net/tylermurphy/hideAndSeek/database/connections/SQLiteConnection.java b/src/main/java/net/tylermurphy/hideAndSeek/database/connections/SQLiteConnection.java deleted file mode 100644 index bbf330b..0000000 --- a/src/main/java/net/tylermurphy/hideAndSeek/database/connections/SQLiteConnection.java +++ /dev/null @@ -1,64 +0,0 @@ -/* - * 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 net.tylermurphy.hideAndSeek.Main; -import org.sqlite.SQLiteConfig; - -import java.io.File; -import java.sql.Connection; -import java.sql.DriverManager; -import java.sql.SQLException; - -public class SQLiteConnection implements DatabaseConnection { - - private final File databaseFile; - private final SQLiteConfig config; - - public SQLiteConnection(){ - - try { - Class.forName("org.sqlite.JDBC"); - } catch (ClassNotFoundException e) { - Main.getInstance().getLogger().severe(e.getMessage()); - throw new RuntimeException(e.getMessage()); - } - - databaseFile = new File(Main.getInstance().getDataFolder(), "database.db"); - - config = new SQLiteConfig(); - config.setSynchronous(SQLiteConfig.SynchronousMode.NORMAL); - config.setTempStore(SQLiteConfig.TempStore.MEMORY); - } - - @Override - public Connection connect() { - Connection conn = null; - try { - String url = "jdbc:sqlite:"+databaseFile.getPath(); - conn = DriverManager.getConnection(url, config.toProperties()); - } catch (SQLException e) { - Main.getInstance().getLogger().severe(e.getMessage()); - e.printStackTrace(); - } - return conn; - } - -} |