import os
import time
import datetime
import pipes

DB_LIST = ['BDECR', 'BDEDO', 'BDEGT', 'BDEHN', 'BDENI', 'BDEPA', 'BDESV']
DB_USER = 'haproxy'
DB_PASS = str(os.getenv('QAPASS'))
DB_HOST = '159.203.104.215'
BACKUP_PATH = '/backup/'


def Backup():

    BACKUP_PATH = 'backup/'
    DATETIME = time.strftime('%d%m%d-%H%M')


    for DB_NAME in DB_LIST:
        DATETIME = time.strftime('%d%m%Y-%H%M')
        FILE_NAME = BACKUP_PATH + f'{DB_NAME}-' + DATETIME + '.sql'

        try:
            os.stat(FILE_NAME)
        except:
            os.mkdir(FILE_NAME)

        print(FILE_NAME)


Backup()