def index (self):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Present listing of all users.

return "ADMIN: Present listing of all users."

index.exposed = True

def edit (self, user_id=None):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Edit form for given user.

return "ADMIN: Edit form for given user."

def index (self):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

description = None

results = None

# Try to connect to the database.

try:

dbconnection = pgdb.connect (database_connect_fields)

dbcursor = dbconnection.cursor()

dbcursor.execute ("SELECT * FROM articles")

# Get the cursor description and results from the query.

description = dbcursor.description

results = dbcursor.fetchall()

# Close the database cursor and connection.

dbcursor.close()

dbconnection.close()

except:

pass

pagecontents = "<p><a href=\"/admin/articles/new\">Create New Article</a></p>\n"

pagecontents += "<h3>Article Listing</h3>\n"

pagecontents += "<ul>\n"

if (results == []):

pagecontents += "<li>No articles found in database.</li>\n"

for result in results:

try:

title = result[sqlutils.getfieldindex ("title", description)]

slug = result[sqlutils.getfieldindex ("slug", description)]

article_id = result[sqlutils.getfieldindex ("article_id", description)]

pagecontents += "<li><a href=\"/admin/articles/edit/" + slug + "\">" + title + "</a>\n"

pagecontents += "[<a href=\"/admin/articles/delete/" + article_id + "\">Delete</a>]</li>\n"

except:

pass

pagecontents += "</ul>\n"

# Present listing of all articles.

return pageutils.generate_page ("Articles Administration", pagecontents)

index.exposed = True

def new (self, edit=False, title=None, slug=None, display=None, body=None, article_id=None):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Form to create new article.

pagecontents = ""

if (edit):

pagecontents += "<form action=\"/admin/articles/processedit\" method=\"post\">"

else:

pagecontents += "<form action=\"/admin/articles/processnew\" method=\"post\">"

pagecontents += "<b>Title</b>:"

pagecontents += "<br>"

if (edit):

pagecontents += "<input type=\"text\" name=\"title\" value=\"" + str(title) + "\">"

else:

pagecontents += "<input type=\"text\" name=\"title\">"

pagecontents += "<br><br>\n"

pagecontents += "<b>Slug</b>:"

pagecontents += "<br>"

if (edit):

pagecontents += "<input type=\"text\" name=\"slug\" value=\"" + str(slug) + "\">"

else:

pagecontents += "<input type=\"text\" name=\"slug\">"

pagecontents += "<br><br>"

pagecontents += "<b>Display Mode</b>:"

pagecontents += "<br>"

pagecontents += "<select name=\"display\">\n"

pagecontents += "<option value=\"0\">Do not display</option>\n"

pagecontents += "<option value=\"1\">Display with no comments</option>\n"

pagecontents += "<option value=\"2\" selected=\"selected\">Display with comments (default)</option>\n"

pagecontents += "</select>\n"

pagecontents += "<br><br>"

pagecontents += "<b>Body</b>:"

pagecontents += "<br>"

if (edit):

pagecontents += "<textarea cols=80 rows=10 name=\"body\">" + str(body) +"</textarea>\n"

else:

pagecontents += "<textarea cols=80 rows=10 name=\"body\"></textarea>\n"

pagecontents += "<br><br>"

if (edit):

pagecontents += "<input type=\"hidden\" name=\"article_id\" value=\"" + str(article_id) + "\">"

if (edit):

pagecontents += "<input type=\"submit\" value=\"Submit Changes\">"

else:

pagecontents += "<input type=\"submit\" value=\"Create New Article\">"

pagecontents += "</form>"

if (edit):

return pageutils.generate_page ("Edit Article", pagecontents)

else:

return pageutils.generate_page ("Create New Article", pagecontents)

new.exposed = True

def processedit (self, title=None, slug=None, display=None, body=None, article_id=None):

return self.processnew (title=title, slug=slug, display=display,

body=body, article_id=article_id, edit=True)

processedit.exposed = True

def processnew (self, title=None, slug=None, display=None, body=None, article_id=None,

edit=False):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# If we got to this page through the /admin/articles/new form, all fields

# should be filled in. If they aren't, something unexpected happened, and

# we shouldn't continue processing the form.

if (title == None or slug == None or display == None or body == None):

return pageutils.generate_page ("Invalid Input for New Article",

"Invalid Input for New Article!")

else:

# Remove any leading or trailing spaces.

title = string.strip (title)

slug = string.strip (slug)

body = string.strip (body)

display = string.strip (display)

author_id = pageutils.get_user_id()

try:

# Connect to the database and insert the values.

dbconnection = pgdb.connect (database_connect_fields)

dbcursor = dbconnection.cursor()

if (edit):

if (article_id == None):

return pageutils.generate_page ("No Article Id Specified",

"No Article Id Specified")

dbcursor.execute ("UPDATE articles SET title=%s, slug=%s, body=%s, display=%d WHERE article_id=%d",

[title, slug, body, int(display), int(article_id)])

else:

dbcursor.execute ("INSERT INTO articles (title, author_id, slug, body, display, creation_date) " +

"VALUES (%s, %s, %s, %s, %s, current_timestamp)",

[title, author_id, slug, body, display])

dbconnection.commit()

# Close the database cursor and connection.

dbcursor.close()

dbconnection.close()

except:

return pageutils.generate_page ("Invalid SQL Query", "Invalid SQL Query!")

raise cherrypy.HTTPRedirect ("/admin/articles/")

processnew.exposed = True

def delete (self, article_id=None):

# Verify user is logged-in admin

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

pagetext = "<p><a href=\"/admin/articles/processdelete/" + str(article_id) + "\">Confirm article/comment deletion</a></p>\n"

return pageutils.generate_page ("Confirm Deletion", pagetext)

delete.exposed = True

def processdelete (self, article_id=None):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Verify we have an article_id

if (article_id == None):

return pageutils.generate_page ("No Article Id Specified", "Nothing to delete!")

try:

# Connect to the database and delete the given article.

dbconnection = pgdb.connect (database_connect_fields)

dbcursor = dbconnection.cursor()

dbcursor.execute ("DELETE FROM articles WHERE article_id=%s", [str(article_id)])

dbconnection.commit()

# Close the database cursor and connection.

dbcursor.close()

dbconnection.close()

except:

return pageutils.generate_page ("Database Error", "Deletion failed!")

return pageutils.generate_page ("Successful Deletion", "The specified article/comment has been deleted.")

processdelete.exposed = True

def edit (self, article_slug = None):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Verify we have an article to work with.

if (article_slug == None):

raise cherrypy.HTTPRedirect ("/articles/")

description = None

results = None

# Try to connect to the database.

try:

dbconnection = pgdb.connect (database_connect_fields)

dbcursor = dbconnection.cursor()

dbcursor.execute ("SELECT * FROM articles WHERE slug=%s", [article_slug])

# Get the cursor description and results from the query.

description = dbcursor.description

results = dbcursor.fetchone()

# Close the database cursor and connection.

dbcursor.close()

dbconnection.close()

except:

pass

if (results == None):

return pageutils.generate_page ("Invalid Article Specified", "Invalid Article Specified")

# Obtain the article title from the database results.

title = ""

try:

title = results[sqlutils.getfieldindex ("title", description)]

except:

pass

# Obtain the article body from the database results.

body = ""

try:

body = results[sqlutils.getfieldindex ("body", description)]

except:

pass

# Obtain the article display value.

display = ""

try:

display = str(results[sqlutils.getfieldindex ("display", description)])

except:

pass

# Obtain the article_id.

article_id = ""

try:

article_id = str(results[sqlutils.getfieldindex ("article_id", description)])

except:

pass

slug = article_slug

return self.new (edit=True, title=title, body=body, display=display, slug=slug, article_id=article_id)

def index (self):

# No reason to present listing of discussions, as this is

# available from the main public view.

return "ADMIN: Select admin options from a particular discussion."

index.exposed = True

def delete (self, discussion_id=None):

# Verify user is logged-in admin

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

pagetext = "<p><a href=\"/admin/discussions/processdelete/" + str(discussion_id) + "\">Confirm discussion/reply deletion</a></p>\n"

return pageutils.generate_page ("Confirm Deletion", pagetext)

delete.exposed = True

def processdelete (self, discussion_id=None):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Verify we have an discussion_id

if (discussion_id == None):

return pageutils.generate_page ("No Discussion Id Specified", "Nothing to delete!")

try:

# Connect to the database and delete the given discussion.

dbconnection = pgdb.connect (database_connect_fields)

dbcursor = dbconnection.cursor()

dbcursor.execute ("DELETE FROM discussions WHERE discussion_id=%s",

[str(discussion_id)])

dbconnection.commit()

# Also delete replies, if any.

dbcursor.execute ("DELETE FROM discussions WHERE refers_to=%s",

[str(discussion_id)])

dbconnection.commit()

# Close the database cursor and connection.

dbcursor.close()

dbconnection.close()

except:

return pageutils.generate_page ("Database Error", "Deletion failed!")

return pageutils.generate_page ("Successful Deletion",

"The specified discussion/reply has been deleted.")

def index (self):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# No reason to present listing of events, as this is available

# from the main public view.

return "ADMIN: Select admin options from a particular event."

index.exposed = True

def delete (self, event_id=None):

# Verify user is logged-in admin

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

pagetext = "<p><a href=\"/admin/events/processdelete/" + str(event_id) + "\">Confirm event deletion</a></p>\n"

return pageutils.generate_page ("Confirm Deletion", pagetext)

delete.exposed = True

def processdelete (self, event_id=None):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Verify we have an event_id

if (event_id == None):

return pageutils.generate_page ("No Event Id Specified", "Nothing to delete!")

try:

# Connect to the database and delete the given discussion.

dbconnection = pgdb.connect (database_connect_fields)

dbcursor = dbconnection.cursor()

dbcursor.execute ("DELETE FROM events WHERE event_id=%s",

[str(event_id)])

dbconnection.commit()

# Close the database cursor and connection.

dbcursor.close()

dbconnection.close()

except:

return pageutils.generate_page ("Database Error", "Deletion failed!")

return pageutils.generate_page ("Successful Deletion",

"The specified event has been deleted.")

def __init__(self):

# Set up the nested admin page classes. No reason

# to maintain these from the top-level index.py file.

self.users = AdminUsersPage()

self.articles = AdminArticlesPage()

self.discussions = AdminDiscussionsPage()

self.events = AdminEventsPage()

def index (self):

# Verify user is logged-in admin.

if (not pageutils.is_admin_p()):

raise cherrypy.HTTPRedirect ("/")

# Present menu of administrative activities

return """

<ul>

<li><a href=\"/admin/users/\">Users Admin</a></li>

<li><a href=\"/admin/articles/\">Articles Admin</a></li>

<li><a href=\"/admin/discussions/\">Discussions Admin</a></li>

<li><a href=\"/admin/events/\">Events Admin</a></li>

</ul>"""