import hashlib,json,sys
from pathlib import Path
sys.path.insert(0,'/www/server/xingyu-im/ops')
from baota_publish_test_users import database,env_values,query
p=Path('/www/server/xingyu-im/bt/xingyu-api'); values=env_values(); conn,_=database(values)
try:
 visible=query(conn,"SELECT COUNT(*) FROM user_privacy_settings privacy JOIN users user ON user.id=privacy.user_id WHERE user.is_test=1 AND user.deleted_at IS NULL AND privacy.online_visible=1")[0][0]
 total=query(conn,"SELECT COUNT(*) FROM users WHERE is_test=1 AND deleted_at IS NULL")[0][0]
finally: conn.close()
print(json.dumps({'backendSha256':hashlib.sha256(p.read_bytes()).hexdigest(),'demonstrationOnlineVisible':visible,'demonstrationTotal':total,'releaseResult':Path('/www/backup/xingyu-presence-20260901-182015/result.json').is_file()}))
assert hashlib.sha256(p.read_bytes()).hexdigest()=='61eccfe663d8fc42428e8b9ed4ac22a713ffe0d4627b0c264ab071703092492a'
assert visible==total and total>0