def test_aaa_normalize_column_name_convert_upper_case_to_lower():
print('aaa')
result = normalize_column_name('STATE_PROVINCE')
assert result == 'state_province'
def test_bbb_normalize_column_name_max_len():
print('bbb')
result = normalize_column_name('state_province', 10)
assert result == 'state_prov'
def test_normalize_column_name_already_normalized():
result = normalize_column_name('state_province')
assert result == 'state_province'
def test_ccc_normalize_column_name_convert_upper_case_to_lower_leading_blanks(
):
print('ccc')
result = normalize_column_name(' STATE_PROVINCE ')
assert result == 'state_province'
def test_normalize_column_name_max_len_do_not_leave_trailing_underscore():
result = normalize_column_name('state_', 6)
assert result == 'state'
def test_normalize_column_name_len_1():
result = normalize_column_name('x')
assert result == 'x'
def test_normalize_column_name_max_len_threshold_exactly():
result = normalize_column_name('state_province', 14)
assert result == 'state_province'
def test_normalize_column_name_max_len_threshold_plus_1():
result = normalize_column_name('state_province', 13)
assert result == 'state_provinc'
def test_normalize_column_name_max_len():
result = normalize_column_name('state_province', 10)
assert result == 'state_prov'
def test_normalize_column_name_strip_leading_and_trailing_whitespace():
result = normalize_column_name(' state_province ')
assert result == 'state_province'
def test_normalize_column_name_replace_dash_with_underscore():
result = normalize_column_name('state-province')
assert result == 'state_province'
def test_normalize_column_name_replace_multiple_spaces():
result = normalize_column_name('state province')
assert result == 'state_province'
def test_normalize_column_name(name, max_len, expected):
result = normalize_column_name(name, max_len)
assert result == expected
