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
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()
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():
init_db()
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)
