org.teiid.resource.adapter.google

Class SpreadsheetConnectionImpl

java.lang.Object

org.teiid.resource.spi.BasicConnection

org.teiid.resource.adapter.google.SpreadsheetConnectionImpl

All Implemented Interfaces:

Connection, GoogleSpreadsheetConnection

public class SpreadsheetConnectionImpl
extends BasicConnection
implements GoogleSpreadsheetConnection

Represents a connection to an Google spreadsheet data source.

Constructor Summary

Constructors

Constructor and Description
SpreadsheetConnectionImpl(SpreadsheetManagedConnectionFactory config, AtomicReference<SpreadsheetInfo> spreadsheetInfo)

Method Summary

Modifier and Type	Method and Description
void	close() Closes Google spreadsheet context, effectively closing the connection to Google spreadsheet.
UpdateResult	deleteRows(String worksheetTitle, String criteria)
RowsResult	executeQuery(String worksheetTitle, String query, Integer offset, Integer limit, int batchSize)
UpdateResult	executeRowInsert(String worksheetTitle, Map<String,Object> pair)
SpreadsheetInfo	getSpreadsheetInfo() Returns information about existing Spreadsheets and worksheets.
boolean	isAlive() Tests the connection to see if it is still valid.
UpdateResult	updateRows(String worksheetTitle, String criteria, List<UpdateSet> set)

Methods inherited from class org.teiid.resource.spi.BasicConnection

cleanUp, createInteraction, getLocalTransaction, getMetaData, getResultSetInfo, getXAResource

Methods inherited from class java.lang.Object

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

Constructor Detail

SpreadsheetConnectionImpl

public SpreadsheetConnectionImpl(SpreadsheetManagedConnectionFactory config,
                                 AtomicReference<SpreadsheetInfo> spreadsheetInfo)

Method Detail

close

public void close()

Closes Google spreadsheet context, effectively closing the connection to Google spreadsheet. (non-Javadoc)

Specified by:

close in interface Connection

isAlive

public boolean isAlive()

Description copied from class: BasicConnection

Tests the connection to see if it is still valid.

Overrides:

isAlive in class BasicConnection

Returns:

executeQuery

public RowsResult executeQuery(String worksheetTitle,
                               String query,
                               Integer offset,
                               Integer limit,
                               int batchSize)

Specified by:

executeQuery in interface GoogleSpreadsheetConnection

getSpreadsheetInfo

public SpreadsheetInfo getSpreadsheetInfo()

Description copied from interface: GoogleSpreadsheetConnection

Returns information about existing Spreadsheets and worksheets.

Specified by:

getSpreadsheetInfo in interface GoogleSpreadsheetConnection

Returns:

updateRows

public UpdateResult updateRows(String worksheetTitle,
                               String criteria,
                               List<UpdateSet> set)

Specified by:

updateRows in interface GoogleSpreadsheetConnection

deleteRows

public UpdateResult deleteRows(String worksheetTitle,
                               String criteria)

Specified by:

deleteRows in interface GoogleSpreadsheetConnection

executeRowInsert

public UpdateResult executeRowInsert(String worksheetTitle,
                                     Map<String,Object> pair)

Specified by:

executeRowInsert in interface GoogleSpreadsheetConnection