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