eventcally/project/services/event_suggestion.py
2021-02-12 15:43:40 +01:00

24 lines
718 B
Python

from sqlalchemy import and_
from sqlalchemy.orm import load_only
from project import db
from project.models import EventReviewStatus, EventSuggestion
def insert_event_suggestion(event_suggestion):
event_suggestion.review_status = EventReviewStatus.inbox
db.session.add(event_suggestion)
def get_event_reviews_badge_query(admin_unit):
return EventSuggestion.query.options(load_only(EventSuggestion.id)).filter(
and_(
EventSuggestion.admin_unit_id == admin_unit.id,
EventSuggestion.review_status == EventReviewStatus.inbox,
)
)
def get_event_reviews_query(admin_unit):
return EventSuggestion.query.filter(EventSuggestion.admin_unit_id == admin_unit.id)