import csv
from pathlib import Path
from datetime import datetime

base_dir = "C:/Projekte/Python"
# timestamp = date.today().strftime('%Y%m%d')

def main():
    csv_reader = csv.reader(open(base_dir + '/gctools/DSG_Uebersetzung.csv', 'r', encoding='latin-1'), delimiter=';')
    translation = dict([(row[0], row[1]) for row in csv_reader if row[1] != ''])
    target = Path(base_dir + '/export_dsg')
    for filename in Path(base_dir + '/export').glob('*'):
        for (old, new) in translation.items():
            if '_' + old in filename.name:
                new_name = filename.name.replace(old, new)
                new_timestamp = datetime.fromtimestamp(filename.stat().st_mtime).strftime('%Y%m%d')

                new_name = new_name[:-4] + '_' + new_timestamp + new_name[-4:]
                new_filename = target.joinpath(new_name)
                print(filename.name + ' => ' + new_filename.name)
                filename.rename(new_filename)
                break


if __name__ == '__main__':
    main()