8000 Add warnings when adding workbook to schedule by guodah · Pull Request #551 · tableau/server-client-python · GitHub
[go: up one dir, main page]

Skip to content

Add warnings when adding workbook to schedule #551

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
Merged
Show file tree
Hide file tree
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
24 changes: 20 additions & 4 deletions tableauserverclient/models/schedule_item.py
Original file line number Diff line number Diff line change
Expand Up @@ -162,10 +162,7 @@ def from_response(cls, resp, ns):

@classmethod
def from_element(cls, parsed_response, ns):
all_warning_xml = parsed_response.findall('.//t:warning', namespaces=ns)
warnings = list() if len(all_warning_xml) > 0 else None
for warning_xml in all_warning_xml:
warnings.append(warning_xml.get('message', None))
warnings = cls._read_warnings(parsed_response, ns)

all_schedule_items = []
all_schedule_xml = parsed_response.findall('.//t:schedule', namespaces=ns)
Expand Down Expand Up @@ -248,3 +245,22 @@ def _parse_element(schedule_xml, ns):

return id, name, state, created_at, updated_at, schedule_type, \
next_run_at, end_schedule_at, execution_order, priority, interval_item

@staticmethod
def parse_add_to_schedule_response(response, ns):
parsed_response = ET.fromstring(response.content)
warnings = ScheduleItem._read_warnings(parsed_response, ns)
all_task_xml = parsed_response.findall('.//t:task', namespaces=ns)

error = "Status {}: {}".format(response.status_code, response.reason) \
if response.status_code < 200 or response.status_code >= 300 else None
task_created = len(all_task_xml) > 0
return error, warnings, task_created

@staticmethod
def _read_warnings(parsed_response, ns):
all_warning_xml = parsed_response.findall('.//t:warning', namespaces=ns)
warnings = list() if len(all_warning_xml) > 0 else None
for warning_xml in all_warning_xml:
warnings.append(warning_xml.get('message', None))
return warnings
20 changes: 12 additions & 8 deletions tableauserverclient/server/endpoint/schedules_endpoint.py
Original file line number Diff line number Diff line change
Expand Up @@ -7,8 +7,8 @@

logger = logging.getLogger('tableau.endpoint.schedules')
# Oh to have a first class Result concept in Python...
AddResponse = namedtuple('AddResponse', ('result', 'error'))
OK = AddResponse(result=True, error=None)
AddResponse = namedtuple('AddResponse', ('result', 'error', 'warnings', 'task_created'))
OK = AddResponse(result=True, error=None, warnings=None, task_created=None)


class Schedules(Endpoint):
Expand Down Expand Up @@ -70,17 +70,21 @@ def create(self, schedule_item):
@api(version="2.8")
def add_to_schedule(self, schedule_id, workbook=None, datasource=None,
task_type=TaskItem.Type.ExtractRefresh):

def add_to(resource, type_, req_factory):
id_ = resource.id
url = "{0}/{1}/{2}s".format(self.siteurl, schedule_id, type_)
add_req = req_factory(id_, task_type=task_type)
response = self.put_request(url, add_req)
if response.status_code < 200 or response.status_code >= 300:
return AddResponse(result=False,
error="Status {}: {}".format(response.status_code, response.reason))
logger.info("Added {} to {} to schedule {}".format(type_, id_, schedule_id))
return OK

error, warnings, task_created = ScheduleItem.parse_add_to_schedule_response(
response, self.parent_srv.namespace)
if task_created:
logger.info("Added {} to {} to schedule {}".format(type_, id_, schedule_id))

if error is not None or warnings is not None:
return AddResponse(result=False, error=error, warnings=warnings, task_created=task_created)
else:
return OK

items = []

Expand Down
9 changes: 9 additions & 0 deletions test/assets/schedule_add_datasource.xml
Original file line number Diff line number Diff line change
@@ -0,0 +1,9 @@
<?xml version='1.0' encoding='UTF-8'?>
<tsResponse xmlns="http://tableau.com/api" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://tableau.com/api http://tableau.com/api/ts-api-2.3.xsd">
<task>
<extractRefresh>
<schedule id="schedule-id" />
<datasource id="datasource-id" />
</extractRefresh>
</task>
</tsResponse>
9 changes: 9 additions & 0 deletions test/assets/schedule_add_workbook.xml
Original file line number Diff line number Diff line change
@@ -0,0 +1,9 @@
<?xml version='1.0' encoding='UTF-8'?>
<tsResponse xmlns="http://tableau.com/api" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://tableau.com/api http://tableau.com/api/ts-api-2.3.xsd">
<task>
<materializeView>
<schedule id="schedule-id" />
<workbook id="workbook-id" />
</materializeView>
</task>
</tsResponse>
12 changes: 12 additions & 0 deletions test/assets/schedule_add_workbook_with_warnings.xml
Original file line number Diff line number Diff line change
@@ -0,0 +1,12 @@
<tsResponse xmlns="http://tableau.com/api" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://tableau.com/api http://tableau.com/api/ts-api-2.3.xsd">
<task>
<materializeView>
<schedule id="schedule-id" />
<workbook id="workbook-id" />
</materializeView>
</task>
<warnings>
<warning message="warning 1"/>
<warning message="warning 2"/>
</warnings>
</tsResponse>
29 changes: 25 additions & 4 deletions test/test_schedule.py
DD0B
Original file line number Diff line number Diff line change
Expand Up @@ -14,6 +14,9 @@
CREATE_WEEKLY_XML = os.path.join(TEST_ASSET_DIR, "schedule_create_weekly.xml")
CREATE_MONTHLY_XML = os.path.join(TEST_ASSET_DIR, "schedule_create_monthly.xml")
UPDATE_XML = os.path.join(TEST_ASSET_DIR, "schedule_update.xml")
ADD_WORKBOOK_TO_SCHEDULE = os.path.join(TEST_ASSET_DIR, "schedule_add_workbook.xml")
ADD_WORKBOOK_TO_SCHEDULE_WITH_WARNINGS = os.path.join(TEST_ASSET_DIR, "schedule_add_workbook_with_warnings.xml")
ADD_DATASOURCE_TO_SCHEDULE = os.path.join(TEST_ASSET_DIR, "schedule_add_datasource.xml")

WORKBOOK_GET_BY_ID_XML = os.path.join(TEST_ASSET_DIR, 'workbook_get_by_id.xml')
DATASOURCE_GET_BY_ID_XML = os.path.join(TEST_ASSET_DIR, 'datasource_get_by_id.xml')
Expand Down Expand Up @@ -208,24 +211,42 @@ def test_add_workbook(self):

with open(WORKBOOK_GET_BY_ID_XML, "rb") as f:
workbook_response = f.read().decode("utf-8")
with open(ADD_WORKBOOK_TO_SCHEDULE, "rb") as f:
add_workbook_response = f.read().decode("utf-8")
with requests_mock.mock() as m:
# TODO: Replace with real response
m.get(self.server.workbooks.baseurl + '/bar', text=workbook_response)
m.put(baseurl + '/foo/workbooks', text="OK")
m.put(baseurl + '/foo/workbooks', text=add_workbook_response)
workbook = self.server.workbooks.get_by_id("bar")
result = self.server.schedules.add_to_schedule('foo', workbook=workbook)
self.assertEqual(0, len(result), "Added properly")

def test_add_workbook_with_warnings(self):
self.server.version = "2.8"
baseurl = "{}/sites/{}/schedules".format(self.server.baseurl, self.server.site_id)

with open(WORKBOOK_GET_BY_ID_XML, "rb") as f:
workbook_response = f.read().decode("utf-8")
with open(ADD_WORKBOOK_TO_SCHEDULE_WITH_WARNINGS, "rb") as f:
add_workbook_response = f.read().decode("utf-8")
with requests_mock.mock() as m:
m.get(self.server.workbooks.baseurl + '/bar', text=workbook_response)
m.put(baseurl + '/foo/workbooks', text=add_workbook_response)
workbook = self.server.workbooks.get_by_id("bar")
result = self.server.schedules.add_to_schedule('foo', workbook=workbook)
self.assertEqual(1, len(result), "Not added properly")
self.assertEqual(2, len(result[0].warnings))

def test_add_datasource(self):
self.server.version = "2.8"
baseurl = "{}/sites/{}/schedules".format(self.server.baseurl, self.server.site_id)

with open(DATASOURCE_GET_BY_ID_XML, "rb") as f:
datasource_response = f.read().decode("utf-8")
with open(ADD_DATASOURCE_TO_SCHEDULE, "rb") as f:
add_datasource_response = f.read().decode("utf-8")
with requests_mock.mock() as m:
# TODO: Replace with real response
m.get(self.server.datasources.baseurl + '/bar', text=datasource_response)
m.put(baseurl + '/foo/datasources', text="OK")
m.put(baseurl + '/foo/datasources', text=add_datasource_response)
datasource = self.server.datasources.get_by_id("bar")
result = self.server.schedules.add_to_schedule('foo', datasource=datasource)
self.assertEqual(0, len(result), "Added properly")
0