X-Git-Url: http://git.veekun.com/zzz-floof.git/blobdiff_plain/68a31d533aba7490c3f1f812075e8ab6eb9265d0..3bdc7971c3359efe7f38eb1b94253b416471b87b:/floof/model/art.py diff --git a/floof/model/art.py b/floof/model/art.py index 8cfcd5a..66cbe0b 100644 --- a/floof/model/art.py +++ b/floof/model/art.py @@ -1,12 +1,87 @@ -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 * -__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 + + + +class Art(Entity): + title = Field(Unicode(120)) + original_filename = Field(Unicode(120)) + hash = Field(String) + + uploaded_by = ManyToOne('User') + tags = OneToMany('Tag') + + # 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) + + 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 tag in tags.split(): + if len(tag) > 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=tag) + tag = find_or_create(Tag, art=self, tagger=user, tagtext=tagtext) + + + def __unicode__(self): + return self.get_path() + + +class Tag(Entity): + # look into how ondelete works. It just sets a database property. + art = ManyToOne('Art', ondelete='cascade') + tagger = ManyToOne('User') + 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 \ No newline at end of file