def test_sql(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel)
data = sheet.to_array()
content = [[]]
# 'pyexcel' here is the table name
assert list(data) == content
mysession.close()
def test_sql(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel)
data = sheet.to_array()
content = [[]]
# 'pyexcel'' here is the table name
assert list(data) == content
mysession.close()
def test_sql_filter_1(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel,
start_row=1, row_limit=1)
data = sheet.to_array()
content = [
['2014-11-11', 0, 'Adam', 11.25]
]
# 'pyexcel'' here is the table name
assert list(data) == content
mysession.close()
def test_sql_filter_1(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel,
start_row=1, row_limit=1)
data = sheet.to_array()
content = [
['2014-11-11', 0, 'Adam', 11.25]
]
# 'pyexcel'' here is the table name
assert list(data) == content
mysession.close()
def test_sql_filter_2(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel, start_column=1)
data = sheet.to_array()
content = [
['id', 'name', 'weight'],
[0, 'Adam', 11.25],
[1, 'Smith', 12.25]
]
# 'pyexcel'' here is the table name
assert list(data) == content
mysession.close()
def test_sql(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel)
data = sheet.to_array()
content = [
['birth', 'id', 'name', 'weight'],
['2014-11-11', 0, 'Adam', 11.25],
['2014-11-12', 1, 'Smith', 12.25]
]
# 'pyexcel' here is the table name
assert list(data) == content
mysession.close()
def test_sql(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel)
data = sheet.to_array()
content = [
['birth', 'id', 'name', 'weight'],
['2014-11-11', 0, 'Adam', 11.25],
['2014-11-12', 1, 'Smith', 12.25]
]
# 'pyexcel' here is the table name
assert list(data) == content
mysession.close()
def test_sql_filter_2(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel, start_column=1)
data = sheet.to_array()
content = [
['id', 'name', 'weight'],
[0, 'Adam', 11.25],
[1, 'Smith', 12.25]
]
# 'pyexcel'' here is the table name
assert list(data) == content
mysession.close()
def test_sql_filter_3(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel,
start_column=1, column_limit=1)
data = sheet.to_array()
content = [
['id'],
[0],
[1]
]
# 'pyexcel'' here is the table name
assert list(data) == content
mysession.close()
def test_sql_filter_3(self):
mysession = Session()
sheet = SQLTableReader(mysession, Pyexcel,
start_column=1, column_limit=1)
data = sheet.to_array()
content = [
['id'],
[0],
[1]
]
# 'pyexcel'' here is the table name
assert list(data) == content
mysession.close()
def test_sql_formating(self):
mysession = Session()
def custom_renderer(row):
return [str(element) for element in row]
# the key for this test case
sheet = SQLTableReader(mysession, Pyexcel,
row_renderer=custom_renderer)
data = sheet.to_array()
content = [
['birth', 'id', 'name', 'weight'],
['2014-11-11', '0', 'Adam', '11.25'],
['2014-11-12', '1', 'Smith', '12.25']
]
eq_(list(data), content)
mysession.close()
def test_sql_formating(self):
mysession = Session()
def custom_renderer(row):
return [str(element) for element in row]
# the key for this test case
sheet = SQLTableReader(mysession, Pyexcel,
row_renderer=custom_renderer)
data = sheet.to_array()
content = [
['birth', 'id', 'name', 'weight'],
['2014-11-11', '0', 'Adam', '11.25'],
['2014-11-12', '1', 'Smith', '12.25']
]
eq_(list(data), content)
mysession.close()