def permission_test(baseSettings, tests):
for test in tests:
settings = dict(baseSettings)
testTableIO = tio.createTableIO(settings=settings)
for key, val in test[0].items():
settings[key] = val
testTableIO.setTable(settings["table"])
x = settings["x"]
y = settings["y"]
try:
value = testTableIO.setValue(x, y, test[1])
assert "w" in settings["permission"], "Set value without permission to write."
except PermissionError:
assert "w" not in settings["permission"], "Faild to getValue."
try:
value = testTableIO.getValue(x, y)
assert test[1] == value, "Expected value: {} got {}".format(
value, test[1])
assert "r" in settings["permission"], "Got value without permission to read."
except PermissionError:
assert "r" not in settings["permission"], "Got permission error."
def read_data(baseSettings, tests):
testTableIO = tio.createTableIO(settings=baseSettings)
for test in tests:
settings = dict(baseSettings)
for key, val in test[0].items():
settings[key] = val
value = testTableIO.getValue(test[0]["x"], test[0]["y"])
assert test[1] == value, "Expected value: {} got {}".format(
value, test[1])
def test_createTableIOFactory():
settings = baseSettings
tests = [["csv", tio.csvTableIO], ["xls", tio.xlsTableIO],
["google", tio.googleSheetTableIO]]
for test in tests:
settings["type"] = test[0]
myTableIO = tio.createTableIO(settings=settings)
testTableIO = test[1](settings=settings)
assert type(myTableIO) == type(
testTableIO
), "Wrong tableIO type was created. Created TableIO was: {}".format(
type(myTableIO))
def read_col(baseSettings, tests):
testTableIO = tio.createTableIO(settings=baseSettings)
for test in tests:
settings = dict(baseSettings)
for key, val in test[0].items():
settings[key] = val
x = settings["x"]
y = settings["y"]
cnt = settings["len"]
try:
values = testTableIO.getCol(x,y,cnt)
assert values == test[1], "Unexpected values {} instead of {}".format(values, test[1])
assert cnt >= 1, "Didn't got a exception with cnt <= 1."
except ValueError:
assert cnt < 1, "Got Exception with cnt >= 1."
def write_data(baseSettings, tests):
testTableIO = tio.createTableIO(settings=baseSettings)
for test in tests:
settings = dict(baseSettings)
for key, val in test[0].items():
settings[key] = val
testTableIO.setTable(settings["table"])
# Clear cell value
testTableIO.setValue(test[0]["x"], test[0]["y"], "")
value = testTableIO.getValue(test[0]["x"], test[0]["y"])
assert "" == value, "Expected value: {} got {}".format(value, test[1])
testTableIO.setValue(test[0]["x"], test[0]["y"], test[1])
value = testTableIO.getValue(test[0]["x"], test[0]["y"])
assert test[1] == value, "Expected value: {} got {}".format(
value, test[1])
def write_row(baseSettings, tests):
testTableIO = tio.createTableIO(settings=baseSettings)
for test in tests:
settings = dict(baseSettings)
for key, val in test[0].items():
settings[key] = val
testTableIO.setTable(settings["table"])
x = settings["x"]
y = settings["y"]
clean = [""] * (len(test[1])+1)
testTableIO.row(x, y, clean)
values = testTableIO.getRow(x, y, len(clean))
assert clean == values, "Unexpected value {} instead of {}".format(values, clean)
testTableIO.setValue(x+len(test[1]), y, test[1][0])
testTableIO.row(x, y, test[1])
value = testTableIO.getValue(x+len(test[1]), y)
assert test[1][0] == value, "Overwrote value behind range."
values = testTableIO.getRow(x, y, len(test[1]))
assert test[1] == values, "Unexpected value {} instead of {}".format(values, test[1])