[
https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin...
]
Filip Elias commented on TEIID-3216:
------------------------------------
Hello Steven,
I am not sure whether I got your point.
For example: I have to update 3 rows. The first and the second row is updated. Update of
the third row fails. What should I do now?
If I put into the update count array [1,1,-3] then the Squirrel will print: 1 row has been
updated. Is this expected?
If I put into the update count array [2] then the Squirrel will print: 2 rows have been
updated. It seems that only the first index of the array is relevant.
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: Task
Components: Misc. Connectors
Reporter: Filip Elias
Assignee: Filip Elias
Fix For: Open To Community
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.8#6338)