Files

341 lines
14 KiB
Python

#!/usr/bin/env python3
"""
AeroTrack LAN Sync Server 自动化测试套件
全面覆盖物理药瓶生命周期、多设备协同、开新瓶、软删除墓碑恢复、跨时区与防覆盖保护。
"""
import unittest
import os
import sys
import json
import time
import socket
import tempfile
import urllib.request
import threading
import datetime
# 动态引入 server 模块
sys.path.insert(0, os.path.dirname(os.path.abspath(__file__)))
import server
def get_free_port():
s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
s.bind(('127.0.0.1', 0))
port = s.getsockname()[1]
s.close()
return port
class ServerIntegrationTestCase(unittest.TestCase):
@classmethod
def setUpClass(cls):
# 使用独立的临时数据库进行隔离测试
cls.temp_dir = tempfile.TemporaryDirectory()
cls.test_db = os.path.join(cls.temp_dir.name, 'test_aerotrack.db')
server.DB_FILE = cls.test_db
server.init_db()
cls.port = get_free_port()
server.server_address = ('127.0.0.1', cls.port)
cls.httpd = server.ThreadedHTTPServer(('127.0.0.1', cls.port), server.SyncHandler)
cls.thread = threading.Thread(target=cls.httpd.serve_forever, daemon=True)
cls.thread.start()
time.sleep(0.5)
@classmethod
def tearDownClass(cls):
cls.httpd.shutdown()
cls.httpd.server_close()
cls.temp_dir.cleanup()
def _post_json(self, path, data):
url = f"http://127.0.0.1:{self.port}{path}"
req = urllib.request.Request(
url,
data=json.dumps(data).encode('utf-8'),
headers={'Content-Type': 'application/json; charset=utf-8'}
)
with urllib.request.urlopen(req, timeout=3) as resp:
self.assertEqual(resp.status, 200)
return json.loads(resp.read().decode('utf-8'))
def _get(self, path):
url = f"http://127.0.0.1:{self.port}{path}"
with urllib.request.urlopen(url, timeout=3) as resp:
return resp.status, resp.read()
def test_01_init_db_schema_and_seed(self):
"""测试 1: 验证数据库表结构完整性与初始药瓶种子自动生成"""
conn = server.get_db()
bottles = conn.execute("SELECT * FROM bottles ORDER BY sequence_number ASC").fetchall()
self.assertEqual(len(bottles), 2)
flix_b1 = [b for b in bottles if b['canister_id'] == 'flixotide_primary'][0]
self.assertEqual(flix_b1['sequence_number'], 1)
self.assertEqual(flix_b1['total_doses'], 60)
self.assertEqual(flix_b1['remaining_doses'], 60)
self.assertEqual(flix_b1['is_active'], 1)
cols = [r['name'] for r in conn.execute("PRAGMA table_info(dose_records)").fetchall()]
self.assertIn('flixotide_bottle_id', cols)
self.assertIn('ventolin_bottle_id', cols)
self.assertIn('is_deleted', cols)
self.assertIn('updated_at', cols)
conn.close()
def test_02_ping_api(self):
"""测试 2: 验证 /api/v1/ping 接口正常连通"""
status, body = self._get('/api/v1/ping')
self.assertEqual(status, 200)
data = json.loads(body.decode('utf-8'))
self.assertEqual(data.get('status'), 'ok')
def test_03_sync_status_api(self):
"""测试 3: 验证 /api/v1/sync/status 接口返回完整的药瓶与方案状态"""
status, body = self._get('/api/v1/sync/status')
self.assertEqual(status, 200)
data = json.loads(body.decode('utf-8'))
self.assertEqual(data.get('status'), 'online')
self.assertIn('bottles', data)
self.assertIn('canisters', data)
self.assertIn('devices', data)
def test_04_device_a_inhalation_deduction(self):
"""测试 4: 设备 A 吸入 2 喷,服务端精准核算余量 (60 -> 58)"""
res = self._post_json('/api/v1/sync', {
'device_name': '妈妈手机',
'device_id': 'dev_phone_a',
'bottles': [],
'records': [
{
'id': 'rec_dose_01',
'startTime': '2026-10-28T05:00:00Z',
'endTime': '2026-10-28T05:01:00Z',
'flixotidePuffs': 2,
'ventolinPuffs': 0,
'flixotideBottleId': 'flix_b1_initial',
'isDeleted': False,
'updatedAt': '2026-10-28T05:01:00Z'
}
],
'canisters': []
})
b1 = [b for b in res['bottles'] if b['id'] == 'flix_b1_initial'][0]
self.assertEqual(b1['remainingDoses'], 58)
can = [c for c in res['canisters'] if c['id'] == 'flixotide_primary'][0]
self.assertEqual(can['remainingDoses'], 58)
def test_05_device_b_syncs_and_sees_deduction(self):
"""测试 5: 设备 B 首次同步,拉取到真实余量 58 喷,不被本地空状态冲刷"""
res = self._post_json('/api/v1/sync', {
'device_name': '爸爸手机',
'device_id': 'dev_phone_b',
'bottles': [],
'records': [],
'canisters': []
})
b1 = [b for b in res['bottles'] if b['id'] == 'flix_b1_initial'][0]
self.assertEqual(b1['remainingDoses'], 58)
self.assertEqual(len(res['records']), 1)
def test_06_device_a_opens_new_bottle_2(self):
"""测试 6: 设备 A 点击【开新瓶】,激活第 2 瓶,第 1 瓶归档,余量刷新为 60 喷"""
now_utc = (datetime.datetime.now(datetime.timezone.utc) + datetime.timedelta(minutes=1)).isoformat()
res = self._post_json('/api/v1/sync', {
'device_name': '妈妈手机',
'device_id': 'dev_phone_a',
'bottles': [
{
'id': 'flix_b1_initial',
'canisterId': 'flixotide_primary',
'name': '辅舒酮',
'sequenceNumber': 1,
'totalDoses': 60,
'openedAt': '2020-01-01T00:00:00Z',
'finishedAt': now_utc,
'isActive': False,
'openedByDevice': '系统初始化',
'updatedAt': now_utc
},
{
'id': 'flix_b2_uuid_test',
'canisterId': 'flixotide_primary',
'name': '辅舒酮',
'sequenceNumber': 2,
'totalDoses': 60,
'openedAt': now_utc,
'isActive': True,
'openedByDevice': '妈妈手机',
'updatedAt': now_utc
}
],
'records': [],
'canisters': []
})
b2 = [b for b in res['bottles'] if b['id'] == 'flix_b2_uuid_test'][0]
self.assertEqual(b2['sequenceNumber'], 2)
self.assertEqual(b2['isActive'], True)
self.assertEqual(b2['remainingDoses'], 60)
# 方案主表自动切换为当前活跃瓶的 60 喷
can = [c for c in res['canisters'] if c['id'] == 'flixotide_primary'][0]
self.assertEqual(can['remainingDoses'], 60)
def test_07_device_b_syncs_and_automatically_switches_to_bottle_2(self):
"""测试 7: 设备 B 同步后自动切换至第 2 瓶,首页对齐为满瓶 60 喷"""
res = self._post_json('/api/v1/sync', {
'device_name': '爸爸手机',
'device_id': 'dev_phone_b',
'bottles': [],
'records': [],
'canisters': []
})
active_flix = [b for b in res['bottles'] if b['canisterId'] == 'flixotide_primary' and b['isActive']][0]
self.assertEqual(active_flix['id'], 'flix_b2_uuid_test')
self.assertEqual(active_flix['sequenceNumber'], 2)
self.assertEqual(active_flix['remainingDoses'], 60)
def test_08_device_b_inhalation_on_bottle_2(self):
"""测试 8: 设备 B 在第 2 瓶上吸入 2 喷,准确扣减第 2 瓶 (60 -> 58)"""
res = self._post_json('/api/v1/sync', {
'device_name': '爸爸手机',
'device_id': 'dev_phone_b',
'bottles': [],
'records': [
{
'id': 'rec_dose_02',
'startTime': '2026-10-28T06:10:00Z',
'endTime': '2026-10-28T06:11:00Z',
'flixotidePuffs': 2,
'ventolinPuffs': 0,
'flixotideBottleId': 'flix_b2_uuid_test',
'isDeleted': False,
'updatedAt': '2026-10-28T06:11:00Z'
}
],
'canisters': []
})
b2 = [b for b in res['bottles'] if b['id'] == 'flix_b2_uuid_test'][0]
self.assertEqual(b2['remainingDoses'], 58)
can = [c for c in res['canisters'] if c['id'] == 'flixotide_primary'][0]
self.assertEqual(can['remainingDoses'], 58)
def test_09_soft_delete_tombstone_restores_dose(self):
"""测试 9: 设备 B 软删除误操作流水,全网标记 is_deleted=1,喷数自动恢复至 60"""
res = self._post_json('/api/v1/sync', {
'device_name': '爸爸手机',
'device_id': 'dev_phone_b',
'bottles': [],
'records': [
{
'id': 'rec_dose_02',
'isDeleted': True,
'updatedAt': '2026-10-28T06:15:00Z'
}
],
'canisters': []
})
b2 = [b for b in res['bottles'] if b['id'] == 'flix_b2_uuid_test'][0]
self.assertEqual(b2['remainingDoses'], 60) # 准确恢复为 60 喷
can = [c for c in res['canisters'] if c['id'] == 'flixotide_primary'][0]
self.assertEqual(can['remainingDoses'], 60)
def test_10_outdated_device_cannot_overwrite_server_truth(self):
"""测试 10: 离线超期设备拿着旧的 40 喷快照上线,服务端拒绝被其覆盖"""
res = self._post_json('/api/v1/sync', {
'device_name': '爷爷旧手机',
'device_id': 'dev_phone_c',
'bottles': [],
'records': [],
'canisters': [
{
'id': 'flixotide_primary',
'totalDoses': 60,
'remainingDoses': 40
}
]
})
can = [c for c in res['canisters'] if c['id'] == 'flixotide_primary'][0]
self.assertEqual(can['remainingDoses'], 60) # 维持权威真值,不被 40 冲刷
def test_11_dashboard_and_web_serving(self):
"""测试 11: 监控看板 HTML 渲染正常,包含物理药瓶档案表"""
status, body = self._get('/dashboard')
self.assertEqual(status, 200)
html = body.decode('utf-8')
self.assertIn('AeroTrack 局域网多设备同步服务器', html)
self.assertIn('物理药瓶开封与换瓶档案', html)
self.assertIn('第 2 瓶', html)
def test_12_medicine_lookup_api(self):
"""测试 12: 药品条码/追溯码在线快速检索 API"""
status, body = self._get('/api/v1/medicine/lookup?code=6925567800018')
self.assertEqual(status, 200)
res = json.loads(body.decode('utf-8'))
self.assertEqual(res['status'], 'ok')
self.assertIn('美林', res['data']['name'])
self.assertEqual(res['data']['spec'], '100ml:2g')
def test_13_family_medicine_sync_and_tombstone(self):
"""测试 13: 家庭药箱多设备双向同步与开封/删除"""
# 设备 A 上报录入美林和滴眼液
res_a = self._post_json('/api/v1/sync', {
'device_name': '妈妈手机',
'device_id': 'dev_phone_mom',
'medicines': [
{
'id': 'med_test_meilin',
'name': '美林 (布洛芬混悬液)',
'category': 'oralLiquid',
'spec': '100ml',
'storageLocation': '常温药箱',
'targetUser': '宝宝',
'expiryDate': '2027-10-31T00:00:00Z',
'shelfLifeDaysAfterOpening': 60,
'isOpened': False,
'updatedAt': '2026-10-28T07:00:00Z'
}
]
})
self.assertIn('medicines', res_a)
meds = res_a['medicines']
meilin = [m for m in meds if m['id'] == 'med_test_meilin'][0]
self.assertEqual(meilin['name'], '美林 (布洛芬混悬液)')
self.assertFalse(meilin['isOpened'])
# 设备 B 同步并将美林标记开封打卡
res_b = self._post_json('/api/v1/sync', {
'device_name': '爸爸手机',
'device_id': 'dev_phone_dad',
'medicines': [
{
'id': 'med_test_meilin',
'name': '美林 (布洛芬混悬液)',
'category': 'oralLiquid',
'expiryDate': '2027-10-31T00:00:00Z',
'shelfLifeDaysAfterOpening': 60,
'isOpened': True,
'openedAt': '2026-10-28T07:30:00Z',
'openedByDevice': '爸爸手机',
'updatedAt': '2026-10-28T07:30:00Z'
}
]
})
meilin_b = [m for m in res_b['medicines'] if m['id'] == 'med_test_meilin'][0]
self.assertTrue(meilin_b['isOpened'])
self.assertEqual(meilin_b['openedByDevice'], '爸爸手机')
# 监控看板中应包含家庭药箱信息
status, body = self._get('/dashboard')
self.assertEqual(status, 200)
html = body.decode('utf-8')
self.assertIn('家庭智能药箱健康与保质期监控', html)
self.assertIn('美林', html)
if __name__ == '__main__':
unittest.main()