source: peerreviewplugin/tags/0.12/3.1/codereview/CodeReviewStruct.py

# -*- coding: utf-8 -*-
#
# Copyright (C) 2005-2006 Team5 
# All rights reserved.
#
# This software is licensed as described in the file COPYING, which
# you should have received as part of this distribution.
#


class CodeReviewStruct(object):
    "Stores a Code Review Entry"

    #Individual CodeReview ID Number
    IDReview = ""

    #Author's username
    Author = ""

    #Status of a code review
    Status = ""

    #Date created (using Trac's internal representation)
    DateCreate = 0

    date_closed = 0

    #Name of the CodeReview
    Name = ""

    #Author's notes
    Notes = ""

    def __init__(self, row):
        if row is not None:
            #initialize variables
            self.IDReview = row[0]
            self.Author = row[1]
            self.Status = row[2]
            self.DateCreate = row[3]
            self.Name = row[4]
            self.Notes = row[5]
            self.date_closed = row[6]

    def save(self, db):
        if self.IDReview == "":
            #Add information to a new database entry
            cursor = db.cursor()
            cursor.execute("""
                INSERT INTO peer_review (owner, status, created, name, notes)
                VALUES (%s, %s, %s, %s, %s)
                """, (self.Author, self.Status, self.DateCreate,
                      self.Name, self.Notes))
            self.IDReview = db.get_last_id(cursor, 'peer_review', 'review_id')
            db.commit()
        else:
            #Update information in existing database entry
            cursor = db.cursor()
            cursor.execute("""
                UPDATE peer_review SET owner=%s, status=%s, created=%s,
                  name=%s, notes=%s WHERE review_id=%s
                """, (self.Author, self.Status, self.DateCreate, self.Name,
                      self.Notes, self.IDReview))
            db.commit()
        return self.IDReview