db_path = folder / 'session.sqlite'
with sqlite3.connect(db_path) as db:
    db.execute('CREATE TABLE IF NOT EXISTS sessions(id TEXT PRIMARY KEY,summary TEXT)')
    db.execute('INSERT OR REPLACE INTO sessions VALUES(?,?)', ('demo-session', json.dumps(output, ensure_ascii=False)))
with sqlite3.connect(db_path) as db:
    restored = json.loads(db.execute('SELECT summary FROM sessions WHERE id=?', ('demo-session',)).fetchone()[0])
normalized = {**restored, 'current_day': {'Wednesday': '周三'}.get(restored['current_day'], restored['current_day']), 'superseded_day': {'Tuesday': '周二'}.get(restored['superseded_day'], restored['superseded_day'])}
check('关闭并重开数据库后事实与待确认项仍在', restored == output and normalized['current_day'] == '周三' and restored['replacement_confirmed'] is False)
result = {'raw_restored_session': restored, 'normalized_session': normalized, 'restart_readback': True}
