Class SpreadsheetConnectionImpl4

  • All Implemented Interfaces:
    org.teiid.resource.api.Connection, BaseConnection, org.teiid.translator.google.api.GoogleSpreadsheetConnection

    public class SpreadsheetConnectionImpl4
    extends Object
    implements BaseConnection, org.teiid.translator.google.api.GoogleSpreadsheetConnection
    Represents a connection to an Google spreadsheet data source. Uses a mixture of Sheets v4 api, visualization, and Sheets v3
    • Constructor Detail

    • Method Detail

      • close

        public void close()
        Specified by:
        close in interface org.teiid.resource.api.Connection
      • executeQuery

        public org.teiid.translator.google.api.result.RowsResult executeQuery​(String worksheetTitle,
                                                                              String query,
                                                                              Integer offset,
                                                                              Integer limit,
                                                                              int batchSize)
        Specified by:
        executeQuery in interface org.teiid.translator.google.api.GoogleSpreadsheetConnection
      • getSpreadsheetInfo

        public org.teiid.translator.google.api.metadata.SpreadsheetInfo getSpreadsheetInfo()
        Specified by:
        getSpreadsheetInfo in interface org.teiid.translator.google.api.GoogleSpreadsheetConnection
      • updateRows

        public org.teiid.translator.google.api.result.UpdateResult updateRows​(String worksheetTitle,
                                                                              String criteria,
                                                                              List<org.teiid.translator.google.api.UpdateSet> set)
        Specified by:
        updateRows in interface org.teiid.translator.google.api.GoogleSpreadsheetConnection
      • deleteRows

        public org.teiid.translator.google.api.result.UpdateResult deleteRows​(String worksheetTitle,
                                                                              String criteria)
        Specified by:
        deleteRows in interface org.teiid.translator.google.api.GoogleSpreadsheetConnection
      • executeRowInsert

        public org.teiid.translator.google.api.result.UpdateResult executeRowInsert​(String worksheetTitle,
                                                                                    Map<String,​Object> pairs)
        Specified by:
        executeRowInsert in interface org.teiid.translator.google.api.GoogleSpreadsheetConnection