from flask import Flask from flask_migrate import Migrate, Manager, MigrateCommand from app.model.base import db app = Flask(__name__) app.config.from_pyfile('secure.py') app.config.from_pyfile('settings.py') migrate = Migrate(app, db) manager = Manager(app) manager.add_command('db', MigrateCommand) if __name__ == '__main__': manager.run()
from app import create_app, db, base, twitter, document_model, user_model, features from personality_recogniser import Recogniser from sqlalchemy import create_engine from itertools import zip_longest from flask_migrate import Manager from bot import Tweety import pandas as pd import time app = create_app() manager = Manager(app) engine = create_engine(app.config["SQLALCHEMY_DATABASE_URI"]) @manager.option("-s", "--schema", dest="s", help="Schema to featurise documents of.", default="personality") @manager.option("-b", "--batch_size", dest="b", help="Batch size to commit to database.", default=100) @manager.option("-f", "--force_all", dest="f", help="Featurise entries that have a feature already.", default=0) def featurise_documents(s, b, f):
#!/usr/bin/env python from flask_migrate import Manager, MigrateCommand from website import app manager = Manager(app) manager.add_command('db', MigrateCommand) if __name__ == '__main__': manager.run()
#Importujeme import root from root import models from flask_migrate import Migrate, Manager, MigrateCommand app = root.app #Nastavíme novou relativní cestu k databázi, jelikož script nespouštíme ze složky root app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///databaze.sqlite3" #Provedeme inicializaci migrate = Migrate(app, root.db) manager = Manager(app) #Přidáme přikaz pro manager manager.add_command("db", MigrateCommand) #Přikaz spustíme, pokud byl script spuštěn if __name__ == "__main__": manager.run()
'message': 'FORBIDDEN | Internal Only' }, 403 else: return fn(*args, **kwargs) return wrapper ####Database#### app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://a:b@c:3306/LKNU' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False db = SQLAlchemy(app) migrate = Migrate(app, db) manager = Manager(app) manager.add_command( 'db', MigrateCommand ) # command 'db' dapat menjalankan semua command MigrateCommand ###########Middleware############# @app.after_request def after_request(response): try: requestData = request.get_json() except Exception as e: requestData = request.args.to_dict() app.logger.warning( "REQUEST_LOG\t%s", json.dumps({
from flask_script import Shell, Server from flask_migrate import Manager, MigrateCommand from services.config import db, migrate from services.app import app from services.resources import Calculation manager = Manager(app) manager.add_command('db', MigrateCommand) manager.add_command('runserver', Server(host='0.0.0.0', port=5000)) if __name__ == '__main__': # manager.run() app.run(debug=True)
import pymysql from flask_migrate import Manager, MigrateCommand, Migrate from app import create_app pymysql.install_as_MySQLdb() app = create_app(config='dev') manage = Manager(app=app) manage.add_command('db', MigrateCommand) if __name__ == '__main__': manage.run()
#!/usr/bin/env python # -*- coding: UTF-8 -*- import os from flask_migrate import Migrate, Manager, MigrateCommand from flask_script import Shell from app import create_app, db from app.models import User, Role app = create_app(os.getenv('FLASK_CONFIG') or 'default') migrate = Migrate(app, db) manager = Manager(app) def make_shell_context(): return dict(db=db, User=User, Role=Role) manager.add_command("shell", Shell(make_context=make_shell_context)) manager.add_command('db', MigrateCommand) @manager.command def test(): """Run the unit tests.""" import unittest tests = unittest.TestLoader().discover('tests') unittest.TextTestRunner(verbosity=2).run(tests) if __name__ == '__main__':
# !/usr/bin/env python3 # -*- coding: utf-8 -*- """ python3 program to store and manipulate personal contact information for current contacts as class-objects in Postgresql using SQLAlchemy and Flask. make database migration command from extension flask_migrate available """ from cntct import create_app from flask_migrate import MigrateCommand, Manager manager = Manager(create_app) manager.add_command('db', MigrateCommand)
from . import create_app from flask_script import Command from flask_migrate import MigrateCommand, Manager class Init_Admin(Command): def run(self): from .models.Admin import Administrator Administrator.init() manager = Manager(create_app) manager.add_command('init_admin', Init_Admin) if __name__ == '__main__': manager.run()
If you want to see a list of commands that you can use with Flask-Migrate: python -m service.db_migrate db --help A useful URL: https://www.youtube.com/watch?v=BAOfjPuVby0&t=384s A useful URL for migration with non-nullable columns https://medium.com/the-andela-way/alembic-how-to-add-a-non-nullable-field-to-a-populated-table-998554003134 Useful bug: https://stackoverflow.com/questions/32311366/alembic-util-command-error-cant-find-identifier Detect minor changes: https://stackoverflow.com/questions/58532518/why-flask-migrations-does-not-detect-a-fields-length-change """ from app import create_app from flask_migrate import Manager, MigrateCommand # Set up the database migration manager = Manager(create_app) manager.add_command('db', MigrateCommand) manager.add_option("-env", "--environment", default='d', required=False) if __name__ == '__main__': manager.run()
import os from app import create_app from flask_migrate import MigrateCommand, Manager from dotenv import load_dotenv load_dotenv() manager = Manager(create_app("production")) manager.add_command('db', MigrateCommand) print(os.environ.get("FLASK_CONFIG")) if __name__ == '__main__': manager.run()
def init_app(app): migrate.init_app(app, db) manager = Manager(app) manager.add_command("db", MigrateCommand)
# 导入扩展Flask_cript from flask_migrate import Manager from flask_migrate import Migrate # ManagerCommand # 导入flask_sqlalchemy扩展 from flask_sqlalchemy import SQLAlchemy # 导入配置对象 from .config1 import Config # 导入配置对象 app = Flask(__name__) # 使用配置对象 app.config.from_object(Config) # 数据库实例 db = SQLAlchemy(app) # 实例化管理对象 manage = Manager(app) # 使用迁移框架 Migrate(app) # 通过管理器对象,添加迁移命令 # 不可以使用 # manage.add_command('db', MigrateCommand) @app.route('/') def index(): return "this is index" if __name__ == '__main__': app.run(debug=True, port=8080)