def test1(self):
self.assertTrue(xxutils.wikicc("") == 0)
self.assertTrue(xxutils.wikicc(" ") == 0)
self.assertTrue(xxutils.wikicc("\t") == 0)
self.assertTrue(xxutils.wikicc("abc") == 0)
self.assertTrue(xxutils.wikicc("a b c") == 0)
self.assertTrue(xxutils.wikicc("abc\ndef") == 0)
self.assertTrue(xxutils.wikicc("{{{abc") == 0)
self.assertTrue(xxutils.wikicc("abc{{{def") == 0)
self.assertTrue(xxutils.wikicc("abc}}}def") == 0)
self.assertTrue(xxutils.wikicc("abc}}}") == 0)
def GetWikiStatByMonth(conn, year, month) :
t = (year, month, )
month_wiki = conn.cursor()
month_wiki.execute("""select name,version,author,length(text),text, strftime('%Y', time/1000000, 'unixepoch', 'localtime') as y ,strftime('%m', time/1000000, 'unixepoch', 'localtime') as m
from wiki
where strftime('%Y', time/1000000, 'unixepoch', 'localtime') = ? and strftime('%m', time/1000000, 'unixepoch', 'localtime')=?""", t)
wiki = {}
for name, version, author, text_len, text, year, month in month_wiki :
row = {}
row["name"] = name
row["version"] = version
row["author"] = author
row["text"] = text
if not xxutils.IsWikiSourcePage(name):
continue
if version == 1 :
row["change"] = xxutils.wikicc(text)
else :
#需要找到前一个版本比较
lastversion = version - 1
t = (name, lastversion)
lastmodify_wiki = conn.cursor()
lastmodify_wiki.execute("""select name,version,author,length(text),text from wiki where name =? and version=?
""", t)
r = lastmodify_wiki.fetchone()
if len(r) > 0 :
lasttext = r[4] # r['text']
else :
lasttext = ""
row["change"] = xxutils.wikicc(lasttext, text)
lastmodify_wiki.close()
wiki = WikiAddItem(wiki, row);
month_wiki.close()
return wiki
def test5(self):
text1 = """abc
def
ghi"""
text2 = """def
ghi
jkl"""
self.assertTrue(xxutils.wikicc(text1, text2) == 0)
def test2(self):
text = """{{{
abc
def
ghi
}}}"""
c = xxutils.wikicc(text)
#print c
self.assertTrue(c == 9)
def test7(self):
text1 = """abc
def
ghi"""
text2 = """{{{
def
ghi
jkl
}}}"""
self.assertTrue(xxutils.wikicc(text1, text2) == 9)
def test6(self):
text1 = """{{{
abc
def
ghi
}}}"""
text2 = """def
ghi
jkl"""
self.assertTrue(xxutils.wikicc(text1, text2) == 0)
def test2(self):
self.assertTrue(xxutils.wikicc("{{{abc}}}", "") == 0)
self.assertTrue(xxutils.wikicc("{{{abc}}}", "abc") == 0)
self.assertTrue(xxutils.wikicc("{{{abc}}}", "def") == 0)
self.assertTrue(xxutils.wikicc("abc", "def") == 0)
self.assertTrue(xxutils.wikicc("abc", "abc") == 0)
self.assertTrue(xxutils.wikicc("abc", "") == 0)
def test3(self):
text1 = """{{{
aaa
bbb
ccc
ddd
eee
}}}"""
text2 = """{{{
aa
ccc
dddd
}}}"""
c = xxutils.wikicc(text1, text2)
#print c
self.assertTrue(c == 6)
def test4(self):
self.assertTrue(xxutils.wikicc("{{{ a b c }}}") == 3)
def test1(self):
self.assertTrue(xxutils.wikicc("{{{abc}}}", "{{{ a b c }}}") == 0)
self.assertTrue(xxutils.wikicc("{{{abc}}}", "{{{\ta\tb\tc\t}}}") == 0)
