Package io.github.mrtesz.teszcore.api.db.table

Interface DBTable

All Superinterfaces:

Copyable<DBTable>

All Known Implementing Classes:

MariaDBTable, SqliteTable

public interface DBTable
extends Copyable<DBTable>

Method Summary

Modifier and Type	Method	Description
DBTable	addBigInt(String name)
DBTable	addBigInt(String name, long def)
DBTable	addColumn(String columnName, String definition)	Add a column to the table
DBTable	addDouble(String name)
DBTable	addDouble(String name, double def)
DBTable	addFloat(String name)
DBTable	addFloat(String name, float def)
DBTable	addIndex(String indexName, String column)	Add an index
DBTable	addInt(String name)
DBTable	addInt(String name, Integer def)
DBTable	addLong(String name)
DBTable	addLong(String name, long def)
DBTable	addText(String name)
DBTable	addText(String name, String def)
DBTable	addUnique(String... unique)	Add a unique key constellation
Map<String,String>	getAlterColumnsCommands()	Create the SQL queries to alter columns of the table
Map<String,String>	getAlterIndexCommands()	Create the SQL queries to alter indexes of the table
String	getCreateCommand()	Create the SQL query to create the table
String	getName()	Get the name of the table
DBTable	setPrimaryKeys(String... keys)	Set the Primary Keys of the Table

Methods inherited from interface io.github.mrtesz.teszcore.copyable.Copyable

copy

Method Details

getName

String getName()

Get the name of the table

Returns:

name

addColumn

DBTable addColumn(String columnName,
 String definition)

Add a column to the table

Parameters:

columnName - name of the column

definition - definition in SQL

setPrimaryKeys

DBTable setPrimaryKeys(String... keys)

Set the Primary Keys of the Table

Parameters:

keys - The keys, wich should be turned into Primarys

addUnique

DBTable addUnique(String... unique)

Add a unique key constellation

Parameters:

unique - The constellation of keys to make unique

addIndex

DBTable addIndex(String indexName,
 String column)

Add an index

Parameters:

indexName - The name of the index

column - The column name to index

addInt

DBTable addInt(String name)

addInt

DBTable addInt(String name,
 Integer def)

addLong

DBTable addLong(String name)

addLong

DBTable addLong(String name,
 long def)

addBigInt

DBTable addBigInt(String name)

addBigInt

DBTable addBigInt(String name,
 long def)

addDouble

DBTable addDouble(String name)

addDouble

DBTable addDouble(String name,
 double def)

addFloat

DBTable addFloat(String name)

addFloat

DBTable addFloat(String name,
 float def)

addText

DBTable addText(String name)

addText

DBTable addText(String name,
 String def)

getCreateCommand

String getCreateCommand()

Create the SQL query to create the table

Returns:

the SQL query to create the table

getAlterColumnsCommands

Map<String,String> getAlterColumnsCommands()

Create the SQL queries to alter columns of the table

Returns:

the SQL queries to alter the columns of the table mapped by invalid input: '<'columnName, command>

getAlterIndexCommands

Map<String,String> getAlterIndexCommands()

Create the SQL queries to alter indexes of the table

Returns:

the SQL queries to alter the indexes of the table mapped by invalid input: '<'indexName, command>