X-Git-Url: http://git.veekun.com/zzz-floof.git/blobdiff_plain/68a31d533aba7490c3f1f812075e8ab6eb9265d0..fca6f64bc81a02c61ba45a13de25f3da2e7630b3:/floof/model/art.py diff --git a/floof/model/art.py b/floof/model/art.py index 8cfcd5a..451383b 100644 --- a/floof/model/art.py +++ b/floof/model/art.py @@ -1,12 +1,124 @@ -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') + + # def __init__(self, **kwargs): + # # I wanted to check for the existence of the file, but... + # # for some reason this FieldStorage object always conditions as falsey. + # # self.hash = save_file("art", kwargs.pop('file')) + # super(Art, self).__init__(**kwargs) + # # this is what super is doing, pretty much. + # # for key, value in kwargs.items(): + # # setattr(self, key, value) + # left for posterity. + + 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') + + # this text setter is no longer useful since I changed the way Art#add_tags works + # but I'll leave it in here just for several minutes nostalgia. + # def set_text(self, text): + # self.tagtext = TagText.get_by(text=text) + # if not self.tagtext: + # self.tagtext = TagText(text=text) + # + # text = property(lambda self: self.tagtext.text, set_text) + + 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) + + # @score.setter + # def score(self, value): + + options = {-1:"sucks", 0:"undecided", 1:"good", 2:"great"} + default = 0 + # options = ["sucks","neutral","good","great"] + + +Rating.reverse_options = dict (zip(Rating.options.values(), Rating.options.keys()))