def update_address(self, email_address, country, city, street, street_num, zip_code): query = 'UPDATE group1.customers SET country=%s, city=%s, street=%s, number=%s, zip_code=%s ' \ 'WHERE group1.customers.email_address = %s;' return dbManager.commit( query, (country, city, street, street_num, zip_code, email_address))
def update_phone_number(self, email_address, phone): query = 'UPDATE group1.customers SET phone_number=%s ' \ 'WHERE group1.customers.email_address = %s;' return dbManager.commit(query, ( phone, email_address, ))
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 update_credit_card(self, email_address, credit_card_number, expiration_date, cvv): query = 'UPDATE group1.credit_cards SET credit_card_number=%s, expiration_date=%s, cvv=%s ' \ 'WHERE group1.credit_cards.email_address = %s;' success = dbManager.commit(query, (credit_card_number, expiration_date, cvv, email_address)) if success > 0: return success return Profile().add_credit_card(email_address, credit_card_number, expiration_date, cvv)
def insert_data(self, email_address, password, user_name, first_name, last_name, country, city, street, number, zip_code, phone_number): query = 'INSERT INTO group1.customers (email_address, password, user_name, first_name, last_name, country, city, street, number, zip_code, phone_number) ' \ 'VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' return dbManager.commit( query, (email_address, password, user_name, first_name, last_name, country, city, street, number, zip_code, phone_number))
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 delete_data(self, email_address): query = 'DELETE FROM group1.customers WHERE email_address = %s' return dbManager.commit(query, (email_address,))
def add_credit_card(self, email_address, credit_card_number, expiration_date, cvv): query = 'INSERT INTO group1.credit_cards (email_address, credit_card_number, expiration_date, cvv) ' \ 'VALUES(%s, %s, %s, %s)' return dbManager.commit(query, (email_address, credit_card_number, expiration_date, cvv))
def update_users_data(self, email_address, password, user_name, first_name, last_name, country, city, street, number, zip_code, phone_number, role): query = 'UPDATE group1.customers SET password=%s, user_name=%s, first_name=%s, last_name=%s, country=%s, city=%s, street=%s, number=%s, zip_code=%s, phone_number=%s, role=%s ' \ 'WHERE group1.customers.email_address=%s;' return dbManager.commit(query, (password, user_name, first_name, last_name, country, city, street, number, zip_code, phone_number, role, email_address))
def update_product_data(self, sku, name, price, description, category_code, img): query = 'UPDATE group1.products SET name=%s, price=%s, description=%s, category_code=%s, img=%s ' \ 'WHERE group1.products.sku=%s;' return dbManager.commit(query, (name, price, description, category_code, img, sku))
def delete_data(self, sku): query = 'DELETE FROM group1.products WHERE sku = %s' return dbManager.commit(query, (sku,))
def insert_data(self, sku, name, price, description, category_code, img): query = 'INSERT INTO group1.products (sku, name, price, description, category_code, img) ' \ 'VALUES(%s, %s, %s, %s, %s, %s)' return dbManager.commit(query, (sku, name, price, description, category_code, img))
def update_category_data(self, category_code, category_name, img): query = 'UPDATE group1.categories SET category_name=%s, img=%s ' \ 'WHERE group1.categories.category_code=%s;' return dbManager.commit(query, (category_name, img, category_code))
def delete_data(self, category_code): query = 'DELETE FROM group1.categories WHERE category_code = %s' return dbManager.commit(query, (category_code,))
def insert_data(self, category_code, category_name, img): query = 'INSERT INTO group1.categories (category_code, category_name, img) ' \ 'VALUES(%s, %s, %s)' return dbManager.commit(query, (category_code, category_name, img))
def update_data(self, email_address, subject, content): query = 'INSERT INTO group1.contact_us(sent_date, subject, content, status, email_address) ' \ 'VALUES(date(NOW()), %s, %s, %s, %s)' return dbManager.commit(query, (subject, content, 'waiting', email_address))