def run():
user_agents = ldUserAgents("./UserAgentString.json")
bookinfos = loadMatrixFromFile("./kaijuannodump.csv")
# bookinfos = loadMatrixFromFile(sys.argv[1])
# newbookinfos = []
sellers = ["亚马逊", "京东", "当当", "北发", "淘书", "博库", "文轩", "中国图书", "China-pub"]
for index in range(1, len(bookinfos)):
if isAready(bookinfos[index][0]):
print "INFO: Already processed"
continue
print "INFO: processing", bookinfos[index][0],
b = BookAPI(bookinfos[index][0], choice(user_agents))
JsonData = json.loads(b.api())
if JsonData["error"]:
appendstr2file(JsonData["isbn"], "error.log")
print "ERROR: got an network error "
sleep(1)
continue
tmpLst = bookinfos[index]
if JsonData["total"] == 0:
for seller in sellers:
tmpLst.append("None")
print "WARNING: no data"
sleep(1)
continue
for seller in sellers:
tmpLst.append("None")
for key in JsonData["data"]:
if seller.decode("UTF-8") in key:
del tmpLst[-1]
tmpLst.append(JsonData["data"][key])
break
# newbookinfos.append(tmpLst)
appendlst2file(lstUtf8(tmpLst), "newkaijuan.csv")
appendstr2file(bookinfos[index][0], "visited.csv")
print "Done"
sleep(1)
def BorrowBook(self, uid, bid):
# 获取系统时间当作借阅时间并计算出应该归还的时间
borrow_time = datetime.datetime.now().strftime('%Y-%m-%d')
return_time = (datetime.datetime.now() +
datetime.timedelta(days=90)).strftime('%Y-%m-%d')
book = BookAPI()
bo = Book()
bo.set_bookid(bid)
record = book.GetBookByField(bo)
record = record[0]
print(record.get_status())
if (record.get_status() == '正常'):
print("You can borrow this book!")
if (input("Do you want to borrow this book?(press YES to borrow)")
== 'YES'):
print("Successful borrowing!")
addborr = BorrowAPI()
obj = Borrow()
# 获取borrowid的最大值
borrowid = int(addborr.GetMaxBorrowid()) + 1
print(borrowid)
obj.set_borrowid(borrowid)
obj.set_userid(uid)
obj.set_bookid(bid)
obj.set_borrowdate(borrow_time)
obj.set_presretdate('0000-00-00')
obj.set_actretdate(return_time)
addborr.InsertBorrowRecord(obj)
book2 = BookAPI()
# 修改图书状态
book2.UpdateRecord('book', 'status', '在借', 'bookid', bid)
else:
print("You don't want to borrow this book......OK")
else:
print("Abnormal book state,you can't borrow this book!")
def book_api(isbn):
user_agents = ldUserAgents('./UserAgentString.json')
b = BookAPI(isbn, choice(user_agents))
return jsonify(b.api())
def __init__(self):
self.bookapi = BookAPI()
class BookClient(object):
def __init__(self):
self.bookapi = BookAPI()
def GetAllBookRecord(self):
funcname = sys._getframe().f_back.f_code.co_name
args = [5]
DisplayResultSet(funcname, self.bookapi.GetAllBookRecord(args[0]),
args)
def GetBookByDis(self):
funcname = sys._getframe().f_back.f_code.co_name
args = [u'数学', u'矿业技术']
for item in args:
DisplayResultSet(funcname, self.bookapi.GetBookByDis(item), item,
2)
def GetBookByMaj(self):
funcname = sys._getframe().f_back.f_code.co_name
args = [u'工业技术', u'数理科学与化学']
for item in args:
DisplayResultSet(funcname, self.bookapi.GetBookByMaj(item), item,
2)
def GetBookByName(self):
funcname = sys._getframe().f_back.f_code.co_name
args = [u'Java', u'Python', u'C++']
for item in args:
DisplayResultSet(funcname, self.bookapi.GetBookByName(item), item,
2)
def GetBookByField(self):
funcname = sys._getframe().f_back.f_code.co_name
book1 = Book()
funcname = sys._getframe().f_back.f_code.co_name
book1.set_author(u'韩国')
book2 = Book()
book2.set_version(u'第一版')
book2.set_booklanguage(u'英文')
book3 = Book()
book3.set_publisher(u'清华大学出版社')
book3.set_stack(u'一层')
book3.set_floor(3)
args = [book1, book2, book3]
for item in args:
DisplayResultSet(funcname, self.bookapi.GetBookByField(item), item,
2)
def InsertBookRecord(self):
funcname = sys._getframe().f_back.f_code.co_name
test = Book()
test.set_bookid('300001')
test.set_bookname('1')
test.set_author('1')
test.set_pages('1')
test.set_collecttime('2010-09-17')
test.set_version('1')
test.set_major('1')
test.set_discipline('1')
test.set_isbn('133-314-2343-16-2')
test.set_booklanguage('1')
test.set_publisher('1')
test.set_status('1')
test.set_abstract('1')
test.set_stack('1')
test.set_shelf('1')
test.set_floor('2')
test.set_bookvalue('1')
args = [test]
DisplayResultSet(
funcname,
self.bookapi.InsertBookRecord(args[0]),
args[0],
)
def UpdateRecord(self):
funcname = sys._getframe().f_back.f_code.co_name
args = ['book', 'bookid', '300000', 'bookid', '300001']
DisplayResultSet(
funcname,
self.bookapi.UpdateRecord(args[0], args[1], args[2], args[3],
args[4]), args)
def DeleteRecord(self):
funcname = sys._getframe().f_back.f_code.co_name
args = ['book', 'bookid', '300000']
DisplayResultSet(funcname,
self.bookapi.DeleteRecord(args[0], args[1], args[2]),
args)
def TestBookClient(self):
self.GetAllBookRecord()
self.GetBookByDis()
self.GetBookByMaj()
self.GetBookByName()
self.GetBookByField()
self.InsertBookRecord()
self.UpdateRecord()
self.DeleteRecord()
