app/django/db/backends/postgresql/version.py
author Lennard de Rijk <ljvderijk@gmail.com>
Sun, 12 Jul 2009 16:01:41 +0200
changeset 2612 216002ba6b86
parent 323 ff1a9aa48cfd
permissions -rw-r--r--
Added view to GradingSurveyGroup to list all records for a specified group. This view will later be extended with options to start Tasks for collecting the data and processing it.

"""
Extracts the version of the PostgreSQL server.
"""

import re

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

def get_version(cursor):
    """
    Returns a tuple representing the major and minor version number of the
    server. For example, (7, 4) or (8, 3).
    """
    cursor.execute("SELECT version()")
    version = cursor.fetchone()[0]
    major, minor = VERSION_RE.search(version).groups()
    return int(major), int(minor)