def post(self): if self.id != 0: try: sqlString = "SELECT 1 FROM `table_user` WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, (self.id,)) result = cur.fetchone() if result == None: self.make_reserror_json(400, "user not exist") else: self.write({ "status": "success", "data":{"code":200, "message": "user exist"} }) except Exception as e: self.make_internalerror() elif len(self.name) > 0: try: sqlString = "SELECT 1 FROM `table_user` WHERE `name`=%s" cur = yield db.connPool().execute(sqlString, (self.name,)) result = cur.fetchone() if result == None: self.make_reserror_json(400, "user not exist") else: self.write({ "status": "success", "data":{"code":200, "message": "user exist"} }) except Exception as e: print(e) self.make_internalerror() else: self.make_badrequest()
def post(self): if not ("postalCodeList" in self.jsonBody) or len(self.jsonBody["postalCodeList"]) == 0: self.make_badrequest() else: try: sqlString = "SELECT `id`, `user`, `price`, `listing_type`, `postal_code`, `status` FROM `table_listing`" filterString = "" objectList = [] if "postalCodeList" in self.jsonBody: for item in self.jsonBody["postalCodeList"]: filterString += item + "," filterString = filterString[:len(filterString) -1] filterString = " WHERE `postal_code` in (" + filterString + ")" sqlString += filterString print(sqlString) cur = yield db.connPool().execute(sqlString) result = cur.fetchall() for row in result: objectList.append(row) objects = json.dumps(objectList) self.write({ "status": "sucess", "data": {"code": 200, "message":"", "listings": objects} }) except Exception as e: print(e) self.make_internalerror()
def post(self): if not ("postalCodeList" in self.jsonBody) or len( self.jsonBody["postalCodeList"]) == 0: self.make_badrequest() else: try: sqlString = "SELECT `id`, `user`, `price`, `listing_type`, `postal_code`, `status` FROM `table_listing`" filterString = "" objectList = [] if "postalCodeList" in self.jsonBody: for item in self.jsonBody["postalCodeList"]: filterString += item + "," filterString = filterString[:len(filterString) - 1] filterString = " WHERE `postal_code` in (" + filterString + ")" sqlString += filterString print(sqlString) cur = yield db.connPool().execute(sqlString) result = cur.fetchall() for row in result: objectList.append(row) objects = json.dumps(objectList) self.write({ "status": "sucess", "data": { "code": 200, "message": "", "listings": objects } }) except Exception as e: print(e) self.make_internalerror()
def post(self): if self.id == 0: self.make_badrequest() else: verified = self.verifyUserId(self.user) if not verified: self.make_notfound() else: try: sqlString = "DELETE FROM `table_listing` WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, (str(self.id), )) affected_rows = cur.rowcount if affected_rows == 0: self.make_reserror_json(400, "id not exist") else: self.write({ "status": "sucess", "data": { "code": 200, "message": "" } }) except Exception as e: print(e) self.make_internalerror()
def post(self): if self.id == 0 or self.user == 0 or self.price <= 0: self.make_badrequest() else: verified = self.verifyUserId(self.user) if not verified: self.make_notfound() else: try: sqlString = "UPDATE `table_listing` SET `price`=%s WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, ( str(self.price), str(self.id), )) affectedRows = cur.rowcount print(affectedRows) if affectedRows == 0: self.make_badrequest() else: self.write({ "status": "sucess", "data": { "code": 200, "message": "" } }) except Exception as e: print(e) self.make_internalerror()
def post(self): if self.id == 0 or self.price <= 0 or len( self.postalCode) == 0 or getListingTypeName( self.listingType) == None or getListingStatusName( self.status) == None: self.make_badrequest() else: verified = self.verifyUserId(self.user) if not verified: self.make_notfound() else: try: sqlString = "UPDATE `table_listing` SET `user`=%s,`price`=%s, `listing_type`=%s, `postal_code`=%s, `status`=%s WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, ( str(self.user), str(self.price), getListingTypeName(self.listingType), self.postalCode, getListingStatusName(self.status), str(self.id), )) affectedRows = cur.rowcount if affectedRows == 0: self.make_badrequest() else: self.write({ "status": "sucess", "data": { "code": 200, "message": "" } }) except Exception as e: print(e) self.make_internalerror()
def post(self): if self.id == 0: self.make_badrequest() else: try: sqlString = "UPDATE `table_user` SET `name`=%s,`address`=%s WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, (self.name, self.address, str(self.id),)) self.write({ "status": "sucess", "data": {"code": 200, "message":""} }) except Exception as e: print (e) self.make_internalerror()
def get(self): try: sqlString = "SELECT l.`id`, u.`name`, `price`, `listing_type`, `postal_code`, `status` FROM `table_listing` l JOIN `table_user` u ON (l.`user`=u.`id`)" cur = yield db.connPool().execute(sqlString) result = cur.fetchall() objectList = [] for row in result: objectList.append(row) objects = json.dumps(objectList) self.write({ "status": "sucess", "data": {"code": 200, "message":"", "listings": objects} }) except Exception as e: print(e) self.make_internalerror()
def post(self): if self.id == 0: self.make_badrequest() else: try: sqlString = "DELETE FROM `table_user` WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, (str(self.id),)) affected_rows = cur.rowcount if affected_rows == 0: self.make_reserror_json(400, "user not exist") else: self.write({ "status": "sucess", "data": {"code": 200, "message":""} }) except Exception as e: print(e) self.make_internalerror()
def post(self): # data validation # {"name": "string", "address":"string"} if len(self.name) == 0: self.make_badrequest() else: try: sqlString = "INSERT INTO `table_user` (`name`, `address`) VALUES (%s, %s)" cur = yield db.connPool().execute(sqlString, (self.name, self.address)) user_id = cur.lastrowid self.write({ "status":"success", "data":{"code":200, "user": {"id": user_id, "name": self.name, "address": self.address}} } ) except err.IntegrityError as e: self.make_reserror_json(400, "user exist already!") except: self.make_internalerror() raise
def get(self): try: sqlString = "SELECT l.`id`, u.`name`, `price`, `listing_type`, `postal_code`, `status` FROM `table_listing` l JOIN `table_user` u ON (l.`user`=u.`id`)" cur = yield db.connPool().execute(sqlString) result = cur.fetchall() objectList = [] for row in result: objectList.append(row) objects = json.dumps(objectList) self.write({ "status": "sucess", "data": { "code": 200, "message": "", "listings": objects } }) except Exception as e: print(e) self.make_internalerror()
def post(self): if self.id == 0 or self.price <= 0 or len(self.postalCode) == 0 or getListingTypeName(self.listingType) == None or getListingStatusName(self.status) == None: self.make_badrequest() else: verified = self.verifyUserId(self.user) if not verified: self.make_notfound() else: try: sqlString = "UPDATE `table_listing` SET `user`=%s,`price`=%s, `listing_type`=%s, `postal_code`=%s, `status`=%s WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, (str(self.user), str(self.price), getListingTypeName(self.listingType), self.postalCode, getListingStatusName(self.status), str(self.id),)) affectedRows = cur.rowcount if affectedRows == 0: self.make_badrequest() else: self.write({ "status": "sucess", "data": {"code": 200, "message":""} }) except Exception as e: print (e) self.make_internalerror()
def post(self): # data validation if self.user == 0 or self.price <= 0.0 or len( self.postalCode) == 0 or getListingTypeName( self.listingType) == None or getListingStatusName( self.status) == None: self.make_badrequest() else: verified = yield self.verifyUserId(self.user) if not verified: self.make_notfound() else: try: sqlString = "INSERT INTO `table_listing` (`user`, `price`, `listing_type`, `postal_code`, `status`) VALUES (%s, %s, %s, %s, %s)" cur = yield db.connPool().execute(sqlString, ( str(self.user), str(self.price), getListingTypeName(self.listingType), self.postalCode, getListingStatusName(self.status), )) id = cur.lastrowid self.write({ "status": "success", "data": { "code": 200, "listing": { "id": id, "user": self.user, "price": str(self.price), "listingType": self.listingType, "postalCode": self.postalCode, "status": self.status } } }) except Exception as e: print(e) self.make_internalerror()
def post(self): if self.id == 0 or self.user == 0 or self.price <= 0: self.make_badrequest() else: verified = self.verifyUserId(self.user) if not verified: self.make_notfound() else: try: sqlString = "UPDATE `table_listing` SET `price`=%s WHERE `id`=%s" cur = yield db.connPool().execute(sqlString, (str(self.price), str(self.id),)) affectedRows = cur.rowcount print(affectedRows) if affectedRows == 0: self.make_badrequest() else: self.write({ "status": "sucess", "data": {"code": 200, "message":""} }) except Exception as e: print (e) self.make_internalerror()
def post(self): # data validation if self.user == 0 or self.price <= 0.0 or len(self.postalCode) == 0 or getListingTypeName(self.listingType) == None or getListingStatusName(self.status) == None: self.make_badrequest() else: verified = yield self.verifyUserId(self.user) if not verified: self.make_notfound() else: try: sqlString = "INSERT INTO `table_listing` (`user`, `price`, `listing_type`, `postal_code`, `status`) VALUES (%s, %s, %s, %s, %s)" cur = yield db.connPool().execute(sqlString, ( str(self.user), str(self.price), getListingTypeName(self.listingType), self.postalCode, getListingStatusName(self.status),) ) id = cur.lastrowid self.write({ "status":"success", "data":{"code":200, "listing": {"id": id, "user": self.user, "price": str(self.price), "listingType": self.listingType, "postalCode": self.postalCode, "status": self.status}} } ) except Exception as e: print (e) self.make_internalerror()