14 lines
494 B
Python
14 lines
494 B
Python
from sqlalchemy import Integer,String,DATETIME,Column
|
|
from util.database import Base,engine
|
|
from datetime import datetime
|
|
|
|
class OrderModel(Base):
|
|
__tablename__ = 'order'
|
|
id = Column(Integer,primary_key=True,autoincrement=True)
|
|
title = Column(String(50),nullable=False)
|
|
userid = Column(Integer,nullable=False)
|
|
create_date = Column(DATETIME,default=datetime.now)
|
|
update_date = Column(DATETIME,default=datetime.now,onupdate=datetime.now)
|
|
|
|
Base.metadata.create_all(engine)
|