X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=Memories%2FSystemTag.pm;h=0383db2f8bb60f325e7d29ca43caa45d47cd696a;hb=5e39f2504d914454f14ef27aa2c1a567c2148d14;hp=3a9fbbf1de72f6ee1d9d8f2ea272bddb6ddcfe5d;hpb=01f2c0cb6a5be655072e5bdf519189b2305f9059;p=memories.git diff --git a/Memories/SystemTag.pm b/Memories/SystemTag.pm index 3a9fbbf..0383db2 100644 --- a/Memories/SystemTag.pm +++ b/Memories/SystemTag.pm @@ -35,28 +35,4 @@ sub view :Exported { package Memories::SystemTagging; use base qw(Memories::DBI); use Class::DBI::Pager; -__PACKAGE__->table("system_tagging"); -__PACKAGE__->columns(TEMP => qw/count/); -__PACKAGE__->columns(Essential => qw/id tag photo/); -__PACKAGE__->set_sql(summary => qq/ -SELECT id, system_tag, count(*) AS count -FROM system_tagging -GROUP BY system_tag -ORDER BY count DESC -LIMIT 50 - /); -__PACKAGE__->set_sql(all => qq/ -SELECT id, tag, count(*) AS count -FROM system_tagging -GROUP BY system_tag -ORDER BY count DESC - /); -Memories::SystemTagging->has_a("photo" => "Memories::Photo"); -Memories::SystemTagging->has_a("tag" => "Memories::SystemTag"); - -Memories::Photo->has_many(system_tags => ["Memories::SystemTagging" => "system_tag"]); -Memories::Photo->has_many(system_taggings => "Memories::SystemTagging"); -Memories::SystemTag->has_many(photos => ["Memories::SystemTagging" => "photo"] ); -Memories::SystemTag->has_many(system_taggings => "Memories::SystemTagging"); - 1;