def renderHist(page_name):
id = request.args.get('id')
result = db.query(
"select pages.pagename, content.content, content.timestamp from pages,content where pages.id = content.pageid and content.id = '%s'"
% id).namedresult()[0]
content = markdown.markdown(wiki_linkify(result.content))
return render_template('one_hist_record.html',
name=result.pagename,
content=content,
timestamp=result.timestamp)
def view_page(page_name):
query = db.query("select * from page where title = '%s'" % page_name)
result_list = query.namedresult()
if len(result_list) > 0:
page = result_list[0]
wiki_linkify_content = wiki_linkify(page.content)
return render_template('view.html',
page=page,
wiki_linkify_content=wiki_linkify_content)
else:
return render_template('placeholder.html', page_name=page_name)
def render_history_page(page_name):
history_id = int(request.form.get('id'))
print history_id
print "BOOOOOOOOOOOM"
history_content = db.query(
"select content from history where id = '%d' order by date_saved desc"
% history_id).namedresult()[0].content
history_content = wiki_linkify(history_content)
history_content = markdown.markdown(history_content)
return render_template('history_page.html',
page_name=page_name,
history_content=history_content)
def show_page(page_id):
"""
Shows the contents of a specific page
"""
page = models.Page(page_id)
page.content = wiki_linkify(page.content)
page.content = Markup(markdown.markdown(page.content))
return render_template("view.html", page_id=page.page_id, \
title=page.title, \
content=page.content,\
last_modified=page.last_modified,\
modified_by=page.modified_by)
def display_page(page_name):
query = db.query("select * from page where page_title = '%s'" % page_name)
result = query.namedresult()
if len(result) < 1:
return render_template('placeholder.html', page_name=page_name)
else:
query2 = db.query("select * from page where page_title = '%s'" %
page_name)
result2 = query2.namedresult()
# page_name = result2[0].page_title
page_content = result2[0].content
print "PAGE CONTENT %r" % page_content
wiki_content = markdown.markdown(wiki_linkify(page_content))
author = result2[0].author
author = markdown.markdown(wiki_linkify(author))
print "string %r" % wiki_content
return render_template('pagename.html',
page_name=page_name,
content=wiki_content,
page_content=page_content,
author=author)
def render_page(page_name):
query = db.query("select * from pages where title = '%s'" % page_name)
if len(query.namedresult()) > 0:
query = query.namedresult()[0]
pages_id = query.id
newest_content = db.query(
"select content from history where pages_id = '%d' order by date_saved desc"
% pages_id).namedresult()[0].content
newest_content = wiki_linkify(newest_content)
newest_content = markdown.markdown(newest_content)
return render_template('existing_page.html',
page_name=page_name,
newest_content=newest_content)
else:
return render_template('placeholder.html', page_name=page_name)
def view_page(page_name):
query = db.query("select * from page where title = $1", page_name)
result_list = query.namedresult()
if len(result_list) > 0:
print result_list
page_content = result_list[0].page_content
page_content = page_content.replace('<', '<').replace('>', '>')
page_content = wiki_linkify(page_content)
parsed_content = Markup(markdown.markdown(page_content))
print page_content
return render_template('view.html',
page_name=page_name,
page_content=parsed_content)
else:
return render_template('placeholder.html', page_name=page_name)
def wiki(page_name):
# id = int(request.form.get('id'))
#since there are multipule content pages you have to select from page_id in descending order to get the newest one
query = db.query(
"select title.id as title_id, page.id as page_id, title.title, page.page_content from page inner join title on page.title_id = title.id where title = $1 order by page_id desc",
page_name)
result_list = query.namedresult()
if len(result_list) > 0:
wiki_page = result_list[0]
wiki_linkify_content = markdown.markdown(
wiki_linkify(wiki_page.page_content))
return render_template('view.html',
title=page_name,
page_name=page_name,
wiki_page=wiki_page,
wiki_linkify_content=wiki_linkify_content)
else:
return render_template('placeholder.html',
title=page_name,
page_name=page_name)
def place_holder(page_name):
# Query database looking for existing information for the page called by the user
query = db.query("select * from page where title = $1",
page_name).namedresult()
all_pages_query = db.query(
"select title from page order by title;").namedresult()
print "\n\nAll pages query: %r\n\n" % all_pages_query
# No information was found in the database for the page
if len(query) == 0:
return render_template("placeholderpage.html",
page_name=page_name,
query=query,
all_pages_query=all_pages_query)
# Information was found in the database for the page
else:
query = query[0]
print query
# Query database looking for historical information for the page called by the user
query_history = db.query(
"select * from page_history where page_id = $1 order by version_number DESC;",
query.id).namedresult()
print query_history
page_content = query.page_content
wiki_linkified_content = wiki_linkify(page_content)
if len(query_history) > 0:
return render_template(
"placeholderpage.html",
page_name=page_name,
query=query,
page_content=Markup(markdown.markdown(wiki_linkified_content)),
query_history=query_history,
all_pages_query=all_pages_query)
else:
return render_template(
"placeholderpage.html",
page_name=page_name,
query=query,
page_content=Markup(markdown.markdown(wiki_linkified_content)),
all_pages_query=all_pages_query)
def display_page(page_name):
query = db.query("select * from page where page_title = $1", page_name)
result = query.namedresult()
if len(result) < 1:
return render_template('placeholder.html', page_name=page_name)
else:
query2 = db.query(
"select page.page_title, content.timestamp, content.content, content.author from page, content where page.id = content.page_id and page.page_title = $1 order by timestamp DESC",
page_name)
result2 = query2.namedresult()
# page_name = result2[0].page_title
page_content = result2[0].content
# print "PAGE CONTENT %r" % page_content
wiki_content = markdown.markdown(wiki_linkify(page_content))
author = result2[0].author
# author = markdown.markdown(wiki_linkify(author))
# print "string %r" % wiki_content
return render_template('pagename.html',
page_name=page_name,
content=wiki_content,
page_content=page_content,
author=author)
def render_placeholder(page_name):
query = db.query(
"select pages.id, pages.pagename, content.content, content.timestamp as ts from pages,content where content.pageid = pages.id and pages.pagename = '%s' order by content.timestamp desc limit 1"
% page_name)
# query = db.query("select pages.id, pages.pagename, content.content, content.timestamp as ts from pages,content where content.pageid = pages.id and pages.pagename = $1 order by content.timestamp desc limit 1", page_name)
results = query.namedresult()
# print "Query: %r" % query
is_available = False
# print "Length: %d" % len(query.namedresult())
if len(results) < 1:
is_available = True
db.insert('pages', {'pagename': page_name})
newid = db.query("select * from pages where pages.pagename = '%s'" %
page_name).namedresult()[0].id
db.insert(
'content', {
'pageid': newid,
'content': "Page Created",
'timestamp': time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime())
})
wiki_page = db.query(
"select pages.id, pages.pagename, content.pageid, content.content, content.timestamp as ts from pages, content where pages.id = content.pageid and pages.pagename = '%s'"
% page_name).namedresult()[0]
else:
wiki_page = results[0]
# if page_name in db.('wiki',)
# db.insert('wiki', pagename=page_name,content="")
timestamp = wiki_page.ts
content = markdown.markdown(wiki_linkify(wiki_page.content))
return render_template('placeholder.html',
page_name=page_name,
is_available=is_available,
wiki_linkify=wiki_linkify,
content=content,
markdown=markdown,
wiki_page=wiki_page,
timestamp=timestamp)
def render_page_name(page_name):
query = db.query(
"select page_content.content, page.id as page_id, page_content.id as content_id from page, page_content where page.id = page_content.page_id and page.page_name = '%s' order by page_content.id desc limit 1"
% page_name)
wiki_page = query.namedresult()
has_content = False
page_is_taken = False
if len(wiki_page) < 1:
content = ""
else:
page_is_taken = True
content = wiki_page[0].content
if len(content) > 0:
has_content = True
else:
pass
content = markdown.markdown(wiki_linkify(content))
return render_template('pageholder.html',
page_is_taken=page_is_taken,
page_name=page_name,
markdown=markdown,
wiki_linkify=wiki_linkify,
has_content=has_content,
content=content)
def camel(word):
return wiki_linkify(word)