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
|
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
"""
Provides patches for some commonly used modules that enable them to work
with pyfakefs.
"""
import os
from pyfakefs import fake_filesystem_unittest
try:
import pandas as pd
except ImportError:
pd = None
try:
import xlrd
except ImportError:
xlrd = None
try:
import openpyxl
except ImportError:
openpyxl = None
class TestPatchedPackages(fake_filesystem_unittest.TestCase):
def setUp(self):
self.setUpPyfakefs()
if pd is not None:
def test_read_csv(self):
path = '/foo/bar.csv'
self.fs.create_file(path, contents='1,2,3,4')
df = pd.read_csv(path)
assert (df.columns == ['1', '2', '3', '4']).all()
def test_read_table(self):
path = '/foo/bar.csv'
self.fs.create_file(path, contents='1|2|3|4')
df = pd.read_table(path, delimiter='|')
assert (df.columns == ['1', '2', '3', '4']).all()
if pd is not None and xlrd is not None:
def test_read_excel(self):
path = '/foo/bar.xlsx'
src_path = os.path.dirname(os.path.abspath(__file__))
src_path = os.path.join(src_path, 'fixtures', 'excel_test.xlsx')
# map the file into another location to be sure that
# the real fs is not used
self.fs.add_real_file(src_path, target_path=path)
df = pd.read_excel(path)
assert (df.columns == [1, 2, 3, 4]).all()
if pd is not None and openpyxl is not None:
def test_write_excel(self):
self.fs.create_dir('/foo')
path = '/foo/bar.xlsx'
df = pd.DataFrame([[0, 1, 2, 3]])
with pd.ExcelWriter(path) as writer:
df.to_excel(writer)
df = pd.read_excel(path)
assert (df.columns == ['Unnamed: 0', 0, 1, 2, 3]).all()
|
