1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
# frozen_string_literal: true
require 'tc_helper'
class TestPivotTableCacheDefinition < Test::Unit::TestCase
def setup
p = Axlsx::Package.new
@ws = p.workbook.add_worksheet
5.times do
@ws << ["aa", "aa", "aa", "aa"]
end
@pivot_table = @ws.add_pivot_table('G5:G6', 'A1:D5')
@cache_definition = @pivot_table.cache_definition
end
def test_initialization
assert(@cache_definition.is_a?(Axlsx::PivotTableCacheDefinition), "must create a pivot table cache definition")
assert_equal(@pivot_table, @cache_definition.pivot_table, 'refers back to its pivot table')
end
def test_pn
assert_equal('pivotCache/pivotCacheDefinition1.xml', @cache_definition.pn)
end
def test_rId
assert_equal @pivot_table.relationships.for(@cache_definition).Id, @cache_definition.rId
end
def test_index
assert_equal(0, @cache_definition.index)
end
def test_cache_id
assert_equal(1, @cache_definition.cache_id)
end
def test_data_sheet
data_sheet = @ws.clone
data_sheet.name = "Pivot Table Data Source"
@pivot_table.data_sheet = data_sheet
assert_includes(@cache_definition.to_xml_string, data_sheet.name, "must set the data source correctly")
end
def test_to_xml_string
schema = Nokogiri::XML::Schema(File.open(Axlsx::SML_XSD))
doc = Nokogiri::XML(@cache_definition.to_xml_string)
errors = []
schema.validate(doc).each do |error|
errors.push error
puts error.message
end
assert_empty(errors, "error free validation")
end
def test_to_xml_string_for_special_characters
cell = @ws.rows.first.cells.first
cell.value = "&><'\""
doc = Nokogiri::XML(@cache_definition.to_xml_string)
errors = doc.errors
assert_empty(errors, "invalid xml: #{errors.map(&:to_s).join(', ')}")
end
end
|
