def create_app(config_class=DevConfig): """ Creates an application instance to run :return: A Flask object """ app = Flask(__name__) # Configure langbridge wth the settings from config.py app.config.from_object(config_class) # Initialise plugins db.init_app(app) login_manager.init_app(app) from populate_db import populate_db from langbridge.models import Teacher, User, BankAccount, Wallet, Language, Lesson, LessonReview with app.app_context(): db.create_all() populate_db() # Register error handlers app.register_error_handler(404, page_not_found) app.register_error_handler(500, internal_server_error) # Register Blueprints from langbridge.main.routes import bp_main app.register_blueprint(bp_main) from langbridge.auth.routes import bp_auth app.register_blueprint(bp_auth) return app
def create_app(config_class=DevConfig): app = Flask(__name__) app.config.from_object(config_class) global images images = UploadSet('image', IMAGES) app.config['UPLOADED_IMAGE_DEST'] = 'static/images' configure_uploads(app, images) db.init_app(app) login_manager.init_app(app) # The following is needed if you want to map classes to an existing database # with app.app_context(): # db.Model.metadata.reflect(db.engine) from populate_db import populate_db from app.models import Member # , Art, Artist, ContributingArtists, Subscriptions, Events, Portfolio with app.app_context(): db.create_all() populate_db() # Register Blueprints from app.main.routes import bp_main app.register_blueprint(bp_main) from app.auth.routes import bp_auth app.register_blueprint(bp_auth) return app
def create_db(): # Creates or opens a file called mydb with a SQLite3 DB db = sqlite3.connect('data/mydb') cursor = db.cursor() cursor.execute(''' CREATE TABLE IF NOT EXISTS genes(id INTEGER PRIMARY KEY, mirtarbase_id TEXT, mirna TEXT, species TEXT, mirna_target_gene TEXT, target_gene INTEGER, species_target_gene TEXT, experiments TEXT, support_type TEXT, refs TEXT) ''') cursor.execute(''' CREATE TABLE IF NOT EXISTS human_gene_coords(id INTEGER PRIMARY KEY, gene_name TEXT, chromosome_name TEXT, gene_start INTEGER, gene_end INTEGER) ''') cursor.execute(''' CREATE TABLE IF NOT EXISTS human_mirna_coords(id INTEGER PRIMARY KEY, gene_name TEXT, mirbase_id TEXT, chromosome_name TEXT, gene_start INTEGER, gene_end INTEGER) ''') populate_db() db.commit() db.close()
def create_app(config_class=DevConfig): """ Creates an application instance to run :return: A Flask object """ app = Flask(__name__) # Configure app wth the settings from config.py app.config.from_object(config_class) # Initialise the database and create tables db.init_app(app) from populate_db import populate_db from app.models import Teacher, Student, Course, Grade with app.app_context(): db.create_all() populate_db() # Register error handlers app.register_error_handler(404, page_not_found) app.register_error_handler(500, internal_server_error) # Register Blueprints from app.main.routes import bp_main app.register_blueprint(bp_main) return app
def fill_db(config): set_config(config) from recastfrontend.server import app with app.app_context(): from recastfrontend.server import db populate_db.populate_db(db) click.secho('filled database at: {}'.format(db.engine.url), fg='green')
def test_populate_db_populates_users(): engine = sqlalchemy.create_engine('sqlite://') session = create_session(engine) try: populate_db(session, total_users=10) connection = session.connection().connection cursor = connection.cursor() cursor.execute('SELECT COUNT(*) FROM Users') assert cursor.fetchone()[0] == 10 cursor.execute('SELECT COUNT(*) FROM UserSessions') assert cursor.fetchone()[0] >= 10 finally: session.close()
def create_app(config_class=DevConfig): """ Creates an application instance to run using settings from config.py :return: A Flask object """ app = Flask(__name__) app.config.from_object(config_class) db.init_app(app) from populate_db import populate_db from app.models import User, City, Forecast with app.app_context(): db.create_all() populate_db() from app.main import bp app.register_blueprint(bp) return app
def refresh_db(): # Creates or opens a file called mydb with a SQLite3 DB db = sqlite3.connect('data/mydb') cursor = db.cursor() cursor.execute(''' DELETE FROM genes ''') cursor.execute(''' DELETE FROM human_gene_coords ''') cursor.execute(''' DELETE FROM human_mirna_coords ''') db.commit() populate_db() db.close()
def create_app(config_class=DevConfig): """ Creates an application instance to run :return: A Flask object """ app = Flask(__name__) app.config.from_object(config_class) db.init_app(app) from populate_db import populate_db from app.models import Teacher, Student, Course, Grade with app.app_context(): db.create_all() populate_db() app.register_error_handler(404, page_not_found) app.register_error_handler(500, internal_server_error) from app.main.routes import bp_main app.register_blueprint(bp_main) return app
def create_app(config_class=DevConfig): """Creates an application instance to run using settings from config.py :return: A Flask object""" app = Flask(__name__) app.config.from_object(config_class) from populate_db import populate_db db.init_app(app) # The following is needed if you want to map classes to an existing database from app.models3 import User, City, Forecast with app.app_context(): # db.Model.metadata.reflect(db.engine) db.create_all() populate_db() # Register Blueprints from app.main.routes import bp_main app.register_blueprint(bp_main) return app
def setUp(self): self.maxDiff = None self.client = MongoClient() self.db = self.client[TEST_DB] self.app = TestApp(app.shopping_cart_app) app.db = self.db # Populate database with random data populate_db(TEST_DB) # Add basket for testing purposes # add some products to basket prod = self.db.products.find_one({'name_slug': 'prod-0-0'}) req = self.app.post_json('/api/basket/add', { 'prod_id': str(prod['_id']), 'amount': 4 }) for prod in self.db.products.find(skip=1, limit=5): req = self.app.post_json( '/api/basket/add', { 'basket_id': json.loads(req.body)['_id'], 'prod_id': str(prod['_id']), 'amount': randint(1, 10) }) self.basket = json.loads(req.body)
def create_app(config_class=DevConfig): """ Creates an application instance to run using settings from config.py :return: A Flask object """ app = Flask(__name__) app.config.from_object(config_class) db.init_app(app) bcrypt.init_app(app) configure_uploads(app, photos) patch_request_class(app) from populate_db import populate_db from app.models import User, Item, ShippingInfo with app.app_context(): db.create_all() populate_db() from app.main import bp app.register_blueprint(bp) return app
# -*- coding: utf-8 -* import pytest from populate_db import populate_db import tt_demo from tt_demo.queries import Query # populate the database with examples for tests populate_db() # start the app mongodb_uri = "mongodb://*****:*****@pytest.fixture(scope='module') def client(): with app.app.test_client() as c: yield c
def reset_test_db(): d = DB() d.create_schema() populate_db(d) return d
csrf = CSRFProtect() def create_app(database): app = Flask(__name__) app.config['SECRET_KEY'] = 'bgnti84;jv_d-0ngr8gvhk' app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///:memory:' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False csrf.init_app(app) with app.app_context(): database.init_app(app) CORS(app) return app db = SQLAlchemy() app = create_app(db) import routes import models from populate_db import populate_db populate_db(db, n_products=25) if __name__ == '__main__': app.run(debug=True)
# -*- coding: utf-8 -*- """ Script to determine when a college football program from a Power-5 conference (ACC, SEC, Big Ten, Big 12, Pac-12) plays a non-Power 5 team on the road. This a semi-rare occurance, Requirements: Python with the SQLAlchemy and Beautiful Soup modules Project page: https://github.com/inkjet/FBS_Power5 Author: Scott Rodkey, [email protected] """ from create_database import create_db, db_location from populate_db import populate_db from calc_matchups import calc_matchups # Create a blank database -- edit create_database.py to specify a specific DB location create_db() # Scrape all FBS schools and their conference from Wikipedia and place them in the database populate_db(db_location) # Look at the 2015 schedule and print a week-by-week report to see if a Power-5 school # is playing a non-Power 5 school on the road calc_matchups(db_location)