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
|
# 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
import sys
import unittest
from pyfakefs import fake_filesystem_unittest
from pyfakefs.helpers import IS_PYPY
try:
import pandas as pd
except ImportError:
pd = None
try:
import xlrd
except ImportError:
xlrd = None
try:
import openpyxl
except ImportError:
openpyxl = None
@unittest.skipIf(
IS_PYPY and sys.version_info < (3, 8), "Has a problem with older PyPy versions"
)
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()
|
