def test_get_product_by_id_failure(self):
try:
product = ProductServiceImpl.get_product_by_id(99)
self.assertEqual(type(product), type(Products()))
except ResourceNotFound as r:
assert True
else:
assert False
def get_product_id(cls, product_id):
sql = "SELECT * FROM products WHERE product_id = %s"
cursor = connection.cursor()
cursor.execute(sql, [product_id])
record = cursor.fetchone()
if record:
return Products(record[0], record[1], record[2], record[3], record[4])
else:
raise ResourceNotFound(f"Product with ID {product_id} - Not Found")
def get_products(cls):
try:
sql = "SELECT * FROM products;"
cursor = connection.cursor()
cursor.execute(sql)
records = cursor.fetchall()
products = []
for product in records:
products.append(Products(product[0], product[1], product[2], product[3], product[4]))
return products
except Exception as e:
raise ResourceNotFound(f"Credentials do not match any existing records. Please try again.")
def __init__(self):
self.connection_manager = ConnectionManager()
self.database = Database()
self.records = Records()
self.categories = Categories()
self.products = Products()
self.substitutes = Substitutes()
self.abandon = Abandon()
self.menu = Menu()
self.register = Register()
self.research = Research()
self.tests = Tests()
self.initialize_database()
def post(self) -> Response:
"""
POST response method for creating product.
JSON Web Token is required.
Authorization is required: Access(admin=true)
:return: JSON object
"""
#authorized: bool = Products.objects.get(id=get_jwt_identity()).access.admin
if True:
data = request.get_json()
post_user = Products(**data).save()
output = {'id': str(post_user.id)}
return jsonify({'result': output})
else:
return forbidden()
def products():
if 'admin' in session:
if request.method == 'POST':
name = request.form['name']
price = request.form['price']
# check if a product already exists
if Products.check_product_exists(name):
# if true, redirect to products page
flash('Product already exists', 'danger')
return redirect(url_for('products'))
else:
# add the product
p = Products(name=name, price=price)
p.insert_record()
flash('Record successfully added', 'success')
return redirect(url_for('products'))
return render_template('products.html')
else:
return redirect(url_for('admin'))
def auctioner():
if session:
if request.method == 'POST':
print(session['email'])
image_url = upload_file(request.files)
pname = request.form['pname']
description = request.form['description']
bid = request.form['bid']
x = Products(img=image_url,
pname=pname,
description=description,
initbid=bid)
x.insert_record()
print('record successfully added')
return redirect(url_for('auctioner'))
else:
return redirect(url_for('auctioner_login'))
return render_template('auctioner.html')
def test_get_product_by_id_success(self):
product = ProductServiceImpl.get_product_by_id(1)
self.assertEqual(type(product), type(Products()))
