SproutCoreTasks-AppEngineBackend/models.py at master · joshholt/SproutCoreTasks-AppEngineBackend · GitHub

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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
""" Purpose: To define model objects used by server.
  Author: Joshua Holt
  Author: Suvajit Gupta
"""

from google.appengine.ext import db

class User(db.Model):
  """ This is the User Model"""
  name = db.StringProperty(required=True, default="_FirstLast")
  loginName = db.StringProperty(required=True, default="_Initials")
  role = db.StringProperty(required=True, default="_Developer")
  #preferences = db.StringProperty() -- NOT Used yet.
  email = db.StringProperty(required=False)
  password = db.StringProperty(required=False)
  authToken = db.StringProperty(required=False)
  createdAt = db.IntegerProperty(required=False)
  updatedAt = db.IntegerProperty(required=False)
  status = db.StringProperty(required=False)


class Project(db.Model):
  """ This is the Project Model"""
  name = db.StringProperty(required=True, default="_NewProject")
  description = db.TextProperty(required=False)
  timeLeft = db.StringProperty(required=False)
  developmentStatus = db.StringProperty(default="_Planned")
  activatedAt = db.IntegerProperty(required=False)
  createdAt = db.IntegerProperty(required=False)
  updatedAt = db.IntegerProperty(required=False)
  status = db.StringProperty(required=False)


class Task(db.Model):
  """ This is the Task Model"""
  name = db.StringProperty(required=True, default="_NewTask")
  description = db.TextProperty(required=False)
  projectId = db.IntegerProperty(required=False)
  priority = db.StringProperty(default="_Medium")
  effort = db.StringProperty(required=False)
  submitterId = db.IntegerProperty() # These keep changing
  assigneeId = db.IntegerProperty()  # These keep changing
  type = db.StringProperty(default="_Other")
  developmentStatus = db.StringProperty(default="_Planned")
  validation = db.StringProperty(default="_Untested")
  createdAt = db.IntegerProperty(required=False)
  updatedAt = db.IntegerProperty(required=False)
  status = db.StringProperty(required=False)


class Watch(db.Model):
  """ This is the Watch Model"""
  taskId = db.IntegerProperty(required=False)
  userId = db.IntegerProperty(required=False)
  createdAt = db.IntegerProperty(required=False)
  updatedAt = db.IntegerProperty(required=False)
  status = db.StringProperty(required=False)


class Comment(db.Model):
  """ This is the Watch Model"""
  description = db.TextProperty(required=False)
  taskId = db.IntegerProperty(required=False)
  userId = db.IntegerProperty(required=False)
  createdAt = db.IntegerProperty(required=False)
  updatedAt = db.IntegerProperty(required=False)
  status = db.StringProperty(required=False)