def test_export_remote_accesses_xlsx():
"""Tests for export remote accesses xlsx file method"""
client = CBWXlsx(API_URL, API_KEY, SECRET_KEY)
file_xlsx = "test.xlsx"
with vcr.use_cassette(
'spec/fixtures/vcr_cassettes/export_file_xlsx.yaml'):
response = client.export_remote_accesses_xlsx(file_xlsx)
workbook = xlrd.open_workbook(file_xlsx)
sheet = workbook.sheet_by_index(0)
for rownum in range(sheet.nrows):
result = sheet.row_values(rownum)
break
assert response is True and result == [
'HOST', 'PORT', 'TYPE', 'NODE_ID', 'SERVER_GROUPS'
]
for rownum in range(1, sheet.nrows):
result = sheet.row_values(rownum)
break
# The group is not assigned yet
assert result == [
'10.0.2.15', 22, 'CbwRam::RemoteAccess::Ssh::WithPassword', 1,
''
]
def test_export_remote_accesses_xlsx():
"""Tests for export remote accesses xlsx file method"""
client = CBWXlsx(API_URL, API_KEY, SECRET_KEY)
file_xlsx = "test.xlsx"
with vcr.use_cassette(
'spec/fixtures/vcr_cassettes/export_file_xlsx.yaml'):
response = client.export_remote_accesses_xlsx(file_xlsx)
workbook = openpyxl.load_workbook(file_xlsx)
worksheet = workbook.active
result = []
for cell in worksheet[1]:
result.append(cell.value)
assert response is True and result == [
'HOST', 'PORT', 'TYPE', 'NODE_ID', 'SERVER_GROUPS'
]
result = []
for cell in worksheet[2]:
result.append(cell.value)
# The group is not assigned yet
assert result == [
'10.0.2.15', 22, 'CbwRam::RemoteAccess::Ssh::WithPassword', 1,
None
]
def test_export_remote_accesses_xlsx():
"""Tests for export remote accesses xlsx file method"""
client = CBWXlsx(API_URL, API_KEY, SECRET_KEY)
file_xlsx = "test.xlsx"
with vcr.use_cassette(
'spec/fixtures/vcr_cassettes/export_file_xlsx.yaml'):
response = client.export_remote_accesses_xlsx(file_xlsx)
workbook = xlrd.open_workbook(file_xlsx)
sheet = workbook.sheet_by_index(0)
for rownum in range(sheet.nrows):
result = sheet.row_values(rownum)
break
assert response is True and result == [
'HOST', 'PORT', 'TYPE', 'NODE', 'GROUPS'
]
for rownum in range(1, sheet.nrows):
result = sheet.row_values(rownum)
break
assert result == [
'server01.example.com', 22.0,
'CbwRam::RemoteAccess::Ssh::WithPassword', 'master',
'Production,test'
]
"""Export remote accesses in file xlsx""" from cbw_api_toolbox.cbw_file_xlsx import CBWXlsx API_KEY = '' SECRET_KEY = '' API_URL = '' FILE_XLSX = "" #Optional parameter XLSX = CBWXlsx(API_URL, API_KEY, SECRET_KEY) print(XLSX.export_remote_accesses_xlsx())