Write a script to safely delete all tables in the correct order, considering foreign key relationships.

编写一个脚本来安全地按顺序删除所有表，考虑到它们之间的外键关系，通常涉及到以下几个步骤。这里我会给出一个通用的Python示例，使用SQLite数据库为例，其他数据库（如MySQL、PostgreSQL等）可能会有所不同，但基本思路是一样的：

import sqlite3

# 连接到SQLite数据库
def connect_to_db(database):
    conn = sqlite3.connect(database)
    cursor = conn.cursor()
    return conn, cursor

# 获取所有表名并按依赖关系排序
def get_tables_and_relations(conn):
    cursor.execute("SELECT name FROM sqlite_master WHERE type='table'")
    tables = [row[0] for row in cursor.fetchall()]
    
    # 获取表间的依赖关系（例如外键）
    relations = {}  # 表名: 参考表名列表
    cursor.execute("""
        SELECT sql FROM sqlite_master 
        WHERE type='view' AND tbl_name IN ({})
    """.format(','.join('?' * len(tables))))
    for view_sql in cursor.fetchall():
        for table_name in tables:
            if table_name in view_sql[0]:
                relations[table_name] = relations.get(table_name, []) + [view_sql[0].split('.')[0]]

    # 按照外键依赖顺序排序
    ordered_tables = []
    while tables:
        current_table = tables.pop(0)
        if not relations.get(current_table):
            ordered_tables.append(current_table)
        else:
            for ref_table in relations[current_table]:
                if ref_table not in tables and ref_table not in ordered_tables:
                    tables.remove(ref_table)
    return ordered_tables

# 安全删除表
def delete_tables(conn, ordered_tables):
    for table_name in ordered_tables:
        cursor.execute(f"DROP TABLE IF EXISTS {table_name};")
        conn.commit()

# 示例使用
database_path = 'your_database.db'
conn, cursor = connect_to_db(database_path)
tables_to_delete = get_tables_and_relations(conn)
delete_tables(conn, tables_to_delete)
conn.close()