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

Class SqliteTable

java.lang.Object

io.github.mrtesz.teszcore.db.table.sqlite.SqliteTable

All Implemented Interfaces:

DBTable, Copyable<DBTable>

public class SqliteTable
extends Object
implements DBTable

Constructor Summary

Constructors

Constructor	Description
SqliteTable(String name)	Create a SqliteTable

Method Summary

Modifier and Type	Method	Description
SqliteTable	addBigInt(String name)
SqliteTable	addBigInt(String name, long def)
SqliteTable	addColumn(String columnName, String definition)	Add a column to the table
SqliteTable	addDouble(String name)
SqliteTable	addDouble(String name, double def)
SqliteTable	addFloat(String name)
SqliteTable	addFloat(String name, float def)
SqliteTable	addIndex(String indexName, String column)	Add an index
SqliteTable	addInt(String name)
SqliteTable	addInt(String name, Integer def)
SqliteTable	addLong(String name)
SqliteTable	addLong(String name, long def)
SqliteTable	addText(String name)
SqliteTable	addText(String name, String def)
SqliteTable	addUnique(String... unique)	Add a unique key constellation
SqliteTable	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
SqliteTable	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

SqliteTable

public SqliteTable(String name)

Create a SqliteTable

Parameters:

name - Name of the table

Method Details

addColumn

public SqliteTable addColumn(String columnName,
 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 SqliteTable 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 SqliteTable 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 SqliteTable addInt(String name)

Specified by:

addInt in interface DBTable

addInt

public SqliteTable addInt(String name,
 Integer def)

Specified by:

addInt in interface DBTable

addLong

public SqliteTable addLong(String name)

Specified by:

addLong in interface DBTable

addLong

public SqliteTable addLong(String name,
 long def)

Specified by:

addLong in interface DBTable

addBigInt

public SqliteTable addBigInt(String name)

Specified by:

addBigInt in interface DBTable

addBigInt

public SqliteTable addBigInt(String name,
 long def)

Specified by:

addBigInt in interface DBTable

addDouble

public SqliteTable addDouble(String name)

Specified by:

addDouble in interface DBTable

addDouble

public SqliteTable addDouble(String name,
 double def)

Specified by:

addDouble in interface DBTable

addFloat

public SqliteTable addFloat(String name)

Specified by:

addFloat in interface DBTable

addFloat

public SqliteTable addFloat(String name,
 float def)

Specified by:

addFloat in interface DBTable

addText

public SqliteTable addText(String name)

Specified by:

addText in interface DBTable

addText

public SqliteTable addText(String name,
 String def)

Specified by:

addText in interface DBTable

addIndex

public SqliteTable 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 SqliteTable 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