예제 #1
0
def create_app(config_file='settings.py'):
    app = Flask(__name__)

    app.config.from_pyfile(config_file)
    db_file = app.config['SQLALCHEMY_DATABASE_URI']
    db_session.global_init(db_file)

    jwt = JWTManager(app)

    from routes import api_v1
    app.register_blueprint(api_v1, url_prefix='/api/v1')

    @app.errorhandler(404)
    def not_found(error):
        return make_response(jsonify({'error': 'Request not found'}), 404)

    return app
예제 #2
0
from flask import Flask, render_template
from models.news import News
from models.news import News2
from models.news import News3
from models import db_session
app = Flask(__name__)
db_session.global_init('db/sqlite.db')


@app.route('/')
def index():
    session = db_session.create_session()
    return render_template(
        'base.html',
        news=session.query(News).order_by(News.date.desc()),
        news2=session.query(News2).order_by(News2.stazh.desc()),
        news3=session.query(News3).order_by(News3.zarplata.desc()))


if __name__ == '__main__':
    app.run('127.0.0.1', 8000, True)
예제 #3
0
from models import db_session
from models.user import User, friends_relation

if __name__ == '__main__':
    db_session.global_init('sqlite:///../../db/wia_db.db')

session = db_session.create_session()
state = friends_relation.insert().values(user_id_1=1, user_id_2=2)
state2 = friends_relation.insert().values(user_id_1=2, user_id_2=1)
session.execute(state)
session.execute(state2)
session.commit()
예제 #4
0
from flask_restful import abort
from models import db_session
from models.add_site import AddSiteForm
from models.topic_form import AddTopicForm
from models.login_form import LoginForm
from models.users import User
from models.sites import Site
from models.topics import Topic
from models.register import RegisterForm

app = Flask(__name__)
app.config['SECRET_KEY'] = 'U74anllYYrxWwqcwImKh8LaGFdb8uM'

login_manager = LoginManager()
login_manager.init_app(app)
db_session.global_init("best_links.sqlite")

@login_manager.user_loader
def load_user(user_id):
    session = db_session.create_session()
    return session.query(User).get(user_id)

@app.route('/login', methods=['GET', 'POST'])
def login():
    form = LoginForm()
    if form.validate_on_submit():
        session = db_session.create_session()
        user = session.query(User).filter(User.email == form.email.data).first()
        if user and user.check_password(form.password.data):
            login_user(user, remember=form.remember_me.data)
            return redirect(f'/{0}/{0}')
예제 #5
0
@login_required
def profile(id):
    db_sess = db_session.create_session()
    prof = db_sess.query(User).get(id)
    return render_template('profile.html',
                           surname=prof.surname,
                           name=prof.name,
                           id=prof.id,
                           age=prof.age,
                           email=prof.email,
                           created_at=prof.created_at)


@app.route('/note/<int:id>')
@login_required
def note(id):
    one_note = \
        requests.get(f'http://localhost:5000/api/note/{id}').json()['notes']
    return render_template("note.html",
                           author_id=one_note['author_id'],
                           created_at=one_note['created_at'],
                           name=one_note['name'],
                           text=one_note['text'])


if __name__ == '__main__':
    db_session.global_init("db/db.sqlite")
    app.register_blueprint(note_api.blueprint)
    app.register_blueprint(message_api.blueprint)
    app.run()
예제 #6
0
def main():
    global engine
    engine = global_init('D:\\Projects\\SlipperBot\\Server\\develop.sqlite3')
    admin.init()
    resources.init_all()
    app.run(host='localhost', port=5000, debug=True)
예제 #7
0
def setup_db():
    db_file = os.path.join(os.path.dirname(__file__), 'db', 'pypi.sqlite')

    db_session.global_init(db_file)
예제 #8
0
from models import db_session
import os
import sqlalchemy as sa
from models.__all_models import *

db_path = os.path.join("db", "market.sqlite")
db_session.global_init(db_path)
# db_path = "reports"

# try:
#     with open("db_config") as f:
#         username, password = f.readline().split()
# except FileNotFoundError:
#     raise FileNotFoundError("Create file with name db_config in root with username and password to "
#                             "database separated with space")
# else:
#     db_session.global_init(db_path, username, password)