def query_to_get_book_goods_info_by_isbn(self, isbn):
sql = 'select isbn, link, platform, instant_price, max(crawling_time) ' \
'from book_goods_info ' \
'where isbn="%s" ' \
'group by platform' %(isbn)
self.cursor.execute(sql)
result_list = self.cursor.fetchall()
goods_list = []
for result in result_list:
goodspo = GoodsPO()
goodspo.set_all(result)
goods_list.append(goodspo)
return goods_list
