-from sqlalchemy import Column, ForeignKey
-from sqlalchemy.orm import relation
-from sqlalchemy.types import Integer, Unicode
+#
+# floof/floof/model/art.py
+#
+# Copyright (c) 2009 Scribblr
+#
-from floof.model import meta
+# from elixir import Entity, Field, Integer, Unicode
+from elixir import *
+import elixir
-__all__ = ['Art']
+from pylons import config
-class Art(meta.TableBase):
- __tablename__ = 'art'
- id = Column(Integer, primary_key=True)
- title = Column(Unicode(length=120), nullable=False)
+from floof.lib.file_storage import get_path, save_file
+from floof.lib.dbhelpers import find_or_create, update_or_create
+import floof.model.comments
+
+class Art(Entity):
+ title = Field(Unicode(120))
+ original_filename = Field(Unicode(120))
+ hash = Field(String, unique=True, required=True)
+
+ uploader = ManyToOne('User', required=True)
+ tags = OneToMany('Tag')
+ discussion = ManyToOne('Discussion')
+
+ user_relations = OneToMany('UserRelation')
+
+
+ def set_file(self, file):
+ self.hash = save_file("art", file)
+ self.original_filename = file.filename
+
+ file = property(get_path, set_file)
+
+ def get_path(self):
+ if self.hash:
+ return get_path("art", self.hash)
+
+
+ def add_tags(self, tags, user):
+ for text in tags.split():
+ if text[0] == '-':
+ # Nega-tags
+ tagtext = TagText.get_by(text=text[1:])
+ if tagtext:
+ tag = Tag.get_by(art=self, tagger=user, tagtext=tagtext)
+ if tag:
+ elixir.session.delete(tag)
+
+ else:
+ if len(text) > 50:
+ raise "Long Tag!" # can we handle this more gracefully?
+ # sqlite seems happy to store strings much longer than the supplied limit...
+
+ # elixir should really have its own find_or_create.
+ tagtext = find_or_create(TagText, text=text)
+ tag = find_or_create(Tag, art=self, tagger=user, tagtext=tagtext)
+
+
+
+
+ def rate(self, score, user):
+ return update_or_create(Rating, {"rater":user, "art":self}, {"score":score})
+
+ def user_score(self, user):
+ rating = Rating.get_by(rater=user, art=self)
+ if rating:
+ return rating.score
+ return Rating.default
+
+ def __unicode__(self):
+ return self.get_path()
+
+
+class Tag(Entity):
+ # look into how ondelete works. This just sets a database property.
+ art = ManyToOne('Art', ondelete='cascade')
+ tagger = ManyToOne('User', ondelete='cascade')
+ tagtext = ManyToOne('TagText')
+
+ def __unicode__(self):
+ if not self.tagtext:
+ return "(broken)"
+ return unicode(self.tagtext)
+
+
+class TagText(Entity):
+ text = Field(Unicode(50)) # gotta enforce this somehow
+ tags = OneToMany('Tag')
+
+ def __unicode__(self):
+ return self.text
+
+
+class Rating(Entity):
+ art = ManyToOne('Art', ondelete='cascade')
+ rater = ManyToOne('User', ondelete='cascade')
+ score = Field(Integer)
+
+ options = {-1:"sucks", 0:"undecided", 1:"good", 2:"great"}
+ default = 0
+
+Rating.reverse_options = dict (zip(Rating.options.values(), Rating.options.keys()))
+
+
+
+class UserRelation(Entity):
+ user = ManyToOne("User")
+ art = ManyToOne("Art")
+ kind = Field(String) # by for of
+ creator = ManyToOne("User")
+ confirmed_by_related_user = Field(Boolean)
+
+ # it is useful to record which authority figure on a given artwork
+ # confirmed the validity of this relation.
+ confirmed_by_authority = ManyToOne("User")
+
+ def __init__(self, **kwargs):
+ super(UserRelation, self).__init__(**kwargs)
+ assert self.user and self.art and self.kind and self.creator
+
+ if self.creator == self.user:
+ self.confirmed_by_related_user = True
+ # TODO: implement authorities
+ # if self.creator in self.art.authorities
+ # self.confirmed_by_authority = self.creator
+
+ def __unicode__(self):
+ return "%s: %s" % (self.kind, self.related_user)
+
+
+
+# class CharacterRelation(Entity):
+# pass