def list_items_in_checkoutcart(cart):
cprint("\n Items in cart : \n", 'red', 'on_white')
items = cart.items
for item in items:
dynamodb_service.get_item_from_dynamodb(item)
# print (item)
if len(cart.saveditems):
for saveditem in cart.saveditems:
dynamodb_service.get_item_from_dynamodb(saveditem[0])
def retrieve_saved_items(self):
with self.conx as cursor:
savedcart_items = "select ci.sku from cartitems ci join cart c on c.cartid = ci.cartid where c.ordered = 0 and c.username = %(usrnm)s"
itemcount = cursor.execute(savedcart_items, {'usrnm': self.user})
if itemcount:
items = cursor.fetchall()
self.saveditems = items
cprint('products in the cart', 'red', 'on_white')
for item in items:
dynamodb_service.get_item_from_dynamodb(item[0])
else:
self.saveditems = ()
cursor.close()
def get_complete_history(username):
conx = awsdbconnect.connecttodb()
conx1 = awsdbconnect.connecttodb()
with conx as cursor:
sql = "select cartid from cart where username = %s and ordered = 1"
rowcount = cursor.execute(sql, username)
for item in cursor:
print("\n Items in order no : %s") % item[0]
with conx1 as cursor1:
sql1 = "select sku from cartitems where cartid = %s"
skucount = cursor1.execute(sql1, item[0])
for sku in cursor1:
dynamodb_service.get_item_from_dynamodb(sku[0])
cursor1.close()
cursor.close()
def get_recent_order(username):
conx = awsdbconnect.connecttodb()
conx1 = awsdbconnect.connecttodb()
with conx as cursor:
sql = "select max(cartid) from cart where username = %s and ordered = 1"
rowcount = cursor.execute(sql, username)
for item in cursor:
print('\n Items in recent order ') #%(str(item[0]))
with conx1 as cursor1:
sql1 = "select sku from cartitems where cartid = %s"
skucount = cursor1.execute(sql1, item[0])
for sku in cursor1:
dynamodb_service.get_item_from_dynamodb(sku[0])
cursor1.close()
cursor.close()
def review_purchase_history(conx, username):
with conx as cursor:
sql = "select cartid from cart where username = %(usrnm)s and ordered = 1 order by dts desc;"
cursor.execute(sql, {'usrnm': username})
recentorder = cursor.fetchone()
cursor.close()
if recentorder is not None:
with conx as cursor:
sql = "select sku from cartitems where cartid = %s"
cursor.execute(sql, recentorder)
cprint("\n recently purchased products : \n", 'red', 'on_white')
for item in cursor:
# print(item)
dynamodb_service.get_item_from_dynamodb(item[0])
cursor.close()