com.sage.orion.sdata.servlet.swtservice
Class TestJDBCResourceKindImpl

java.lang.Object
  com.sage.orion.sdata.servlet.JDBCResourceKind
      com.sage.orion.sdata.servlet.swtservice.TestJDBCResourceKindImpl

All Implemented Interfaces:

ResourceKind

public class TestJDBCResourceKindImpl
extends JDBCResourceKind

A test JDBC ResourceKind implementor which handles request for the DB table TSFLAT

Nested Class Summary

Nested classes/interfaces inherited from class com.sage.orion.sdata.servlet.JDBCResourceKind

JDBCResourceKind.HTTPMethodsAuthorizator, JDBCResourceKind.ResourceAuthorizator, JDBCResourceKind.ResourceDataAuthorizator

Field Summary

Fields inherited from class com.sage.orion.sdata.servlet.JDBCResourceKind

ADD, ALTER_TABLE, AND, CLOSE_BRACE, COMMA, CONSTRAINT, DEFAULT, DEFAULT_LANGUAGE_CODE, DELETE_FROM, DROP, DROP_TABLE, FROM, NOT_NULL, OPEN_BRACE, PRIMARY_KEY, SELECT, UICONTENT_SQL_SELECT_STMT, VARCHAR_50, WHERE

Constructor Summary

TestJDBCResourceKindImpl(ApplicationContext context, ConnectionPool connectionPool, java.lang.String authToken)
Constructor

Method Summary

protected java.util.List<FieldDefinition>	getAllFields() returns a list of FieldDefinitions in the ResourceKind
protected java.lang.String	getCalculateFieldValue(java.lang.String value, SDataRequest request, java.sql.ResultSet resultSet, int fieldIndex) Get the value of the calculated field, if it is a regular (non-calculated) field then the original value will be returned unchanged
protected java.util.ArrayList<java.lang.String>	getIncludeColumns() Get the columns of the JDBC table that needs to be included
java.lang.String	getName()
protected java.lang.String[]	getPrimaryKey() Get the primary key of the underlying JDBC table for which one JDBCResourceKindImpl is created
protected java.lang.String	getTableName() Get the JDBC table name for which ResourceKindImpl is created
boolean	isUserSpecificResource() Indicates whether the resource is user specific or not.
protected boolean	supportDelete() Indicates whether the ResourceKind in general supports DELETE or not.
protected boolean	supportGet() Indicates whether the ResourceKind in general supports GET or not.
protected boolean	supportPost() Indicates whether the ResourceKind in general supports POST or not.
protected boolean	supportPut() Indicates whether the ResourceKind in general supports PUT or not.

Methods inherited from class com.sage.orion.sdata.servlet.JDBCResourceKind

addCompanyIDField, addRecordsForAllCompanies, buildUserFilter, canDelete, canDeleteOnData, canGet, canGetOnData, canPost, canPostOnData, canPut, canPutOnData, createPreparedEntryGetStatement, doDelete, doGet, doPost, doPut, doSchema, doTemplate, fillResultSetResourceElement, findUIContentTextValueInDB, focusOnResultSet, freeConnection, getApplicationContext, getAuthToken, getCaseInsensitiveColumns, getColumnNamesFromList, getCompanyIDField, getCompanyIDForFilter, getConnection, getCurrentRequest, getCurrentUser, getCustomizedQuery, getDatabaseType, getDefaultFeedCount, getFieldData, getFieldSchemaIdentity, getFieldSchemaName, getFieldSchemaType, getInstance, getKeyValueForKeyName, getMaxFeedCount, getOrderByClause, getOrderByClauseForKeyField, getPreparedStatement, getQueryStringForParam, getResourceKindFieldsCount, getResultRecordAndCreateResponse, getSchema, getTemplate, getTransText, getUserIDField, getUserIDForFilter, handleRequest, maintainTable, moveRecordPointerToKeyInURL, requiresCompanyIdInjection, requiresSignon, requiresUserIdInjection, shutdown, splitKeyIntoSegments, splitResourceSelectorKeyIntoSegments

Methods inherited from class java.lang.Object

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

Constructor Detail

TestJDBCResourceKindImpl

public TestJDBCResourceKindImpl(ApplicationContext context,
                                ConnectionPool connectionPool,
                                java.lang.String authToken)

Constructor

Parameters:

context - SData servlet context

connectionPool - connectionPool of the underlying DB

authToken - the authentication token

Method Detail

getTableName

protected java.lang.String getTableName()

Get the JDBC table name for which ResourceKindImpl is created

Specified by:

getTableName in class JDBCResourceKind

Returns:

the JDBC table name

getName

public java.lang.String getName()

getPrimaryKey

protected java.lang.String[] getPrimaryKey()

Get the primary key of the underlying JDBC table for which one JDBCResourceKindImpl is created

Specified by:

getPrimaryKey in class JDBCResourceKind

Returns:

the primary key

getIncludeColumns

protected java.util.ArrayList<java.lang.String> getIncludeColumns()

Get the columns of the JDBC table that needs to be included

Overrides:

getIncludeColumns in class JDBCResourceKind

Returns:

the list of column names that needs to be included in the result set

getAllFields

protected java.util.List<FieldDefinition> getAllFields()

returns a list of FieldDefinitions in the ResourceKind

Specified by:

getAllFields in class JDBCResourceKind

Returns:

FieldDefinition list

getCalculateFieldValue

protected java.lang.String getCalculateFieldValue(java.lang.String value,
                                                  SDataRequest request,
                                                  java.sql.ResultSet resultSet,
                                                  int fieldIndex)

Get the value of the calculated field, if it is a regular (non-calculated) field then the original value will be returned unchanged

Specified by:

getCalculateFieldValue in class JDBCResourceKind

Parameters:

value - value of the field

request - the input SDataRequest

resultSet - resultSet returned by query

fieldIndex - fieldIndex - 0-based

Returns:

the value of the field

isUserSpecificResource

public boolean isUserSpecificResource()

Indicates whether the resource is user specific or not. If the resource is user specific, it generally requires user sign on.

Specified by:

isUserSpecificResource in class JDBCResourceKind

Returns:

True if the resource is user specific, false otherwise.

supportDelete

protected boolean supportDelete()

Indicates whether the ResourceKind in general supports DELETE or not.

Specified by:

supportDelete in class JDBCResourceKind

Returns:

True if the ResourceKind supports DELETE, false otherwise.

supportGet

protected boolean supportGet()

Indicates whether the ResourceKind in general supports GET or not.

Specified by:

supportGet in class JDBCResourceKind

Returns:

True if the ResourceKind supports GET, false otherwise.

supportPost

protected boolean supportPost()

Indicates whether the ResourceKind in general supports POST or not.

Specified by:

supportPost in class JDBCResourceKind

Returns:

True if the ResourceKind supports POST, false otherwise.

supportPut

protected boolean supportPut()

Indicates whether the ResourceKind in general supports PUT or not.

Specified by:

supportPut in class JDBCResourceKind

Returns:

True if the ResourceKind supports PUT, false otherwise.