Package wtf.choco.veinminer.data

Class PersistentDataStorageMySQL

java.lang.Object

wtf.choco.veinminer.data.PersistentDataStorageSQL

wtf.choco.veinminer.data.PersistentDataStorageMySQL

All Implemented Interfaces:

PersistentDataStorage

public final class PersistentDataStorageMySQL
extends PersistentDataStorageSQL

An implementation of PersistentDataStorage for MySQL servers.

Nested Class Summary

Nested classes/interfaces inherited from interface wtf.choco.veinminer.data.PersistentDataStorage

PersistentDataStorage.Type

Constructor Summary

Constructors

Constructor	Description
PersistentDataStorageMySQL(@NotNull VeinMinerServer veinMiner, @NotNull String host, int port, @NotNull String username, @NotNull String password, @NotNull String database, @NotNull String tablePrefix)	Construct a new PersistentDataStorageMySQL.

Method Summary

Modifier and Type	Method	Description
protected @NotNull String	getCreatePlayersTableStatement()	Get the statement used to create the players table.
protected @NotNull String	getInsertPlayerDataStatement()	Get the statement used to insert a player's data into the players table.
protected @NotNull String	getSelectAllPlayerDataBatchQuery(int count)	Get the statement used to select multiple players' data from the players table.
protected @NotNull String	getSelectAllPlayerDataQuery()	Get the statement used to select all of a player's data from the players table.
@NotNull PersistentDataStorage.Type	getType()	Get the PersistentDataStorage.Type of persistent storage.
protected void	initDriver()	Initialize the SQL driver required for this implementation.
protected @NotNull Connection	openConnection()	Open a new Connection to the database.

Methods inherited from class wtf.choco.veinminer.data.PersistentDataStorageSQL

importLegacyData, init, load, load, save, save

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PersistentDataStorageMySQL

public PersistentDataStorageMySQL(@NotNull
 @NotNull VeinMinerServer veinMiner,
 @NotNull
 @NotNull String host,
 int port,
 @NotNull
 @NotNull String username,
 @NotNull
 @NotNull String password,
 @NotNull
 @NotNull String database,
 @NotNull
 @NotNull String tablePrefix)

Construct a new PersistentDataStorageMySQL.

Parameters:

veinMiner - the vein miner server

host - the server host

port - the server port

username - the username

password - the password

database - the database to use

tablePrefix - the prefix for all tables created by this implementation

Method Details

getType

@NotNull
public @NotNull PersistentDataStorage.Type getType()

Description copied from interface: PersistentDataStorage

Get the PersistentDataStorage.Type of persistent storage.

Returns:

the type

initDriver

protected void initDriver()
                   throws ClassNotFoundException

Description copied from class: PersistentDataStorageSQL

Initialize the SQL driver required for this implementation.

Specified by:

initDriver in class PersistentDataStorageSQL

Throws:

ClassNotFoundException - if the driver class could not be found

openConnection

@NotNull
protected @NotNull Connection openConnection()
                                      throws SQLException

Description copied from class: PersistentDataStorageSQL

Open a new Connection to the database.

Specified by:

openConnection in class PersistentDataStorageSQL

Returns:

a new connection

Throws:

SQLException - if an SQL exception occurred while opening the connection

getCreatePlayersTableStatement

@NotNull
protected @NotNull String getCreatePlayersTableStatement()

Description copied from class: PersistentDataStorageSQL

Get the statement used to create the players table.

Specified by:

getCreatePlayersTableStatement in class PersistentDataStorageSQL

Returns:

the create table statement

getInsertPlayerDataStatement

@NotNull
protected @NotNull String getInsertPlayerDataStatement()

Description copied from class: PersistentDataStorageSQL

Get the statement used to insert a player's data into the players table.

Specified by:

getInsertPlayerDataStatement in class PersistentDataStorageSQL

Returns:

the insert player data statement

getSelectAllPlayerDataQuery

@NotNull
protected @NotNull String getSelectAllPlayerDataQuery()

Description copied from class: PersistentDataStorageSQL

Get the statement used to select all of a player's data from the players table.

Specified by:

getSelectAllPlayerDataQuery in class PersistentDataStorageSQL

Returns:

the select player data statement

getSelectAllPlayerDataBatchQuery

@NotNull
protected @NotNull String getSelectAllPlayerDataBatchQuery(int count)

Description copied from class: PersistentDataStorageSQL

Get the statement used to select multiple players' data from the players table.

Specified by:

getSelectAllPlayerDataBatchQuery in class PersistentDataStorageSQL

Parameters:

count - the amount of players that need selecting

Returns:

the select player data statement