def get_timeline_events(self, req, start, stop, filters):
# timeline动作的输入
if 'wiki' in filters:
wiki = WikiSystem(self.env)
format = req.args.get('format')
href = format == 'rss' and req.abs_href or req.href
db = self.env.get_db_cnx()
cursor = db.cursor()
cursor.execute("SELECT time,name,comment,author,version "
"FROM wiki WHERE time>=%s AND time<=%s",
(start, stop))
for t,name,comment,author,version in cursor:
title = Markup('<em>%s</em> '+ u"编辑者 %s",
wiki.format_page_name(name), author)
diff_link = html.A(u'变化', href=href.wiki(name, action='diff',
version=version))
if format == 'rss':
comment = wiki_to_html(comment or '--', self.env, req, db,
absurls=True)
else:
comment = wiki_to_oneliner(comment, self.env, db,
shorten=True)
if version > 1:
comment = Markup('%s (%s)', comment, diff_link)
yield 'wiki', href.wiki(name), title, t, author, comment
# Attachments
att = AttachmentModule(self.env)
for event in att.get_timeline_events(req, db, 'wiki', format,
start, stop,
lambda id: html.EM(id)):
yield event
def render_macro(self, req, name, content):
prefix = content or None
wiki = WikiSystem(self.env)
return html.UL([html.LI(html.A(wiki.format_page_name(page),
href=req.href.wiki(page)))
for page in sorted(wiki.get_pages(prefix))])
def render_macro(self, req, name, content):
prefix = content or None
wiki = WikiSystem(self.env)
return html.UL([html.LI(html.A(wiki.format_page_name(page),
href=req.href.wiki(page)))
for page in sorted(wiki.get_pages(prefix))])
def render_macro(self, req, name, content):
prefix = limit = None
if content:
argv = [arg.strip() for arg in content.split(",")]
if len(argv) > 0:
prefix = argv[0]
if len(argv) > 1:
limit = int(argv[1])
db = self.env.get_db_cnx()
cursor = db.cursor()
sql = "SELECT name, " " max(version) AS max_version, " " max(time) AS max_time " "FROM wiki"
args = []
if prefix:
sql += " WHERE name LIKE %s"
args.append(prefix + "%")
sql += " GROUP BY name ORDER BY max_time DESC"
if limit:
sql += " LIMIT %s"
args.append(limit)
cursor.execute(sql, args)
entries_per_date = []
prevdate = None
for name, version, time in cursor:
date = format_date(time)
if date != prevdate:
prevdate = date
entries_per_date.append((date, []))
entries_per_date[-1][1].append((name, int(version)))
wiki = WikiSystem(self.env)
return html.DIV(
[
html.H3(date)
+ html.UL(
[
html.LI(
html.A(wiki.format_page_name(name), href=req.href.wiki(name)),
" ",
version > 1
and html.SMALL(
"(", html.A("diff", href=req.href.wiki(name, action="diff", version=version)), ")"
)
or None,
)
for name, version in entries
]
)
for date, entries in entries_per_date
]
)
def render_macro(self, req, name, content):
prefix = limit = None
if content:
argv = [arg.strip() for arg in content.split(',')]
if len(argv) > 0:
prefix = argv[0]
if len(argv) > 1:
limit = int(argv[1])
db = self.env.get_db_cnx()
cursor = db.cursor()
sql = 'SELECT name, ' \
' max(version) AS max_version, ' \
' max(time) AS max_time ' \
'FROM wiki'
args = []
if prefix:
sql += ' WHERE name LIKE %s'
args.append(prefix + '%')
sql += ' GROUP BY name ORDER BY max_time DESC'
if limit:
sql += ' LIMIT %s'
args.append(limit)
cursor.execute(sql, args)
entries_per_date = []
prevdate = None
for name, version, time in cursor:
date = format_date(time)
if date != prevdate:
prevdate = date
entries_per_date.append((date, []))
entries_per_date[-1][1].append((name, int(version)))
wiki = WikiSystem(self.env)
return html.DIV(
[html.H3(date) +
html.UL([html.LI(
html.A(wiki.format_page_name(name), href=req.href.wiki(name)),
' ',
version > 1 and
html.SMALL('(', html.A('diff',
href=req.href.wiki(name, action='diff',
version=version)), ')') \
or None)
for name, version in entries])
for date, entries in entries_per_date])
def get_timeline_events(self, req, start, stop, filters):
# timeline动作的输入
if 'wiki' in filters:
wiki = WikiSystem(self.env)
format = req.args.get('format')
href = format == 'rss' and req.abs_href or req.href
db = self.env.get_db_cnx()
cursor = db.cursor()
cursor.execute(
"SELECT time,name,comment,author,version "
"FROM wiki WHERE time>=%s AND time<=%s", (start, stop))
for t, name, comment, author, version in cursor:
title = Markup('<em>%s</em> ' + u"编辑者 %s",
wiki.format_page_name(name), author)
diff_link = html.A(u'变化',
href=href.wiki(name,
action='diff',
version=version))
if format == 'rss':
comment = wiki_to_html(comment or '--',
self.env,
req,
db,
absurls=True)
else:
comment = wiki_to_oneliner(comment,
self.env,
db,
shorten=True)
if version > 1:
comment = Markup('%s (%s)', comment, diff_link)
yield 'wiki', href.wiki(name), title, t, author, comment
# Attachments
att = AttachmentModule(self.env)
for event in att.get_timeline_events(req, db, 'wiki', format,
start, stop,
lambda id: html.EM(id)):
yield event
