def addLocation(self, jsonObj): logger.info('%s', jsonObj) if (isinstance(jsonObj, dict)): db = database.Database() q = """ INSERT INTO Retail_Locations (rName, rStreet, rCity, rState, rZip) VALUES (%s, %s, %s, %s, %s) """ params = [ jsonObj['rName'], jsonObj['rStreet'], jsonObj['rCity'], jsonObj['rState'], jsonObj['rZip'] ] result = db.queryDB(q, params, True) return result else: return "Please send a JSON object"
def addProduct(self, jsonObj): logger.info('%s', jsonObj) logger.info('This is a %s', type(jsonObj)) if (isinstance(jsonObj, dict)): db = database.Database() q = """ INSERT INTO Products (pCost, pName, pDepartment, pWeight) VALUES(%s, %s, %s, %s) """ params = [ jsonObj['pCost'], jsonObj['pName'], jsonObj['pDepartment'], jsonObj['pWeight'] ] result = db.queryDB(q, params, True) return result else: return "Please send a JSON object"
def addSells(self, jsonObj): logger.info('%s', jsonObj) logger.info('This is a %s', type(jsonObj)) if (isinstance(jsonObj, dict)): db = database.Database() q = """ INSERT INTO Sells (Sales_Price, Date, Qty, Retail_Locations_rID, Products_pID) VALUES(%s, %s, %s, %s, %s) """ params = [ jsonObj['Sales_Price'], jsonObj['Date'], jsonObj['Qty'], jsonObj['Retail_Locations_rID'], jsonObj['Products_pID'] ] result = db.queryDB(q, params, True) return result else: return "Please send a JSON object"
def updateProductById(self, jsonObj, id): logger.info('%s', jsonObj) logger.info('%s', id) if (isinstance(jsonObj, dict)): if (jsonObj['pID'] is None or jsonObj['pID'] is not id): jsonObj['pID'] = id db = database.Database() q = """ UPDATE Products SET pCost = %s, pName = %s, pDepartment = %s, pWeight = %s WHERE pID = %s """ params = [ jsonObj['pCost'], jsonObj['pName'], jsonObj['pDepartment'], jsonObj['pWeight'], jsonObj['pID'] ] result = db.queryDB(q, params, True) return result else: return "Please send a JSON object"
def updateLocationById(self, jsonObj, id): logger.info('%s', jsonObj) logger.info('%s', id) if (isinstance(jsonObj, dict)): if (jsonObj['rID'] is None or jsonObj['rID'] is not id): jsonObj['rID'] = id db = database.Database() q = """ UPDATE Retail_Locations SET rName = %s, rStreet = %s, rCity = %s, rState = %s, rZip = %s WHERE rID = %s """ params = [ jsonObj['rName'], jsonObj['rStreet'], jsonObj['rCity'], jsonObj['rState'], jsonObj['rZip'], jsonObj['rID'] ] result = db.queryDB(q, params, True) return result else: return "Please send a JSON object"
def updateSellsById(self, jsonObj, id): logger.info('%s', jsonObj) logger.info('%s', id) if (isinstance(jsonObj, dict)): if (jsonObj['transactionID'] is None or jsonObj['transactionID'] is not id): jsonObj['transacctionID'] = id db = database.Database() q = """ UPDATE Sells SET Sales_Price = %s, Date = %s, Qty = %s, Retail_Locations_rID = %s, Products_pID = %s WHERE transactionID = %s """ params = [ jsonObj['Sales_Price'], jsonObj['Date'], jsonObj['Qty'], jsonObj['Retail_Locations_rID'], jsonObj['Products_pID'], jsonObj['transactionID'] ] result = db.queryDB(q, params, True) return result else: return "Please send a JSON object"
def getLocationById(self, id): logger.info('Getting Retail Location by id: %s', id) db = database.Database() q = """SELECT * FROM Retail_Locations WHERE rID=%s""" result = db.queryDB(q, [id]) return result
def getAllLocations(self): logger.info('Getting all Retail Locations') db = database.Database() q = """SELECT * FROM Retail_Locations""" result = db.queryDB(q) return result
def deleteProductById(self, id): logger.info('Deleting product with id: %s', id) db = database.Database() q = """DELETE FROM Products WHERE pID=%s""" result = db.queryDB(q, [id], True) return result
def deleteSellsById(self, id): logger.info('Deleting transaction with id: %s', id) db = database.Database() q = """DELETE FROM Sells WHERE transactionID=%s""" result = db.queryDB(q, [id], True) return result
def getProductById(self, id): logger.info('Getting product by id: %s', id) db = database.Database() q = """SELECT * FROM Products WHERE pID=%s""" result = db.queryDB(q, [id]) return result
def getSellsById(self, id): logger.info('Getting Transaction by id: %s', id) db = database.Database() q = """SELECT * FROM Sells WHERE transactionID=%s""" result = db.queryDB(q, [id]) return result
def getAllSells(self): logger.info('Getting all transactions') db = database.Database() q = """SELECT * FROM Sells""" result = db.queryDB(q) return result
def deleteLocationById(self, id): logger.info('Delete location with id: %s', id) db = database.Database() q = """DELETE FROM Retail_Locations WHERE rID=%s""" result = db.queryDB(q, [id], True) return result
def getAllProducts(self): logger.info('Getting all Products') db = database.Database() q = """SELECT * FROM Products""" result = db.queryDB(q) return result