Request: Query Band Read/Write Support

[r-richmond]

Certain Datasources have query bands and it would be extremely helpful to be able to modify these programatically.

[t8y8]

@r-richmond Thank you for opening a request!

Would it be possible to include a dummy-tds or twb that already has a query band in it?
It would also be great to include a sample query band update you might make.
It's very helpful for us when building test cases and understand the requirements.

(I'm marking this as an enhancement)

[r-richmond]

Sure,

I've attached a dummy workbook that contains both sample query bands & sample initial sql.

As far as an example use case. I would like to be able to write something like

for workbook in folder:
  for datasource in workbook:
    if datasource.query_band is none:
      datasource.query_band = 'TableauReport=<workbookname>';
   elif datasource.query_band does not contain 'TableauReport=<workbookname>':
      datasource.query_band += '\n TableauReport=<workbookname>';

note: in this case I'd like to be the special value that you can use in query bands now and not a hardcoded string of the current workbook name.

bands_initial_dummy_workbook.twb.zip

[r-richmond]

Marking this as closed with release 0.6 & the merging of #123