python SQLAlchemy创建mysql数据库连接

from sqlalchemy import create_enginefrom sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKeyengine = create_engine('mysql+pymysql://root:123456@localhost:3306/test', echo=True)metadata = MetaData()users = Table('users', metadata,<span style="white-space:pre"></span>Column('id', Integer(), primary_key=True),<span style="white-space:pre"></span>Column('name', String(20)),<span style="white-space:pre"></span>Column('fullname', String(20)))addresses = Table('addresses', metadata,<span style="white-space:pre"></span>Column('id', Integer(), primary_key=True),<span style="white-space:pre"></span>Column('user_id', None, ForeignKey('users.id')),<span style="white-space:pre"></span>Column('email_address', String(30), nullable=False))metadata.create_all(engine)