def setUp(self): self.app = app self.client = app.test_client() self.userInfo = { "user": "******", "Surname": "Kamara", "Email": "*****@*****.**", "Firstname": "deo", "Password": "******" } self.user = {"user": "******", "Password": "******"} self.shoplist = {"newlist": "shoes"} self.renamelist = {"newName": "underwear"} self.shopllist = json.dumps(self.shoplist) self.conevertInfo = json.dumps(self.userInfo) self.conevertUser = json.dumps(self.user) with self.app.app_context(): db.create_all() self.rs = self.client.post('/auth/register/', data=self.conevertInfo, content_type='application/json') self.rsu = self.client.post('/auth/login/', data=self.conevertUser, content_type='application/json') tok1 = json.loads(self.rsu.data) self.tok = tok1['token']
def setup(self): self.app = create_app(config_name='testing') self.client = self.app.test_client self.driver_info = {'loc': 1.345000, 'lat': 1.345000, 'acc': 0.8} with self.app.app_context(): db.create_all()
def setUp(self): self.test_db_file = tempfile.mkstemp()[1] application.config[ 'SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + self.test_db_file application.config['TESTING'] = True application.config['WTF_CSRF_ENABLED'] = False self.app = application.test_client() db.create_all()
def setUp(self): self.test_db_file = tempfile.mkstemp()[1] app.config[ 'SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + self.test_db_file app.config['TESTING'] = True app.config['WTF_CSRF_ENABLED'] = False self.app = app.test_client() self.lookup_patcher = patch('geoip.geolite2.lookup', autospec=True) PatchedLookup = self.lookup_patcher.start() PatchedLookup.return_value = IPInfo( '17.0.0.1', {'location': { 'time_zone': 'America/Los_Angeles' }}) db.create_all()
def setUp(self): self.test_db_file = tempfile.mkstemp()[1] app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + self.test_db_file app.config['TESTING'] = True app.config['WTF_CSRF_ENABLED'] = False self.app = app.test_client() self.lookup_patcher = patch('geoip.geolite2.lookup', autospec=True) PatchedLookup = self.lookup_patcher.start() PatchedLookup.return_value = IPInfo('17.0.0.1', { 'location': { 'time_zone': 'America/Los_Angeles' } }) db.create_all()
def setUp(self): self.test_db_file = tempfile.mkstemp()[1] app.config[ 'SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + self.test_db_file app.config['TESTING'] = True app.config['WTF_CSRF_ENABLED'] = False self.app = app.test_client() self.geoip_city_patcher = mock.patch( 'geoip2.models.City', location=geoip2.records.Location(time_zone='America/Los_Angeles')) PatchedGeoipCity = self.geoip_city_patcher.start() self.geoip_reader_patcher = mock.patch('geoip2.database.Reader') PatchedGeoipReader = self.geoip_reader_patcher.start() PatchedGeoipReader().city.return_value = PatchedGeoipCity db.create_all()
def db(app): """ Returns a session wide database using a Flask-SQLAlchemy database connection. """ _db.app = app _db.create_all() # Add the local authority data to the database (this is a workaround you don't need this for your coursework!) data_path = app.config['DATA_PATH'] csv_file = Path(data_path).joinpath('household_recycling.csv') #csv_file = Path(__file__).parent.parent.joinpath("data").joinpath("household_recycling.csv") df = pd.read_csv(csv_file, usecols=['Code', 'Area']) df.drop_duplicates(inplace=True) df.set_index('Code', inplace=True) df.to_sql('area', _db.engine, if_exists='replace') yield _db _db.drop_all()
def setUp(self): db.session.commit() db.drop_all() db.create_all() # Add the local authority data to the database (this is a workaround you don't need this for your coursework!) csv_file = Path(__file__).parent.parent.joinpath( "data/household_recycling.csv") df = pd.read_csv(csv_file, usecols=['Code', 'Area']) df.drop_duplicates(inplace=True) df.set_index('Code', inplace=True) df.to_sql('area', db.engine, if_exists='replace') # Add a user and profile to the database u = User(firstname='TestFirstname1', lastname='TestLastname1', email='*****@*****.**') u.set_password('test1') p = Profile(username='******', bio='Something about test1.', area='Barnet', user_id=u.id) u.profiles.append(p) db.session.add(u) db.session.commit()
def setUp(self): app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite://' db.create_all()
from my_app import app, db from flask import render_template, request, redirect, url_for, flash, session from my_app.models import Business, Review import json #from analysis import analysis_of_b db.create_all() @app.route("/") def index(): b = [] rs = [] # if request.args['messages']: # data = request.args['messages'] # data = session['messages'] # place_name = data[0] # place_id = data[1] # b = [Business.query.filter(Business.place_id == place_id).first()] # rs = Review.query.filter_by(business_id=place_id).all() # all reviews # return render_template("index.html", reviews=r, business=bs) return render_template("index.html", reviews=rs, business=b) @app.route('/api', methods=['POST']) def review(): b = [] rs = [] if request.method == 'POST': data = request.form["name"].split('.') place_name = data[0]
def setUp(self): self.app = create_app(TestConfig) self.app_context = self.app.app_context() self.app_context.push() db.create_all()
def setUp(self): db.create_all()