X-Git-Url: http://git.veekun.com/zzz-floof.git/blobdiff_plain/68a31d533aba7490c3f1f812075e8ab6eb9265d0..5a8f3bd86e5fbcdd1ae077b15c17a66de14c091e:/floof/model/art.py?ds=sidebyside diff --git a/floof/model/art.py b/floof/model/art.py index 8cfcd5a..ff8035a 100644 --- a/floof/model/art.py +++ b/floof/model/art.py @@ -1,12 +1,134 @@ -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