def test_Explore_Theater_Theater_filter(self):
user_service = UserService()
filters = {
'city': "",
'selectedState': None,
'selectedCompany': '4400 Theater Company',
'selectedTheater': 'Star Movies'
}
actual = user_service.ExploreTheater(filters)
expected = [{
'comName': '4400 Theater Company',
'thName': 'Star Movies',
'thStreet': '4400 Rocks Ave',
'thCity': 'Boulder',
'thState': 'CA',
'thZipcode': '80301'
}]
assert len(actual) == len(expected)
assert sorted(actual,
key=functools.cmp_to_key(compare_theater)) == sorted(
expected, key=functools.cmp_to_key(compare_theater))
def test_Explore_Theater_CityFilter(self):
user_service = UserService()
filters = {
'city': "New York",
'selectedState': None,
'selectedCompany': None,
'selectedTheater': None
}
actual = user_service.ExploreTheater(filters)
expected = [
{
'comName': "EZ Theater Company",
'thName': "Main Movies",
'thStreet': "123 Main St",
'thCity': "New York",
'thState': 'NY',
'thZipcode': '10001'
},
]
assert len(actual) == len(expected)
assert sorted(actual,
key=functools.cmp_to_key(compare_theater)) == sorted(
expected, key=functools.cmp_to_key(compare_theater))
def test_logVisit(self):
user_service = UserService()
filters = {
'i_thname': 'Cinema Star',
'i_coname': '4400 Theater Company',
'i_visitdate': '2019-11-24T01:38:50.493Z'
}
date = dateutil.parser.parse(filters['i_visitdate']).date()
user_name = 'georgep'
length = 0
connection = get_conn()
with connection.cursor() as cursor:
leng = "select visitID from UserVisitTheater"
cursor.execute(leng)
length = cursor.fetchall()
connection.commit()
connection.close()
new_id = len(length) + 1
user_service.LogVisit(user_name, filters)
connection = get_conn()
with connection.cursor() as cursor:
info = """select visitID, username, thName, comName, visitDate from UserVisitTheater where
visitID=(%s) and username=(%s)
and thName=(%s)
and comName=(%s)
and visitDate=(%s)"""
cursor.execute(info, (new_id, user_name, filters['i_thname'],
filters['i_coname'], date))
data = cursor.fetchall()
connection.commit()
sql_del = """delete From UserVisitTheater where visitID = (%s)"""
cursor.execute(sql_del, (new_id))
connection.commit()
connection.close()
assert len(data) == 1
def test_visit_history_empty(self):
filterz = {}
connection = get_conn()
with connection.cursor() as cursor:
user_service = UserService()
user_service.VisitHistory('calcwizard', filterz)
cursor.execute(
"select * from UserVisitTheater where username='******'")
data = cursor.fetchall()
connection.commit()
connection.close()
assert len(data) == 3
def test_Explore_Theater_Bad_state(self):
user_service = UserService()
filters = {
'city': "New York",
'selectedState': 'AL',
'selectedCompany': None,
'selectedTheater': None
}
actual = user_service.ExploreTheater(filters)
expected = []
assert len(actual) == len(expected)
assert sorted(actual,
key=functools.cmp_to_key(compare_theater)) == sorted(
expected, key=functools.cmp_to_key(compare_theater))
def test_Explore_Theater_Company_Filter(self):
user_service = UserService()
filters = {
'city': "",
'selectedState': None,
'selectedCompany': '4400 Theater Company',
'selectedTheater': None
}
actual = user_service.ExploreTheater(filters)
expected = [{
'comName': '4400 Theater Company',
'thName': 'Cinema Star',
'thStreet': '100 Cool Place',
'thCity': 'San Francisco',
'thState': 'CA',
'thZipcode': '94016'
}, {
'comName': '4400 Theater Company',
'thName': 'Star Movies',
'thStreet': '4400 Rocks Ave',
'thCity': 'Boulder',
'thState': 'CA',
'thZipcode': '80301'
}, {
'comName': '4400 Theater Company',
'thName': "Jonathan's Movies",
'thStreet': '67 Pearl Dr',
'thCity': 'Seattle',
'thState': 'WA',
'thZipcode': '98101'
}]
assert len(actual) == len(expected)
assert sorted(actual,
key=functools.cmp_to_key(compare_theater)) == sorted(
expected, key=functools.cmp_to_key(compare_theater))
def test_visit_history(self):
filterz = {
'i_comName': '4400 Theater Company',
'i_minVisitDate': datetime.date(2005, 11, 25),
'i_maxVisitDate': datetime.date(2012, 11, 30)
}
connection = get_conn()
with connection.cursor() as cursor:
user_service = UserService()
user_service.VisitHistory('imready', filterz)
cursor.execute(
"select * from UserVisitTheater where username='******'")
data = cursor.fetchall()
connection.commit()
connection.close()
assert len(data) == 1
def test_Explore_Theater_NoFilters(self):
user_service = UserService()
filters = {
'city': "",
'selectedState': None,
'selectedCompany': None,
'selectedTheater': None
}
actual = user_service.ExploreTheater(filters)
expected = [{
'comName': "EZ Theater Company",
'thName': "Main Movies",
'thStreet': "123 Main St",
'thCity': "New York",
'thState': 'NY',
'thZipcode': '10001'
}, {
'comName': "EZ Theater Company",
'thName': 'Star Movies',
'thStreet': '745 GT St',
'thCity': 'Atlanta',
'thState': 'GA',
'thZipcode': '30332'
}, {
'comName': '4400 Theater Company',
'thName': 'Cinema Star',
'thStreet': '100 Cool Place',
'thCity': 'San Francisco',
'thState': 'CA',
'thZipcode': '94016'
}, {
'comName': '4400 Theater Company',
'thName': 'Star Movies',
'thStreet': '4400 Rocks Ave',
'thCity': 'Boulder',
'thState': 'CA',
'thZipcode': '80301'
}, {
'comName': '4400 Theater Company',
'thName': "Jonathan's Movies",
'thStreet': '67 Pearl Dr',
'thCity': 'Seattle',
'thState': 'WA',
'thZipcode': '98101'
}, {
'comName': 'Awesome Theater Company',
'thName': 'ABC Theater',
'thStreet': '880 Color Dr',
'thCity': 'Austin',
'thState': 'TX',
'thZipcode': '73301'
}, {
'comName': 'AI Theater Company',
'thName': 'ML Movies',
'thStreet': '314 Pi St',
'thCity': 'Pallet Town',
'thState': 'KS',
'thZipcode': '31415'
}]
assert len(actual) == len(expected)
assert sorted(actual,
key=functools.cmp_to_key(compare_theater)) == sorted(
expected, key=functools.cmp_to_key(compare_theater))
root = logging.getLogger()
root.addHandler(handler)
app = Flask(__name__, static_folder="build/static", template_folder="build")
CORS(app)
app.config['EXPLAIN_TEMPLATE_LOADING'] = True
db_reset()
# create services
login_service = LoginService()
register_service = RegisterService()
manager_service = ManagerService()
drop_down_service = DropDownService()
user_service = UserService()
customer_service = CustomerService()
admin_service = AdminService()
#-----------Main------------
@app.route('/', defaults={'path': ''})
@app.route('/<path:path>')
def index(path):
return render_template('index.html')
#------------LOGIN------------
@app.route('/userLogin', methods=['POST'])
def userLogin():
data = request.get_json()