使用Flask SQLAlchemy查询过滤器获取免费课程和收费课程.zip

from flask import Flask,render_template from flask_sqlalchemy import SQLAlchemy import pymysql import datetime from sqlalchemy import desc app = Flask(__name__) # 基本配置 app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True app.config['SQLALCHEMY_DATABASE_URI'] = ( 'mysql+pymysql://root:root@localhost/flask' ) db = SQLAlchemy(app) # 实例化SQLAlchemy类 # 创建数据表类 class Course(db.Model): course_id = db.Column(db.BigInteger,nullable=False,primary_key=True) product_id = db.Column(db.BigInteger,nullable=False) product_type = db.Column(db.Integer, nullable=False) product_name = db.Column(db.String(125), nullable=False) provider = db.Column(db.String(125), nullable=False) score = db.Column(db.Float(2)) score_level = db.Column(db.Integer) learner_count = db.Column(db.Integer) lesson_count = db.Column(db.Integer) lector_name = db.Column(db.String(125)) original_price = db.Column(db.Float(2)) discount_price = db.Column(db.Float(2)) discount_rate = db.Column(db.Float(2)) img_url = db.Column(db.String(125)) big_img_url = db.Column(db.String(125)) description = db.Column(db.Text) class Sale(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) course_id = db.Column(db.BigInteger, db.ForeignKey('course.course_id')) product_name = db.Column(db.String(125), nullable=False) learner_count = db.Column(db.Integer) create_time = db.Column(db.Date, default=datetime.date.today()) course = db.relationship('Course', backref=db.backref('sale', lazy='dynamic')) class User(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) username = db.Column(db.String(125), nullable=False) email = db.Column(db.String(125), nullable=False) password = db.Column(db.String(125), nullable=False) @app.route('/') def index(): """ 首页 :return: """ # 获取热门课程 hot_course = Course.query.filter( Course.original_price != 0).order_by( desc(Course.learner_count)).limit(6).all() # 获取免费课程 free_course = Course.query.filter_by(original_price=0).order_by( desc(Course.learner_count)).limit(6).all() return render_template('index.html', hot_course=hot_course, free_course=free_course) if __name__ == "__main__": app.run(debug=True)