def init_ext(app): # db.init_app(app) # migrate.init_app(app,db) init_db(app) init_api(app) mail.init_app(app) cache.init_app(app)
def initdb(): models.init_db() # uncomment to initialize database automatically for # every run # models.init_db()
def create_app(config_class=Config): app = Flask(__name__) app.config.from_object(Config) db.init_app(app) bcrypt.init_app(app) login_manager.init_app(app) manager = Manager(app) manager.add_command('db', MigrateCommand) migrate.init_app(app, db) from app.users.routes import users from app.models import init_db from app.main.routes import main from app.posts.routes import posts from app.errors.handlers import errors with app.app_context(): init_db() app.register_blueprint(users) app.register_blueprint(posts) app.register_blueprint(main) app.register_blueprint(errors) """ NOTE: NOT USED IN PRODUCTION if not app.debug: file_handler = FileHandler('errorlog.txt') file_handler.setLevel(WARNING) app.logger.addHandler(file_handler) """ return app
def generate_db(): app.logger.info("Start make db") currentsession = get_user_session_by_userid() serviceprovider = [ '3 River Wireless', 'ACS Wireless', 'Alltel', 'AT&T', 'Bell Canada', 'Bell Canada', 'Bell Mobility (Canada)', 'Bell Mobility', 'Blue Sky Frog', 'Bluegrass Cellular', 'Boost Mobile', 'BPL Mobile', 'Carolina West Wireless', 'Cellular One', 'Cellular South', 'Centennial Wireless', 'CenturyTel', 'Cingular (Now AT&T)', 'Clearnet', 'Comcast', 'Corr Wireless Communications', 'Dobson', 'Edge Wireless', 'Fido', 'Golden Telecom', 'Helio', 'Houston Cellular', 'Idea Cellular', 'Illinois Valley Cellular', 'Inland Cellular Telephone', 'MCI', 'Metrocall', 'Metrocall 2-way', 'Metro PCS', 'Microcell', 'Midwest Wireless', 'Mobilcomm', 'MTS', 'Nextel', 'OnlineBeep', 'PCS One', "President's Choice", 'Public Service Cellular', 'Qwest', 'Rogers AT&T Wireless', 'Rogers Canada', 'Satellink', 'Southwestern Bell', 'Sprint', 'Sumcom', 'Surewest Communicaitons', 'T-Mobile', 'Telus', 'Tracfone', 'Triton', 'Unicel', 'US Cellular', 'Solo Mobile', 'Sprint', 'Sumcom', 'Surewest Communicaitons', 'T-Mobile', 'Telus', 'Triton', 'Unicel', 'US Cellular', 'US West', 'Verizon', 'Virgin Mobile', 'Virgin Mobile Canada', 'West Central Wireless', 'Western Wireless' ] db_session.close() drop_db() init_db() user = User('admin', '1') user.email = 'admin@localhost' user.mobilenumber = '800 000 0000' user.referfrom = 'admin' user.active = 1 user.paidservice = 1 user.create_date = datetime.datetime.now() user.modified_date = datetime.datetime.now() db_session.add(user) db_session.commit() sps = {} for row in serviceprovider: if row not in sps: sps[row] = 1 sp = ServiceProvider() sp.name = row try: db_session.add(sp) db_session.commit() except: db_session.rollback() return output_json("status:ok", 200)
def create_app(): from app.commands import init_command from app.models import init_db app = Flask(__name__, instance_relative_config=True) app.config.from_mapping( SECRET_KEY=settings.SECRET_KEY, SQLALCHEMY_BINDS=settings.SQLALCHEMY_BINDS, SQLALCHEMY_TRACK_MODIFICATIONS=True, ) init_db(app) init_command(app) return app
def main(): args = parse_args() logging.basicConfig(level=logging.DEBUG if args.debug else logging.INFO) db_manager = init_db(args.db_name, args.db_user, args.db_pass, args.db_host, args.db_port) if args.tickers_file: parse(args.tickers_file, args.threads_count) handlers = ( ('GET', '', tickers_handler), ('GET', '/api', api_tickers_handler), ('GET', '/{ticker:\w+}', ticker_handler), ('GET', '/api/{ticker:\w+}', api_ticker_handler), ('GET', '/{ticker}/insider', insiders_handler), ('GET', '/api/{ticker}/insider', api_insiders_handler), ('GET', '/{ticker}/insider/{name}', insider_handler), ('GET', '/api/{ticker}/insider/{name}', api_insider_handler), ('GET', '/{ticker}/analytics', analytics_handler), ('GET', '/api/{ticker}/analytics', api_analytics_handler), ('GET', '/{ticker}/delta', delta_handler), ('GET', '/api/{ticker}/delta', api_delta_handler), ) app = Application(middlewares=[error_middleware]) app['db_manager'] = db_manager for handler in handlers: app.router.add_route(*handler) aiohttp_jinja2.setup(app, loader=jinja2.PackageLoader('app', 'templates')) run_app(app, host=args.host, port=args.port)
def __init__(self, **kwargs): settings = dict( debug=options.debug, xsrf_cookies=False, cookie_secret="nzjxcjasduuqwheazmu293nsadhaslzkci9023nsadnua9sdads/Vo=" ) settings.update(kwargs) tornado.web.Application.__init__(self, handlers, **settings) engine = create_engine(options.db_path, convert_unicode=True, echo=options.debug) self.db_session = m.init_db(engine)
def initdb(): init_db()
def init(): init_db()
from app import create_app from app.models import init_db from flask_bootstrap import Bootstrap app = create_app() bootstrap = Bootstrap(app) if __name__ == '__main__': init_db(app) app.run()
def initialize_app(flask_app): configure_app(flask_app) CORS(flask_app) JWT(flask_app, authenticate, identity) api.init_app(flask_app) init_db()
from app import create_app app = create_app() if __name__ == '__main__': from app.models import init_db init_db() app.run()
import dotenv from flask import Flask from app.models import init_db from app.models.scott import DeptModel, EmpModel from app.models.lotto import IF_LOTTO_PRZWIN_MST dotenv.load_dotenv(dotenv_path=".env") app = Flask(__name__) app.config.from_object("app.config.flask.DevelopmentConfig") db = init_db(app) # data = lambda r: {c.name: str(getattr(r, c.name)) for c in r.__table__.columns} def row2dict(row): d = {} for column in row.__table__.columns: d[column.name] = str(getattr(row, column.name)) return d with app.app_context(): # db.drop_all() db.create_all() records = IF_LOTTO_PRZWIN_MST.query.all() for record in records: print( row2dict(record) ) # dept = DeptModel(deptno=10, dname="ACCOUNTING", location="NEW YORK")
def create_app(test_config=None): # create the app configuration app = Flask(__name__, instance_path=environ.get('FLASK_APP_INSTANCE', '/user/src/app/instance')) # Itial config stage app.config.from_mapping( AUTH_LEEWAY=timedelta(seconds=int(environ.get( 'AUTH_LEEWAY', '30'))), # leeway in seconds POSTGRES_HOST=environ.get('POSTGRES_HOST', ''), POSTGRES_USER=environ.get('POSTGRES_USER', ''), POSTGRES_DATABASE=environ.get('POSTGRES_DATABASE', environ.get('POSTGRES_USER', '')), POSTGRES_PASSWORD=environ.get('POSTGRES_PASSWORD', ''), SQLALCHEMY_TRACK_MODIFICATIONS=False, BASEURL=environ.get('BASEURL', ''), DOCKER_HOST=environ.get('DOCKER_HOST', ''), DOCKER_BASEURL='http://{}'.format(environ.get('DOCKER_HOST', '')), TOKEN_ISSUER=environ.get('TOKEN_ISSUER', environ.get('BASEURL', 'app-logic')), ZOOKEEPER_CONNECTION_STR=environ.get('ZOOKEEPER_CONNECTION_STR', 'zoo1,zoo2,zoo3'), AUTH_CONFIG_FROM_ZOO=bool( strtobool(environ.get('AUTH_CONFIG_FROM_ZOO', 'False')))) # 'postgresql+psycopg2://username:password@host/databse' app.config[ 'SQLALCHEMY_DATABASE_URI'] = 'postgresql+psycopg2://{}:{}@{}/{}'.format( app.config['POSTGRES_USER'], app.config['POSTGRES_PASSWORD'], app.config['POSTGRES_HOST'], app.config['POSTGRES_DATABASE']) if test_config is None: # load the instance config if it exists, when not testing app.config.from_pyfile(path.join(app.instance_path, 'config.py'), silent=True) else: app.config.from_mapping(test_config) if app.config.get('POSTGRES_HOST') == '': raise Exception('No postgres database host was provided. ' 'POSTGRES_HOST environment variable cannot be omitted') if app.config.get('POSTGRES_USER') == '': raise Exception('No postgres database user was provided. ' 'POSTGRES_USER environment variable cannot be omitted') if app.config.get('POSTGRES_PASSWORD') == '': raise Exception( 'No postgres database user password was provided. ' 'POSTGRES_PASSWORD environment variable cannot be omitted') if app.config.get('BASEURL') == '': raise Exception('No service base url was provided. ' 'BASEURL environment variable cannot be omitted') if app.config.get('DOCKER_HOST') == '': raise Exception('No network host within docker was provided. ' 'DOCKER_HOST environment variable cannot be omitted') global sm sm = StorageManager(app.logger, app.config['TOKEN_ISSUER'], app.config['PRIVATE_KEY'].decode('utf-8')) # Zookeeper init and connection stage znode_data = { 'TOKEN_ISSUER': app.config['TOKEN_ISSUER'], 'BASEURL': app.config['BASEURL'], 'DOCKER_HOST': app.config['DOCKER_HOST'], 'DOCKER_BASEURL': app.config['DOCKER_BASEURL'], 'PUBLIC_KEY': app.config['PUBLIC_KEY'].decode('utf-8') } global zk zk = AppZoo( KazooClient(app.config['ZOOKEEPER_CONNECTION_STR'], connection_retry=KazooRetry(max_tries=-1), logger=app.logger), znode_data, sm) # Get auth info before first request app.before_first_request(get_auth_info) db.init_app(app) mi.init_app(app, db, directory=environ.get('FLASK_APP_MIGRATIONS', 'migrations')) ma.init_app(app) # for some reason when not in development # this call fails /shrug if app.env == 'development': from app import models models.init_db(app) from app import service app.register_blueprint(service.bp) return app
from app import app from app.models import init_db import os db = os.path.abspath(os.path.dirname(__file__)) + '/questions.db' if not os.path.isfile(db): init_db() app.run(debug=True)
def init_db(): models.init_db()
def get(self, *args, **kwargs): init_db() self.write('初始化表成功')
def init_db_command(): """Clear existing data and create new tables.""" init_db() print("Initialized the database.")
def get(self): # 找到Base的所有子类,并在数据库中创建这些表 init_db() self.write('创建数据库成功')
def init_db(): try: get_users() except: from app.models import init_db init_db(user_datastore)