def create_app(): app = Flask('tatakelola') Compress(app) app.config.from_pyfile('../common/app.cfg') app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False app.config['SQLALCHEMY_DATABASE_URI'] = app.config[ 'TATAKELOLA_SQLALCHEMY_DATABASE_URI'] # binds mean that tables with bind_key will fetch from below uris app.config['SQLALCHEMY_BINDS'] = { 'sideka': app.config['ADMIN_SQLALCHEMY_DATABASE_URI'], 'keuangan': app.config['KEUANGAN_SQLALCHEMY_DATABASE_URI'] } app.register_blueprint(AdminController) app.register_blueprint(ApbdesController) app.register_blueprint(GeojsonController) app.register_blueprint(PendudukController) app.register_blueprint(RegionController) app.register_blueprint(SummaryController) app.register_blueprint(StatisticController) app.register_blueprint(LayoutController) app.register_blueprint(BoundaryController) db.init_app(app) ma.init_app(app) CORS(app) with app.app_context(): # bind=None means that only main database is auto-created db.create_all(bind=None) return app
def create_app(): app = Flask('posyandu') app.config.from_pyfile('../common/app.cfg') app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False app.config['SQLALCHEMY_DATABASE_URI'] = app.config[ 'POSYANDU_SQLALCHEMY_DATABASE_URI'] # binds mean that tables with bind_key will fetch from below uris app.config['SQLALCHEMY_BINDS'] = { 'sideka': app.config['ADMIN_SQLALCHEMY_DATABASE_URI'] } app.register_blueprint(UserController) app.register_blueprint(ParentController) app.register_blueprint(ChildController) app.register_blueprint(GrowthController) app.register_blueprint(DevelopmentController) app.register_blueprint(VaccineController) db.init_app(app) ma.init_app(app) CORS(app) with app.app_context(): # bind=None means that only main database is auto-created db.create_all(bind=None) return app
def create_app(): app = Flask('keuangan') app.config.from_pyfile('../common/app.cfg') app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False app.config['SQLALCHEMY_DATABASE_URI'] = app.config[ 'KEUANGAN_SQLALCHEMY_DATABASE_URI'] # binds mean that tables with bind_key will fetch from below uris app.config['SQLALCHEMY_BINDS'] = { 'sideka': app.config['ADMIN_SQLALCHEMY_DATABASE_URI'] } app.register_blueprint(KegiatanController) app.register_blueprint(PenerimaanController) app.register_blueprint(PenganggaranController) app.register_blueprint(ProgressController) app.register_blueprint(RegionController) app.register_blueprint(BudgetController) app.register_blueprint(SppController) app.register_blueprint(LikelihoodController) app.register_blueprint(AdminController) db.init_app(app) ma.init_app(app) cache.init_app(app) CORS(app) with app.app_context(): # bind=None means that only main database is auto-created db.create_all(bind=None) return app
def db(app): """A database for the tests.""" _db.app = app with app.app_context(): _db.create_all() yield _db # Explicitly close DB connection _db.session.close() _db.drop_all()
__author__ = 'matti' from flask import Flask from resources.video import Video from flask_restful import Api from common.database import db from common.config import DebugConfig def create_app(): app = Flask(__name__) app.config.from_object(DebugConfig) api = Api(app) api.add_resource(Video, '/video','/video/<int:videoid>') db.init_app(app) return app if __name__ == '__main__': app = create_app() with app.app_context(): db.drop_all() db.create_all() app.run()
__tablename__ = "MenuList" name = db.Column(db.String(80), nullable=False) sex = db.Column(db.Integer, default=0) age = db.Column(db.Integer, default=0) address = db.Column(db.String(120), default='') identify_card = db.Column(db.String(20), default=0) campus_id = db.Column(db.String(30), default='') cantact = db.Column(db.String(20), default='') app = Flask(__name__) app.config[ 'SQLALCHEMY_DATABASE_URI'] = "mysql://*****:*****@192.168.74.128:16868/SmartCampus" db.init_app(app) app.app_context().push() db.create_all() tm = TreeManager(MenuList, db.session) test1 = MenuList(age=1, name="pc") tm.add_node(node=test1) test2 = MenuList(age=2, name="pc") tm.add_node(test1.node_uuid, test2) test3 = MenuList(age=3, name="pc") tm.add_node(test1.node_uuid, test3) test4 = MenuList(age=4, name="pc") tm.add_node(test2.node_uuid, test4) #tm.delete_node(test2.node_uuid) #node=tm.find_node(test3.node_uuid) #if node is None: # print "None" #else: # print node.node_uuid
def create_db(): db.create_all()