aboutsummaryrefslogtreecommitdiff
path: root/ustayml/views
diff options
context:
space:
mode:
Diffstat (limited to 'ustayml/views')
-rw-r--r--ustayml/views/students.py18
1 files changed, 2 insertions, 16 deletions
diff --git a/ustayml/views/students.py b/ustayml/views/students.py
index fef1a82..ba1de04 100644
--- a/ustayml/views/students.py
+++ b/ustayml/views/students.py
@@ -1,4 +1,3 @@
-import math
import datetime
from flask import (
Blueprint, flash, g, redirect, render_template, request, url_for
@@ -6,7 +5,7 @@ from flask import (
from werkzeug.exceptions import abort
from ustayml.views.auth import login_required
-from ustayml.db import get_db
+from ustayml.db import get_db, get_paginated_items
bp = Blueprint('students', __name__, url_prefix='/students')
@@ -70,17 +69,4 @@ def details(id):
return render_template(
'students/details.html',
date=datetime.datetime.now()
- )
-
-
-# Helper functions
-
-def get_paginated_items(query: str, params: list=[], pagination: dict={}):
- limit = pagination.get('pagesize', 100)
- offset = pagination.get('page', 0) * limit
- with get_db().cursor() as cursor:
- cursor.execute(f"{query} LIMIT %s OFFSET %s;", params + [limit, offset])
- pagination['n_pages'] = math.ceil(cursor.rowcount / limit)
- pagination['rowcount'] = cursor.rowcount
- items = cursor.fetchall()
- return items
+ ) \ No newline at end of file