def __get_post_review(email_cnt, idx):
'''
Review for posts.
'''
for key in router_post:
recent_posts = MPost.query_recent_edited(tools.timestamp() -
TIME_LIMIT,
kind=key)
for recent_post in recent_posts:
hist_rec = MPostHist.get_last(recent_post.uid)
editor_name = recent_post.extinfo[
'def_editor_name'] if 'def_editor_name' in recent_post.extinfo else recent_post.user_name
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, editor_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], router_post[key],
recent_post.uid))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, editor_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], router_post[key],
recent_post.uid))
email_cnt = email_cnt + foo_str
idx = idx + 1
return email_cnt, idx
def __get_diff_recent():
'''
Generate the difference of posts. recently.
'''
diff_str = ''
for key in router_post:
recent_posts = MPost.query_recent_edited(tools.timestamp() -
TIME_LIMIT,
kind=key)
for recent_post in recent_posts:
hist_rec = MPostHist.get_last(recent_post.uid)
if hist_rec:
raw_title = hist_rec.title
new_title = recent_post.title
infobox = diff_table(raw_title, new_title)
diff_str = diff_str + '''
<h2 style="color:red;font-size:larger;font-weight:70;">TITLE: {0}</h2>
'''.format(recent_post.title) + infobox
infobox = diff_table(hist_rec.cnt_md, recent_post.cnt_md)
diff_str = diff_str + '<h3>CONTENT:{0}</h3>'.format(
recent_post.title) + infobox + '</hr>'
else:
continue
return diff_str
def get_diff_str(*args):
mpost = MPost()
mposthist = MPostHist()
diff_str = ''
for key in router_post.keys():
recent_posts = mpost.query_recent_edited(tools.timestamp() -
time_limit,
kind=key)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
raw_title = hist_rec.title
new_title = recent_post.title
infobox = diff_table(raw_title, new_title)
# infobox = test[start:end] + '</table>'
# if ('diff_add' in infobox) or ('diff_chg' in infobox) or ('diff_sub' in infobox):
diff_str = diff_str + '<h2 style="color:red; font-size:larger; font-weight:70;">TITLE: {0}</h2>'.format(
recent_post.title) + infobox
infobox = diff_table(hist_rec.cnt_md, recent_post.cnt_md)
diff_str = diff_str + '<h3>CONTENT:{0}</h3>'.format(
recent_post.title) + infobox + '</hr>'
else:
continue
return diff_str
def test_query_recent_edited(self):
kwargs = {
'keywords': '',
'user_name': '7788',
'kind': '1',
}
self.add_message(**kwargs)
pp = MPost.query_recent_edited(1539069122)
TF = False
for i in range(pp.count()):
if pp[i].uid == self.uid:
assert pp[i].user_name == '7788'
TF = True
else:
continue
assert TF == True
self.tearDown()
class TestMPost():
def setup(self):
print('setup 方法执行于本类中每条用例之前')
self.uu = MPost()
self.m2c = MPost2Catalog()
self.ml = MLabel()
self.m2l = MPost2Label()
self.labeluid = '9999'
self.raw_count = self.uu.get_counts()
self.post_title = 'ccc'
self.uid = tools.get_uu4d()
self.post_id = '66565'
self.tag_id = '2342'
self.post_id2 = '89898'
self.slug = 'huio'
def test_insert(self):
raw_count = self.uu.get_counts()
post_data = {
'title': self.post_title,
'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
'user_name': 'Tome',
'view_count': 1,
'logo': '/static/',
'keywords': 'sdf',
}
self.uu.create_post(self.uid, post_data)
new_count = self.uu.get_counts()
tt = self.uu.get_by_uid(self.uid)
assert tt.title == post_data['title']
assert tt.cnt_md == tornado.escape.xhtml_unescape(post_data['cnt_md'])
assert tt.cnt_html == tools.markdown2html(post_data['cnt_md'])
assert raw_count + 1 == new_count
self.tearDown()
def test_insert_2(self):
'''Wiki insert: Test invalid title'''
post_data = {
'title': '',
'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
'user_name': 'Tome',
'view_count': 1,
'logo': '/static/',
'keywords': 'sdf',
}
uu = self.uu.create_post(self.uid, post_data)
assert uu == False
post_data = {
'title': '1',
'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
'user_name': 'Tome',
'view_count': 1,
'logo': '/static/',
'keywords': 'sdf',
}
uu = self.uu.create_post(self.uid, post_data)
assert uu == False
post_data = {
'title': '天',
'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
'user_name': 'Tome',
'view_count': 1,
'logo': '/static/',
'keywords': 'sdf',
}
uu = self.uu.create_post(self.uid, post_data)
self.tearDown()
assert uu == False
def add_message(self, **kwargs):
post_data = {
'name': kwargs.get('name', 'category'),
'slug': kwargs.get('slug', self.slug),
'order': kwargs.get('order', '0'),
'kind': kwargs.get('kind1', '1'),
'pid': kwargs.get('pid', '0000'),
}
MCategory.add_or_update(self.tag_id, post_data)
p_d = {
'title': kwargs.get('title', 'iiiii'),
'cnt_md': kwargs.get('cnt_md', 'grgr'),
'time_create': kwargs.get('time_create', '1992'),
'time_update': kwargs.get('time_update', '1996070600'),
'user_name': kwargs.get('user_name', 'yuanyuan'),
'view_count': kwargs.get('view_count', 1),
'logo': kwargs.get('logo', 'prprprprpr'),
'memo': kwargs.get('memo', ''),
'order': kwargs.get('order', '1'),
'keywords': kwargs.get('keywords', ''),
'extinfo': kwargs.get('extinfo', {}),
'kind': kwargs.get('kind2', '1'),
'valid': kwargs.get('valid', 1),
}
post_id = kwargs.get('post_id', self.post_id)
MPost.get_by_uid(post_id)
MPost.create_post(post_id, p_d)
MPost2Catalog.add_record(self.post_id, self.tag_id)
def test_get_by_title(self):
post_data = {
'title': self.post_title,
'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
'user_name': 'Tome',
'view_count': 1,
'logo': '/static/',
'keywords': 'sdf',
}
uid = self.uu.create_post(self.uid, post_data)
ss = self.uu.get_by_uid(uid)
assert ss.title == post_data['title']
self.tearDown()
def test_get_by_title2(self):
'''Test Wiki title with SPACE'''
post_data = {
'title': ' ' + self.post_title + ' ',
'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
'user_name': 'Tome',
'view_count': 1,
'logo': '/static/',
'keywords': 'sdf',
}
uid = self.uu.create_post(self.uid, post_data)
ss = self.uu.get_by_uid(uid)
assert ss.title == self.post_title
self.tearDown()
def test_query_cat_random(self):
self.add_message()
p = {'limit': 300}
TF = False
qq = self.uu.query_cat_random(self.tag_id, **p)
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_recent_most(self):
self.add_message()
qq = self.uu.query_recent_most(num=300)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_recent(self):
self.add_message()
qq = self.uu.query_recent(num=300)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_all(self):
self.add_message()
kwargs = {
'limit': 300,
}
pp = self.uu.query_all(**kwargs)
TF = False
for i in pp:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_keywords_empty(self):
self.add_message()
pp = self.uu.query_keywords_empty()
TF = False
for i in pp:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_dated(self):
self.add_message()
qq = self.uu.query_dated(num=2000)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_most_pic(self):
self.add_message()
qq = self.uu.query_most_pic(300)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_cat_recent(self):
self.add_message()
qq = self.uu.query_cat_recent(self.tag_id, num=300)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_most(self):
self.add_message()
qq = self.uu.query_most(num=300)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_delete(self):
self.add_message()
qq = self.uu.delete(self.post_id)
assert qq
self.tearDown()
def test_update_view_count_by_uid(self):
post_data = {
'title': self.post_title,
'cnt_md': '## adslkfjasdf\n lasdfkjsadf',
'user_name': 'Tome',
'view_count': 1,
'logo': '/static/',
'keywords': 'sdf',
}
self.uu.create_post(self.uid, post_data)
rec = self.uu.get_by_uid(self.uid)
viewcount0 = rec.view_count
assert viewcount0 >= 1
for x in range(100):
self.uu.update_misc(rec.uid, count=True)
viewcount1 = self.uu.get_by_uid(self.uid).view_count
self.tearDown()
assert viewcount1 >= 101
def test_upate(self):
y = {'logo': '123123'}
self.add_message(**y)
qq = {
'title': 'oppssss',
'logo': 'fffff',
'cnt_md': 'iiii',
'user_name': 'yy'
}
self.uu.update(self.post_id, qq)
aa = self.uu.get_by_uid(self.post_id)
assert aa.logo == qq['logo']
assert aa.title == qq['title']
self.tearDown()
def test_get_by_uid(self):
y = {'logo': '123123'}
self.add_message(**y)
a = self.uu.get_by_uid(self.post_id)
assert a.logo == y['logo']
self.tearDown()
def test_get_counts(self):
a = self.uu.get_counts()
self.add_message()
b = self.uu.get_counts()
assert a + 1 >= b
self.tearDown()
def test_update_field(self):
y = {'logo': '123123'}
self.add_message(**y)
self.uu.update_field(self.post_id, self.post_id2)
bb = self.uu.get_by_uid(self.post_id)
aa = self.uu.get_by_uid(self.post_id2)
assert bb == None
assert aa.logo == y['logo']
self.tearDown()
def test_update_cnt(self):
self.add_message()
qq = {'cnt_md': 'iiii', 'user_name': ' yy '}
self.uu.update_cnt(self.post_id, qq)
bb = self.uu.get_by_uid(self.post_id)
assert bb.cnt_md == qq['cnt_md']
self.tearDown()
def test_update_order(self):
self.add_message()
self.uu.update_order(self.post_id, '1')
bb = self.uu.get_by_uid(self.post_id)
assert bb.order == '1'
self.tearDown()
def test_add_or_update(self):
bb = self.uu.get_by_uid(self.post_id)
assert bb == None
p_d = {
'title': 'iiiii',
'cnt_md': 'grgr',
'time_create': '1992',
'time_update': '1996070600',
'user_name': 'yuanyuan',
'view_count': '1',
'logo': 'prprprprpr',
'memo': '',
'order': '1',
'keywords': '',
'extinfo': {},
'kind': '1',
'valid': '1',
}
self.uu.add_or_update(self.post_id, p_d)
bb = self.uu.get_by_uid(self.post_id)
assert bb.title == p_d['title']
qq = {
'title': 'oppssss',
'logo': 'fffff',
'cnt_md': 'iiii',
'user_name': 'yy'
}
self.uu.add_or_update(self.post_id, qq)
aa = self.uu.get_by_uid(self.post_id)
self.tearDown()
assert aa.logo == qq['logo']
assert aa.title == qq['title']
self.tearDown()
def test_query_random(self):
self.add_message()
q = {'num': 300}
qq = self.uu.query_random(**q)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_recent_edited(self):
self.add_message()
qq = self.uu.query_recent_edited(1555)
TF = False
for i in qq:
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_by_tag(self):
TF = False
self.add_message()
qq = self.uu.query_by_tag(self.tag_id)
print(qq.count())
for i in qq:
print(i.title)
if i.uid == self.post_id:
TF = True
self.tearDown()
assert TF
def test_query_cat_recent_with_label(self):
name = 'kkkk'
p_d = {'extinfo': {'def_tag_arr': name}}
self.add_message(**p_d)
self.uu.query_cat_recent_with_label(self.tag_id, label=name, num=300)
qq = self.uu.get_by_uid(self.post_id)
assert qq.extinfo == p_d['extinfo']
self.tearDown()
def test_query_cat_recent_no_label(self):
self.add_message()
qq = self.uu.query_cat_recent_no_label(self.tag_id, num=300)
print(qq.count())
print(qq)
assert qq[0].uid == self.post_id
self.tearDown()
def test_query_total_cat_recent(self):
name = 'kkkk'
p_d = {'extinfo': {'def_tag_arr': name}}
self.add_message(**p_d)
qq = self.uu.query_total_cat_recent([self.tag_id, '9090'],
label=name,
num=300)
assert qq[0].uid == self.post_id
self.tearDown()
def test_query_total_cat_recent_no_label(self):
self.add_message()
qq = self.uu.query_total_cat_recent_no_label([self.tag_id], num=300)
assert qq[0].uid == self.post_id
self.tearDown()
def test_get_next_record(self):
self.add_message()
q = {
'post_id': self.post_id2,
'title': '90909090',
'cnt_md': 'oosdfsfofsf',
'time_create': '1996'
}
self.add_message(**q)
qq = self.uu.get_next_record(self.post_id2)
print(qq)
assert qq.uid == self.post_id
self.tearDown()
def test_get_previous_record(self):
self.add_message()
q = {
'post_id': self.post_id2,
'title': '90909090',
'cnt_md': 'oosdfsfofsf',
'time_create': '1996'
}
self.add_message(**q)
qq = self.uu.get_previous_record(self.post_id)
assert qq.uid == self.post_id2
self.tearDown()
def test_get_all(self):
ose = self.uu.get_all(kind='1')
TF = True
for i in ose:
if self.post_id == i.uid:
TF = False
assert TF
self.add_message()
eee = self.uu.get_all(kind='1')
TF = False
for i in eee:
if self.post_id == i.uid:
TF = True
self.tearDown()
assert TF
def test_update_jsonb(self):
p = {'ii': 'ii00ii'}
self.add_message()
self.uu.update_jsonb(self.post_id, p)
aa = self.uu.get_by_uid(self.post_id)
assert aa.extinfo == p
self.tearDown()
def test_modify_meta(self):
self.add_message()
p_d = {
'title': 'qqqii',
'cnt_md': 'qwqwqw',
'time_create': '1999',
'time_update': '2019',
'user_name': 'max',
'view_count': '1',
'logo': 'opps',
'memo': '',
'order': '1',
'extinfo': {},
'kind': '1',
'valid': '1',
}
self.uu.modify_meta(self.post_id, p_d)
aa = self.uu.get_by_uid(self.post_id)
self.tearDown()
assert aa.title == p_d['title']
def test_modify_init(self):
self.add_message()
p_d = {'keywords': 'io'}
self.uu.modify_init(self.post_id, p_d)
aa = self.uu.get_by_uid(self.post_id)
assert aa.keywords == p_d['keywords']
self.tearDown()
def test_get_view_count(self):
p_d = {'view_count': 3}
self.add_message(**p_d)
qq = self.uu.get_view_count(self.post_id)
assert qq == p_d['view_count']
self.tearDown()
def test_query_most_by_cat(self):
self.add_message()
a = self.uu.query_most_by_cat(catid=self.tag_id, kind='1')
assert a[0].uid == self.post_id
self.tearDown()
def test_query_least_by_cat(self):
self.add_message()
a = self.uu.query_least_by_cat(cat_str=self.tag_id, kind='1')
assert a[0].uid == self.post_id
self.tearDown()
def test_get_by_keyword(self):
p_d = {'title': 'yyyyy'}
self.add_message(**p_d)
aa = self.uu.get_by_keyword(p_d['title'], kind='1')
assert aa[0].uid == self.post_id
self.tearDown()
def test_query_extinfo_by_cat(self):
oo = 'd99s9s'
p_d = {'extinfo': {'def_cat_uid': oo}}
self.add_message(**p_d)
aa = self.uu.query_extinfo_by_cat(oo, kind='1')
assert aa[0].uid == self.post_id
self.tearDown()
def test_query_by_tagname(self):
oo = 'd99s9s'
p_d = {'extinfo': {'def_tag_arr': oo}}
self.add_message(**p_d)
aa = self.uu.query_by_tagname(oo, kind='1')
assert aa[0].uid == self.post_id
self.tearDown()
def test_query_pager_by_tag(self):
oo = 'd99s9s'
p_d = {'extinfo': {'def_tag_arr': oo}}
self.add_message(**p_d)
aa = self.uu.query_pager_by_tag(oo, kind='1')
assert aa[0].uid == self.post_id
self.tearDown()
def test_add_meta(self):
p_d = {
'title': 'qqqii',
'cnt_md': 'qwqwqw',
'time_create': '1999',
'time_update': '2019',
'user_name': 'max',
'view_count': '1',
'logo': 'opps',
'memo': '',
'order': '1',
'kind': '1',
'valid': 1,
}
self.uu.add_meta(self.post_id, p_d)
aa = self.uu.get_by_uid(self.post_id)
self.tearDown()
assert aa.title == p_d['title']
def test_query_under_condition(self):
oo = {'def_tag_arr': 'd99s9s'}
p_d = {'extinfo': oo}
self.add_message(**p_d)
aa = self.uu.query_under_condition(oo, kind='1')
print(aa.count())
assert aa[0].uid == self.post_id
self.tearDown()
def test_addata_init(self):
p_d = {
'sig': self.post_id,
'title': 'qqq4ii',
'cnt_md': 'qwqwqw',
'user_name': 'max',
'view_count': '1',
'logo': 'opps',
'memo': '',
'order': '1',
'cnt_html': 'dddd',
'kind': '2',
'valid': 1,
}
print('fddfsfdsfdsfd')
self.uu.addata_init(p_d)
print('fddfsfdsfdsfd')
aa = self.uu.get_by_uid(self.post_id)
print(aa)
assert aa.title == p_d['title']
self.tearDown()
def test_query_list_pager(self):
oo = {'def_tag_arr': 'd99s9s'}
p_d = {'extinfo': oo}
self.add_message(**p_d)
qq = self.uu.query_list_pager(oo, 1, kind='1')
print(qq[0])
assert qq[0].uid == self.post_id
self.tearDown()
def test_count_of_certain_kind(self):
a = self.uu.count_of_certain_kind(1)
self.add_message()
b = self.uu.count_of_certain_kind(1)
assert a + 1 <= b
self.tearDown()
def test_total_number(self):
a = self.uu.total_number(1)
self.add_message()
b = self.uu.total_number(1)
assert a + 1 <= b
self.tearDown()
def tearDown(self):
print("function teardown")
tt = self.uu.get_by_uid(self.uid)
if tt:
print('翻翻翻翻翻翻翻翻翻翻翻翻翻翻翻翻翻翻3')
self.uu.delete(self.uid)
tt = MCategory.get_by_uid(self.tag_id)
if tt:
MCategory.delete(self.tag_id)
tt = self.uu.get_by_uid(self.post_id)
if tt:
MCategory.delete(self.tag_id)
MPost.delete(self.post_id2)
MPost.delete(self.post_id)
MPost2Catalog.remove_relation(self.post_id, self.tag_id)
print('545456365635653')
tt = MLabel.get_by_slug(self.slug)
if tt:
print('8888888888')
MLabel.delete(tt.uid)
def run_edit_diff():
email_cnt = '''<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
table.diff {font-family:Courier; border:medium;}
.diff_header {background-color:#e0e0e0}
td.diff_header {text-align:right}
.diff_next {background-color:#c0c0c0}
.diff_add {background-color:#aaffaa}
.diff_chg {background-color:#ffff77}
.diff_sub {background-color:#ffaaaa}
</style></head><body>'''
idx = 1
email_cnt = email_cnt + '<table border=1>'
mpost = MPost()
mposthist = MPostHist()
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'post', recent_post.uid + '.html'))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'post', recent_post.uid + '.html'))
email_cnt = email_cnt + foo_str
idx = idx + 1
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60,
kind='2')
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, router_post['2'], recent_post.uid))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, router_post['2'], recent_post.uid))
email_cnt = email_cnt + foo_str
idx = idx + 1
mpost = MWiki()
mposthist = MWikiHist()
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'wiki', recent_post.title))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'wiki', recent_post.title))
email_cnt = email_cnt + foo_str
idx = idx + 1
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60,
kind='2')
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'page', recent_post.uid + '.html'))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'page', recent_post.uid + '.html'))
email_cnt = email_cnt + foo_str
idx = idx + 1
email_cnt = email_cnt + '</table>'
mpost = MPost()
mposthist = MPostHist()
diff_str = ''
######################################################
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
print('=' * 10)
print(recent_post.title)
raw_title = hist_rec.title
new_title = recent_post.title
infobox = diff_table(raw_title, new_title)
# if len(test) > 1:
# start = test.find('<table class="diff"') # 起点记录查询位置
# end = test.find('</table>')
# infobox = test[start:end] + '</table>'
# if ('diff_add' in infobox) or ('diff_chg' in infobox) or ('diff_sub' in infobox):
diff_str = diff_str + '<h2 style="color:red; font-size:larger; font-weight:70;">TITLE: {0}</h2>'.format(
recent_post.title) + infobox
test = diff_table(hist_rec.cnt_md, recent_post.cnt_md)
print(test)
# if len(test) >1 :
# start = test.find('<table class="diff"') # 起点记录查询位置
# end = test.find('</table>')
# infobox = test[start:end] + '</table>'
# if ('diff_add' in infobox) or ('diff_chg' in infobox) or ('diff_sub' in infobox):
diff_str = diff_str + '<h3>CONTENT</h3>'.format(
recent_post.title) + test + '</hr>'
else:
continue
######################################################
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60,
kind='2')
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
print('=' * 10)
print(recent_post.title)
raw_title = hist_rec.title
new_title = recent_post.title
infobox = diff_table(raw_title, new_title)
# infobox = test[start:end] + '</table>'
# if ('diff_add' in infobox) or ('diff_chg' in infobox) or ('diff_sub' in infobox):
diff_str = diff_str + '<h2 style="color:red; font-size:larger; font-weight:70;">TITLE: {0}</h2>'.format(
recent_post.title) + infobox
infobox = diff_table(hist_rec.cnt_md, recent_post.cnt_md)
diff_str = diff_str + '<h3>CONTENT</h3>'.format(
recent_post.title) + infobox + '</hr>'
else:
continue
###########################################################
if len(diff_str) < 20000:
email_cnt = email_cnt + diff_str
email_cnt = email_cnt + '''<table class="diff" summary="Legends">
<tr> <th colspan="2"> Legends </th> </tr>
<tr> <td> <table border="" summary="Colors">
<tr><th> Colors </th> </tr>
<tr><td class="diff_add"> Added </td></tr>
<tr><td class="diff_chg">Changed</td> </tr>
<tr><td class="diff_sub">Deleted</td> </tr>
</table></td>
<td> <table border="" summary="Links">
<tr><th colspan="2"> Links </th> </tr>
<tr><td>(f)irst change</td> </tr>
<tr><td>(n)ext change</td> </tr>
<tr><td>(t)op</td> </tr>
</table></td> </tr>
</table></body>'''
# print (email_cnt)
print('edit diff count:', idx)
if idx > 1:
send_mail(post_emails, "{0}|{1}|{2}".format(smtp_cfg['name'], '文档更新情况',
datestr), email_cnt)
def run_edit_diff(*args):
email_cnt = '''<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
table.diff {font-family:Courier; border:medium;}
.diff_header {background-color:#e0e0e0}
td.diff_header {text-align:right}
.diff_next {background-color:#c0c0c0}
.diff_add {background-color:#aaffaa}
.diff_chg {background-color:#ffff77}
.diff_sub {background-color:#ffaaaa}
</style></head><body>'''
idx = 1
email_cnt = email_cnt + '<table border=1>'
mpost = MPost()
mposthist = MPostHist()
for key in router_post.keys():
recent_posts = mpost.query_recent_edited(tools.timestamp() -
time_limit,
kind=key)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], router_post[key],
recent_post.uid))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], router_post[key],
recent_post.uid))
email_cnt = email_cnt + foo_str
idx = idx + 1
## wiki
mpost = MWiki()
mposthist = MWikiHist()
recent_posts = mpost.query_recent_edited(tools.timestamp() - time_limit)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], 'wiki', recent_post.title))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], 'wiki', recent_post.title))
email_cnt = email_cnt + foo_str
idx = idx + 1
## page.
recent_posts = mpost.query_recent_edited(tools.timestamp() - time_limit,
kind='2')
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], 'page', recent_post.uid))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(SITE_CFG['site_url'], 'page', recent_post.uid))
email_cnt = email_cnt + foo_str
idx = idx + 1
email_cnt = email_cnt + '</table>'
###########################################################
diff_str = get_diff_str()
if len(diff_str) < 20000:
email_cnt = email_cnt + diff_str
email_cnt = email_cnt + '''</body></html>'''
if idx > 1:
send_mail(post_emails, "{0}|{1}|{2}".format(SMTP_CFG['name'], '文档更新情况',
datestr), email_cnt)
def run_edit_diff():
email_cnt = '''<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
table.diff {font-family:Courier; border:medium;}
.diff_header {background-color:#e0e0e0}
td.diff_header {text-align:right}
.diff_next {background-color:#c0c0c0}
.diff_add {background-color:#aaffaa}
.diff_chg {background-color:#ffff77}
.diff_sub {background-color:#ffaaaa}
</style></head><body>'''
idx = 1
email_cnt = email_cnt + '<table border=1>'
mpost = MPost()
mposthist = MPostHist()
for key in router_post.keys():
recent_posts = mpost.query_recent_edited(tools.timestamp() -
time_limit,
kind=key)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, router_post[key], recent_post.uid))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, router_post[key], recent_post.uid))
email_cnt = email_cnt + foo_str
idx = idx + 1
## wiki
mpost = MWiki()
mposthist = MWikiHist()
recent_posts = mpost.query_recent_edited(tools.timestamp() - time_limit)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'wiki', recent_post.title))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(
idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'wiki', recent_post.title))
email_cnt = email_cnt + foo_str
idx = idx + 1
## page.
recent_posts = mpost.query_recent_edited(tools.timestamp() - time_limit,
kind='2')
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_chg">Edit</td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'page', recent_post.uid))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td>{1}</td><td class="diff_add">New </td><td>{2}</td>
<td><a href="{3}">{3}</a></td></tr>
'''.format(idx, recent_post.user_name, recent_post.title,
os.path.join(site_url, 'page', recent_post.uid))
email_cnt = email_cnt + foo_str
idx = idx + 1
email_cnt = email_cnt + '</table>'
mpost = MPost()
mposthist = MPostHist()
diff_str = ''
######################################################
######################################################
for key in router_post.keys():
recent_posts = mpost.query_recent_edited(tools.timestamp() -
time_limit,
kind=key)
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
print('=' * 10)
print(recent_post.title)
raw_title = hist_rec.title
new_title = recent_post.title
infobox = diff_table(raw_title, new_title)
# infobox = test[start:end] + '</table>'
# if ('diff_add' in infobox) or ('diff_chg' in infobox) or ('diff_sub' in infobox):
diff_str = diff_str + '<h2 style="color:red; font-size:larger; font-weight:70;">TITLE: {0}</h2>'.format(
recent_post.title) + infobox
infobox = diff_table(hist_rec.cnt_md, recent_post.cnt_md)
diff_str = diff_str + '<h3>CONTENT</h3>'.format(
recent_post.title) + infobox + '</hr>'
else:
continue
###########################################################
if len(diff_str) < 20000:
email_cnt = email_cnt + diff_str
email_cnt = email_cnt + '''</body></html>'''
# print (email_cnt)
print('edit diff count:', idx)
if idx > 1:
send_mail(post_emails, "{0}|{1}|{2}".format(smtp_cfg['name'], '文档更新情况',
datestr), email_cnt)
def run_edit_diff():
email_cnt = '''<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
table.diff {font-family:Courier; border:medium;}
.diff_header {background-color:#e0e0e0}
td.diff_header {text-align:right}
.diff_next {background-color:#c0c0c0}
.diff_add {background-color:#aaffaa}
.diff_chg {background-color:#ffff77}
.diff_sub {background-color:#ffaaaa}
</style></head><body>'''
mpost = MPost()
mposthist = MPostHist()
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60)
email_cnt = email_cnt + '<table border=1>'
idx = 1
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
foo_str = '''
<tr><td>{0}</td><td class="diff_chg">Edit</td><td>{1}</td>
<td><a href="{2}">{2}</a></td></tr>
'''.format(
idx, recent_post.title,
os.path.join(site_url, 'post', recent_post.uid + '.html'))
email_cnt = email_cnt + foo_str
else:
foo_str = '''
<tr><td>{0}</td><td class="diff_add">New </td><td>{1}</td>
<td><a href="{2}">{2}</a></td></tr>
'''.format(
idx, recent_post.title,
os.path.join(site_url, 'post', recent_post.uid + '.html'))
email_cnt = email_cnt + foo_str
idx = idx + 1
email_cnt = email_cnt + '</table>'
recent_posts = mpost.query_recent_edited(tools.timestamp() - 24 * 60 * 60)
diff_str = ''
for recent_post in recent_posts:
hist_rec = mposthist.get_last(recent_post.uid)
if hist_rec:
print('=' * 10)
print(recent_post.title)
raw_title = hist_rec.title
new_title = recent_post.title
test = HtmlDiff.make_file(HtmlDiff(), [raw_title], [new_title])
# if len(test) > 1:
start = test.find('<table class="diff"') # 起点记录查询位置
end = test.find('</table>')
infobox = test[start:end] + '</table>'
if ('diff_add' in infobox) or ('diff_chg'
in infobox) or ('diff_sub'
in infobox):
diff_str = diff_str + '<h2 style="color:red; font-size:larger; font-weight:70;">TITLE: {0}</h2> TITLE'.format(
recent_post.title) + infobox
raw_md = hist_rec.cnt_md.split('\n')
new_md = recent_post.cnt_md.split('\n')
test = HtmlDiff.make_file(HtmlDiff(), raw_md, new_md)
# if len(test) >1 :
start = test.find('<table class="diff"') # 起点记录查询位置
end = test.find('</table>')
infobox = test[start:end] + '</table>'
if ('diff_add' in infobox) or ('diff_chg'
in infobox) or ('diff_sub'
in infobox):
diff_str = diff_str + '<h2 style="color:red; font-size:larger; font-weight:70;">TITLE: {0}</h2> CONTENT'.format(
recent_post.title) + infobox + '</hr>'
else:
continue
if len(diff_str) < 8000:
email_cnt = email_cnt + diff_str
email_cnt = email_cnt + '''<table class="diff" summary="Legends">
<tr> <th colspan="2"> Legends </th> </tr>
<tr> <td> <table border="" summary="Colors">
<tr><th> Colors </th> </tr>
<tr><td class="diff_add"> Added </td></tr>
<tr><td class="diff_chg">Changed</td> </tr>
<tr><td class="diff_sub">Deleted</td> </tr>
</table></td>
<td> <table border="" summary="Links">
<tr><th colspan="2"> Links </th> </tr>
<tr><td>(f)irst change</td> </tr>
<tr><td>(n)ext change</td> </tr>
<tr><td>(t)op</td> </tr>
</table></td> </tr>
</table></body>'''
print(email_cnt)
send_mail(post_emails, "{0}|{1}|{2}".format(smtp_cfg['name'], '文档更新情况',
datestr), email_cnt)
def test_query_recent_edited(self):
MPost.query_recent_edited(1539069122)
assert True
