sqlalchemy 删除指定表 创建指定表

重点

del_list = [Cvg.__table__, Filtered.__table__, Odm_id.__table__]


Base.metadata.drop_all(tables=del_list)
Base.metadata.create_all(tables=del_list)

整个代码

import xlrd
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine, Column, String, Integer, func
from sqlalchemy.orm import sessionmaker
from datetime import datetime
s = datetime.now()

HOSTNAME = '127.0.0.1'
PORT = '3306'
DATABASE = 'hongmei'
USERNAME = 'root'
PASSWORD = 'root'

# dialect+driver://username:password@host:port/database
DB_URI = "mysql+pymysql://{username}:{password}@{host}:{port}/{db}?charset=utf8".format(username=USERNAME,password=PASSWORD,host=HOSTNAME,port=PORT,db=DATABASE)

engine = create_engine(DB_URI)
Base = declarative_base(engine)

session = sessionmaker(engine)()



class Cvg(Base):
    __tablename__ = 'cvg'
    id = Column(Integer, primary_key=True, autoincrement=True)
    aws_sku = Column(String(50))
    supplier_sku = Column(String(50))
    qty_picked = Column(Integer)
    qty_on_hold = Column(Integer)
    qty_available = Column(Integer)
    odm_id = Column(String(50))

class Filtered(Base):
    __tablename__ = 'filtered'
    id = Column(Integer, primary_key=True, autoincrement=True)
    site = Column(String(50))
    aws_sku = Column(String(50))
    supplier_sku = Column(String(50))
    qty_picked = Column(Integer)
    qty_on_hold = Column(Integer)
    qty_available = Column(Integer)
    odm_id = Column(String(50))

class Odm_id(Base):
    __tablename__ = 'odm_id'
    id = Column(Integer, primary_key=True, autoincrement=True)
    site = Column(String(50))
    aws_sku = Column(String(50))
    supplier_sku = Column(String(50))
    qty_available = Column(Integer)
    odm_id = Column(String(50))

class Ww(Base):
    __tablename__ = 'ww'
    id = Column(Integer, primary_key=True, autoincrement=True)
    site = Column(String(50))
    pn = Column(String(50))
    fox_pn = Column(String(50))
    project = Column(String(50))
    type = Column(String(50))
    qty_reservation = Column(Integer)
    qty_picked = Column(Integer)
    qty_on_hold = Column(Integer)
    qty_available = Column(Integer)
    on_way = Column(Integer)

class Week_data(Base):
    __tablename__ = 'week_data'
    id = Column(Integer, primary_key=True, autoincrement=True)
    day = Column(String(50),primary_key=True)
    week = Column(String(50))
    site = Column(String(50), primary_key=True)
    pn = Column(String(50), primary_key=True)
    fox_pn = Column(String(50))
    total = Column(String(50))

class Week_name(Base):
    __tablename__ = 'week_name'
    id = Column(Integer, primary_key=True, autoincrement=True)
    day = Column(String(50), primary_key=True)
    week = Column(String(50))


del_list = [Cvg.__table__, Filtered.__table__, Odm_id.__table__]


Base.metadata.drop_all(tables=del_list)
Base.metadata.create_all(tables=del_list)