+ original_filename = Field(Unicode(120))
+ hash = Field(Unicode(40), unique=True, required=True)
+ mimetype = Field(Unicode(32), required=True)
+
+ uploader = ManyToOne('User', required=True)
+ tags = OneToMany('Tag')
+ discussion = ManyToOne('Discussion')
+
+ art_users = OneToMany('ArtUser')
+
+ @property
+ def file_path(self):
+ return get_path("art", self.hash)
+
+ # Associated users
+ # XXX ok these could stand to do the filtering sql-side
+ @property
+ def artists(self):
+ return (au.user for au in self.art_users if au.type == ArtUserType.BY)
+
+ @property
+ def recipients(self):
+ return (au.user for au in self.art_users if au.type == ArtUserType.FOR)
+
+ @property
+ def participants(self):
+ return (au.user for au in self.art_users if au.type == ArtUserType.OF)
+
+class ArtUserType(object):
+ BY = 1
+ FOR = 2
+ OF = 3
+
+class ArtUser(Entity):
+ art = ManyToOne('Art', required=True)
+ user = ManyToOne('User', required=True)
+ type = Field(Integer, required=True) # ArtUserType