import psycopg2
from psycopg2 import Error

def update_expiration_date():
    try:
        # 连接到 PostgreSQL 数据库
        connection = psycopg2.connect(user="your_username",
                                      password="your_password",
                                      host="your_host",
                                      port="your_port",
                                      database="adco")

        cursor = connection.cursor()

        # 执行更新操作
        cursor.execute("UPDATE ir_config_parameter SET value = '123456' WHERE key = 'database.expiration_date';")
        connection.commit()
        print("成功更新记录")

    except (Exception, Error) as error:
        print("更新记录时出错:", error)

    finally:
        # 关闭数据库连接
        if connection:
            cursor.close()
            connection.close()
            print("PostgreSQL 连接已关闭")

if __name__ == '__main__':
    update_expiration_date()