+from floof.lib.file_storage import get_path, save_file
+from floof.lib.dbhelpers import find_or_create, update_or_create
+from floof.model.users import User
+
+
+class Art(Entity):
+ title = Field(Unicode(120))
+ 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
+
+ # TODO: admin log ought to remember who confirmed the relation.
+ # (tag history will remember who proposed it)