def test_rss_parse(self):
fLOG(
__file__,
self._testMethodName,
OutputPrint=__name__ == "__main__")
path = os.path.abspath(os.path.split(__file__)[0])
file = os.path.join(path, "data", "xdbrss.xml")
assert os.path.exists(file)
rss = StreamRSS(titleb="yy",
type="rss",
xmlUrl="http://blog.yhathq.com/rss.xml",
htmlUrl="http://blog.yhathq.com/",
keywordsb=["python"],
id=5)
res = rss.enumerate_post(fLOG=fLOG)
nb = 0
for _ in res:
nb += 1
assert len(_.title) > 0
assert nb > 0
def test_rss_parse(self):
fLOG(
__file__,
self._testMethodName,
OutputPrint=__name__ == "__main__")
path = os.path.abspath(os.path.split(__file__)[0])
file = os.path.join(path, "data", "xdbrss.xml")
assert os.path.exists(file)
rss = StreamRSS(titleb="XD",
type="rss",
xmlUrl="http://www.xavierdupre.fr/blog/xdbrss.xml",
htmlUrl="http://www.xavierdupre.fr/blog/xd_blog_nojs.html",
keywordsb=["python"],
id=5)
res = rss.enumerate_post(fLOG=fLOG)
nb = 0
for _ in res:
nb += 1
assert len(_.title) > 0
assert nb > 0
res = rss.enumerate_post(file, fLOG=fLOG)
nb = 0
lres = list(res)
nb = 0
for _ in lres:
nb += 1
assert len(_.title) > 0
assert nb > 0
fLOG("nb post=", nb)
dbfile = os.path.join(path, "temp_rssp.db3")
if os.path.exists(dbfile):
os.remove(dbfile)
db = Database(dbfile, LOG=fLOG)
db.connect()
BlogPost.fill_table(db, "posts", lres)
db.close()
db = Database(dbfile, LOG=fLOG)
db.connect()
assert db.has_table("posts")
assert db.get_table_nb_lines("posts") == nb
sql = "SELECT * FROM posts"
cur = db.execute(sql)
val = {}
for row in cur:
val[row[-1]] = 0
assert len(val) == 6
key, value = val.popitem()
assert key is not None
# we insert the blog a second time
BlogPost.fill_table(db, "posts", lres)
sql = "SELECT * FROM posts"
cur = db.execute(sql)
val = {}
for row in cur:
val[row[-1]] = 0
assert len(val) == 6
# we insert the blog a third time
BlogPost.fill_table(db, "posts", lres)
sql = "SELECT * FROM posts"
cur = db.execute(sql)
val = {}
for row in cur:
val[row[-1]] = 0
assert len(val) == 6
db.close()
