09使用sqlalchemy创建表和类的映射关系2

from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey  # 导入元素
from sqlalchemy.orm import mapper  # 导入映射关系
from sqlalchemy import create_engine

engine = create_engine('mysql+pymysql://cai:123@localhost/test?charset=utf8', echo=True)
metedata = MetaData(bind=engine)
userTable = Table(
    'user',
    metedata,
    Column('id', Integer, primary_key=True),
    Column('name', String(50), unique=True),
    Column('fullname', String(50)),
    Column('password', String(20), default='123')
)


class User(object):
    def __int__(self, name, fullname, pwd):
        self.name = name
        self.fullname = fullname
        self.pwd = pwd


mapper(User, userTable)#绑定映射
metedata.create_all(engine)