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)