def init_db(): # import all modules here that might define models so that # they will be registered properly on the metadata. Otherwise # you will have to import them first before calling init_db() import models db.create_all() Base.metadata.create_all(bind=engine)
def before_all(context): app.config.from_object('config.TestingConfig') # context.client = app.test_client() context.server = main context.address = main.address context.thread = threading.Thread(target=context.server.serve_forever) context.thread.start() # start flask app server context.browser = webdriver.Firefox() db.init_app(app) with app.app_context(): # Extensions like Flask-SQLAlchemy now know what the "current" app # is while within this block. Therefore, you can now run........ db.create_all() user1 = User('Sathwik', 'Singari', '*****@*****.**', 'dm08b048') user1.set_user_farmer() db.session.add(user1) db.session.add(User('Bilbo', 'Baggins', '*****@*****.**', 'bilbobaggins')) db.session.add(Unit('Kg')) db.session.add(Unit('gm')) db.session.add(Unit('l')) db.session.add(Unit('ml')) db.session.flush() db.session.add(Address('123 Hill Rd', None, 'Sydney', 'NSW', 'Australia', 2010)) db.session.add(Address('126 Hill Rd', None, 'Sydney', 'NSW', 'Australia', 2010)) db.session.flush() db.session.add(Farm('Shire Farms', 1)) db.session.add(Farm('Mordor Farms', 2)) db.session.flush() db.session.add(Works(1, 1)) db.session.add(Works(1, 2)) db.session.flush() db.session.add(User('Joe', 'Farmer', '*****@*****.**', 'louise1993')) db.session.commit()
def _db(app): ''' Provide the transactional fixtures with access to the database via a Flask-SQLAlchemy database connection. ''' db = SQLAlchemy(app=app) db.create_all() db.session.commit() return db
def create_database(): from database_create import insert_initial_values_sensor_locations, insert_initial_values_sensor_types, insert_initial_RPIValues db.create_all() insert_initial_values_sensor_locations() insert_initial_values_sensor_types() insert_initial_RPIValues() return render_template("index.html")
def create_base_data(u): with app.app_context(): db.drop_all() db.create_all() r = Role(name='admin', description='Superuser') u.roles.append(r) db.session.add(r) db.session.add(u) db.session.commit()
def create_user(): db.create_all() with app.app_context(): password = encrypt_password('admin') user_datastore.create_role(name='admin', description='Administrator') user_datastore.create_role(name='user', description='Simple user') user_datastore.create_user(email='*****@*****.**', password=password) user = User.query.first() role = Role.query.first() user_datastore.add_role_to_user(user, role) db.session.commit()
def before_all(context): app.config.from_object('config.TestingConfig') # context.client = app.test_client() context.server = main context.address = main.address context.thread = threading.Thread(target=context.server.serve_forever) context.thread.start() # start flask app server context.browser = webdriver.Firefox() db.init_app(app) with app.app_context(): # Extensions like Flask-SQLAlchemy now know what the "current" app # is while within this block. Therefore, you can now run........ db.create_all() db.session.add(User('Sathwik', 'Singari', '*****@*****.**', 'dm08b048')) db.session.add(User('Bilbo', 'Baggins', '*****@*****.**', 'bilbobaggins')) User.query.get(1).set_user_farmer() db.session.add(User('Billy', 'Bogan','*****@*****.**','password')) db.session.add(Unit('Kg')) db.session.add(Unit('gm')) db.session.add(Unit('l')) db.session.add(Unit('ml')) db.session.flush() db.session.add(Address('123 Hill Rd', None, 'Sydney', 'NSW', 'Australia', 2010)) db.session.add(Address('126 Hill Rd', None, 'Sydney', 'NSW', 'Australia', 2010)) db.session.add(Farm('Shire Farms', 1)) db.session.add(Farm('Mordor Farms', 2)) #db.session.add(Image('eggplant.jpg', 'produce/1/eggplant.jpeg')) #db.session.add(Produce('Eggplant', 'Sweet organic eggplants', 'Vegetable', 1, 1)) #db.session.add(Price(1, 1, 4.35)) #db.session.add(Price(1, 2, 2.8)) db.session.add(Produce('corn', 'vegetable', 'tasty', 1, 1)) db.session.add(Produce('milk', 'dairy', 'yum', 2, 2)) db.session.flush() db.session.add(Price(1, 1, 2.2)) db.session.add(Price(2, 1, 4.4)) db.session.add(RecentProduce(1, 1)) db.session.flush() db.session.add(Works(1, 1)) db.session.add(Works(1, 2)) db.session.add(Works(4,1)) db.session.flush() db.session.add(User('Joe', 'Farmer', '*****@*****.**', 'louise1993')) #db.session.add(Works(4, 1)) db.session.add(Field('west block', 'Shire Farms', 1)) db.session.add(Resource('fertiliser', 1)) db.session.commit()
def setUp(self): db.create_all() db.session.add(User('Sathwik', 'Singari', '*****@*****.**', 'dm08b048')) db.session.add(User('Bilbo', 'Baggins', '*****@*****.**', 'bilbobaggins')) db.session.add(Unit('Kg')) db.session.add(Unit('gm')) db.session.add(Unit('l')) db.session.add(Unit('ml')) db.session.flush() db.session.add(Address('123 Hill Rd', None, 'Sydney', 'NSW', 'Australia', 2010)) db.session.add(Address('126 Hill Rd', None, 'Sydney', 'NSW', 'Australia', 2010)) db.session.flush() db.session.add(Farm('Shire Farms', 1)) db.session.add(Farm('Mordor Farms', 2)) db.session.flush() db.session.add(Works(1, 1)) db.session.add(Works(2, 2)) db.session.flush() db.session.commit()
def setup_flask(): app = Flask(__name__) app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER app.config['MAX_CONTENT_LENGTH'] = 16 * 1024 * 1024 app.config['JWT_SECRET_KEY'] = "supersecretkeyhastochange" app.config['JWT_ACCESS_TOKEN_EXPIRES'] = False app.config['SQLALCHEMY_DATABASE_URI'] = f'sqlite:///{DB_PATH}' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False CORS(app) Compress(app) jwt = JWTManager(app) # init DB with app.app_context(): db.init_app(app) if not os.path.exists(DB_PATH): db.create_all() admin = User(username="******", password="******") if db.session.query(User).filter_by(username='******').count() < 1: db.session.add(admin) db.session.commit() return app
from controllers import ProduceController from shared import db # Creating application object app = Flask(__name__) host = "http://localhost" port = "5000" address = host + ':' + port # Setting app configuration app.config.from_object('config.DevelopmentConfig') # Creating SQLAlchemy Object db.init_app(app) with app.app_context(): db.create_all() def serve_forever(): app.run() def shutdown_server(): func = request.environ.get('werkzeug.server.shutdown') if func is None: raise RuntimeError("Not running with Werkzeug server") func() #keyes for payment stripe_keys = {
from flask import Flask, render_template from shared import db from data_processing import read_and_clean_data, insert_into_db, query_data app = Flask(__name__) # Configure the Flask app to connect to this database app.config['SQLALCHEMY_DATABASE_URI'] = \ 'postgres://*****:*****@localhost/exercise' # Initialize the app with the SQLAlchemy object from the model file db.init_app(app) # Create the database db.create_all(app=app) @app.route("/") def output(): """ Brings up page to parse the data, insert into the database and redirect to the next page, displaying the result. :return: """ return render_template('home.html') @app.route("/results/") def show_results():
def setUp(self): db.create_all() self._start_minio() storage._s3_client.create_bucket(Bucket="attachments") storage._s3_client.create_bucket(Bucket="thumbs")
def init_db(): with app.app_context(): db.create_all()
def initialize_db(): db.create_all()
import os from customjsonencoder import CustomJSONEncoder from model.Board import Board from model.Slip import gen_slip from model.Tag import Tag import model.Media import model.Poster from shared import db db.create_all() # set up some boards for board_name in ("anime", "tech", "meta", "politics", "gaming", "music"): board = Board(name=board_name) db.session.add(board) # admin credentials generation admin = gen_slip("admin", "admin") admin.is_admin = True db.session.add(admin) # special tags for tag_name, bg_style, text_style in (("general", "bg-secondary", "text-light"),): tag = Tag(name=tag_name, bg_style=bg_style, text_style=text_style) db.session.add(tag) db.session.commit() # write a secret so we can have session support open("secret", "w").write(str(os.urandom(16))) # create upload and thumbnail directory if necessary if not os.path.exists("uploads/thumb"): os.makedirs("uploads/thumb")
def handler(postgresql): app = create_app(db_url=postgresql.url()) with app.app_context() as app: db.create_all()
def setUp(self): app.config.from_pyfile('configs/testing.cfg') self.app = app.test_client() with app.app_context(): db.create_all()
def create_default_user(): db.create_all() access_control.fill_database() db.session.commit()