24 lines
510 B
Python
Executable File
24 lines
510 B
Python
Executable File
|
|
|
|
from sqlalchemy import Column, Integer, String, Boolean
|
|
|
|
#ORM基类
|
|
from sqlalchemy.ext.declarative import declarative_base
|
|
|
|
#创建ORM
|
|
Base = declarative_base()
|
|
|
|
class Admin(Base):
|
|
__tablename__ = "admin"
|
|
|
|
#字段 主键 索引
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
|
|
name = Column(String, index=True)
|
|
#唯一约束
|
|
username = Column(String, unique=True, index=True)
|
|
|
|
password = Column(String)
|
|
|
|
is_superuser = Column(Boolean, default=False, nullable=False)
|