def get_parent_id(self, node_id): self.db = DBManager() query = "select (parent_node), node_content from nodes where node_id = '%s' " % node_id res = self.db.fetch(query=query) res1 = res[0].parent_node res2 = res[0].node_content return res1, res2
def insert_node_comment(self, discussion_id, parent_node, title, email, node_level): self.db = DBManager() query = "insert into nodes (discussion_id, parent_node, node_content, node_owner, node_level) values ('%s', '%s', '%s', '%s', '%s')" % ( discussion_id, parent_node, title, email, node_level) res = self.db.commit(query=query) return res
def insert_discuss(self, discussion_id, title, description, due_date, email): self.db = DBManager() query = "insert into discussions(discussion_id, title, description, due_date, discussion_owner) values ('%s','%s','%s','%s','%s')" % ( discussion_id, title, description, due_date, email) user = self.db.commit(query=query) self.insert_node_question(discussion_id, title, email) return user
def insert_into_products_orders(self, cart_table, max_order): self.db = DBManager() for key, value in cart_table.items(): product_id = cart_table[key]['id'] quantity = cart_table[key]['quantity'] row = self.db.commit( "insert into products_in_order(order_id, product_id, quantity) VALUES ('%s', '%s', '%s')" % ( max_order, product_id, quantity)) return row
def set_new_order(self, fname: str, email: str, phone: str, city: str, address: str, door: str, comments: str, delivery: str, credit_card, cvv, made_by, all_total_quantity, all_total_price): self.db = DBManager() row = self.db.commit( "insert into orders(Full_Name, Email, Phone, City, Street, Apartment, Comments, Delivery_Option, Credit_Card, cvv, made_by, total_quantity, amount_order) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % ( fname, email, phone, city, address, door, comments, delivery, credit_card, cvv, made_by, all_total_quantity, all_total_price)) return row
def check_if_joined(self, discussion_id, email): self.db = DBManager() query = "select * from user_vote_disc where voter='%s' and discussion_id='%s' " % ( email, discussion_id) res = self.db.fetch(query=query) if len(res): res = True else: res = False print(res) return res
def rank_final_decision(self, email, discussion_id, node_id, amount): self.db = DBManager() query1 = "select score from user_vote_disc where voter='%s' and discussion_id='%s' " % ( email, discussion_id) res1 = self.db.fetch(query=query1) res1 = int(res1[0].score) query2 = "select node_score from nodes where node_id='%s'" % node_id res2 = self.db.fetch(query=query2) res2 = int(res2[0].node_score) amount = int(amount) if res1 >= amount: update_user_tokens = "update user_vote_disc set score = '%s' where voter='%s' and discussion_id='%s' " % ( res1 - amount, email, discussion_id) self.db.commit(query=update_user_tokens) update_node_score = "update nodes set node_score = '%s' where node_id='%s'" % ( res2 + amount, node_id) self.db.commit(query=update_node_score)
def get_level_parent(self, node_id): self.db = DBManager() parent_level = "select parent_node from nodes where node_id = '%s' " % node_id res = self.db.fetch(query=parent_level) if res[0].parent_node is None: res = 0 flag = 1 else: res = res[0].parent_node flag = 0 if res is not None and flag == 0: query = "select node_level from nodes where node_id = '%s' " % res res = self.db.fetch(query=query) res = res[0].node_level else: res = 0 return res
def vote_for_comment(self, email, discussion_id, node_id, amount, first_time, last_time): self.db = DBManager() query1 = "select score from user_vote_disc where voter='%s' and discussion_id='%s' " % ( email, discussion_id) res1 = self.db.fetch(query=query1) res1 = int(res1[0].score) query2 = "select node_score from nodes where node_id='%s'" % node_id res2 = self.db.fetch(query=query2) res2 = int(res2[0].node_score) amount = int(amount) if res1 >= amount: if first_time == 1: update_user_tokens = "update user_vote_disc set score = '%s' where voter='%s' and discussion_id='%s' " % ( res1 - amount, email, discussion_id) self.db.commit(query=update_user_tokens) if last_time == 1: update_node_score = "update nodes set node_score = '%s' where node_id='%s'" % ( res2 + amount, node_id) self.db.commit(query=update_node_score) return True else: return False
def register_new_user(self, email: str, password: str, fname: str, lname: str, phone: str, date, gender: str): self.db = DBManager() row = self.db.commit( "insert into customers(Email, User_Password, First_Name, Last_Name, Phone, Birth_Date, Gender) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (email, password, fname, lname, phone, date, gender)) return row
def _init_(self): """ Init dbmanager """ self.db = DBManager()
def get_max_order(self): self.db = DBManager() row = self.db.fetch('select (max(order_id)) as cartid from orders') row = row[0] return row
def insert_contact_us(self, fname: str, email: str, phone: str, text_area: str): self.db = DBManager() row = self.db.commit( "insert into contact_us(FullName, Email, Phone, comments) VALUES ('%s', '%s', '%s', '%s')" % (fname, email, phone, text_area)) return row
def user_data(self, uname: str, password: str): self.db = DBManager() row = self.db.fetch('select * from customers where Email=%s and User_Password=%s', (uname, password)) return row
class DBQuery: def _init_(self): """ Init dbmanager """ self.db = DBManager() def get_product_vradim(self, product_name: str): self.db = DBManager() row = self.db.fetch('select * from products where Product_Name=%s', (product_name,)) return row def get_product_sahlav(self, product_name: str, product_type: str): self.db = DBManager() row = self.db.fetch('select * from products where Product_Name=%s and Dairy=%s', (product_name, product_type)) return row def get_product_malabi(self, product_type: str, malabi_syrup: str, malabi_topping: str): self.db = DBManager() row = self.db.fetch('select * from products where Dairy=%s and Syrup=%s and Topping=%s', (product_type, malabi_syrup, malabi_topping)) return row def user_data(self, uname: str, password: str): self.db = DBManager() row = self.db.fetch('select * from customers where Email=%s and User_Password=%s', (uname, password)) return row def get_max_order(self): self.db = DBManager() row = self.db.fetch('select (max(order_id)) as cartid from orders') row = row[0] return row def insert_contact_us(self, fname: str, email: str, phone: str, text_area: str): self.db = DBManager() row = self.db.commit( "insert into contact_us(FullName, Email, Phone, comments) VALUES ('%s', '%s', '%s', '%s')" % (fname, email, phone, text_area)) return row def register_new_user(self, email: str, password: str, fname: str, lname: str, phone: str, date, gender: str): self.db = DBManager() row = self.db.commit( "insert into customers(Email, User_Password, First_Name, Last_Name, Phone, Birth_Date, Gender) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (email, password, fname, lname, phone, date, gender)) return row def set_new_order(self, fname: str, email: str, phone: str, city: str, address: str, door: str, comments: str, delivery: str, credit_card, cvv, made_by, all_total_quantity, all_total_price): self.db = DBManager() row = self.db.commit( "insert into orders(Full_Name, Email, Phone, City, Street, Apartment, Comments, Delivery_Option, Credit_Card, cvv, made_by, total_quantity, amount_order) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % ( fname, email, phone, city, address, door, comments, delivery, credit_card, cvv, made_by, all_total_quantity, all_total_price)) return row def update_customer(self, fname: str, lname: str, birthdate, phone, id): self.db = DBManager() row = self.db.commit( 'update customers set First_Name=%s, Last_Name=%s, Birth_Date=%s, Phone=%s where Email=%s', (fname, lname, birthdate, phone, id)) return row def get_user(self, id): self.db = DBManager() row = self.db.fetch('select * from customers where Email=%s', (id,)) return row def delete_user(self, id): self.db = DBManager() row = self.db.commit( 'delete from orders where made_by=%s', (id,)) return row def delete_user_customer(self, id): self.db = DBManager() row = self.db.commit('delete from customers where Email=%s', (id,)) return row def insert_into_products_orders(self, cart_table, max_order): self.db = DBManager() for key, value in cart_table.items(): product_id = cart_table[key]['id'] quantity = cart_table[key]['quantity'] row = self.db.commit( "insert into products_in_order(order_id, product_id, quantity) VALUES ('%s', '%s', '%s')" % ( max_order, product_id, quantity)) return row
def delete_user_customer(self, id): self.db = DBManager() row = self.db.commit('delete from customers where Email=%s', (id,)) return row
def delete_favorite(self, email, discussion_id): self.db = DBManager() query = "Delete from favorites where email = '%s' and discussion_id = '%s'" % ( email, discussion_id) res = self.db.commit(query=query) return res
def get_merge_list(self, discussion_id): self.db = DBManager() query = "select node_content from nodes where discussion_id = '%s' " % discussion_id res = self.db.fetch(query=query) return res
def get_user(self, id): self.db = DBManager() row = self.db.fetch('select * from customers where Email=%s', (id,)) return row
def get_all_comments_list(self, discussion_id): self.db = DBManager() query = "select * from nodes as n join users as u on n.node_owner = u.email where discussion_id = '%s' " % discussion_id res = self.db.fetch(query=query) return res
def get_discussions_by_id(self, discussion_id): self.db = DBManager() query = "SELECT * FROM discussions as d join users as u on d.discussion_owner = u.email where discussion_id = '%s'" % discussion_id res = self.db.fetch(query=query) return res
def get_favorites(self, email): self.db = DBManager() query = "SELECT discussion_id FROM favorites where email = '%s'" % email res = self.db.fetch(query=query) return res
def get_max_id_discuss(self): self.db = DBManager() max_id = self.db.fetch( "select (max(discussion_id)+1) as max_discuss from discussions") max_id = max_id[0].max_discuss return max_id
def get_all_discussions(self): self.db = DBManager() query = "SELECT * FROM discussions" res = self.db.fetch(query=query) return res
def update_customer(self, fname: str, lname: str, birthdate, phone, id): self.db = DBManager() row = self.db.commit( 'update customers set First_Name=%s, Last_Name=%s, Birth_Date=%s, Phone=%s where Email=%s', (fname, lname, birthdate, phone, id)) return row
def insert_favorite(self, email, discussion_id): self.db = DBManager() query = "insert into favorites(email, discussion_id ) values ('%s','%s')" % ( email, discussion_id) res = self.db.commit(query=query) return res
def delete_user(self, id): self.db = DBManager() row = self.db.commit( 'delete from orders where made_by=%s', (id,)) return row
def get_product_sahlav(self, product_name: str, product_type: str): self.db = DBManager() row = self.db.fetch('select * from products where Product_Name=%s and Dairy=%s', (product_name, product_type)) return row
def get_product_vradim(self, product_name: str): self.db = DBManager() row = self.db.fetch('select * from products where Product_Name=%s', (product_name,)) return row
def get_product_malabi(self, product_type: str, malabi_syrup: str, malabi_topping: str): self.db = DBManager() row = self.db.fetch('select * from products where Dairy=%s and Syrup=%s and Topping=%s', (product_type, malabi_syrup, malabi_topping)) return row