Package com.djrapitops.plan.storage.database.sql.building

Class Sql

java.lang.Object

com.djrapitops.plan.storage.database.sql.building.Sql

Direct Known Subclasses:

Sql.MySQL, Sql.SQLite

public abstract class Sql
extends Object

Duplicate String reducing utility class for SQL language Strings.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	Sql.MySQL
static class	Sql.SQLite

Field Summary

Fields

Modifier and Type	Field	Description
static final String	AND
static final String	BOOL
static final String	DELETE_FROM
static final String	DISTINCT
static final String	DOUBLE
static final String	FROM
static final String	GROUP_BY
static final String	ID
static final String	INNER_JOIN
static final String	INT
static final String	IS_NOT_NULL
static final String	IS_NULL
static final String	LEFT_JOIN
static final String	LIMIT
static final String	LONG
static final String	OFFSET
static final String	OR
static final String	ORDER_BY
static final String	P_UUID
static final String	SELECT
static final String	TEXT
static final String	UNION
static final String	UNION_ALL
static final String	WHERE

Constructor Summary

Constructors

Constructor	Description
Sql()

Method Summary

Modifier and Type	Method	Description
static String	concat(DBType dbType, String one, String two)
abstract String	dateToDayOfWeek(String sql)
abstract String	dateToDayStamp(String sql)
abstract String	dateToEpochSecond(String sql)
abstract String	dateToHour(String sql)
abstract String	dateToHourStamp(String sql)
abstract String	epochSecondToDate(String sql)
static String	floor(String expression)
static long	getDayEpochMs(int day)	Turn day of week to epoch ms.
abstract String	insertOrIgnore()
static String	max(String expression)
static String	min(String expression)
static String	nParameters(int n)
static void	setDoubleOrNull(PreparedStatement statement, int index, Double value)
static void	setStringOrNull(PreparedStatement statement, int index, String value)
static String	varchar(int length)

Methods inherited from class java.lang.Object

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

Field Details

ID

public static final String ID

See Also:

• Constant Field Values

P_UUID

public static final String P_UUID

See Also:

• Constant Field Values

INT

public static final String INT

See Also:

• Constant Field Values

DOUBLE

public static final String DOUBLE

See Also:

• Constant Field Values

LONG

public static final String LONG

See Also:

• Constant Field Values

BOOL

public static final String BOOL

See Also:

• Constant Field Values

SELECT

public static final String SELECT

See Also:

• Constant Field Values

DISTINCT

public static final String DISTINCT

See Also:

• Constant Field Values

FROM

public static final String FROM

See Also:

• Constant Field Values

DELETE_FROM

public static final String DELETE_FROM

See Also:

• Constant Field Values

WHERE

public static final String WHERE

See Also:

• Constant Field Values

GROUP_BY

public static final String GROUP_BY

See Also:

• Constant Field Values

ORDER_BY

public static final String ORDER_BY

See Also:

• Constant Field Values

INNER_JOIN

public static final String INNER_JOIN

See Also:

• Constant Field Values

LEFT_JOIN

public static final String LEFT_JOIN

See Also:

• Constant Field Values

UNION

public static final String UNION

See Also:

• Constant Field Values

UNION_ALL

public static final String UNION_ALL

See Also:

• Constant Field Values

AND

public static final String AND

See Also:

• Constant Field Values

OR

public static final String OR

See Also:

• Constant Field Values

IS_NULL

public static final String IS_NULL

See Also:

• Constant Field Values

IS_NOT_NULL

public static final String IS_NOT_NULL

See Also:

• Constant Field Values

LIMIT

public static final String LIMIT

See Also:

• Constant Field Values

OFFSET

public static final String OFFSET

See Also:

• Constant Field Values

TEXT

public static final String TEXT

See Also:

• Constant Field Values

Constructor Details

Sql

public Sql()

Method Details

nParameters

public static String nParameters(int n)

varchar

public static String varchar(int length)

floor

public static String floor(String expression)

min

public static String min(String expression)

max

public static String max(String expression)

getDayEpochMs

public static long getDayEpochMs(int day)

Turn day of week to epoch ms.

1st of January 1970 (Epoch) is Thursday (-2).

Parameters:

day - 1 = Sunday, 2 = Monday etc.. 7 = Saturday

Returns:

Milliseconds since epoch for this day to be given by SimpleDateFormat "EEEE"

setStringOrNull

public static void setStringOrNull(PreparedStatement statement,
 int index,
 String value)
                            throws SQLException

Throws:

SQLException

setDoubleOrNull

public static void setDoubleOrNull(PreparedStatement statement,
 int index,
 Double value)
                            throws SQLException

Throws:

SQLException

concat

public static String concat(DBType dbType,
 String one,
 String two)

epochSecondToDate

public abstract String epochSecondToDate(String sql)

dateToEpochSecond

public abstract String dateToEpochSecond(String sql)

dateToDayStamp

public abstract String dateToDayStamp(String sql)

dateToHourStamp

public abstract String dateToHourStamp(String sql)

dateToDayOfWeek

public abstract String dateToDayOfWeek(String sql)

dateToHour

public abstract String dateToHour(String sql)

insertOrIgnore

public abstract String insertOrIgnore()