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
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)
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()
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}')
@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()
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)
def setup_db(): db_file = os.path.join(os.path.dirname(__file__), 'db', 'pypi.sqlite') db_session.global_init(db_file)
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)