org.teiid.resource.adapter.google

Class SpreadsheetConnectionImpl4

java.lang.Object

org.teiid.resource.spi.BasicConnection

org.teiid.resource.adapter.google.SpreadsheetConnectionImpl4

All Implemented Interfaces:

Connection, GoogleSpreadsheetConnection

public class SpreadsheetConnectionImpl4
extends BasicConnection
implements GoogleSpreadsheetConnection

Represents a connection to an Google spreadsheet data source. Uses a mixture of Sheets v4 api, visualization, and Sheets v3

Constructor Summary

Constructors

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

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> pairs)
SpreadsheetInfo	getSpreadsheetInfo() Returns information about existing Spreadsheets and worksheets.
SpreadsheetInfo	getV2SpreadsheetInfo()
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

SpreadsheetConnectionImpl4

public SpreadsheetConnectionImpl4(SpreadsheetManagedConnectionFactory config,
                                  AtomicReference<SpreadsheetInfo> spreadsheetInfo,
                                  AtomicReference<SpreadsheetInfo> v2SpreadsheetInfo)

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:

getV2SpreadsheetInfo

public SpreadsheetInfo getV2SpreadsheetInfo()

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> pairs)

Specified by:

executeRowInsert in interface GoogleSpreadsheetConnection