Package generalDatabase.sqlite

Class SqliteSQLTypes

java.lang.Object

generalDatabase.SQLTypes

generalDatabase.sqlite.SqliteSQLTypes

public class SqliteSQLTypes
extends SQLTypes

Field Summary

Fields

Modifier and Type	Field	Description
static final org.sqlite.SQLiteConfig.DateClass	dateClass

Constructor Summary

Constructors

Constructor	Description
SqliteSQLTypes()

Method Summary

Modifier and Type	Method	Description
String	formatColumnName(String columnName)	Format the column name.
String	formatDateTimeMatchString(long timeMilliseconds)	Allow slightly different formatting when we're trying to get an exact match of a milliseconds time.
String	formatDBDateTimeQueryString(long timeMilliseconds)	Format the time for insertion into a WHERE %s BETWEEN %s clause, mostly used by the Viewer.
Object	getTimeStamp(Long timeMillis)	Get a time object in the appropriate format for whichever database we're using.
int	systemSqlType(int sqlType)	Some SQL types are unavailable on some systems, so qutomatically swap them for something else.
String	typeToString(int sqlType, int length, boolean counter)

Methods inherited from class generalDatabase.SQLTypes

createTableItem, formatColumnName, formatTableName, getLocalTimeStamp, getLongValue, isAllowBlanks, makeDouble, makeDouble, makeFloat, makeFloat, makeInList, millisFromTimeStamp, setAllowBlanks, stringToLength, stringToType, typeToString, typeToString

Methods inherited from class java.lang.Object

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

Field Details

dateClass

public static final org.sqlite.SQLiteConfig.DateClass dateClass

Constructor Details

SqliteSQLTypes

public SqliteSQLTypes()

Method Details

typeToString

public String typeToString(int sqlType,
 int length,
 boolean counter)

Overrides:

typeToString in class SQLTypes

formatColumnName

public String formatColumnName(String columnName)

Description copied from class: SQLTypes

Format the column name. Formats may be slightly different for different DBMS's. e.g. MS Access can put quotes around names. OODB requires them to be all upper case, etc.

Overrides:

formatColumnName in class SQLTypes

Parameters:

columnName -

Returns:

formatted column name.

systemSqlType

public int systemSqlType(int sqlType)

Description copied from class: SQLTypes

Some SQL types are unavailable on some systems, so qutomatically swap them for something else.

Overrides:

systemSqlType in class SQLTypes

Parameters:

sqlType -

Returns:

getTimeStamp

public Object getTimeStamp(Long timeMillis)

Description copied from class: SQLTypes

Get a time object in the appropriate format for whichever database we're using.

Overrides:

getTimeStamp in class SQLTypes

Parameters:

timeMillis - Time in milliseconds.

Returns:

Appropriate object (Generally TimeStamp, but SWLite uses Long)

formatDBDateTimeQueryString

public String formatDBDateTimeQueryString(long timeMilliseconds)

Description copied from class: SQLTypes

Format the time for insertion into a WHERE %s BETWEEN %s clause, mostly used by the Viewer. This has been wrapped here so that we can support a different format for SQLLite

Overrides:

formatDBDateTimeQueryString in class SQLTypes

Parameters:

timeMilliseconds - Time in milliseconds

Returns:

String to insert into a where clause.

formatDateTimeMatchString

public String formatDateTimeMatchString(long timeMilliseconds)

Description copied from class: SQLTypes

Allow slightly different formatting when we're trying to get an exact match of a milliseconds time.

Overrides:

formatDateTimeMatchString in class SQLTypes

Parameters:

timeMilliseconds - time in milliseconds.

Returns:

formatted time string.