def add_products(adminpassword):
"""Add Products to the categories"""
conn = create_db()
cur = conn.cursor()
cur.execute("SELECT password from ADMIN")
password = cur.fetchone()
if password and adminpassword == password[0]:
name = click.prompt('Please enter product name', type=str)
description = click.prompt('Please enter product description',type=str)
amount = click.prompt('Please enter product amount', type=int)
product_category = click.prompt('Please enter product category name',type=str)
#product_category=product_category.lower()
cur=conn.cursor()
cur.execute("SELECT category_id FROM CATEGORIES WHERE name=:name",{'name':str(product_category)})
category_id=cur.fetchone()
if category_id:
category_id = category_id[0]
id = random.randint(1, 100000)
conn.execute("INSERT INTO PRODUCTS VALUES (?,?,?,?,?)", (id,name,description,amount,int(category_id)))
conn.commit()
flag = click.prompt('do you want to continue yes/no', type=str)
if flag.lower() == 'yes':
cli()
else:
click.echo('Categories added successfully')
print('\n')
print(pd.read_sql_query("SELECT product_name,description,amount from PRODUCTS",conn))
else:
click.echo('Please enter correct category name')
else:
click.echo('Incorrect password')
def add_my_cart(username,password):
"""
Add products to your cart
"""
conn = create_db()
cur = conn.cursor()
cur.execute("SELECT username,password FROM USERS WHERE username=:username AND password=:password",
{"username": username, 'password': password})
user_name = cur.fetchone()
if user_name is not None and username==user_name[0] and password == user_name[1]:
user_name = user_name[0]
product_name = click.prompt('enter product name to add', type=str)
#product_name=product_name.lower()
cur.execute("SELECT amount FROM PRODUCTS WHERE product_name=:product_name", {'product_name': product_name})
amount=cur.fetchone()
if amount is not None:
amount=amount[0]
id = random.randint(1, 10000000)
conn.execute("INSERT INTO MYCART VALUES(?,?,?,?)", (id, str(product_name), int(amount), str(user_name)))
conn.commit()
click.echo('Your cart:')
print('\n')
print(pd.read_sql_query(
"SELECT product_name,amount FROM MYCART WHERE username=:username", conn,
params={'username': str(user_name)}))
else:
click.echo('Product not found enter valid product name please')
else:
click.echo('Incorrect Username Or Password')
def view_coupons():
"""View list of all Coupons"""
conn = create_db()
cur=conn.cursor()
cur.execute("SELECT coupon_code,end_date,discount,type_of_usage FROM COUPONS")
coupons=cur.fetchone()
if coupons:
print(pd.read_sql_query("SELECT coupon_code,end_date,discount,type_of_usage FROM COUPONS", conn))
else:
click.echo('NO coupons available')
def view_all_products():
"""View product details"""
conn = create_db()
cur = conn.cursor()
cur.execute("SELECT product_name FROM PRODUCTS")
products = cur.fetchone()
if products:
print(pd.read_sql_query("SELECT product_name,description,amount FROM PRODUCTS", conn))
else:
click.echo('No products added on SITE, Visit Again in sometime')
def register():
"""User registration"""
user_name = click.prompt('Please enter a username', type=str)
password= click.prompt('Please enter a password', type=str,hide_input=True)
#flag=click.prompt('do you want to continue',type=str)
#if flag=='yes':
#cli()
conn=create_db()
id=random.randint(1, 100000)
conn.execute("INSERT INTO USERS VALUES (?,?)", (user_name, password))
conn.commit()
def view_product():
"""View product details"""
conn = create_db()
cur=conn.cursor()
cur.execute("SELECT product_name FROM PRODUCTS")
product=cur.fetchone()
if product:
product_name = click.prompt('enter the product name to view details', type=str)
print('\n')
print(pd.read_sql_query("SELECT product_name,description,amount FROM PRODUCTS WHERE product_name=:product_name",conn,params={'product_name':product_name}))
else:
click.echo('No products added on SITE, Visit Again in sometime')
def add_categories(adminpassword):
"""Add Categories"""
conn = create_db()
cur = conn.cursor()
cur.execute("SELECT password from ADMIN")
password = cur.fetchone()
if password and adminpassword == password[0]:
name = click.prompt('Please enter type of categories you want', type=str)
name = name.lower()
id = random.randint(1, 100000)
conn.execute("INSERT INTO CATEGORIES VALUES (?,?)", (id,name))
conn.commit()
flag = click.prompt('do you want to continue', type=str)
if flag == 'yes':
cli()
else:
click.echo('Categories added successfully')
print('\n')
print(pd.read_sql_query("SELECT * FROM CATEGORIES",conn))
else:
click.echo('Incorrect Password')
def remove_from_cart(username,password):
"""Remove products from cart"""
conn = create_db()
cur = conn.cursor()
cur.execute("SELECT username,password FROM USERS WHERE username=:username AND password=:password",
{"username": username, 'password': password})
user_name = cur.fetchone()
if user_name is not None and username == user_name[0] and password == user_name[1]:
user_name = user_name[0]
click.echo('Your cart:')
print('\n')
print(pd.read_sql_query(
"SELECT product_name,amount FROM MYCART WHERE username=:username", conn,
params={'username': str(user_name)}))
product_name = click.prompt('enter product name to remove', type=str)
conn.execute("DELETE FROM MYCART WHERE product_name=:product_name COLLATE NOCASE",
{'product_name': product_name})
conn.commit()
click.echo('Product removed from your cart')
else:
click.echo('Incorrect Username or password')
def add_coupons(adminpassword):
"""Add coupons by admin """
conn = create_db()
cur = conn.cursor()
cur.execute("SELECT password from ADMIN")
password = cur.fetchone()
if password and password[0] == adminpassword:
coupon_code = click.prompt('Please enter coupon code', type=str)
end_date = click.prompt('Please enter end date in yyyy-mm-dd format only ', type=str)
discount = click.prompt('Please enter discount', type=int)
type_of_usage = click.prompt('Please enter type of usage, Enter 1 for one time, 10 for multiple, 100 for unlimited times', type=int)
id=random.randint(1, 10000000)
conn.execute("INSERT INTO COUPONS VALUES(?,?,?,?,?)", (id, coupon_code, end_date, discount, type_of_usage))
conn.commit()
flag = click.prompt('do you want to continue yes/no', type=str)
if flag.lower() == 'yes':
cli()
else:
click.echo('Coupons added successfully')
print('\n')
print(pd.read_sql_query("SELECT coupon_code,end_date,discount,type_of_usage FROM COUPONS", conn))
else:
click.echo('Incorrect password Not authorized')
def checkout(username,password):
"""Buy all products from cart apply coupon if any and checkout"""
current_date = datetime.datetime.now()
date = current_date.date()
conn = create_db()
cur = conn.cursor()
cur.execute("SELECT username,password FROM USERS WHERE username=:username AND password=:password",
{"username": username, 'password': password})
user_name = cur.fetchone()
if user_name is not None and username == user_name[0] and password == user_name[1]:
user_name = user_name[0]
cur.execute("SELECT username FROM MYCART WHERE username=:username", {'username': str(user_name)})
check_cart=cur.fetchone()
if check_cart:
print(pd.read_sql_query("SELECT coupon_code,end_date,discount,type_of_usage FROM COUPONS", conn))
print('\n')
apply_coupon = click.prompt('do u want to apply any coupon of above,[yes/no] ', type=str)
if apply_coupon.lower()=='yes':
coupon_code = click.prompt('Enter coupon code', type=str)
query=conn.execute("SELECT end_date,discount,type_of_usage FROM COUPONS WHERE coupon_code=:coupon_code",{'coupon_code':coupon_code})
query=query.fetchone()
print('query ',query)
if query is not None and query[2]>0 and str(date)> str(query[0]):
coupon_end_date=query[0]
coupon_discount=query[1]
coupon_usage=query[2]
user_cart=conn.execute("SELECT SUM(amount) FROM MYCART WHERE username=:username",{'username':user_name})
amount=user_cart.fetchone()[0]
discount_amount=(amount*coupon_discount)/100
final_amount=amount-discount_amount
print(pd.read_sql_query(
"SELECT product_name,amount FROM MYCART WHERE username=:username", conn,
params={'username': str(user_name)}))
print('')
print('\n')
print('Total Bill Amount =',amount)
print('Discounted Amount =',discount_amount)
print('Amount to be paid =', final_amount)
conn.execute("DELETE FROM MYCART WHERE username=:username", {'username': user_name})
conn.commit()
if not coupon_usage >10:
conn.execute("UPDATE COUPONS SET type_of_usage=type_of_usage-1 WHERE coupon_code=:coupon_code",{'coupon_code':coupon_code})
conn.commit()
else:
click.echo('Invalid Coupon code or coupon expired')
elif apply_coupon.lower() == 'no':
user_cart = conn.execute("SELECT SUM(amount) FROM MYCART WHERE username=:username", {'username': user_name})
amount = user_cart.fetchone()[0]
print(pd.read_sql_query(
"SELECT product_name,amount FROM MYCART WHERE username=:username", conn,
params={'username': str(user_name)}))
conn.execute("DELETE FROM MYCART WHERE username=:username", {'username': user_name})
conn.commit()
if amount > 10000:
final_bill = amount-500
print('\n')
print('Total Bill Amount =', amount)
print('Discounted Amount = 500')
print('Amount to be paid =', final_bill)
else:
print('Amount to be paid =', amount)
else:
click.echo('Cart Empty,Add some products in cart first')
else:
click.echo('Incorrect Username or password')
def set_admin(username, password):
"""Admin registration"""
conn = create_db()
conn.execute("INSERT INTO ADMIN VALUES(?,?)", (username, password))
conn.commit()
def view_categories():
"""View list of all categories of products"""
conn = create_db()
print(pd.read_sql_query("SELECT name FROM CATEGORIES", conn))