连接数据库并修改

import pymysql
# ip = "10.10.243.61"
# port = 3306
# user = "root"
# passwd = "Abc123456+"
# db = "ad-system"


def update_campaign():
    print("开始更新系列-------------")
    conn = pymysql.connect(host=ip, user=user, passwd=passwd, db=db, port=port, charset='utf8')
    # 获取游标
    cur = conn.cursor()

    try:
        if cur.execute("""UPDATE advertseries SET status='PAUSED' WHERE status='草稿';"""):
            print('Successful')
            conn.commit()
        else:
            print("未执行")
    except:
        print('Fail')
    
    # 关闭游标
    cur.close()
    # 关闭数据库
    conn.close()
    print("更新系列结束-------------")


def update_set():
    print("开始更新广告组-------------")

    conn = pymysql.connect(host=ip, user=user, passwd=passwd, db=db, port=port, charset='utf8')
    # 获取游标
    cur = conn.cursor()
    
    try:
        if cur.execute("""UPDATE advertset SET advert_set_status='PAUSED' WHERE advert_set_status='草稿';"""):
            print('Successful')
            conn.commit()
        else:
            print("未执行")
    except:
        print('Fail')
    
    # 关闭游标
    cur.close()
    # 关闭数据库
    conn.close()
    print("更新广告组结束-------------")


def update_ad():
    print("开始更新广告-------------")

    conn = pymysql.connect(host=ip, user=user, passwd=passwd, db=db, port=port, charset='utf8')
    # 获取游标
    cur = conn.cursor()
    
    try:
        if cur.execute("""UPDATE advert SET advert_state='PAUSED' WHERE advert_state='草稿';"""):
            print('Successful')
            conn.commit()
        else:
            print("未执行")
    except:
        print('Fail')
    
    # 关闭游标
    cur.close()
    # 关闭数据库
    conn.close()
    print("更新广告结束-------------")


update_campaign()
update_set()
update_ad()