21 lines
418 B
Python
21 lines
418 B
Python
|
|
||
|
|
|
||
|
|
from sqlalchemy import Column, Integer, String
|
||
|
|
|
||
|
|
#ORM基类
|
||
|
|
from sqlalchemy.ext.declarative import declarative_base
|
||
|
|
|
||
|
|
#创建ORM
|
||
|
|
Base = declarative_base()
|
||
|
|
|
||
|
|
class Products(Base):
|
||
|
|
__tablename__ = "products"
|
||
|
|
|
||
|
|
#字段 主键 索引
|
||
|
|
id = Column(Integer, primary_key=True, index=True)
|
||
|
|
#唯一约束
|
||
|
|
name = Column(String, unique=True, index=True)
|
||
|
|
|
||
|
|
described = Column(String)
|
||
|
|
|