Class Sql.SQLite

java.lang.Object

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

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

Enclosing class:

Sql

public static class Sql.SQLite
extends Sql

Nested Class Summary

Nested classes/interfaces inherited from class Sql

Sql.MySQL, Sql.SQLite

Field Summary

Fields inherited from class Sql

AND, BOOL, DELETE_FROM, DISTINCT, DOUBLE, FROM, GROUP_BY, ID, INNER_JOIN, INSERT_INTO, INT, IS_NOT_NULL, IS_NULL, LEFT_JOIN, LIMIT, LIMIT_1, LONG, OFFSET, OR, ORDER_BY, P_UUID, SELECT, SET, TEXT, UNION, UNION_ALL, UPDATE, WHERE

Constructor Summary

Constructors

Constructor	Description
SQLite()

Method Summary

Modifier and Type	Method	Description
String	dateToDayOfWeek(String sql)
String	dateToDayStamp(String sql)
String	dateToEpochSecond(String sql)
String	dateToHour(String sql)
String	dateToHourStamp(String sql)
String	epochSecondToDate(String sql)
String	greatest(String values)
String	insertOrIgnore()
String	least(String values)

Methods inherited from class Sql

concat, floor, getDayEpochMs, getDoubleOrNull, getIntOrNull, lockForUpdate, max, min, nParameters, setDoubleOrNull, setIntOrNull, setStringOrNull, varchar

Methods inherited from class Object

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

Constructor Details

SQLite

public SQLite()

Method Details

epochSecondToDate

public String epochSecondToDate(String sql)

Specified by:

epochSecondToDate in class Sql

dateToEpochSecond

public String dateToEpochSecond(String sql)

Specified by:

dateToEpochSecond in class Sql

dateToDayStamp

public String dateToDayStamp(String sql)

Specified by:

dateToDayStamp in class Sql

dateToHourStamp

public String dateToHourStamp(String sql)

Specified by:

dateToHourStamp in class Sql

dateToDayOfWeek

public String dateToDayOfWeek(String sql)

Specified by:

dateToDayOfWeek in class Sql

dateToHour

public String dateToHour(String sql)

Specified by:

dateToHour in class Sql

insertOrIgnore

public String insertOrIgnore()

Specified by:

insertOrIgnore in class Sql

least

public String least(String values)

Specified by:

least in class Sql

greatest

public String greatest(String values)

Specified by:

greatest in class Sql