如何转储某些SQLite3表的数据？

$ sqlite3 mydatabase.db
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> .dump mytable
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE mytable (id INTEGER PRIMARY KEY, name TEXT, age INTEGER);
INSERT INTO "mytable" VALUES(1,'John',30);
INSERT INTO "mytable" VALUES(2,'Alice',25);
INSERT INTO "mytable" VALUES(3,'Bob',35);
COMMIT;

import sqlite3

# 连接到数据库
conn = sqlite3.connect('mydatabase.db')

# 创建一个游标对象
cursor = conn.cursor()

# 获取表名列表
tables = cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")

# 遍历表名列表
for table_name in tables:
    # 获取表结构
    schema = cursor.execute(f"SELECT sql FROM sqlite_master WHERE name='{table_name[0]}';")
    print(schema.fetchone()[0])

    # 获取表数据
    data = cursor.execute(f"SELECT * FROM {table_name[0]};")

    # 遍历表数据并输出
    for row in data.fetchall():
        print(f"INSERT INTO {table_name[0]} VALUES({','.join(row)});")

# 关闭连接
conn.close()