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,))