def test_dao(db): dao=ReaderDao(db) re1 ={} re1['reader_name']= 'dw' re1['sex']='2' re2= {'reader_name':'yin','sex':'1','email':'chi@de','type':'1'} re3 = {'age':'13','type':'0'} #ret = dao.insert_by_dict(re2) #print 'insert reader : %s, ret: %s' % (str(re1),str(ret)) #h = dao.get_by_rname('dw') #print 'get by reader_name, ret: %s'% str(h) #ret = dao.get_by_title('python') #print 'get by title ,ret: %s' % str(ret) ret = dao.del_by_rid(2) #ret=dao.update_by_rid('2',re3) print ret
def initialize(self): self.db = self.application.db self.readerdao = ReaderDao(self.db) self.Resp = Resp()
class ReaderHandler(tornado.web.RequestHandler): def initialize(self): self.db = self.application.db self.readerdao = ReaderDao(self.db) self.Resp = Resp() def post(self): data = self.request.body h = json.loads(data) logging.info("in post method. receive data: %s", str(data)) reader_name = h.get('reader_name', None) reader_name = tools.strip_string(reader_name) if reader_name == None: logging.error("there is no parameter 'reader_name'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_name') self.write(resp) return sex = tools.to_int(h.get('sex', None)) age = tools.to_int(h.get('age', None)) email = tools.strip_string(h.get('email', None)) logging.debug("check parameters complete, ready to save in db") reader = {} reader['reader_name'] = reader_name reader['sex'] = sex reader['age'] = age reader['email'] = email ret = self.readerdao.insert_by_dict(reader) if ret == None: err_str = "error oucurred when insert into table 'reader'" logging.error(err_str) resp = self.Resp.make_response(code=RespCode.DB_ERROR, err_str=err_str) self.write(resp) return logging.info('save reader object successed! the reader: %s', str(reader)) reader['reader_id'] = ret resp = self.Resp.make_response(code=RespCode.SUCCESS, content=reader) self.write(resp) def delete(self): reader_id = self.get_argument('reader_id', None) reader_id = tools.strip_string(reader_id) if reader_id == None: logging.error("there is no parameter 'reader_id'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_id') self.write(resp) return logging.info("in delete method! delete reader by reader_id:'%s'.", str(reader_id)) ret = self.readerdao.del_by_rid(reader_id) if ret == None: err_str = "error oucurred when delete reader by id: %s" % reader_id logging.error(err_str) resp = self.Resp.make_response(code=RespCode.INVALID_PARAMETER, err_str=err_str) self.write(resp) return logging.info("delete reader object successed!") resp = self.Resp.make_response(code=RespCode.SUCCESS, para='delete reader') self.write(resp) def get(self): rid = self.get_argument('reader_id', None) rid = tools.to_int(rid) if rid == None: logging.error("there is no reader_id!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER) self.write(resp) return logging.info("reader detail! readerid:'%s'", str(rid)) ret = self.readerdao.get_by_rid(rid) resp = ret logging.info('query result: %s', str(resp)) 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) def put(self): data = self.request.body h = json.loads(data) logging.info("in update method! receive data: %s", str(data)) reader_id = h.get('reader_id', None) reader_id = tools.strip_string(reader_id) if reader_id == None: logging.error("there is no parameter 'reader_id'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_id') self.write(resp) return if_exist = self.readerdao.if_exist(reader_id) if if_exist == False: logging.error("the book doesn't existed!") resp = self.Resp.make_response(code=RespCode.INVALID_PARAMETER, para='READER_id') self.write(resp) return ret = self.readerdao.update_by_rid(reader_id, h) reader = self.readerdao.get_by_rid(reader_id) logging.info('update reader object successed! the reader: %s', str(reader)) resp = self.Resp.make_response(code=RespCode.SUCCESS, content=reader, pare="update reader") self.write(resp)
def initialize(self): self.db = self.application.db self.bookdao=BookDao(self.db) self.readerdao=ReaderDao(self.db) self.borrowdao=BorrowDao(self.db) self.Resp=Resp()
class ReaderHandler(tornado.web.RequestHandler): def initialize(self): self.db = self.application.db self.bookdao=BookDao(self.db) self.readerdao=ReaderDao(self.db) self.borrowdao=BorrowDao(self.db) self.Resp=Resp() def insert(self): data = self.request.body h = json.loads(data) logging.error("in insert method. receive data:%s", str(data)) reader_name = h.get('reader_name',None) reader_name = tools.strip_string(reader_name) if reader_name == None: logging.error("there is no parameter 'reader_name'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER,para='reader_name') self.write(resp) return sex=tools.to_int(h.get('sex',None)) age=tools.to_int(h.get('age',None)) email=tools.strip_string(h.get('email','')) logging.debug("check parameters complete, ready to save in db") reader={} reader['reader_name']=reader_name reader['sex']=sex reader['age']=age reader['email']=email ret = self.readerdao.insert_by_dict(reader) #########insert fail return None?############### if ret == None: err_str="error oucurred when insert into table 'reader'" logging.error(err_str) resp = self.Resp.make_response(code = RespCode.DB_ERROR,err_str=err_str) self.write(resp) return logging.info('save reader object successed! the reader: %s', str(reader)) reader['reader_id']=ret resp = self.Resp.make_response(code=RespCode.SUCCESS,content=reader) self.write(resp) def delbyrid(self): reader_id=self.get_argument('reader_id',None) reader_id=tools.strip_string(reader_id) if reader_id == None: logging.error("there is no parameter 'reader_id'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_id') self.write(resp) return logging.info("in delete method! delete reader by reader_id:'%s'.",str(reader_id)) ret=self.readerdao.del_by_rid(bid) ''' if ret == None: resp= self.Resp.make_response(code = RespCode. ''' logging.info("delete reader object successed!") resp = self.Resp.make_response(code=RespCode.SUCCESS) self.write(resp) def update(self): data=self.request.body h = json.loads(data) logging.info("in update method! receive data: %s", str(data)) reader_id=h.get('reader_id',None) reader_id=tools.strip_string(reader_id) reader_name=tools.strip_string(h.get('reader_name',None)) if reader_id ==None: logging.error("there is no parameter 'reader_id'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_id') self.write(resp) return if_exist=self.readerdao.if_exist(reader_id) if if_exist == False: logging.error("the book doesn't existed!") resp=self.Resp.make_response(code=RespCode.NO_RECORD, para='book_id') self.write(resp) return ret=self.readerdao.update_by_rid(reader_id,h) # get=self.bookdao.get_by_bid(book_id) # book={} # book['addr']=tools.strip_string(h.get(addr,get['addr'])) # book['author']=tools.strip_string(h.get('author',get['author'])) # book['publisher']=tools.strip_string(h.get('publisher',get['pubulisher'])) # book['description']=tools.strip_string(h.get('description',get['description'])) # book['price']=float(h.get('price',get['price'])) # ret=self.bookdao.update_by_bid(book_id,book) #ret return reader=self.readerdao.get_by_rid(reader_id) logging.info('update reader object successed! the reader: %s', str(reader)) resp = self.Resp.make_response(code=RespCode.SUCCESS,content=reader) self.write(resp) def getbyrid(self): rid=self.get_argument('readerid',None) rid=tools.strip_string(rid) resp=None if rid != None: logging.info("reader detail! readerid:'%s'",str(rid)) ret=self.readerdao.get_by_rid(rid) resp=ret logging.info('query result: %s', str(resp)) else: logging.error("there is no input!") resp=self.Resp.make_response(code=RespCode.NO_PARAMETER,pare= 'input') self.write(resp) return 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)
class UserHandler(tornado.web.RequestHandler): def initialize(self): self.db = self.application.db self.bookdao=BookDao(self.db) self.readerdao=ReaderDao(self.db) self.borrowdao=BorrowDao(self.db) self.Resp=Resp() def search(self): se=self.get_argument('book',None) se=tools.strip_string(se) resp = [] if se != None: logging.info("in search method! get search input:'%s'",str(se)) ret=self.bookdao.get_by_title(se) resp.extend(ret) ret=self.bookdao.get_by_auther(se) resp.extend(ret) ret=self.bookdao.get_by_publisher(se) resp.extend(ret) logging.info('query result: %s', str(resp)) else: logging.error("there is no input!") resp=self.Resp.make_response(code=RespCode.NO_PARAMETER,pare= 'input') self.write(resp) return 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) def getbybid(self): bid=self.get_argument('book_id',None) bid=tools.strip_string(bid) resp=None if bid != None: logging.info("bookdetail! bookid:'%s'",str(bid)) ret=self.bookdao.get_by_bid(bid) resp=ret h=self.borrowdao.if_exist(bid) if h==True: resp['onsheet']='no' else: resp['onsheet']='yes' logging.info('query result: %s', str(resp)) else: logging.error("there is no input!") resp=self.Resp.make_response(code=RespCode.NO_PARAMETER,pare= 'bid') self.write(resp) return 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) def searchbyrid(self): rid = self.get_argument('readerid',None) rid = tools.strip_string(rid) resp=None if readerid != None: logging.info("in searchbyrid method! get reader by readerid:'%s'",str(rid)) ret= self.readerdao.get_by_rid(rid) resp=ret books=self.borrowdao.get_by_readerid(rid) resp["books"]=books logging.info('query result: %s', str(resp)) 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) def renew(self): bookid=self.get_argument('bookid',None) bookid=self.tools.strip_string(bookid) if bookid == None: logging.error("there is no input!") resp=self.Resp.make_response(code=RespCode.NO_PARAMETER,pare='bid') self.write(resp) return logging.info('renew book id:%s',str(bookid)) ret=self.borrowdao.update_renew(bookid) if ret: #####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=update_returndate(re1stamp,bookid) logging.info("renew success! bookid:'%s'",str(bookid)) else: logging.error("Fail! already done before.") resp = self.Resp.make_response(code=RespCode.HAS_EXISTED) self.write(resp) resp = self.Resp.make_response(code=RespCode.SUCCESS) self.write(resp)
def initialize(self): self.db = self.application.db self.bookdao = BookDao(self.db) self.readerdao = ReaderDao(self.db) self.borrowdao = BorrowDao(self.db) self.Resp = Resp()
class ReaderHandler(tornado.web.RequestHandler): def initialize(self): self.db = self.application.db self.bookdao = BookDao(self.db) self.readerdao = ReaderDao(self.db) self.borrowdao = BorrowDao(self.db) self.Resp = Resp() def insert(self): data = self.request.body h = json.loads(data) logging.error("in insert method. receive data:%s", str(data)) reader_name = h.get('reader_name', None) reader_name = tools.strip_string(reader_name) if reader_name == None: logging.error("there is no parameter 'reader_name'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_name') self.write(resp) return sex = tools.to_int(h.get('sex', None)) age = tools.to_int(h.get('age', None)) email = tools.strip_string(h.get('email', '')) logging.debug("check parameters complete, ready to save in db") reader = {} reader['reader_name'] = reader_name reader['sex'] = sex reader['age'] = age reader['email'] = email ret = self.readerdao.insert_by_dict(reader) #########insert fail return None?############### if ret == None: err_str = "error oucurred when insert into table 'reader'" logging.error(err_str) resp = self.Resp.make_response(code=RespCode.DB_ERROR, err_str=err_str) self.write(resp) return logging.info('save reader object successed! the reader: %s', str(reader)) reader['reader_id'] = ret resp = self.Resp.make_response(code=RespCode.SUCCESS, content=reader) self.write(resp) def delbyrid(self): reader_id = self.get_argument('reader_id', None) reader_id = tools.strip_string(reader_id) if reader_id == None: logging.error("there is no parameter 'reader_id'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_id') self.write(resp) return logging.info("in delete method! delete reader by reader_id:'%s'.", str(reader_id)) ret = self.readerdao.del_by_rid(bid) ''' if ret == None: resp= self.Resp.make_response(code = RespCode. ''' logging.info("delete reader object successed!") resp = self.Resp.make_response(code=RespCode.SUCCESS) self.write(resp) def update(self): data = self.request.body h = json.loads(data) logging.info("in update method! receive data: %s", str(data)) reader_id = h.get('reader_id', None) reader_id = tools.strip_string(reader_id) reader_name = tools.strip_string(h.get('reader_name', None)) if reader_id == None: logging.error("there is no parameter 'reader_id'!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, para='reader_id') self.write(resp) return if_exist = self.readerdao.if_exist(reader_id) if if_exist == False: logging.error("the book doesn't existed!") resp = self.Resp.make_response(code=RespCode.NO_RECORD, para='book_id') self.write(resp) return ret = self.readerdao.update_by_rid(reader_id, h) # get=self.bookdao.get_by_bid(book_id) # book={} # book['addr']=tools.strip_string(h.get(addr,get['addr'])) # book['author']=tools.strip_string(h.get('author',get['author'])) # book['publisher']=tools.strip_string(h.get('publisher',get['pubulisher'])) # book['description']=tools.strip_string(h.get('description',get['description'])) # book['price']=float(h.get('price',get['price'])) # ret=self.bookdao.update_by_bid(book_id,book) #ret return reader = self.readerdao.get_by_rid(reader_id) logging.info('update reader object successed! the reader: %s', str(reader)) resp = self.Resp.make_response(code=RespCode.SUCCESS, content=reader) self.write(resp) def getbyrid(self): rid = self.get_argument('readerid', None) rid = tools.strip_string(rid) resp = None if rid != None: logging.info("reader detail! readerid:'%s'", str(rid)) ret = self.readerdao.get_by_rid(rid) resp = ret logging.info('query result: %s', str(resp)) else: logging.error("there is no input!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, pare='input') self.write(resp) return 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)
class UserHandler(tornado.web.RequestHandler): def initialize(self): self.db = self.application.db self.bookdao = BookDao(self.db) self.readerdao = ReaderDao(self.db) self.borrowdao = BorrowDao(self.db) self.Resp = Resp() def search(self): se = self.get_argument('book', None) se = tools.strip_string(se) resp = [] if se != None: logging.info("in search method! get search input:'%s'", str(se)) ret = self.bookdao.get_by_title(se) resp.extend(ret) ret = self.bookdao.get_by_auther(se) resp.extend(ret) ret = self.bookdao.get_by_publisher(se) resp.extend(ret) logging.info('query result: %s', str(resp)) else: logging.error("there is no input!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, pare='input') self.write(resp) return 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) def getbybid(self): bid = self.get_argument('book_id', None) bid = tools.strip_string(bid) resp = None if bid != None: logging.info("bookdetail! bookid:'%s'", str(bid)) ret = self.bookdao.get_by_bid(bid) resp = ret h = self.borrowdao.if_exist(bid) if h == True: resp['onsheet'] = 'no' else: resp['onsheet'] = 'yes' logging.info('query result: %s', str(resp)) else: logging.error("there is no input!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, pare='bid') self.write(resp) return 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) def searchbyrid(self): rid = self.get_argument('readerid', None) rid = tools.strip_string(rid) resp = None if readerid != None: logging.info("in searchbyrid method! get reader by readerid:'%s'", str(rid)) ret = self.readerdao.get_by_rid(rid) resp = ret books = self.borrowdao.get_by_readerid(rid) resp["books"] = books logging.info('query result: %s', str(resp)) 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) def renew(self): bookid = self.get_argument('bookid', None) bookid = self.tools.strip_string(bookid) if bookid == None: logging.error("there is no input!") resp = self.Resp.make_response(code=RespCode.NO_PARAMETER, pare='bid') self.write(resp) return logging.info('renew book id:%s', str(bookid)) ret = self.borrowdao.update_renew(bookid) if ret: #####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 = update_returndate(re1stamp, bookid) logging.info("renew success! bookid:'%s'", str(bookid)) else: logging.error("Fail! already done before.") resp = self.Resp.make_response(code=RespCode.HAS_EXISTED) self.write(resp) resp = self.Resp.make_response(code=RespCode.SUCCESS) self.write(resp)