Python create_all示例

示例#1

文件： __init__.py 项目： vickazy/sideka_app_server

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

示例#2

文件： __init__.py 项目： vickazy/sideka_app_server

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

示例#3

文件： __init__.py 项目： vickazy/sideka_app_server

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

示例#4

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

示例#5

文件： app.py 项目： melonmanchan/gachimuch.io-api

__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()

示例#6

文件： test.py 项目： xmetadata/smart-campus

    __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

示例#7

文件： __init__.py 项目： LADOSSIFPB/LaNoCentro

def create_db():
    db.create_all()