def selectMemberByMemberId2(self, member_id): try: c = self.conn.cursor() c.execute('''SELECT member_id, save_folder FROM pixiv_master_member WHERE member_id = ? ''', (member_id, )) row = c.fetchone() if row is not None: return PixivListItem(row[0], row[1]) else: return PixivListItem(int(member_id), '') except BaseException: print 'Error at selectMemberByMemberId():', str(sys.exc_info()) print 'failed' raise finally: c.close()
def selectMembersByLastDownloadDate(self, difference): l = list() try: c = self.conn.cursor() try: int_diff = int(difference) except ValueError: int_diff = 7 c.execute('''SELECT member_id, save_folder, (julianday(Date('now')) - julianday(last_update_date)) as diff FROM pixiv_master_member WHERE is_deleted <> 1 AND ( last_image == -1 OR diff > ? ) ORDER BY member_id''', (int_diff, )) result = c.fetchall() for row in result: item = PixivListItem(row[0], row[1]) l.append(item) except BaseException: print 'Error at selectMembersByLastDownloadDate():', str(sys.exc_info()) print 'failed' raise finally: c.close() return l
def selectAllMember(self, isDeleted=False): l = list() try: c = self.conn.cursor() c.execute('''SELECT member_id, save_folder FROM pixiv_master_member WHERE is_deleted = ? ORDER BY member_id''', (int(isDeleted), )) result = c.fetchall() for row in result: item = PixivListItem(row[0], row[1]) l.append(item) except BaseException: print 'Error at selectAllMember():', str(sys.exc_info()) print 'failed' raise finally: c.close() return l