SQLAchemy

#创建表
def  create_db():
        engine = create_engine =(‘mysql+pymysql://root:741741@localhost:3306/db1‘,max_overflow = 5)
        Base.metadata.create_all(engine)

#删除表
def  drop_db()
         engine = create_engine =(‘mysql+pymysql://root:741741@localhost:3306/db1‘,max_overflow = 5)
         Base.metadata.drop_all(engine)

#!/usr/bin/env python
# -*- coding:utf-8 -*-

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey, UniqueConstraint, Index
from sqlalchemy.orm import sessionmaker, relationship
from sqlalchemy import create_engine

engine = create_engine("mysql+pymysql://root:741741@localhost/db1",max_overflow = 5)

Base = declarative_base()

#创建单表

class  UserType(Base):
    __tablename__ = ‘usertype‘

    id = Column(Integer,primary_key = True,autoincrement = True)
    title = Column(String(32),nullable = True,index = True)

class  Users(Base):
   __tablename__ = ‘users‘

    id = Column(Integer.primary_key = True,autoincrement = True,nullable=True)
    name = Column(String(32),nullable=True)
    extra  = Column(string(16))
    user_type_id = Column(Integer,ForeignKey(‘usertype,id‘))

    __table_args__(
        UniqueConstraint(‘id‘,‘name‘,name = ‘uix_id_name‘)
        Index (‘ix_id_name‘,‘name‘,‘extra‘)           
)