org.restsql.core.impl

Class SqlResourceImpl

java.lang.Object

org.restsql.core.impl.SqlResourceImpl

All Implemented Interfaces:

SqlResource

public class SqlResourceImpl
extends Object
implements SqlResource

Represents a SQL Resource, a queryable and updatable database "view". Loads metadata on creation and caches it.

Author:

Mark Sawers

Constructor Summary

Constructors

Constructor and Description
SqlResourceImpl(String name, SqlResourceDefinition definition, SqlResourceMetaData metaData, SqlBuilder sqlBuilder, List<Trigger> triggers)

Method Summary

Methods

Modifier and Type	Method and Description
SqlResourceDefinition	getDefinition() Returns SQL resource information defined by the user, including query, validated attributes and trigger.
SqlResourceMetaData	getMetaData() Returns meta data for SQL resource.
String	getName() Returns SQL resource name.
List<Trigger>	getTriggers() Returns triggers classes.
List<Map<String,Object>>	read(Request request) Executes query returning results as an object collection.
String	read(Request request, String mediaType) Executes query returning results as a string.
static String	removeWhitespaceFromSql(String sql)
WriteResponse	write(Request request) Executes database write (insert, update or delete).

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlResourceImpl

public SqlResourceImpl(String name,
               SqlResourceDefinition definition,
               SqlResourceMetaData metaData,
               SqlBuilder sqlBuilder,
               List<Trigger> triggers)
                throws SqlResourceException

Throws:

SqlResourceException

Method Detail

removeWhitespaceFromSql

public static String removeWhitespaceFromSql(String sql)

getDefinition

public SqlResourceDefinition getDefinition()

Description copied from interface: SqlResource

Returns SQL resource information defined by the user, including query, validated attributes and trigger.

Specified by:

getDefinition in interface SqlResource

Returns:

definition

getMetaData

public SqlResourceMetaData getMetaData()

Description copied from interface: SqlResource

Returns meta data for SQL resource.

Specified by:

getMetaData in interface SqlResource

Returns:

SQL rsource meta data

getName

public String getName()

Description copied from interface: SqlResource

Returns SQL resource name.

Specified by:

getName in interface SqlResource

Returns:

SQL resource name

getTriggers

public List<Trigger> getTriggers()

Description copied from interface: SqlResource

Returns triggers classes.

Specified by:

getTriggers in interface SqlResource

Returns:

list of trigger classes

read

public List<Map<String,Object>> read(Request request)
                              throws SqlResourceException

Executes query returning results as an object collection.

Specified by:

read in interface SqlResource

Parameters:

request - Request object

Returns:

list of rows, where each row is a map of name-value pairs

Throws:

SqlResourceException - if a database access error occurs

read

public String read(Request request,
          String mediaType)
            throws SqlResourceException

Executes query returning results as a string.

Specified by:

read in interface SqlResource

Parameters:

request - Request object

mediaType - response format, use internet media type e.g. application/xml

Returns:

list of rows, where each row is a map of name-value pairs

Throws:

SqlResourceException - if a database access error occurs

write

public WriteResponse write(Request request)
                    throws SqlResourceException

Executes database write (insert, update or delete).

Specified by:

write in interface SqlResource

Parameters:

request - Request object

Returns:

write Response object

Throws:

SqlResourceException - if the request is invalid or a database access error or trigger exception occurs