from sqlalchemy import text import models import utils import random from models import (db) from config import DATA_IMAGES_PATH, IGN_KEY import json from datetime import datetime from flask_babel import format_datetime, gettext, ngettext main = Blueprint('main', __name__, template_folder='tpl') db = SQLAlchemy() dicotheme_schema = models.DicoThemeSchema(many=True) dicostheme_schema = models.DicoSthemeSchema(many=True) photo_schema = models.TPhotoSchema(many=True) site_schema = models.TSiteSchema(many=True) themes_sthemes_schema = models.CorSthemeThemeSchema(many=True) villes_schema = models.VilleSchema(many=True) communes_schema = models.CommunesSchema(many=True) @main.route('/') def home(): """ sql = text("SELECT value FROM geopaysages.conf WHERE key = 'home_blocks'") rows = db.engine.execute(sql).fetchall() id_photos = json.loads(rows[0]['value']) get_photos = models.TPhoto.query.filter( models.TPhoto.id_photo.in_(id_photos))
from config import DATA_IMAGES_PATH, DATA_NOTICES_PATH from pypnusershub import routes as fnauth from pypnusershub.db.models import AppUser import models import json import utils import os from env import db api = Blueprint('api', __name__) photo_schema = models.TPhotoSchema(many=True) site_schema = models.TSiteSchema(many=True) themes_schema = models.DicoThemeSchema(many=True) subthemes_schema = models.DicoSthemeSchema(many=True) licences_schema = models.LicencePhotoSchema(many=True) corThemeStheme_Schema = models.CorThemeSthemeSchema(many=True) themes_sthemes_schema = models.CorSthemeThemeSchema(many=True) ville_schema = models.VilleSchema(many=True) @api.route('/api/sites', methods=['GET']) def returnAllSites(): get_all_sites = models.TSite.query.order_by('ref_site').all() sites = site_schema.dump(get_all_sites) for site in sites: if len(site.get("t_photos")) > 0: if site.get('main_photo') == None: first_photo = site.get("t_photos") main_photo = models.TPhoto.query.filter_by(