[teiid-issues] [JBoss JIRA] (TEIID-3216) Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13027390#comment-13027390 ] 

Steven Hawkins commented on TEIID-3216:
---------------------------------------

> I believe expressions can be used as update values. For example, these queries works:

Those work because the values are pre-evaluated or have a compensating procedure created, since they use unsupported constructs for the source.  An expression using one of the supported functions - YEAR(col) - should get pushed and should fail in SpreadSheetCriteriaVisitor.getStringValue.

> You say that "LIKE" limitation could be addressed with capabilities. How can I disable "LIKE" capability for update or delete statements?

That would require an enhancement.  We'd have to create a compensating procedure to first perform a select with the like criteria, then process the update/delete against the rows.

> is there anything else I should do regarding this jira?

As long as it seems like that we're in a good initial state, we can resolve this one and open new ones as needed.

> Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector
> ----------------------------------------------------------------------------
>
>                 Key: TEIID-3216
>                 URL: https://issues.jboss.org/browse/TEIID-3216
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Filip Elias
>            Assignee: Filip Elias
>             Fix For: 8.10
>
>
> Current plan is to use list-based feed of the Google Data API[1].
> There are three known issues:
> performance - to delete/update 100 rows Teiid must generate 100 http requests
> consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't.
> headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet)
> Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers.
> [1] https://developers.google.com/google-apps/spreadsheets/



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)