# 53 query函數可查詢的數據 1. 模型對象。指定查找這個模型中所有的對象 2. 模型中的屬性。可以指定只查找某個模型的其中幾個屬性 3. 聚合函數 * func.count:統計行的數量 * func.avg:求平均值 * func.max:求最大值 * func.min:求最小值 * func.sum:求和 4. 'func'上，其實沒有任何聚合函數，但是因為底層做了一些魔術，只要mysql中有聚合函數，都可以通過func調用 ```text 實例:session.query(func.avg(Arictle.title)).first() ``` ```text from sqlalchemy import create_engine,Column,Integer,String,DateTime,String,Float,func from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker import random HOSTNAME = '127.0.0.1' PORT = "3306" USERNAME = "root" PASSWORD = "123456" DATABASE = "xt_flask" DB_URI = "mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8".format(USERNAME,PASSWORD,HOSTNAME,PORT,DATABASE) from datetime import datetime 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) price = Column(Float,nullable=False) def __repr__(self): return "<Article(title:%s)>" % self.title # Base.metadata.drop_all() # Base.metadata.create_all() # for x in range(6): # article = Article(title='title%s'%x,price=random.randint(50,100)) # print(article) # session.add(article) # session.commit() # 模型對象 # articles = session.query(Article).all() # # for article in articles: # # print(article) # print(articles) # # 模型中的屬性 # articles = session.query(Article.title,Article.price).all() # print(articles) # 聚合函數 count = session.query(func.count(Article.id)).first() print(count) avg = session.query(func.avg(Article.price)).first() print(avg) max = session.query(func.max(Article.price)).first() print(max) min = session.query(func.min(Article.price)).first() print(min) sum = session.query(func.sum(Article.price)).first() print(sum) print(func.sum(Article.title)) ```