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 test_ImportListTxt(self):
DB = PixivDBManager(target="test.db.sqlite")
DB.createDatabase()
l = PixivListItem.parseList("test.list.txt", config.rootDirectory)
result = DB.importList(l)
# self.assertEqual(result, 0)
assert result == 0
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 testSelectAllMember(self):
DB = PixivDBManager(target="test.db.sqlite")
DB.createDatabase()
l = PixivListItem.parseList("test.list.txt", config.rootDirectory)
result = DB.selectAllMember()
self.assertEqual(len(result), LIST_SIZE)
for item in result:
print(item.memberId, item.path)
def testSelectAllMember(self):
DB = PixivDBManager(target="test.db.sqlite")
DB.createDatabase()
l = PixivListItem.parseList("test.list.txt", config.rootDirectory)
result = DB.selectAllMember()
self.assertEqual(len(result), LIST_SIZE)
for item in result:
print item.memberId, item.path
def test_SelectMembersByLastDownloadDate(self):
DB = PixivDBManager(target="test.db.sqlite")
DB.createDatabase()
l = PixivListItem.parseList("test.list.txt", config.rootDirectory)
result = DB.selectMembersByLastDownloadDate(7)
# self.assertEqual(len(result), LIST_SIZE)
assert len(result) == LIST_SIZE
for item in result:
print(item.memberId, item.path)
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
def testImportListTxt(self):
DB = PixivDBManager(target="test.db.sqlite")
DB.createDatabase()
l = PixivListItem.parseList("test.list.txt", config.rootDirectory)
result = DB.importList(l)
self.assertEqual(result, 0)
