Add is_featured boolean property to the Work model, so that Works can be designated as "featured" items in various places in the UI. This will be used to allow Sponsors, Programs, and Organizations to select Documents that should be included in their sidebar menus. Perhaps featured "site" Documents, such as site-wide Terms of Service, should probably be listed below the "User (sign-out)" menu, since the User will have to read and agree to these before being allowed to use the site. A collapsable Javascript sidebar is probably going to be needed soon... Patch by: Todd Larsen Review by: to-be-reviewed

     1

"""

     2

Extracts the version of the PostgreSQL server.

     3

"""

     4

     5

import re

     6

     7

VERSION_RE = re.compile(r'PostgreSQL (\d+)\.(\d+)\.')

     8

     9

def get_version(cursor):

    10

    """

    11

    Returns a tuple representing the major and minor version number of the

    12

    server. For example, (7, 4) or (8, 3).

    13

    """

    14

    cursor.execute("SELECT version()")

    15

    version = cursor.fetchone()[0]

    16

    major, minor = VERSION_RE.search(version).groups()

    17

    return int(major), int(minor)

    18