flask_paginate对mysql数据进行分页查询

使用flask_paginate对mysql数据进行分页查询，这里介绍使用原生sql方法，也可以使用SQLAlchemy对数据做查询

app.py

from flask import Flask,render_template,redirect
from flask import request
from db_helper import MySQL
from flask_paginate import Pagination,get_page_parameter
 
app = Flask(__name__)
      
@app.route('/test/', defaults={'page': 1})
@app.route('/test/<page>')
def test(page):
    page = request.args.get(get_page_parameter(), type=int, default=int(page))
　　dbconn = MySQL(host='10.10.10.1', user='root', passwd='passwd', db='test', port=3306, charset="utf8mb4")
    select_sql = "select * from server"
　　# 分页数
    page_num = 5
    filter_sql =  ("  ORDER BY id ASC LIMIT {limit} offset {offset}".format(limit=page_num, offset = (page_num * int(page)-page_num)))
    ret_sql = select_sql + filter_sql
    table_data = dbconn.fetch_rows(ret_sql, as_dict=True)
    table_data_total = len(dbconn.fetch_rows(select_sql, as_dict=True))
    paginate = Pagination(page=page, total=table_data_total,per_page=page_num)
    return render_template('test.html', table_ret = table_data, paginate=paginate)
 
if __name__ == "__main__":
    app.run()

1	`## https://www.cnblogs.com/liucx/`

1	`test.html`

<div class="col">
           <table class="table table-bordered table-hover">
               <thead>
                   <th>服务器名</th>
                   <th>服务器IP</th>
                   <th>服务器端口</th>
                   <th>服务器用户</th>
                   <th>操作</th>
               </thead>
               <tbody id="tbodycontent">
                   {% if table_ret %}
                   {% for row in table_ret %}
                   <tr>
                       <td> {{ row.name }}</td>
                       <td> {{ row.ip }}</td>
                       <td> {{ row.port }}</td>
                       <td> {{ row.user }}</td>
                       <td> </td>
                   </tr>
                   {% endfor %}
                   {% endif %}
               </tbody>
           </table>
           <div class="page_footer"><span class="page_total">共 {{ paginate.total }} 条</span> {{ paginate.links }}</div>
       </div>