index.cgi

   1 #!/usr/bin/env python
   2
   3 # Copyright (c) 2008, 2009, Simon Morgan <sjm@spamcop.net>
   4 #
   5 # Permission to use, copy, modify, and/or distribute this software for any
   6 # purpose with or without fee is hereby granted, provided that the above
   7 # copyright notice and this permission notice appear in all copies.
   8 #
   9 # THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
  10 # WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
  11 # MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
  12 # ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
  13 # WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
  14 # ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
  15 # OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
  16
  17 import cgi
  18 #import cgitb; cgitb.enable()
  19 import sqlite3
  20
  21 import common
  22 import config
  23
  24 form = cgi.FieldStorage()
  25
  26 print "Content-type: text/html; charset=UTF-8\n"
  27
  28 print '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">'
  29 print '<html>'
  30
  31 common.print_headers(config.TITLE)
  32
  33 conn = common.connect()
  34
  35 numposts = common.getnumposts(conn)
  36 if numposts == 0:
  37     common.print_msg('Nothing here yet. How about you <a href="post.cgi">post</a> something interesting?')
  38 else:
  39     if form.has_key("id"):
  40         if common.getnumposts(conn, form.getvalue("id")) > 0:
  41             (title, text, date) = conn.execute("SELECT title, text, date FROM entries WHERE id = ?", (form.getvalue("id"),)).fetchone()
  42             common.print_post(title, text, date)
  43         else:
  44             common.print_msg("No such post.")
  45     else:
  46         offset = 0
  47         if form.has_key("offset"):
  48             offset = int(form.getvalue("offset"))
  49         for (postid, title, text, date) in conn.execute("SELECT id, title, text, date FROM entries ORDER BY date DESC LIMIT ? OFFSET ?", (config.NUMPOSTS, offset)):
  50             title = '<a href="index.cgi?id=%s">%s</a>' % (postid, title)
  51             common.print_post(title, text, date)
  52
  53         # Only print the navigation bar if the number of posts exceeds
  54         # the number to be displayed per page.
  55         if numposts > config.NUMPOSTS:
  56             print '<div id="navigation">'
  57             if offset > 0:
  58                 newoffset = offset - config.NUMPOSTS
  59                 if newoffset < 0:
  60                     newoffset = 0
  61                 print '<a href="index.cgi?offset=%s">Prev</a>' % newoffset
  62             if offset + config.NUMPOSTS < numposts:
  63                 newoffset = offset + config.NUMPOSTS
  64                 print '<a href="index.cgi?offset=%s">Next</a>' % newoffset
  65             print '</div>'
  66
  67 print '</html>'
  68
  69 conn.close()