19 lines
903 B
Python
19 lines
903 B
Python
#!/usr/bin/env python3
|
|
"""Read-only post-release verification for nearby post media."""
|
|
import json
|
|
import sys
|
|
|
|
sys.path.insert(0, '/www/server/xingyu-im/ops')
|
|
from baota_publish_test_users import BT, database, digest, env_values, health, query
|
|
|
|
EXPECTED = 'e8e071ec7006a32303f7cd654cddad8afda22ecb4fe83464305a9d3aef4d7280'
|
|
health()
|
|
assert digest(BT / 'xingyu-api') == EXPECTED
|
|
connection, _ = database(env_values())
|
|
try:
|
|
row = query(connection, "SELECT post.id,COUNT(media.id) FROM posts post JOIN users user ON user.id=post.user_id LEFT JOIN post_media media ON media.post_id=post.id WHERE user.public_id=%s AND post.status=1 AND post.deleted_at IS NULL GROUP BY post.id ORDER BY post.created_at DESC LIMIT 1", ('TESTCN000100',))[0]
|
|
assert row == (1, 2)
|
|
print(json.dumps({'health': 'ok', 'backendSha256': EXPECTED, 'postId': row[0], 'mediaCount': row[1]}))
|
|
finally:
|
|
connection.close()
|