def findAll(self): conn = ConnectionManagment.getConnection() cursor = conn.cursor() sql = 'select * from customer' cursor.execute(sql) data = cursor.fetchall() conn.commit() conn.close return data
def save(self, storeHouse): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tuple_storeHouse = (storeHouse.number, storeHouse.place) sql = 'insert into storehouse (store_number,store_place) values(%s,%s)' cursor.execute(sql, tuple_storeHouse) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def update(self, id, data): conn = ConnectionManagment.getConnection() cursor = conn.cursor() sql = 'UPDATE salesperson SET commission_rate = %s where sp_id = %s' tuple_update = (data, id) cursor.execute(sql, tuple_update) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def delete(self, id): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tupleId = (id, ) sql = 'delete from salesperson where sp_id = %s' cursor.execute(sql, tupleId) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def save(self, order): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tuple_order = (order.id, order.date, order.customer_id) sql = 'insert into orders (order_id,order_date,customer_id) values(%s,%s,%s)' cursor.execute(sql, tuple_order) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def update(self, id, data): conn = ConnectionManagment.getConnection() cursor = conn.cursor() sql = 'UPDATE product SET price = %s where product_id = %s' tuple_update = (data, id) cursor.execute(sql, tuple_update) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def save(self, product): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tuple_product = (product.id, product.desc, product.product_class, product.price) sql = 'insert into product (product_id,product_desc,product_class,price) values(%s,%s,%s)' cursor.execute(sql, tuple_product) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def findAll(self): conn = ConnectionManagment.getConnection() cursor = conn.cursor() sql = 'select * from orders' cursor.execute(sql) data = cursor.fetchall() conn.commit() conn.close orderList = [] for item in data: product = Order(item[0], item[1], item[2]) orderList.append(product) return orderList
def findAll(self): conn = ConnectionManagment.getConnection() cursor = conn.cursor() sql = 'select * from storehouse' cursor.execute(sql) data = cursor.fetchall() conn.commit() conn.close storeHouseList = [] for item in data: storeHouse = StoreHouse(item[0], item[1]) storeHouseList.append(storeHouse) return storeHouseList
def findAll(self): conn = ConnectionManagment.getConnection() cursor = conn.cursor() sql = 'select * from product' cursor.execute(sql) data = cursor.fetchall() conn.commit() conn.close productList = [] for item in data: product = Product(item[0], item[1], item[2], item[3]) productList.append(product) return productList
def findAll(self): conn = ConnectionManagment.getConnection() cursor = conn.cursor() sql = 'select * from salesperson' cursor.execute(sql) data = cursor.fetchall() conn.commit() conn.close salespersonList = [] for item in data: salesperson = SalesPerson(item[0], item[1], item[2], item[3], item[4], item[5]) salespersonList.append(salesperson) return salespersonList
def save(self, customer): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tuple_customer = (customer.id, customer.name, customer.governrate, customer.town, customer.street_number, customer.balance, customer.salesperson_id) sql = 'insert into customer (customer_id,customer_name,governrate,town,street_number,balance,sp_id)' \ 'values(%s,%s,%s,%s,%s,%s,%s)' cursor.execute(sql, tuple_customer) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def save(self, salesPerson): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tuple_salesPerson = (salesPerson.id, salesPerson.name, salesPerson.governrate, salesPerson.town, salesPerson.street_number, salesPerson.commission_rate) sql = 'insert into salesperson (sp_id,sp_name,governrate,town,street_number,commission_rate) ' \ 'values(%s,%s,%s,%s,%s,%s)' cursor.execute(sql, tuple_salesPerson) conn.commit() conn.close if cursor.rowcount > 0: return True else: return False
def findById(self, id): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tuple_id = (id, ) sql = 'select * from orders where order_id = %s' cursor.execute(sql, tuple_id) item = cursor.fetchone() conn.commit() conn.close try: order = Order(item[0], item[1], item[2]) except: order = Order(None, None, None) return order
def findById(self, id): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tuple_id = (id, ) sql = 'select * from storehouse where store_number = %s' cursor.execute(sql, tuple_id) item = cursor.fetchone() conn.commit() conn.close try: storeHouse = StoreHouse(item[0], item[1]) except: storeHouse = StoreHouse(None, None) return storeHouse
def findById(self, id): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tupleId = (id, ) sql = 'select * from product where product_id = %s' cursor.execute(sql, tupleId) item = cursor.fetchone() conn.commit() conn.close try: product = Product(item[0], item[1], item[2], item[3]) except: product = Product(None, None, None, None) return product
def findById(self, id): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tupleId = (id, ) sql = 'select * from customer where customer_id = %s' cursor.execute(sql, tupleId) item = cursor.fetchone() conn.commit() conn.close try: customer = Customer(item[0], item[1], item[2], item[3], item[4], item[5], item[6]) except: customer = Customer(None, None, None, None, None, None, None) return customer
def findById(self, id): conn = ConnectionManagment.getConnection() cursor = conn.cursor() tupleId = (id, ) sql = 'select * from salesperson where sp_id = %s' cursor.execute(sql, tupleId) item = cursor.fetchone() conn.commit() conn.close try: salesperson = SalesPerson(item[0], item[1], item[2], item[3], item[4], item[5]) except: salesperson = SalesPerson(None, None, None, None, None, None) return salesperson