def clean_name()

in flatten_join_nested_file.py [0:0]

• 18 lines of code
• 7 McCabe index (conditional complexity)

def clean_name(name_type, tbl_name, col_name, table_name_list, text_to_replace):
    if name_type == 'table':
        tbl_name = rm_suffix(tbl_name, '.val', 0)
        new_name = tbl_name.lower().replace(
            text_to_replace, "").replace(".", "_").replace("_val_", "_")
    elif name_type == 'column':
        col_name = rm_suffix(col_name, '.val', 0)
        new_name = col_name.lower().replace(
            ".val.", "_").replace(".", "_").replace("__", "_")
        if new_name in table_name_list:
            new_name = new_name+"_sk"
        elif new_name == 'id':
            new_name = tbl_name+"_sk"
        elif new_name == 'index':
            new_name = "rownum"
        elif not keep_table_prefix:
            new_name = new_name.replace(tbl_name+"_", "")
    return new_name