Код: Выделить всё
import pandas as pd
import numpy as np
import time
import datetime
import os
from pathlib import Path
import pyodbc
import sqlalchemy as sql
import inspect
import requests
import configparser
import re
import time
import math
from io import StringIO
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
logstuff = dict()
logstuff['Duplicity'] = 1
logstuff['basename'] = Path(__file__).stem
def GetLogFile():
global logstuff
LogFileName = os.environ['TEMP'] + '\\TWCO'
if not os.path.exists(LogFileName):
os.mkdir(LogFileName)
# print("In function: logstuff[basename]=" + logstuff['basename'])
if 'basename' in logstuff.keys():
LogFileName = LogFileName + "\\" + logstuff['basename'] + datetime.datetime.now().strftime("%Y%m%d-%H%M%S") + ".log"
else:
LogFileName = LogFileName + "\\" + Path(__file__).stem + datetime.datetime.now().strftime("%Y%m%d-%H%M%S") + ".log"
SALog = open(LogFileName, "w")
SALog.write("Python program " + Path(__file__).stem + " starting...\n")
logstuff['FileNumber'] = SALog
logstuff['FileName'] = LogFileName
return logstuff
def logsomething(logstring):
global logstuff
output = (datetime.datetime.now()).strftime("%Y-%m-%d %H:%M:%S") + " " + logstring
if logstuff['FileNumber']:
logstuff["FileNumber"].write(output + "\n")
if logstuff['Duplicity'] == 1:
print(output)
else:
print(output)
def ChangeDate(Date):
return datetime.datetime.strftime(datetime.datetime.strptime(Date, "%a, %d %b %Y %H:%M:%S"), "%d/%b/%Y %H:%M:%S")
def MakeBigInt(MyVar):
if isinstance(MyVar, float):
if math.isnan(MyVar):
return 0
else:
return int(MyVar)
else:
return int(MyVar)
def MakeString(MyVar):
if isinstance(MyVar, (float, int)):
if math.isnan(MyVar):
return ""
else:
return str(MyVar)
if isinstance(MyVar, str):
return MyVar
def MakeFloat(MyVar):
return float(MyVar)
start_time = time.time()
# os.system('cls')
ComputerName = os.environ['COMPUTERNAME']
ScriptName = str(Path(__file__))
GetLogFile()
logsomething("Reading the configuration files.")
config = configparser.ConfigParser(interpolation=None)
logsomething("Loaded ConfigParser")
config.read("//pri-lvm-na01/export_five9/Util/Five9CredsSA.ini")
logsomething("Opened Five9CredsSA.ini")
Five9Username = config['Communications']['Five9UserName']
logsomething("Five9 User Name: " + Five9Username)
Five9Password = config['Communications']['Five9Password']
logsomething("Five9 Password (don't tell anyone): " + Five9Password)
Код: Выделить всё
echo Running Program > Five9INRRpt.log
"C:/Program Files/Python312/python.exe" c:/Software/Py/Five9INRRpt.py >> Five9INRRpt.log
Код: Выделить всё
Python program Five9INRRpt starting...
2024-12-16 19:55:37 Reading the configuration files.
2024-12-16 19:55:37 Loaded ConfigParser
2024-12-16 19:55:40 Opened Five9CredsSA.ini
Большое спасибо!
Подробнее здесь: https://stackoverflow.com/questions/792 ... duled-task