INNER CODE UNIT · Python
offset
stanfrbd/cyberbro · app.py:354
offset: int = (page - 1) * per_page
# Build base query
base_query = db.session.query(AnalysisResult).filter(AnalysisResult.results != [])
base_query = apply_time_range_filter(base_query, time_range)
base_query = apply_search_filter(base_query, search_query, search_type)
# Handle observable search separately (requires in-memory filtering)
if search_query and search_type == "observable":
all_results = base_query.order_by(AnalysisResult.end_time.desc()).all()
filtered_results = filter_by_observable(all_results, search_query)
total_count = len(filtered_results)
analysis_results = filtered_results[offset : offset + per_page]
else:
total_count = base_query.count()
analysis_results = (
base_query.order_by(AnalysisResult.end_time.desc()).limit(per_page).offset(offset).all()
)