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(