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
