Source code for openpyxl.chartsheet.tests.test_publish

from __future__ import absolute_import
# Copyright (c) 2010-2017 openpyxl

import pytest

from openpyxl.xml.functions import fromstring, tostring
from openpyxl.tests.helper import compare_xml

@pytest.fixture
[docs]def WebPublishItem(): from ..publish import WebPublishItem return WebPublishItem
[docs]class TestWebPulishItem:
[docs] def test_read(self, WebPublishItem): src = """ <webPublishItem id="6433" divId="Views_6433" sourceType="chart" sourceRef="" sourceObject="Chart 1" destinationFile="D:\Publish.mht" autoRepublish="0"/> """ xml = fromstring(src) webPulishItem = WebPublishItem.from_tree(xml) assert webPulishItem.id == 6433 assert webPulishItem.sourceObject == "Chart 1"
[docs] def test_write(self, WebPublishItem): webPublish = WebPublishItem(id=6433, divId="Views_6433", sourceType="chart", sourceRef="", sourceObject="Chart 1", destinationFile="D:\Publish.mht", title="First Chart", autoRepublish=False) expected = """ <webPublishItem id="6433" divId="Views_6433" sourceType="chart" sourceRef="" sourceObject="Chart 1" destinationFile="D:\Publish.mht" title="First Chart" autoRepublish="0"/> """ xml = tostring(webPublish.to_tree()) diff = compare_xml(xml, expected) assert diff is None, diff
@pytest.fixture
[docs]def WebPublishItems(): from ..publish import WebPublishItems return WebPublishItems
[docs]class TestWebPublishItems:
[docs] def test_read(self, WebPublishItems): src = """ <webPublishItems count="1"> <webPublishItem id="6433" divId="Views_6433" sourceType="chart" sourceRef="" sourceObject="Chart 1" destinationFile="D:\Publish.mht" autoRepublish="0"/> </webPublishItems> """ xml = fromstring(src) webPublishItems = WebPublishItems.from_tree(xml) assert webPublishItems.count == 1 assert webPublishItems.webPublishItem[0].sourceObject == "Chart 1"
[docs] def test_write(self, WebPublishItems): from ..publish import WebPublishItem webPublish_6433 = WebPublishItem(id=6433, divId="Views_6433", sourceType="chart", sourceRef="", sourceObject="Chart 1", destinationFile="D:\Publish.mht", title="First Chart", autoRepublish=False) webPublish_64487 = WebPublishItem(id=64487, divId="Views_64487", sourceType="chart", sourceRef="Ref_545421", sourceObject="Chart 15", destinationFile="D:\Publish_12.mht", title="Second Chart", autoRepublish=True) webPublishItems = WebPublishItems(webPublishItem=[webPublish_6433, webPublish_64487]) expected = """ <WebPublishItems count="2"> <webPublishItem id="6433" divId="Views_6433" sourceType="chart" sourceRef="" sourceObject="Chart 1" destinationFile="D:\Publish.mht" title="First Chart" autoRepublish="0"/> <webPublishItem id="64487" divId="Views_64487" sourceType="chart" sourceRef="Ref_545421" sourceObject="Chart 15" destinationFile="D:\Publish_12.mht" title="Second Chart" autoRepublish="1"/> </WebPublishItems> """ xml = tostring(webPublishItems.to_tree()) diff = compare_xml(xml, expected) assert diff is None, diff