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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
# frozen_string_literal: true
require 'tc_helper'
class TestPic < Test::Unit::TestCase
def setup
stub_request(:get, 'https://example.com/sample-image.png')
.to_return(body: File.new('examples/sample.png'), status: 200)
@p = Axlsx::Package.new
ws = @p.workbook.add_worksheet
@test_img = @test_img_jpg = "#{File.dirname(__FILE__)}/../fixtures/image1.jpeg"
@test_img_png = "#{File.dirname(__FILE__)}/../fixtures/image1.png"
@test_img_gif = "#{File.dirname(__FILE__)}/../fixtures/image1.gif"
@test_img_fake = "#{File.dirname(__FILE__)}/../fixtures/image1_fake.jpg"
@test_img_remote_png = "https://example.com/sample-image.png"
@test_img_remote_fake = "invalid_URI"
@image = ws.add_image image_src: @test_img, hyperlink: 'https://github.com/randym', tooltip: "What's up doc?", opacity: 5
@image_remote = ws.add_image image_src: @test_img_remote_png, remote: true, hyperlink: 'https://github.com/randym', tooltip: "What's up doc?", opacity: 5
end
def test_initialization
assert_equal(@p.workbook.images.first, @image)
assert_equal('image1.jpeg', @image.file_name)
assert_equal(@image.image_src, @test_img)
end
def test_remote_img_initialization
assert_equal(@p.workbook.images[1], @image_remote)
assert_nil(@image_remote.file_name)
assert_equal(@image_remote.image_src, @test_img_remote_png)
assert_predicate(@image_remote, :remote?)
end
def test_anchor_swapping
# swap from one cell to two cell when end_at is specified
assert(@image.anchor.is_a?(Axlsx::OneCellAnchor))
start_at = @image.anchor.from
@image.end_at 10, 5
assert(@image.anchor.is_a?(Axlsx::TwoCellAnchor))
assert_equal(start_at.col, @image.anchor.from.col)
assert_equal(start_at.row, @image.anchor.from.row)
assert_equal(10, @image.anchor.to.col)
assert_equal(5, @image.anchor.to.row)
# swap from two cell to one cell when width or height are specified
@image.width = 200
assert(@image.anchor.is_a?(Axlsx::OneCellAnchor))
assert_equal(start_at.col, @image.anchor.from.col)
assert_equal(start_at.row, @image.anchor.from.row)
assert_equal(200, @image.width)
end
def test_hyperlink
assert_equal("https://github.com/randym", @image.hyperlink.href)
@image.hyperlink = "http://axlsx.blogspot.com"
assert_equal("http://axlsx.blogspot.com", @image.hyperlink.href)
end
def test_name
assert_raise(ArgumentError) { @image.name = 49 }
assert_nothing_raised { @image.name = "unknown" }
assert_equal("unknown", @image.name)
end
def test_start_at
assert_raise(ArgumentError) { @image.start_at "a", 1 }
assert_nothing_raised { @image.start_at 6, 7 }
assert_equal(6, @image.anchor.from.col)
assert_equal(7, @image.anchor.from.row)
end
def test_width
assert_raise(ArgumentError) { @image.width = "a" }
assert_nothing_raised { @image.width = 600 }
assert_equal(600, @image.width)
end
def test_height
assert_raise(ArgumentError) { @image.height = "a" }
assert_nothing_raised { @image.height = 600 }
assert_equal(600, @image.height)
end
def test_image_src
assert_raise(ArgumentError) { @image.image_src = __FILE__ }
assert_raise(ArgumentError) { @image.image_src = @test_img_fake }
assert_nothing_raised { @image.image_src = @test_img_gif }
assert_nothing_raised { @image.image_src = @test_img_png }
assert_nothing_raised { @image.image_src = @test_img_jpg }
assert_equal(@image.image_src, @test_img_jpg)
end
def test_remote_image_src
assert_raise(ArgumentError) { @image_remote.image_src = @test_img_fake }
assert_raise(ArgumentError) { @image_remote.image_src = @test_img_remote_fake }
assert_nothing_raised { @image_remote.image_src = @test_img_remote_png }
assert_equal(@image_remote.image_src, @test_img_remote_png)
end
def test_descr
assert_raise(ArgumentError) { @image.descr = 49 }
assert_nothing_raised { @image.descr = "test" }
assert_equal("test", @image.descr)
end
def test_to_xml
schema = Nokogiri::XML::Schema(File.open(Axlsx::DRAWING_XSD))
doc = Nokogiri::XML(@image.anchor.drawing.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_has_correct_r_id
r_id = @image.anchor.drawing.relationships.for(@image).Id
doc = Nokogiri::XML(@image.anchor.drawing.to_xml_string)
assert_equal r_id, doc.xpath("//a:blip").first["r:embed"]
end
end
|
