mzinfo/V2/tests/Product.py

# coding: utf-8
from sqlalchemy import Column, Integer, String,Date,Numeric,Text
from sqlalchemy.ext.declarative import declarative_base
# 创建对象的基类:
Base = declarative_base()

class Product(Base):
    # 表的名字:
    __tablename__ = 'product'
    # 表的结构:
    PRODUCTID = Column(Integer,autoincrement=True, primary_key=True)
    NAME = Column(String(100))
    # AUTHOR = Column(String(25))
    # PUBLISHER = Column(String(50))
    # PUBLISHTIME = Column(Date)
    # PRODUCTNO = Column(String(25))
    # SATETYSTOCKLEVEL = Column(Integer)
    # ORIGINALPRICE = Column(Numeric(19,4))
    # NOWPRICE = Column(Numeric(19,4))
    # DISCOUNT = Column(Numeric(2,1))
    # DESCRIPTION = Column(Text)
    # TYPE = Column(String(5))
    # PAPERTOTAL = Column(Integer)
    # WORDTOTAL = Column(Integer)
    # SELLSTARTTIME = Column(Date)
    # SELLENDTIME = Column(Date)