from pony.orm import * from models.DataBase import DataBase from models.EntityTags import EntityTags db = DataBase.get_database() class Questionnaire(db.Entity): id = PrimaryKey(int, auto=True) event = Required(str) title = Required(str) tag = Optional('EntityTags') questions = Set('Question') bot_state = Set('State') @staticmethod @db_session def get_questionnaire(keyword): q = select(q for q in Questionnaire if q.tag.tag_value == keyword)[:] if len(q) == 0: return None return q[0] @staticmethod @db_session def get_questionnaire_by_id(q_id): return Questionnaire[q_id] @staticmethod @db_session def select_all_questionnaires(): q = select(p for p in Questionnaire)[:]
# coding: utf-8 import os from flask import Flask, request, send_from_directory, render_template, redirect, url_for, session import messenger as pltfm from config import CONFIG from fbpage import page from forms.create_forms import * from models.all_models import * from WitClient import WitClient from models.DataBase import DataBase DataBase.generate() app = Flask(__name__) app.config.update(dict( SECRET_KEY=CONFIG['SECRET_KEY'], WTF_CSRF_SECRET_KEY=CONFIG['WTF_CSRF_SECRET_KEY'] )) parentdir = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) os.sys.path.insert(0, parentdir) @app.route('/index') @app.route('/') def index(): if 'count' in session: session['count'] += 1 else: session['count'] = 0 return render_template('index.html', count=session['count'])