mysql多级目录数据库设置

SELECT * FROM project1.users
UNION ALL
SELECT * FROM project2.users;

import os
import mysql.connector

def create_directory_structure(base_dir):
    if not os.path.exists(base_dir):
        os.makedirs(base_dir)
    os.makedirs(os.path.join(base_dir, 'project1'))
    os.makedirs(os.path.join(base_dir, 'project2'))

def create_tables_in_directories():
    db_config = {
        'host': 'localhost',
        'user': 'root',
        'password': 'password'
    }

    projects = ['project1', 'project2']
    for project in projects:
        conn = mysql.connector.connect(**db_config, database=project)
        cursor = conn.cursor()
        cursor.execute(f"CREATE TABLE {project}_users (id INT PRIMARY KEY, name VARCHAR(255))")
        cursor.execute(f"CREATE TABLE {project}_orders (id INT PRIMARY KEY, user_id INT)")
        conn.commit()
        cursor.close()
        conn.close()

if __name__ == "__main__":
    base_dir = 'db_directories'
    create_directory_structure(base_dir)
    create_tables_in_directories()