Eidan T.
115 lines
4.7 KiB
Python
115 lines
4.7 KiB
Python
import os
|
|
|
|
from App.Config.GeneralConfig import GeneralConfig
|
|
from App.Config.GeneralConfig import ConfigFTP
|
|
from App.Utils.db_utils import DatabaseManager
|
|
from App.Utils.ftp_utils import FTPManager
|
|
from App.Utils.sftp_utils import SFTPManager
|
|
|
|
|
|
|
|
class FeduroConfig:
|
|
|
|
def __init__(self):
|
|
#Inicializando la base de datos
|
|
self.databaseCode = 'IS001'
|
|
self.databaseID = '00010007'
|
|
|
|
self.database = DatabaseManager(self.databaseCode, self.databaseID)
|
|
|
|
#Inicialzando el FTP
|
|
self.ftpdatabase = FTPManager(ConfigFTP.ftp_server, ConfigFTP.ftp_user, ConfigFTP.ftp_password, ConfigFTP.ftp_port)
|
|
|
|
#Inicializando el SFTP
|
|
self.sftp_host = 'c6a3nxpth6mf4.eastus2.azurecontainer.io'
|
|
self.sftp_port = 22
|
|
self.sftp_username = 'eLeader01'
|
|
self.sftp_password = 'c8gNBhJE@zt$ZkT&'
|
|
|
|
self.sftpdatabase = SFTPManager(self.sftp_host, self.sftp_port, self.sftp_username, self.sftp_password)
|
|
|
|
|
|
#Inicializando SharePoint
|
|
|
|
self.userSharepoint = 'feddatadeployment.im@pg.com' #os.getenv('sharepointPG_user')
|
|
self.passwordSharepoint = 'Feduro_PG_2025$' #= os.getenv('sharepointPG_password')
|
|
self.siteSharepoint = 'https://pgone.sharepoint.com/sites/feduroinfinitystores' #os.getenv('sharepointPG_site')
|
|
|
|
|
|
#General configuration feduro
|
|
self.areaID = '0007'
|
|
self.project_name = 'FEDURO'
|
|
self.classID = '0003'
|
|
|
|
|
|
self.reports = self.database.get_execute_query(f"select * from TransferData where active = 1")
|
|
|
|
|
|
|
|
|
|
self.reports_sftp = {'Cobertura':'/upload/FEDURO/DataCollection/Cobertura/CoberturaCheckIn-Out/',
|
|
'NegociadasIS001':'/upload/FEDURO/DataCollection/Negociadas/AC Ejecutado/',
|
|
'Promociones':'/upload/FEDURO/DataCollection/Promociones/PROMO EJECUTADA/',
|
|
'Precios':'',
|
|
'Fmot':'/upload/FEDURO/DataCollection/Fmot/fmot Data/',
|
|
'QualityDisplay':'/upload/FEDURO/DataCollection/Quality Display/',
|
|
'Checkout':'/upload/FEDURO/DataCollection/CheckOut/Data/',
|
|
'QualityShelf':'/upload/FEDURO/DataCollection/QualityShelf/QualityShelf_Data/',
|
|
'SOSFeduro':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'OsaTorre':'',
|
|
'OsaPsmt':'',
|
|
'OsaFarmacia':'',
|
|
'OsaFotografico':'/upload/FEDURO/DataCollection/OSA/OSA_Fotos_Categoria/',
|
|
'DataAvailability':'',
|
|
'OsaAnalogo': '/upload/FEDURO/DataCollection/OSA/Data/',
|
|
'ModuloTareas': '/upload/FEDURO/DataCollection/ModuloTareas/Data/',
|
|
'SOSAPDO_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSBabyCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSFabricCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSFamilyCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSFemCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSHairCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSHomeCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSOralCare_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/',
|
|
'SOSPHC_IS001':'/upload/FEDURO/DataCollection/SOS/Share of Share Ejecutado/'
|
|
}
|
|
|
|
|
|
|
|
self.reportsID = {'Cobertura':'0001',
|
|
'NegociadasIS001':'0002',
|
|
'Promociones':'0003',
|
|
#'Precios':'0004',
|
|
'Fmot':'0005',
|
|
'QualityDisplay':'0006',
|
|
'Checkout':'0007',
|
|
'QualityShelf':'0008',
|
|
'SOSFeduro':'0009',
|
|
#'OsaTorre':'0010',
|
|
#'OsaPsmt':'0011',
|
|
#'OsaFarmacia':'0012',
|
|
'OsaFotografico':'0013',
|
|
#'DataAvailability':'0014',
|
|
'OsaAnalogo':'0015',
|
|
'ModuloTareas':'0016',
|
|
#'SOSAPDO_IS001':'0017',
|
|
#'SOSBabyCare_IS001':'0018',
|
|
#'SOSFabricCare_IS001':'0019',
|
|
#'SOSFamilyCare_IS001':'0020',
|
|
#'SOSFemCare_IS001':'0012',
|
|
#'SOSHairCare_IS001':'0022',
|
|
#'SOSHomeCare_IS001':'0023',
|
|
#'SOSOralCare_IS001':'0024',
|
|
#'SOSPHC_IS001':'0025'
|
|
}
|
|
|
|
self.steps = {
|
|
"sftp": True,
|
|
"ftp": True,
|
|
"sharepoint_python": True,
|
|
"sharepoint_N8N": False,
|
|
}
|
|
|
|
|
|
|
|
|