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