def get_user_data(self, email_address=None, password=None):
query = 'SELECT customers.first_name, customers.last_name, customers.email_address, customers.user_name ' \
'FROM group1.customers WHERE customers.email_address=%s AND customers.password=%s'
return dbManager.fetch(query, (
email_address,
password,
))
def get_data(self, id=None):
query = 'SELECT group1.customers.user_name as user_name,' \
' group1.reviews.rank, content, group1.reviews.date as date ' \
'FROM group1.reviews JOIN group1.customers ' \
'ON group1.reviews.user_name = group1.customers.user_name ' \
'WHERE group1.reviews.sku=%s ' \
'ORDER BY date DESC, user_name'
return dbManager.fetch(query, (id,))
def update_password(self, email_address, old_password,new_password):
query = 'SELECT password FROM group1.customers WHERE email_address = %s'
real_old_password = dbManager.fetch(query, (email_address,))
if real_old_password[0].password == old_password:
query = 'UPDATE group1.customers SET password=%s ' \
'WHERE group1.customers.email_address = %s;'
return dbManager.commit(query, (new_password, email_address))
return False
def upload_data(self, rank, content, user_name, id, email_address):
vertify_query = 'SELECT details.*, include.sku FROM (' \
' SELECT group1.customers.user_name, o.id as order_id, o.date_of_order ' \
'FROM group1.customers JOIN group1.orders o ON customers.email_address = o.email_address ' \
'WHERE customers.email_address = %s ) as details ' \
'JOIN group1.include ON details.order_id = include.order_id '
customer_buy_the_product = dbManager.fetch(vertify_query, (email_address,))
if customer_buy_the_product == 0:
return (False, 'You need to buy the product in order to post a review')
product_reviews = Reviews().get_data(id)
for review in product_reviews:
if review.user_name == user_name:
return (False, 'You already post review for this product')
query = 'INSERT INTO group1.reviews (date, `rank`, content, user_name, sku) ' \
'VALUES(date(NOW()), %s, %s, %s, %s)'
return (True, dbManager.commit(query, (rank, content, user_name, id)))
def get_data(self, id=None):
query = 'SELECT user_data.*, group1.reviews.`rank`, group1.reviews.date, group1.reviews.content ' \
'FROM ( SELECT user_orders.*, credit_cards.expiration_date ' \
'FROM ( ' \
'SELECT details.*, product_details.name as product_name, product_details.img,' \
' product_details.price, product_details.sku FROM (SELECT group1.customers.*, o.id as order_id,' \
' o.date_of_order FROM group1.customers ' \
'LEFT JOIN group1.orders o ON customers.email_address = o.email_address ' \
'WHERE customers.email_address = %s ORDER BY o.date_of_order DESC LIMIT 10) as details' \
' LEFT JOIN (SELECT group1.products.*, group1.include.order_id FROM group1.products ' \
'JOIN group1.include ON products.sku = include.sku) as product_details ' \
'ON details.order_id = product_details.order_id ORDER BY product_details.name) as user_orders ' \
'LEFT JOIN group1.credit_cards ON user_orders.email_address = credit_cards.email_address) AS user_data ' \
'LEFT JOIN group1.reviews ' \
'ON (user_data.user_name = group1.reviews.user_name AND user_data.sku = group1.reviews.sku)'
return dbManager.fetch(query, (id,))
def get_data(self, id=None):
query = 'SELECT * FROM group1.products WHERE group1.products.sku=%s'
return dbManager.fetch(query, (id,))
def get_data_edit(self, id=None):
query = 'SELECT * FROM group1.customers WHERE customers.email_address=%s'
return dbManager.fetch(query, (id,))
def get_data(self, id=None):
query = 'SELECT * FROM group1.customers WHERE role="admin" or role="content manager" or role="dba"'
return dbManager.fetch(query)
def get_data(self, id=None):
query = 'SELECT * FROM group1.products'
return dbManager.fetch(query)
def get_data_edit(self, id=None):
query = 'SELECT * FROM group1.categories WHERE categories.category_code=%s'
return dbManager.fetch(query, (id,))
def get_data(self, id=None):
query = 'SELECT * FROM group1.categories'
return dbManager.fetch(query)
def get_user_data(self, user_name=None, password=None):
query = 'SELECT * FROM group1.customers ' \
'WHERE customers.user_name=%s AND customers.password=%s ' \
'AND (role="admin" or role="content manager" or role="dba");'
return dbManager.fetch(query, (user_name, password,))
def get_data(self, id=None):
query = 'SELECT category_code as code, category_name as name, img FROM group1.categories'
return dbManager.fetch(query)
def get_data(self, id=None):
query = 'SELECT * FROM products ' \
'WHERE products.category_code=%s'
return dbManager.fetch(query, (id,))