Python -多重表创建

import MySQLdb

# 连接数据库
conn = MySQLdb.connect(host='localhost', user='root', password='password', db='mydatabase')
cursor = conn.cursor()

# 创建表格
table1 = '''
CREATE TABLE table1 (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(255),
  age INT
)
'''

table2 = '''
CREATE TABLE table2 (
  id INT PRIMARY KEY AUTO_INCREMENT,
  city VARCHAR(255),
  country VARCHAR(255)
)
'''

# 执行SQL语句
cursor.execute(table1)
cursor.execute(table2)

# 提交更改
conn.commit()

# 关闭连接
cursor.close()
conn.close()

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

# 创建引擎和会话
engine = create_engine('mysql://root:password@localhost/mydatabase')
Session = sessionmaker(bind=engine)
session = Session()

# 创建基类
Base = declarative_base()

# 创建表格类
class Table1(Base):
    __tablename__ = 'table1'
    
    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String(255))
    age = Column(Integer)
    
class Table2(Base):
    __tablename__ = 'table2'
    
    id = Column(Integer, primary_key=True, autoincrement=True)
    city = Column(String(255))
    country = Column(String(255))

# 创建表格
Base.metadata.create_all(engine)

# 关闭会话
session.close()