老师这是啥错误·
from sqlalchemy import create_engine,Column,Integer,Float,Boolean,DECIMAL,Enum,\
Date,DateTime,Time,String,Text,func,or_,and_,ForeignKey,Table
from sqlalchemy.dialects.mysql import LONGTEXT
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker,relationship,backref
import random,time
from datetime import datetime
HOSTNAME = '127.0.0.1'
PORT = '3306'
DATABASE = 'first_sqlalchemy'
USERNAME = 'root'
PASSWORD = '123456'
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 Article(Base):
__tablename__ = 'article'
id = Column(Integer, primary_key=True, autoincrement=True)
title = Column(String(50), nullable=False)
create_time = Column(DateTime, nullable=False, default=datetime.now)
__mapper_args__ = {
"order_by": create_time # 正序
# "order_by": create_time.desc() #倒序
}
def __repr__(self):
return "<Article(title:%s,create_time:%s)>" % (self.title,self.create_time)
def add_data():
Base.metadata.drop_all()
Base.metadata.create_all()
article1 = Article(title='title1')
session.add(article1)
session.commit()
time.sleep(3)#3秒后再添加另一个数据
article2 = Article(title='title2')
session.add(article2)
session.commit()
def oper():
#正序排序
# article1=session.query(Article).order_by(Article.create_time).all()
# print(article1)
#降序排序
article2=session.query(Article).all()
print(article2)
if __name__=="__main__":
add_data()
oper()
D:\python__virtual\flask_ennv\Scripts\python.exe "D:/pythonz资料/所有资料 flask sql/4.源码/35_sqlalchemy_demo/Demo16_02.py"
Traceback (most recent call last):
File "D:\pythonz资料\所有资料 flask sql\4.源码\35_sqlalchemy_demo\Demo16_02.py", line 23, in <module>
class Article(Base):
File "D:\python__virtual\flask_ennv\lib\site-packages\sqlalchemy\orm\decl_api.py", line 72, in __init__
_as_declarative(reg, cls, dict_)
File "D:\python__virtual\flask_ennv\lib\site-packages\sqlalchemy\orm\decl_base.py", line 126, in _as_declarative
return _MapperConfig.setup_mapping(registry, cls, dict_, None, {})
File "D:\python__virtual\flask_ennv\lib\site-packages\sqlalchemy\orm\decl_base.py", line 177, in setup_mapping
return cfg_cls(registry, cls_, dict_, table, mapper_kw)
File "D:\python__virtual\flask_ennv\lib\site-packages\sqlalchemy\orm\decl_base.py", line 314, in __init__
self._early_mapping(mapper_kw)
File "D:\python__virtual\flask_ennv\lib\site-packages\sqlalchemy\orm\decl_base.py", line 200, in _early_mapping
self.map(mapper_kw)
File "D:\python__virtual\flask_ennv\lib\site-packages\sqlalchemy\orm\decl_base.py", line 992, in map
mapper_cls(self.cls, self.local_table, **self.mapper_args),
TypeError: __init__() got an unexpected keyword argument 'order_by'
Process finished with exit code 1