Package me.lorenzo0111.pluginslib.database.objects

Class Table

java.lang.Object

me.lorenzo0111.pluginslib.database.objects.Table

public class Table
extends Object

SQL Table

Constructor Summary

Constructors

Constructor	Description
Table(IScheduler scheduler, Connection connection, String name, List<Column> columns)	Deprecated. Use Table(IScheduler, IConnectionHandler, String, List)
Table(IScheduler scheduler, IConnectionHandler connection, String name, List<Column> columns)

Method Summary

Modifier and Type	Method	Description
void	add(DatabaseSerializable serializable)	Add a DatabaseSerializable to the table
CompletableFuture<ResultSet>	all()	Get all items from table
void	clear()	Clear the table
CompletableFuture<List<DatabaseSerializable>>	convertResult(ResultSet set, DatabaseSerializable serializable)	Convert a ResultSet to a Database Serializable
void	create()	Create the table in the database
CompletableFuture<ResultSet>	find(String key, Object value)	Find something inside the table
List<Column>	getColumns()
Connection	getConnection()
String	getName()
CompletableFuture<Integer>	removeWhere(String key, Object value)	Remove something from the table
CompletableFuture<Integer>	removeWhere(String key, DatabaseSerializable serializable)	Remove something from the table
void	run(Runnable runnable)	Run something async

Methods inherited from class java.lang.Object

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

Constructor Details

Table

@Deprecated
public Table(IScheduler scheduler,
 Connection connection,
 String name,
 List<Column> columns)

Deprecated.

Use Table(IScheduler, IConnectionHandler, String, List)

Parameters:

scheduler - Scheduler

connection - SQL Connection

name - Name of the table

columns - List of columns

See Also:

• Column

Table

public Table(IScheduler scheduler,
 IConnectionHandler connection,
 String name,
 List<Column> columns)

Method Details

create

public void create()

Create the table in the database

convertResult

public CompletableFuture<List<DatabaseSerializable>> convertResult(ResultSet set,
 DatabaseSerializable serializable)

Convert a ResultSet to a Database Serializable

Parameters:

set - ResultSet to convert

serializable - an instance of a serializable that has the DatabaseSerializable.from(Map) method

Returns:

A future with a list of serializable

all

public CompletableFuture<ResultSet> all()

Get all items from table

Returns:

a result set with all the entries of the table

add

public void add(DatabaseSerializable serializable)

Add a DatabaseSerializable to the table

Parameters:

serializable - Item to add to the table

clear

public void clear()

Clear the table

removeWhere

public CompletableFuture<Integer> removeWhere(String key,
 Object value)

Remove something from the table

Parameters:

key - key to find

value - Value of the key

Returns:

A completable future with the amount of the affected tables

removeWhere

public CompletableFuture<Integer> removeWhere(String key,
 DatabaseSerializable serializable)

Remove something from the table

Parameters:

key - key to find

serializable - serializable that contains the key

Returns:

A completable future with the amount of the affected tables

find

public CompletableFuture<ResultSet> find(String key,
 Object value)

Find something inside the table

Parameters:

key - Key to find

value - Value to find

Returns:

A ResultSet

run

public void run(Runnable runnable)

Run something async

Parameters:

runnable - Runnable to run

getName

public String getName()

Returns:

Name of the table

getConnection

public Connection getConnection()
                         throws SQLException

Returns:

Connection

Throws:

SQLException - if something goes wrong

getColumns

public List<Column> getColumns()

Returns:

Table columns