def get_all_campaigns(): """ Get all campaign tags in DB """ result = db.session.query(Tags.campaigns).filter(Tags.campaigns.isnot(None)) dto = TagsDTO() dto.tags = [r for r, in result] return dto
def get_all_organisations(): """ Get all org tags in DB """ result = db.session.query(Tags.organisations).filter(Tags.organisations.isnot(None)) dto = TagsDTO() dto.tags = [r for r, in result] return dto
def get_all_campaign_tag(preferred_locale='en'): query = db.session.query(Project.id, Project.campaign_tag, Project.private, Project.status)\ .join(ProjectInfo)\ .filter(ProjectInfo.locale.in_([preferred_locale, 'en'])) \ .filter(Project.private != True)\ .filter(Project.campaign_tag.isnot(None))\ .filter(Project.campaign_tag != '') query = query.distinct(Project.campaign_tag) query = query.order_by(Project.campaign_tag) tags_dto = TagsDTO() tags_dto.tags = [r[1] for r in query] return tags_dto