Python测试案例

最新推荐文章于 2024-04-17 19:56:50 发布

Spring-

最新推荐文章于 2024-04-17 19:56:50 发布

阅读量204

点赞数

文章标签： python 开发语言数据库

本文链接：https://blog.csdn.net/mobo123/article/details/130245158

版权

import psycopg2
import requests

conn = psycopg2.connect(
    host="10.10.10.10",
    database="it",
    user="test",
    password="test",
    port=8432
)

cur = conn.cursor()

# 查询语句
cur.execute(
    "select guid , wechat_groupid,group_wechat_content  from public.p_wechat_content where send_flag = 0")

rows = cur.fetchall()

# 打印结果
for row in rows:
    url = 'https://lang.com/api/itms_01_api_01_common_01_system/WeChatGroup_S1?'
    kw = {'chatID': row[1],
          'Content': row[2]}
    response = requests.post(url, params=kw)
    print(response.content.decode())
    print(row[0])
    cur.execute(
        "update public.p_wechat_content set send_flag  = 1  where guid  = %s", (row[0],))
    conn.commit()

cur.close()
conn.close()

import psycopg2
# TNS
conn = psycopg2.connect(
    host="10.10.10.10",
    database="it",
    user="test",
    password="test",
    port=8432
)
# 连接数据库
cur = conn.cursor()
# 查询语句
cur.execute(
    "  select\
            date_part('day', now() - a.u_time) delay_day,\
            b.emp_desc next_desc,\
            a.next_operator,\
            c.process_desc,\
            a.itsm_id,\
            a.itsm_title,\
            d.emp_desc,\
            a.c_time\
        from\
            public.p_itsm_status a,\
            public.s_user_info b,\
            public.m_process_info c,\
            public.s_user_info d\
        where\
            a.next_operator = b.emp_no\
            and a.next_process = c.guid\
            and a.c_emp_no = d.emp_no\
            and a.u_time <= now() + '-1 day'\
        order by\
            date_part('day', now() - a.u_time) desc\
    ")
# 游标
rows = cur.fetchall()

# 循环获取数据
for row in rows:
    print(row)
    cur.execute(
        "   insert\
                into\
            public.p_wechat_content1\
                ( wechat_emp_no,\
                group_wechat_content)\
            values( %s,\
'\
【IT运营管理平台通知】\n\
超时服务待处理\n\
超时天数: '||%s||'\n\
服务单号: '||%s||'\n\
服务标题: '||%s||'\n\
流程节点：'||%s||'\n\
请及时登陆系统处理!');\
", (row[2],row[0], row[4], row[5], row[3],))
    # 提交请求
    conn.commit()
# 关闭游标
cur.close()
# 关闭数据库连接
conn.close()

import cx_Oracle
import requests

conn = cx_Oracle.connect('LangSQMS/password123@10.10.10.10:1521/szdw')
cur = conn.cursor()

# 查询语句
cur.execute("SELECT distinct B.SQM_DRI ,'厂商未回复,请确认!' content  FROM SQMS.P_SUPPLIER_REPLY A,SQMS.M_SUPPLIER B WHERE A.SUPPLIER_GUID = B.GUID(+) AND A.REPLY_TIME IS NULL AND A.C_TIME < sysdate-1")

rows = cur.fetchall()

# 打印结果
for row in rows:
    url = 'https://lang.com/api/itms_01_api_01_common_01_system/WeChat_S1?EmpCodes='+row[0]+'&Content='+row[1]
    response = requests.post(url)
    print(response.content.decode())
    print(row[0])
    print(row[1])
    print(url)
    conn.commit()
cur.close()
conn.close()