~launchpad-pqm/launchpad/devel

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
# Copyright 2009 Canonical Ltd.  This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).

# pylint: disable-msg=E0611,W0212

__metaclass__ = type

__all__ = ['SprintAttendance']

from storm.locals import (
    Bool,
    Int,
    Reference,
    Store,
    )
from zope.interface import implements

from canonical.database.datetimecol import UtcDateTimeCol
from lp.blueprints.interfaces.sprintattendance import ISprintAttendance
from lp.registry.interfaces.person import validate_public_person
from lp.services.database.stormbase import StormBase


class SprintAttendance(StormBase):
    """A record of the attendance of a person at a sprint."""

    implements(ISprintAttendance)

    __storm_table__ = 'SprintAttendance'

    id = Int(primary=True)

    sprint_id = Int(name='sprint')
    sprint = Reference(sprint_id, 'Sprint.id')

    attendeeID = Int(name='attendee', validator=validate_public_person)
    attendee = Reference(attendeeID, 'Person.id')

    time_starts = UtcDateTimeCol(notNull=True)
    time_ends = UtcDateTimeCol(notNull=True)
    is_physical = Bool(default=True)

    def __init__(self, sprint, attendee):
        self.sprint = sprint
        self.attendee = attendee