19 lines
548 B
Python
19 lines
548 B
Python
"""修正 dev_test_openid 用户状态为 pending（与已有申请记录一致）"""
|
||
import os
|
||
import psycopg2
|
||
from dotenv import load_dotenv
|
||
|
||
load_dotenv()
|
||
dsn = os.environ["APP_DB_DSN"]
|
||
conn = psycopg2.connect(dsn)
|
||
conn.autocommit = True
|
||
cur = conn.cursor()
|
||
|
||
cur.execute("UPDATE auth.users SET status = 'pending', updated_at = NOW() WHERE wx_openid = 'dev_test_openid'")
|
||
print(f"更新行数: {cur.rowcount}")
|
||
|
||
cur.execute("SELECT id, status FROM auth.users WHERE wx_openid = 'dev_test_openid'")
|
||
print(f"验证: {cur.fetchone()}")
|
||
|
||
conn.close()
|