def test_check_row_1():
row = {'name': 'Bob', 'age': '5', 'eye colour': 'blue'}
assert check_row(row, ('age', '==', 5))
assert not check_row(row, ('eye colour', '==', 5))
assert check_row(row, ('eye colour', '==', 'blue'))
assert check_row(row, ('age', '>=', 4))
assert check_row(row, ('age', '<=', 1000))
def test_check_row_logical():
row = {
'Month': 'January',
'High(deg C)': '-4',
'Low(deg C)': '-13',
'Rain(days)': '9'
}
assert check_row(row, (('Rain(days)', '==', 9), 'OR', ('Month', '==', 1)))
assert not check_row(row,
(('Rain(days)', '==', 9), 'AND', ('Month', '==', 1)))
def test_check_row_logical():
row = {
'INSTNM': 'Oakwood University',
'ADM_RATE_ALL': '0.3435',
'SAT_AVG_ALL': '924'
}
assert check_row(row,
(('SAT_AVG_ALL', '==', 924), 'OR', ('INSTNM', '==', 924)))
assert not check_row(row, (('SAT_AVG_ALL', '==', 924), 'AND',
('INSTNM', '==', 924)))
def test_check_row():
"""Check row with floating point values"""
row = {
'INSTNM': 'Oakwood University',
'ADM_RATE_ALL': '0.3435',
'SAT_AVG_ALL': '924'
}
assert check_row(row, ('SAT_AVG_ALL', '==', 924))
assert not check_row(row, ('INSTNM', '==', 'Tuskegee University'))
assert check_row(row, ('INSTNM', '==', 'Oakwood University'))
assert check_row(row, ('ADM_RATE_ALL', '>=', 0.3))
assert check_row(row, ('ADM_RATE_ALL', '<=', 0.49))
def test_check_row_1():
"""Check row with negative numbers"""
row = {
'Month': 'January',
'High(deg C)': '-4',
'Low(deg C)': '-13',
'Rain(days)': '9'
}
assert check_row(row, ('Rain(days)', '==', 9))
assert not check_row(row, ('Month', '==', 1))
assert check_row(row, ('Month', '==', 'January'))
assert check_row(row, ('Low(deg C)', '>=', -14))
assert check_row(row, ('High(deg C)', '<=', -4))
def test_check_row_logical():
row = {'name': 'Bob', 'age': '5', 'eye colour': 'blue'}
assert check_row(row, (('age', '==', 5), 'OR', ('eye colour', '==', 5)))
assert not check_row(row,
(('age', '==', 5), 'AND', ('eye colour', '==', 5)))
def test_check_row_2():
"""Check row for header"""
hmap = header_map(table[0])
row = row2dict(hmap, table[0])
assert check_row(row, ('eye colour', '==', 'eye colour'))