import traceback
import requests
import logging
import os
from mysql_factory.connection import Conn_Db
from mysql_factory.dau import Data_utils
from Git_factory.dau import Data_Handle
from Git_factory.connection import Conn_Git
from pprint import pprint
from utils import Config_Utils
from suds.client import Client
b = os.path.dirname(__file__)
git_sql_cfg_file = os.path.join(b,'E:/xxxx/xxxx/xxx/sql.yaml')
git_sql_cfg = Config_Utils.read_config(git_sql_cfg_file)
department_name=input("请输入需要查询的部门: ")
git_sql_week__cfg = git_sql_cfg['sql_email'].format(department_name)
git_sql_history_cfg = git_sql_cfg['sql_all_email'].format(department_name)
pool,conn = Conn_Db.get_connection_pool("test_server")
cursor = conn.cursor()
cursor.execute(git_sql_week__cfg )
results=cursor.fetchall()
ret = []
for i in results:
temp = {
'date_range':i[0],'USER':i[1],'USER_ID':i[2
python发送HTML表格邮件
最新推荐文章于 2024-05-10 08:55:44 发布