# -*- coding: utf-8 -*- import sqlite3, io, sys sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8') c = sqlite3.connect(r'backend\data\shuili_exam.db') cur = c.cursor() # soft-delete my test notes cur.execute("UPDATE notes SET is_deleted=1 WHERE id IN (91,92,93)") print('notes soft-deleted:', cur.rowcount) # soft-delete my test embedded video cur.execute("UPDATE embedded_videos SET is_deleted=1 WHERE title LIKE 'S3%'") print('videos soft-deleted:', cur.rowcount) c.commit() print('done; notes now active:', cur.execute("SELECT COUNT(*) FROM notes WHERE is_deleted=0").fetchone()[0])