class BorrowHandler(tornado.web.RequestHandler):
def initialize(self):
self.db = self.application.db
self.borrowdao = BorrowDao(self.db)
self.Resp = Resp()
def get(self):
bookid = self.get_argument('bookid', None)
readerid = self.get_argument('readerid', None)
bid = tools.strip_string(bookid)
rid = tools.strip_string(readerid)
resp = None
if bid == None and rid == None:
logging.error("there is no parament bookid or readerid!")
resp = self.Resp.make_response(code=RespCode.NO_PARAMETER,
para='id')
self.write(resp)
return
if bid != None:
logging.info("borrow detail! bookid:'%s'", str(bid))
resp = self.borrowdao.get_by_bookid(bid)
logging.info('query result: %s', str(resp))
elif rid != None:
logging.info("borrow detail! readerid:'%s'", str(rid))
resp = self.borrowdao.get_by_readerid(rid)
logging.info('query result: %s', str(resp))
else:
return
# bo = tools.to_int(borrow['borrowdate'])
# re = tools.to_int(borrow['returndate'])
# bo=datetime.datetime.utcfromstamp(bo)
# re= datetime.datetime.utcfromstamp(re)
# borrow['borrowdate'] = str(bo)
# borrow['returndate'] = str(re)
if resp == None or len(resp) == 0:
logging.error('there is no record!')
resp = self.Resp.make_response(code=RespCode.NO_RECORD)
self.write(resp)
resp = self.Resp.make_response(code=RespCode.SUCCESS, content=resp)
self.write(resp)
# _method = self.get_argument('_method', None)
# if method == 'lost':
# self.lost()
#
# def clear(self):
# pass
#
def post(self):
data = self.request.body
h = json.loads(data)
logging.info("in post method. receive data:%s", str(data))
bookid = h.get('bookid', None)
bookid = tools.strip_string(bookid)
readerid = h.get('readerid', None)
readerid = tools.strip_string(readerid)
resp = None
if bookid == None or readerid == None:
logging.error("there is no parament bookid or readerid!")
resp = self.Resp.make_response(code=RespCode.NO_PARAMETER,
para='id')
self.write(resp)
return
borrow = {}
borrow['bookid'] = bookid
borrow['readerid'] = readerid
nowstamp = int(time.time())
datearray = datetime.datetime.utcfromtimestamp(nowstamp)
re = datearray + datetime.timedelta(days=31)
restamp = int(time.mktime(re.timetuple()))
borrow['borrowdate'] = nowstamp
borrow['returndate'] = restamp
ret = self.borrowdao.insert_by_dict(borrow)
if ret == None:
logging.error("error oucurred when insert into table 'borrow'")
resp = self.Resp.make_response(code=RespCode.DB_ERROR)
self.write(resp)
return
logging.info("borrow successed! The book: %s", str(bookid))
borrow['brw_id'] = ret
resp = self.Resp.make_response(code=RespCode.SUCCESS,
content=borrow,
para="borrow")
self.write(resp)
def delete(self):
bookid = self.get_argument('bookid', None)
bookid = tools.strip_string(bookid)
resp = None
if bookid == None:
logging.error("there is no parament bookid!")
resp = self.Resp.make_response(code=RespCode.NO_PARAMETER,
para='id')
self.write(resp)
return
now = datetime.datetime.now()
borrow = self.borrowdao.get_by_bookid(bookid)
# re=datetime.datetime.utcfromtimestamp(borrow['returndate'])
# delta=re-now
# days=getattr(delta,'days')
# if days < 0:
# logging.error("this book is delay for %s days",str(abs(days)))
# resp = self.Resp.make_response(code=Resp.DELAY,para=days)
# self.write(resp)
logging.info("delete borrow book %s", str(bookid))
ret = self.borrowdao.del_by_bookid(bookid)
logging.info("delete successed!")
resp = self.Resp.make_response(code=RespCode.SUCCESS, para="return")
self.write(resp)
def put(self):
data = self.request.body
h = json.loads(data)
bookid = h.get('bookid', None)
if bookid == None:
logging.error("there is no input!")
resp = self.Resp.make_response(code=RespCode.NO_PARAMETER,
pare='bookid')
self.write(resp)
return
#sql = "SELECT renew FROM borrow WHERE bookid='%s'"%str(bookid)
# ret=self.db.get(sql)
# if ret['renew'] == 0:
# logging.info('renew book id:%s',str(bookid))
# ret = self.borrowdao.update_renew(bookid)
#####add a month###
re = self.borrowdao.get_by_bookid(bookid)
restamp = re['returndate']
datearray = datetime.datetime.utcfromtimestamp(restamp)
re1 = datearray + datetime.timedelta(days=31)
re1stamp = int(time.mktime(re1.timetuple()))
ret = self.borrowdao.update_returndate(re1stamp, bookid)
logging.info("renew success! bookid:'%s'", str(bookid))
resp = self.Resp.make_response(code=RespCode.SUCCESS, para="renew")
self.write(resp)
