app
from flask import Flask
from flask_script import Manager
from App.extends import init_third
from App.views import bp
app = Flask(__name__)
app.config.from_pyfile("settings.py")
manager = Manager(app)
init_third(app)
app.register_blueprint(bp)
if __name__ == '__main__':
manager.run()
settings
DEBUG = True
SQLALCHEMY_DATABASE_URI = "mysql+pymysql://root:19970223@localhost:3306/py2"
SQLALCHEMY_TRACK_MODIFICATIONS = False
App.extends
from flask_sqlalchemy import SQLAlchemy
from flask_bootstrap import Bootstrap
db = SQLAlchemy()
bst = Bootstrap()
def init_third(app):
db.init_app(app=app)
bst.init_app(app)
App.models
class User(db.Model):
__tablename__ = 'user'
uid = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(30), nullable=False)
password = db.Column(db.String(128), nullable=False)
gender = db.Column(db.Integer)
1
App.views
from flask import Blueprint, render_template
from App.models import User
bp = Blueprint("bp",__name__)
@bp.route("/list/")
@bp.route("/list/<int:page>/")
def list_user(page=1):
pagination = User.query.paginate(page,2)
print(pagination.__dict__)
return render_template("list1.html",**locals())
list.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title