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

Class MariaDBTable

java.lang.Object

io.github.mrtesz.teszcore.db.table.mariadb.MariaDBTable

All Implemented Interfaces:

DBTable, Copyable<DBTable>

public class MariaDBTable
extends Object
implements DBTable

Builder class to configure MariaDB tables

Constructor Summary

Constructors

Constructor	Description
MariaDBTable(@NotNull String name)	Create a MariaDBTable

Method Summary

Modifier and Type	Method	Description
MariaDBTable	addBigInt(@NotNull String name)
MariaDBTable	addBigInt(@NotNull String name, long def)
MariaDBTable	addBoolean(@NotNull String name)
MariaDBTable	addBoolean(@NotNull String name, boolean def)
MariaDBTable	addColumn(@NotNull String columnName, @NotNull String definition)	Add a column to the table
MariaDBTable	addDate(@NotNull String name)
MariaDBTable	addDateNow(@NotNull String name)
MariaDBTable	addDouble(@NotNull String name)
MariaDBTable	addDouble(@NotNull String name, double def)
MariaDBTable	addFloat(@NotNull String name)
MariaDBTable	addFloat(@NotNull String name, float def)
MariaDBTable	addIndex(String indexName, String column)	Add an index
MariaDBTable	addInt(@NotNull String name)
MariaDBTable	addInt(@NotNull String name, Integer def)
MariaDBTable	addLong(@NotNull String name)
MariaDBTable	addLong(@NotNull String name, long def)
MariaDBTable	addLongText(@NotNull String name)
MariaDBTable	addLongText(@NotNull String name, String def)
MariaDBTable	addMediumText(@NotNull String name)
MariaDBTable	addMediumText(@NotNull String name, String def)
MariaDBTable	addText(@NotNull String name)
MariaDBTable	addText(@NotNull String name, String def)
MariaDBTable	addTimestamp(@NotNull String name)
MariaDBTable	addTimestampNow(@NotNull String name)
MariaDBTable	addUnique(String... unique)	Add a unique key constellation
MariaDBTable	addVarchar(@NotNull String name, int length)
MariaDBTable	addVarchar(@NotNull String name, int length, String def)
MariaDBTable	copy()	Copy the executing class
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
MariaDBTable	setPrimaryKeys(String... keys)	Set the Primary Keys of the Table

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.github.mrtesz.teszcore.api.db.table.DBTable

getName

Constructor Details

MariaDBTable

public MariaDBTable(@NotNull
 @NotNull String name)

Create a MariaDBTable

Parameters:

name - Name of the table

Method Details

addColumn

public MariaDBTable addColumn(@NotNull
 @NotNull String columnName,
 @NotNull
 @NotNull String definition)

Description copied from interface: DBTable

Add a column to the table

Specified by:

addColumn in interface DBTable

Parameters:

columnName - name of the column

definition - definition in SQL

setPrimaryKeys

public MariaDBTable setPrimaryKeys(String... keys)

Description copied from interface: DBTable

Set the Primary Keys of the Table

Specified by:

setPrimaryKeys in interface DBTable

Parameters:

keys - The keys, wich should be turned into Primarys

addUnique

public MariaDBTable addUnique(String... unique)

Description copied from interface: DBTable

Add a unique key constellation

Specified by:

addUnique in interface DBTable

Parameters:

unique - The constellation of keys to make unique

addInt

public MariaDBTable addInt(@NotNull
 @NotNull String name)

Specified by:

addInt in interface DBTable

addInt

public MariaDBTable addInt(@NotNull
 @NotNull String name,
 Integer def)

Specified by:

addInt in interface DBTable

addLong

public MariaDBTable addLong(@NotNull
 @NotNull String name)

Specified by:

addLong in interface DBTable

addLong

public MariaDBTable addLong(@NotNull
 @NotNull String name,
 long def)

Specified by:

addLong in interface DBTable

addBigInt

public MariaDBTable addBigInt(@NotNull
 @NotNull String name)

Specified by:

addBigInt in interface DBTable

addBigInt

public MariaDBTable addBigInt(@NotNull
 @NotNull String name,
 long def)

Specified by:

addBigInt in interface DBTable

addDouble

public MariaDBTable addDouble(@NotNull
 @NotNull String name)

Specified by:

addDouble in interface DBTable

addDouble

public MariaDBTable addDouble(@NotNull
 @NotNull String name,
 double def)

Specified by:

addDouble in interface DBTable

addFloat

public MariaDBTable addFloat(@NotNull
 @NotNull String name)

Specified by:

addFloat in interface DBTable

addFloat

public MariaDBTable addFloat(@NotNull
 @NotNull String name,
 float def)

Specified by:

addFloat in interface DBTable

addText

public MariaDBTable addText(@NotNull
 @NotNull String name)

Specified by:

addText in interface DBTable

addText

public MariaDBTable addText(@NotNull
 @NotNull String name,
 String def)

Specified by:

addText in interface DBTable

addVarchar

public MariaDBTable addVarchar(@NotNull
 @NotNull String name,
 int length)

addVarchar

public MariaDBTable addVarchar(@NotNull
 @NotNull String name,
 int length,
 String def)

addMediumText

public MariaDBTable addMediumText(@NotNull
 @NotNull String name)

addMediumText

public MariaDBTable addMediumText(@NotNull
 @NotNull String name,
 String def)

addLongText

public MariaDBTable addLongText(@NotNull
 @NotNull String name)

addLongText

public MariaDBTable addLongText(@NotNull
 @NotNull String name,
 String def)

addBoolean

public MariaDBTable addBoolean(@NotNull
 @NotNull String name)

addBoolean

public MariaDBTable addBoolean(@NotNull
 @NotNull String name,
 boolean def)

addDate

public MariaDBTable addDate(@NotNull
 @NotNull String name)

addDateNow

public MariaDBTable addDateNow(@NotNull
 @NotNull String name)

addTimestamp

public MariaDBTable addTimestamp(@NotNull
 @NotNull String name)

addTimestampNow

public MariaDBTable addTimestampNow(@NotNull
 @NotNull String name)

addIndex

public MariaDBTable addIndex(String indexName,
 String column)

Description copied from interface: DBTable

Add an index

Specified by:

addIndex in interface DBTable

Parameters:

indexName - The name of the index

column - The column name to index

getCreateCommand

public String getCreateCommand()

Description copied from interface: DBTable

Create the SQL query to create the table

Specified by:

getCreateCommand in interface DBTable

Returns:

the SQL query to create the table

getAlterColumnsCommands

public Map<String,String> getAlterColumnsCommands()

Description copied from interface: DBTable

Create the SQL queries to alter columns of the table

Specified by:

getAlterColumnsCommands in interface DBTable

Returns:

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

getAlterIndexCommands

public Map<String,String> getAlterIndexCommands()

Description copied from interface: DBTable

Create the SQL queries to alter indexes of the table

Specified by:

getAlterIndexCommands in interface DBTable

Returns:

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

copy

public MariaDBTable copy()

Description copied from interface: Copyable

Copy the executing class

Specified by:

copy in interface Copyable<DBTable>

Returns:

a copy of the class executed in