me.eccentric_nz.TARDIS.database

Class QueryFactory

java.lang.Object

me.eccentric_nz.TARDIS.database.QueryFactory

public class QueryFactory
extends java.lang.Object

Do basic SQL INSERT, UPDATE and DELETE queries.

Constructor Summary

Constructors

Constructor and Description
QueryFactory(TARDIS plugin)

Method Summary

Modifier and Type	Method and Description
void	addToVoid(int id) Add a TARDIS id to the thevoid table.
void	alterCondenserBlockCount(int amount, java.util.HashMap<java.lang.String,java.lang.Object> where) Removes condenser block counts from an SQLite database table.
void	alterEnergyLevel(java.lang.String table, int amount, java.util.HashMap<java.lang.String,java.lang.Object> where, org.bukkit.entity.Player p) Adds or removes Artron Energy from an SQLite database table.
boolean	claimTARDIS(org.bukkit.entity.Player player, int id) Claim an abandoned TARDIS.
void	doDelete(java.lang.String table, java.util.HashMap<java.lang.String,java.lang.Object> where) Deletes rows from an SQLite database table.
void	doInsert(java.lang.String table, java.util.HashMap<java.lang.String,java.lang.Object> data) Inserts data into an SQLite database table.
boolean	doSyncDelete(java.lang.String table, java.util.HashMap<java.lang.String,java.lang.Object> where) Deletes rows from an SQLite database table.
int	doSyncInsert(java.lang.String table, java.util.HashMap<java.lang.String,java.lang.Object> data) Inserts data into an SQLite database table.
void	doSyncUpdate(java.lang.String table, java.util.HashMap<java.lang.String,java.lang.Object> data, java.util.HashMap<java.lang.String,java.lang.Object> where) Updates data in an SQLite database table.
void	doUpdate(java.lang.String table, java.util.HashMap<java.lang.String,java.lang.Object> data, java.util.HashMap<java.lang.String,java.lang.Object> where) Updates data in an SQLite database table.
void	insertControl(int id, int type, java.lang.String l, int s) Inserts or updates data in a database table.
void	insertLocations(java.util.HashMap<java.lang.String,java.lang.Object> data, java.lang.String biome, int id) Inserts data into an SQLite database table.
void	insertSyncControl(int id, int type, java.lang.String l, int s) Inserts or updates data in a database table.
void	saveBiome(int id, java.lang.String biome) Save the biome the Police Box lands in to the current table so that it can be restored after it leaves.
void	updateCondensedBlockCount(int new_size, int id, java.lang.String block_data) Updates the Artron condenser block count for a specific block.
void	updateLocations(java.util.HashMap<java.lang.String,java.lang.Object> data, java.lang.String biome, int id) Updates data in an SQLite database table.

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryFactory

public QueryFactory(TARDIS plugin)

Method Detail

doInsert

public void doInsert(java.lang.String table,
                     java.util.HashMap<java.lang.String,java.lang.Object> data)

Inserts data into an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

table - the database table name to insert the data into.

data - a HashMap<String, Object> of table fields and values to insert.

doSyncInsert

public int doSyncInsert(java.lang.String table,
                        java.util.HashMap<java.lang.String,java.lang.Object> data)

Inserts data into an SQLite database table. This method builds a prepared SQL statement from the parameters supplied and then executes the insert.

Parameters:

table - the database table name to insert the data into.

data - a HashMap<String, Object> of table fields and values to insert.

Returns:

the primary key of the record that was inserted

doUpdate

public void doUpdate(java.lang.String table,
                     java.util.HashMap<java.lang.String,java.lang.Object> data,
                     java.util.HashMap<java.lang.String,java.lang.Object> where)

Updates data in an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

table - the database table name to update.

data - a HashMap<String, Object> of table fields and values update.

where - a HashMap<String, Object> of table fields and values to select the records to update.

doSyncUpdate

public void doSyncUpdate(java.lang.String table,
                         java.util.HashMap<java.lang.String,java.lang.Object> data,
                         java.util.HashMap<java.lang.String,java.lang.Object> where)

Updates data in an SQLite database table. This method executes the SQL on the main thread.

Parameters:

table - the database table name to update.

data - a HashMap<String, Object> of table fields and values update.

where - a HashMap<String, Object> of table fields and values to select the records to update.

doDelete

public void doDelete(java.lang.String table,
                     java.util.HashMap<java.lang.String,java.lang.Object> where)

Deletes rows from an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

table - the database table name to insert the data into.

where - a HashMap<String, Object> of table fields and values to select the records to delete.

doSyncDelete

public boolean doSyncDelete(java.lang.String table,
                            java.util.HashMap<java.lang.String,java.lang.Object> where)

Deletes rows from an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

table - the database table name to insert the data into.

where - a HashMap<String, Object> of table fields and values to select the records to delete.

Returns:

true or false depending on whether the data was deleted successfully

alterEnergyLevel

public void alterEnergyLevel(java.lang.String table,
                             int amount,
                             java.util.HashMap<java.lang.String,java.lang.Object> where,
                             org.bukkit.entity.Player p)

Adds or removes Artron Energy from an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

table - the database table name to insert the data into.

amount - the amount of energy to add or remove (use a negative value)

where - a HashMap<String, Object> of table fields and values to select the records to alter.

p - the player who receives the success message.

alterCondenserBlockCount

public void alterCondenserBlockCount(int amount,
                                     java.util.HashMap<java.lang.String,java.lang.Object> where)

Removes condenser block counts from an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

amount - the amount of blocks to remove

where - a HashMap<String, Object> of table fields and values to select the records to alter.

insertControl

public void insertControl(int id,
                          int type,
                          java.lang.String l,
                          int s)

Inserts or updates data in a database table. This method executes the SQL in a separate thread.

Parameters:

id - the database table name to insert the data into.

type - the type of control to insert.

l - the string location of the control

s - what level the control is (0 primary, 1 secondary (BAKER), 2 tertiary (WOOD))

insertSyncControl

public void insertSyncControl(int id,
                              int type,
                              java.lang.String l,
                              int s)

Inserts or updates data in a database table. This method executes the SQL in a separate thread.

Parameters:

id - the database table name to insert the data into.

type - the type of control to insert.

l - the string location of the control

s - what level the control is (0 primary, 1 secondary (BAKER), 2 tertiary (WOOD))

insertLocations

public void insertLocations(java.util.HashMap<java.lang.String,java.lang.Object> data,
                            java.lang.String biome,
                            int id)

Inserts data into an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

data - a HashMap<String, Object> of table fields and values to insert.

biome - the biome of the Police Box location

id - the tardis_id

updateLocations

public void updateLocations(java.util.HashMap<java.lang.String,java.lang.Object> data,
                            java.lang.String biome,
                            int id)

Updates data in an SQLite database table. This method executes the SQL in a separate thread.

Parameters:

data - a HashMap<String, Object> of table fields and values to update.

biome - the biome value to update

id - the tardis_id

updateCondensedBlockCount

public void updateCondensedBlockCount(int new_size,
                                      int id,
                                      java.lang.String block_data)

Updates the Artron condenser block count for a specific block.

Parameters:

new_size - the newly calculated total number of blocks condensed

id - the tardis_id of the record to update

block_data - the block_data of the record to update

saveBiome

public void saveBiome(int id,
                      java.lang.String biome)

Save the biome the Police Box lands in to the current table so that it can be restored after it leaves. This is only done if `police_box.set_biome: true` is set in the config.

Parameters:

id - the TARDIS to update

biome - the biome to save

addToVoid

public void addToVoid(int id)

Add a TARDIS id to the thevoid table.

Parameters:

id - the tardis_id to add

claimTARDIS

public boolean claimTARDIS(org.bukkit.entity.Player player,
                           int id)

Claim an abandoned TARDIS.

Parameters:

player - the claiming player

id - the TARDIS id

Returns:

true if the claim was a success