root/trunk/refresh-tagcache.rb

require 'rubygems'
$:.unshift('lib')
require 'blog'
require 'objects'


def dump_taglist
  TagList.select.each do |t|
    puts "#{t.count.to_s.rjust(5)} #{t.tag}"
  end
end

blog = Blog.new('config.yaml')

puts "Before:"
dump_taglist

Tag.select.each do |tag|
  tag.delete
end

Entry.select.each do |e|
  e.tags.split(/ /).each { |t|
    tag = Tag.new
    tag.tag = t
    tag.entry_id = e.entry_id
    tag.write
  }
end

puts "After:"
dump_taglist