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
