33 lines
1.2 KiB
Python
33 lines
1.2 KiB
Python
import psycopg2
|
|
|
|
conn = psycopg2.connect(
|
|
host='117.72.182.135', port=5432, user='postgres',
|
|
password='zhang520..', dbname='allapp'
|
|
)
|
|
cur = conn.cursor()
|
|
|
|
# 1. 检查 b_user.avatar
|
|
cur.execute("SELECT id, avatar FROM b_user WHERE avatar IS NOT NULL AND avatar != ''")
|
|
rows = cur.fetchall()
|
|
print(f"b_user avatar: {len(rows)} 条")
|
|
for r in rows[:5]:
|
|
print(f" id={r[0]}: {r[1]}")
|
|
|
|
# 2. 查 b_clothing_outfit 的结构 (需要 family_id)
|
|
cur.execute("SELECT column_name FROM information_schema.columns WHERE table_name='b_clothing_outfit' AND column_name IN ('id','family_id','cover_file_key') ORDER BY ordinal_position")
|
|
print(f"\nb_clothing_outfit cols: {[r[0] for r in cur.fetchall()]}")
|
|
|
|
cur.execute("SELECT id, family_id, cover_file_key FROM b_clothing_outfit WHERE cover_file_key IS NOT NULL AND cover_file_key != ''")
|
|
rows = cur.fetchall()
|
|
print(f" 非空: {len(rows)} 条")
|
|
for r in rows:
|
|
print(f" id={r[0]} family_id={r[1]}: {r[2]}")
|
|
|
|
# 3. 查所有 family_id 在 b_finance_category
|
|
cur.execute("SELECT id, family_id, icon_file_key FROM b_finance_category WHERE icon_file_key IS NOT NULL AND icon_file_key != '' LIMIT 3")
|
|
print(f"\nb_finance_category 样本:")
|
|
for r in cur.fetchall():
|
|
print(f" id={r[0]} family_id={r[1]}: {r[2]}")
|
|
|
|
conn.close()
|